Uploading an excel .csv file into Reckon Hosted

  • 1
  • Question
  • Updated 2 years ago
  • Answered
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. 
Photo of Alex Jeffries

Alex Jeffries

  • 460 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
It may have something to do with the Creditors Control, generally you need to assign a supplier name to this.
Photo of John G

John G, Information Support Analyst

  • 27,350 Points 20k badge 2x thumb
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
Photo of Alex Jeffries

Alex Jeffries

  • 460 Points 250 badge 2x thumb
Thanks John, but if I'm not using excel to important transactions, how do I do it??
Photo of John G

John G, Information Support Analyst

  • 27,350 Points 20k badge 2x thumb
Hi Alex,

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


regards,
John
Photo of Alex Jeffries

Alex Jeffries

  • 460 Points 250 badge 2x thumb
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? 
Photo of John G

John G, Information Support Analyst

  • 27,350 Points 20k badge 2x thumb
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
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
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?
(Edited)