Importing a Bank Statement into Quicken
Comments
-
Hi Michael, any transactions you want to appear in the program needs to be imported using the IIF format. If you have a requirement to regularly import transactions into your data file, it would be a good idea to use some kind of 3rd party software such as ZedAxis
-IM0 -
There is also the QODBC path ...but I have never got that off the ground as it used to consume a licence a force me into single bloody user mode! ... which once you have a database style connection to the Reckon data file you can supposedly read and write a subset of the data. You would still need a Microsoft Access type interface to process the input and feed it into the QODBC pipe... And I understand that the interface is slow because it actually translates everything into XML along the way.0
-
thanks for this information. but I need a simple solution - to be more specfic - I have in this case 100 lines of expenses in a CSV file (downloaded from a bank) - how would I go about importing this into a "quicken home & business " account0
-
I use an Excel based converter called CSV2QIF from Propersoft, who offer a number of conversion programs. Take a look at www.propersoft.net.
Ian Robertson
0 -
thanks for that solution - I also found another - but still none for free
0 -
Hi Michael,
QIF is the format to import bank statements into Accounts Personal and Accounts Business (the old Quicken and Quickbooks). Most banks will give you the option to export to a QIF file – sometimes it’s called Quicken or AUS Quicken.
Can you get another copy in this format?
Regards,
John
0 -
Hi John - I am using Travelex - they do not have any output format at all - so I have just copied their report and pasted it to excel. Bank entries are OK. Why is it that Quicken does not allow CSV import anyway?
0 -
Hello again Michael,
Importing data from 3rd party sources has never been a primary feature for our products – Accounts Business has more options than Accounts Personal.
We understand that the role of downloading from bank accounts has changed and our forthcoming new product ReckonOne will have a banking module to allow direct download from bank accounts.
QIF has become a standard format that enables you to match a bank entry to your Accounts entry and add more information to the transaction and keep track of its status so you do not double up.
Regards,
John2 -
Hi Michael, so you need a free AND simple solution.
You're more likely to find:
1) A simple solution where someone has created a soluton to save you time, therefore they will charge you for it
2) A free solution which requires you to do add some effort to get it working
Quicken doesn't allow free-form import of CSV data as that would require field mapping and other transformations, whereas they already have a QIF format specification designed to bring import/export data.
-IM0
Categories
- All Categories
- 6.8K Accounts Hosted
- 17 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 40 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 30 Reckon Mate App
- 2.7K Reckon One
- 17 📢 Reckon One - Announcements
- 14 Reckon Invoices App
- 24 Reckon Insights
- 101 Reckon API
- 310 Point of Sale
- 1.9K Personal Plus and Home & Business
- 72 About Reckon Community