How to import QIF in new version of Hosted?

  • 1
  • Question
  • Updated 4 years ago
  • Answered
  • (Edited)
Hi there,


With the release of new version of Reckon Hosted.
I cannot import now my bank statements (qif file) saved in my local pc.
I tried the two blue buttons on the top page (upload and download)
but it won't works and nothing happened.
I can't see the uploaded files (qif) in B and Q drive to download from
the import bank statement menu in Quickbooks.
Online bank and credit card accounts was already setup and I was
doing it before the updates.
Please help,ASAP.


Many thanks,


Rod Parungao
Photo of Rod Parungao

Rod Parungao

  • 130 Points 100 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Shane

Shane, Employee

  • 7,448 Points 5k badge 2x thumb
Hi Rod,


With the new Reckon Accounts Hosted V2 use the upload button (arrow facing up), browse to your QIF file, duoble click it, which will move it to the "Upload" folder on your Q drive.  From there you import as usual, just select the QIF file from the Upload folder that is on your Q drive.



Let me know how it goes.

Regards,
Shane.
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hey Ashley,

Few points to raise, Pocketbook is an Online/Cloud Based App much like our Modular Cloud Accounting Solution > Reckon One. Hosted gives you full desktop functionality which often is not available in other Cloud Accounting Software. Most importantly, Hosted and Reckon One are tailored towards business needs, unlike PocketBooks which is a personal finance tool like Pocketbooks - i.e. Can it do BAS?

I thank you for you suggestion regarding getting a better process, and am happy to say that Reckon Accounts 2015 will see the launch of 'Renaming Rules', which will allow you to set up rules for imported QIF or direct BankData Feeds - Reckon One already offers this function. The video below shows QIF imports and setting up rules, it will run similarly.
 


Cheers,
Mirko
Photo of Ashley Joyce

Ashley Joyce

  • 700 Points 500 badge 2x thumb
Hi Mirko,

How does BAS functionality have anything to do with importing and categorising bank feed transactions into an accounting system in a intuitive and automated way?

Pocketbook doesn't have BAS functionality, because you & I both know that it is a entirely free cloud-based software app (both desktop & mobile) for managing an individuals personal finances. It is not aimed at the business market with BAS lodgement, its for individual use (users who do their personal tax return once a year).

In my opinion, business solutions, like Reckon Hosted, which are user-pay models should be streaks ahead of the free apps in all respects... including the importing of bank feeds.... when clearly this is not the case in respect to Reckon Hosted compared to Pocketbook!

I've been using Reckon Hosted since it first started several years ago.... probably the most time consuming process is doing the bank reconciliation. I can spend a few hours matching up all my bank transactions every BAS time. Its extremely time-consuming.  

I'm glad to hear progress has been made towards import rules for categorising transactions. I just hope its not too cumbersome otherwise users wont use it. 
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hey Ashley, I understand your quite valid points - this is the direction being taken within Reckon One. At the same we time remain committed to our Desktop and Hosted users, which is why this change is being implemented in the 2015 release.
Pocketbook, and similar, are most likely free because they are a small start-up trying to build subscribers before offering the business for sale. Bank feeds are not free, just free to their customers. Someone is paying for it, and it will be for a reason.
Photo of Ashley Joyce

Ashley Joyce

  • 700 Points 500 badge 2x thumb
A product like Pocketbook could stay entirely free if it can find ways to monetize the information it stores. Not unlike how big companies like Google have made successful business models by giving away free online cloud services to their users such as Google search & Google mapping.

The buying habits of the hundreds of thousands of pocketbook users could be extremely valuable to marketing companies in Australia looking to better understand the demographic segmentation of the Australian consumer Market. This data can be packaged in such a way that does not disclose personal information of the individual Pocketbook users. 

Pocketbook could still be sold off to someone like Google looking to make acquisition with a cloud service that already favors this type of revenue model. The great thing about this kind of revenue model, is once the entirely free cloud service has reached a critical mass it makes it nearly impossible for other software companies too come along and sell a subscription service... unless of course that subscription service adds extra functionality that the entirely free software does not already cater for... in most cases this market will be much smaller.   
Photo of Rod Parungao

Rod Parungao

  • 130 Points 100 badge 2x thumb
This reply was created from a merged topic originally titled
QIF import in new version of Hosted?.


Hi Kevin,



With the release of new version of Reckon Hosted.
I cannot import now my bank statements (qif file) saved in my local pc.
I tried the two blue buttons on the top page (upload and download)
but it won't works and nothing happened.
I can't see the uploaded files (qif) in B and Q drive to download from
the import bank statement menu in Quickbooks.

The online bank and credit accounts are already set up.
Please help.


Many thanks,


Rod Parungao

Note: This topic was created from a reply on the Reckon Plus 2014 Importing Error topic.
Photo of Michael Van Niekerk

Michael Van Niekerk

  • 258 Points 250 badge 2x thumb
My uploaded QIF Files do not appear in the Q or B drives (if they even attempt to upload, most of the time I just get a message saying that this file is not supported). This is NOT good enough Reckon! what a way to destroy what was working for millions of customers.
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb

Hi Michael,

The import is working as expected, and we have not changed the QIF import process into the banking centre from the older version, so something else is at play here.

