Home |
  Search |Quick FAQs Only


KNOWLEDGEBASE > ISSUE OVERVIEW


Previous
Add to Bookmarks
Print Issue Print Issue
Email Issue

An error occurred while processing your online banking data when importing a QIF file into QB
ID: 4711 Category: Accounts - Business Range - Desktop & Hosted (previously QuickBooks) Status: Resolved Views: 641


Question:

Why won’t my bank data, in a QIF file created on my bank’s website, not import into QuickBooks.  I keep getting an error message.



Solution:

The error message is a generic one so users should examine other known issues first:


From CBA:  http://kb.reckon.com.au/issue_view.asp?ID=4625


                     http://kb.reckon.com.au/issue_view.asp?ID=3995


From SGB:  http://kb.reckon.com.au/issue_view.asp?ID=4618


From Westpac:  http://kb.reckon.com.au/issue_view.asp?ID=4626


From ANZ & Suncorp:  http://kb.reckon.com.au/issue_view.asp?ID=50


 


If you still have a problem, then it may be because there are more transactions than the 50 transactions limit that QuickBooks can handle. 


 


Workaround


Split your QIF file into a number of files that contain no more than 50 transactions. 


In Windows Explorer, make a number of copies of your QIF file so that each file will contain no more than 50 transactions.


You can view a QIF file through Notepad.  Right-click the file in Windows Explorer and select Open with and select Notepad.


The QIF has this format:


File Type Marker:                                   !Type:Bank


1st Tran Line – Date:                               D21/06/11


2nd Tran Line – Amount:                          T70.00


3rd Tran Line – Details:                           Deposit for Suite


4th Tran Line – End of Record marker:       ^


 


In the first file, delete all transactions from record 51.  Save the file.


In the second file, ensure you maintain the first line (File Type Marker), delete transactions 101 onwards, then delete transactions 1 – 50.


In the third file, ensure you maintain the first line (File Type Marker), delete transactions 151 onwards, then delete transactions 1 – 100.


Continue this step for all your files. 


Import each QIF file into QuickBooks. 


 



Related Issues:
No related issue is available.

Submitted: 1/11/2012 Modified: 1/11/2012


Did this solution answer your question ? Please leave a comment, click here.

Rate how well this question was answered.
100% 75% 50% 25% 0%