Uploading an excel .csv file into Reckon Hosted
Alex Jeffries
Member Posts: 20 Novice Member
I'm trying to upload monthly journal movements into Reckon Hosted in the format below, however it is telling me that the account type is invalid and as there are errors I can't upload anything. The excel file has been saved as a .csv file as the help screen suggested but it's still not working.
Is anyone able to provide me with a correct format for upload or a fix for the current format I have? It's very frustrating that something so simple is causing so much trouble.
Is anyone able to provide me with a correct format for upload or a fix for the current format I have? It's very frustrating that something so simple is causing so much trouble.
0
Comments
-
It may have something to do with the Creditors Control, generally you need to assign a supplier name to this.
0 -
Hi Alex,
Change your csv file to an IIF file by renaming it from nnnnnn.csv to nnnnnn.iif. Provided the file has followed all the rules then it should import through File > Utilities > Import > IIF files. See the Help Index for information on importing transactions through IIF.
Use Excel to start new Accounts and Items only, not transactions.
Hope this helps.
regards,
John
1 -
Thanks John, but if I'm not using excel to important transactions, how do I do it??0
-
Hi Alex,
To clarify, use File Explorer to rename the nnnnnn.csv file to nnnnnn.iif.
regards,
John0 -
Will do. But you've said that Excel shouldn't be used to upload transactions... is there a different program that should be used or is it just not possible?0
-
Hi Alex,
Within Reckon Accounts its only through IIF file that you can import transactions.
For 3rd party applications that can interface with the Reckon Accounts database (desktop), check out the Add-On Marketplace for QODBC (FlexTools) and Zed Axis and others.
regards,
John
0 -
Hi Alex..it does not matter what the file is called. .but it must be saved in a tab delimited format. .. I think your main issue though is also the date format. .. have you tried importing using mm/dd/yy instead?0
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll
- 33 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 25 Reckon Mate App
- 2.6K Reckon One
- 9 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 74 About Reckon Community