Uploading an excel .csv file into Reckon Hosted

Alex Jeffries

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. 

Jacqui Allen

It may have something to do with the Creditors Control, generally you need to assign a supplier name to this.

John G

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

Alex Jeffries

Thanks John, but if I'm not using excel to important transactions, how do I do it??

John G

Hi Alex,

To clarify, use File Explorer to rename the nnnnnn.csv file to nnnnnn.iif.


regards,
John

Alex Jeffries

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? 

John G

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

Linda ABC

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?