When you select the upload button and then select the QIF on your local machine it should upload straight to Q:\Upload.

To test, run this, and then click the download button in hosted, but then navigate to Q: > Upload and have a look what QIF files are present, if any?

Also advise what bank you are with, as there is a known issue with the CBA at the moment where they have changed the format of the QIF.


Regards,
Jason Hollis - Partner Relationship Manager


Photo of Michael Van Niekerk

Michael Van Niekerk

  • 258 Points 250 badge 2x thumb
Hi Jason,

I have just tried yet again to import a new QIF file, this time I have been able to locate it, and QB says that it has converted the file, but the reconciliation window is not coming up, so I can't complete my bank rec. I see all 3 screens as mentioned below, then nothing happens, where as I used to get the split window for the reconciliation after the third screen. any ideas?
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb
G'Day Michael. Have a look at the last post to Jen re going through the utilities > import > web connect files... path as the web connect file should be sitting with the QIF as it sounds as though the conversion has taken place.

See how you go with that process.

Regards,
Jason
(Edited)
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Another simple one (which I overlook on a daily basis on most programs haha!) is changing the toggle to "view/show all file types" ?
Photo of Jen2014

Jen2014

  • 110 Points 100 badge 2x thumb
I have downloaded the bank transactions from QIF to QBO into Upload folder etc.  Went through the normal process as previously done.  Choose the account to Import into.... and then nothing happens.
I can not see the file to be able to process.  It is not within Online Banking.  Please help
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb
Hi Jen,

Just to clarify, you should be uploading the QIF file to the Q Drive, then converting the QIF to QBO from within Reckon Accounts Hosted (check the file locations as below. ie Q:\)



When you click OK you should see (very quickly)..



Then...



Can you confirm this is the process you are following, and what screens you are not seeing?



Regards,
Jason
Photo of Jen2014

Jen2014

  • 110 Points 100 badge 2x thumb
Hi Jason
I see the Import screen, the files are correct - loaded from Q drive, enter the account to import into.
Click ok. Then nothing. Import screen goes and I am left in the Online Banking window. There is no file imported to view.
I have gone through the process many times before the upgrade, so is there another setting that needs to be changes somewhere?
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb

Hi Jen, so you are not getting the 'Import new transactions now' option? (the 3rd screenshot above). Is that right?

Can you physically go to the Q drive and see the QIF file as well as the QBO file?

If you open the QIF file on your local computer (using notepad) can you see data incl amounts, dates and payment references?

Which bank is the QIF from?


Thanks,
Jason

(Edited)
Photo of Gary Price

Gary Price

  • 2,252 Points 2k badge 2x thumb
Just a thought...have you tried the alt + PageUp key combination.  This works when the BAS  page disappears...perhaps might work for your missing window...perhaps
Photo of Jen2014

Jen2014

  • 110 Points 100 badge 2x thumb
Hi - I get the quick flash of "Converting QIF file" window but not the "Import Transactions Now" window.  
The file has been converted though as I can see it in the Upload folder.  
I have checked the file by opening it in Notepad and it contains all the data I want to get into Reckon.

Just tried it all again, I get the message about there already being a QBO file, so I agree to overwrite it.  Then it converts it (again) and then nothing. All I am left with is whatever screen I was already in. No other options are given.

ALT + PageUp key did not work either.

Would be really great if I can get this to work as GST return is overdue and Mr Tax man would be happy too!

Any suggestions?
Jen
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb

OK Jen,

What if you try to import the QBO file directly?

Go to... File > Utilities > Import > Web Connect Files... and navigate to your QBO file.

 Do you get the 'Select Bank Account' window to open by using this method?

(Edited)
Photo of Jen2014

Jen2014

  • 110 Points 100 badge 2x thumb
Hi Jason,
Thank you so much. I have been away all day and just saw your message.  I have imported the file in without a problem.  The standard window appeared as to which bank account to load file into and then it was available within "Online Banking Centre"

But there is something wrong when the normal standard way does not work. But thank you again for the 'work around' it means I can get my accounts done.  I will contact Reckon Techs when they open their doors again on Monday to advise of the fault.

Appreciate your help.
Jen
Photo of Fiona

Fiona

  • 130 Points 100 badge 2x thumb
I am having this exact same problem.  My Qif file converts to QBO - I can see it in my Q drive - uploads.  I get asked to select which account to import it to, I select the account.  I then get asked if I would like to import the new transactions now, I select yes.  I then get taken to the online banking centre and no file is showing.  Any suggestions?
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 10,156 Points 10k badge 2x thumb
Hi Fiona, 

Did you try the process above....? That is...

...try to import the QBO file directly?

Go to... File > Utilities > Import > Web Connect Files... and navigate to your QBO file.


Regards,

Jason

Photo of Fiona

Fiona

  • 130 Points 100 badge 2x thumb

Hi Jason,


I gave it a go but no luck.

I discovered that it will not import into my account because I have it classed as a foreign currency account. 

My home currency is Indonesian Rupiah so Reckon won't accept the statement (even though the account is set up in AUD and the bank account is a Nab AUD account). 


Thanks for checking up - any ideas on how to get around it? 


Fiona

This conversation is no longer open for comments or replies.