Importing QIF files from Bendigo Bank to Reckon Accounts Home & Business 2019
Options
Bob Allardice
Member Posts: 3 ✭
I am having trouble importing QIF transaction files from Bendigo bank. Only a few transactions are being imported instead of the 30 or so that so in the file itself when edited using Notepad.
After a few trials I have found that deleting the L field lines from each trnsaction in the QIF files allows all the records to be imported. There are L fields in downloads from my other banks but they seem to import OK
very strange - any ideas?
After a few trials I have found that deleting the L field lines from each trnsaction in the QIF files allows all the records to be imported. There are L fields in downloads from my other banks but they seem to import OK
very strange - any ideas?
0
Comments
-
Hi Bob
I can't help you specifically with Bendigo Bank. From some old QIF notes I saw that the 'L' Field in a QIF file is:
L Category (Category/Subcategory/Transfer/Class)
Andrew0 -
thanks, i have seen that too. i'll just keep editing the file as it is the only one I have trouble with0
-
Hi Bob,
Just in case it may assist others affected can you please confirm the following:
For the Bendigo Bank QIF file, are those lines that have the "L" character as the first character in the line, is there additional data that represents the Category/SubCategory/Transfer/Class value or are they blank?
Example:!Type:Bank D03/03/19 T-379.00 PCITY OF SPRINGFIELD LFuel:car ^
or!Type:Bank D03/03/19 T-379.00 PCITY OF SPRINGFIELD L ^
https://en.wikipedia.org/wiki/Quicken_Interchange_Format
Regards,
Data Recovery TeamRegards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0 -
They have characters after the "L" eg
LTCR
^
LJCR
^
LWDL
^
LDEP
^
I have seen these on the category list so they should be seen as a valid entry but for some reason they are not. Deleting those "L" lines makes the import succeed0 -
Hi Bob,
Thanks for confirming that.
Not quite sure why that is not working for you.
As a test a QIF as shown below!Type:Bank D03/03/19 T-379.00 PCITY OF SPRINGFIELD LTCR
^
Was imported into a newly created blank test data file into an account called "Chequing"
The Category "TCR" (of type expense) was ensured to be already present in the Category List.
The import was successful and the transaction appeared ready to be accepted into the register.
You've indicated that in your circumstance, the removal of the line beginning with that "L" identifier, allows the import to succeed.
Another test showed that if the value after "L" identifier did not exist in the Category List, that a pop up notification window is displayed indicating that there was an "unrecognised category or class found" with a prompt asking whether a new category or class should be created.
If you are comfortable with opening up QIF files in a text editor and want to get to the bottom of the issue, consider:
a) whether creating a new test category such as "ZZZZ" in your existing data file, then modifying one of those transactions that normally would not have been imported by changing the line from say "LTCR" to "LZZZZ" allows it to import
b) whether importing a small subset of the Bendigo QIF into a blank new file to see if the behaviour remains the same.
Regards,
Data Recovery Team
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community