import (Some) customers/suppliers/items

  • 1
  • Question
  • Updated 10 months ago
I'm just setting up reckon one and have decided not to attempt the import as my old Quickbooks has a lot of historical errors, many inactive customers/suppliers/items and the file goes back years so is beyond the "free" conversation.

My thoughts are export an excel/CSV file from Quickbooks, edit/clean it to remove the mess, then import it into Reckon one.

Is there any way to supply this list of (customers/suppliers/items) that could be imported to reckon one?

Thanks for the help
John Morrison
Photo of John Morrison

John Morrison

  • 90 Points 75 badge 2x thumb

Posted 10 months ago

  • 1
Photo of Nitesh Sharma

Nitesh Sharma, Employee

  • 260 Points 250 badge 2x thumb

Hi John, 

Welcome to Reckon Community.

Unfortunately, the data from external file cannot be directly imported into Reckon One. However, you can request a data conversion from your existing software/file to Reckon One through the link below.

https://www.odyssey-resources.com/reckon/

 

Regards,

Nitesh
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 9,444 Points 5k badge 2x thumb
@Nitesh - this is the correct site: https://www.reckon.com/au/data-conversion/
Photo of John Morrison

John Morrison

  • 90 Points 75 badge 2x thumb
I already explained in the original post that conversion isn't an option.

That is disappointing as it's such a simple thing to do at Reckons end of things.

Looks like I'll have to roll my own using the web interface.  Not as elegant but still not a hard task.
Photo of Jason Hollis

Jason Hollis, Head of Product

  • 9,444 Points 5k badge 2x thumb
Hi John,

We have generic templates we use internally to import csv lists into Reckon One.

Create the LIST REPORTS in Reckon Accounts / QuickBooks desktop (filtering / altering columns where applicable) and export these as CSV named appropriately eg. suppliers, customers, COA, Items. Clean up any old entries and provide the team with these to import into Reckon One (when contacted after completing the step below).

Go to: https://www.reckon.com/au/data-conversion/

Select Excel as the method you are converting from. When contacted by the team provide them with the csv's.

Note: It's better to include too many columns of data than not enough. The team can always delete what is not applicable for Reckon One.
Photo of John Morrison

John Morrison

  • 90 Points 75 badge 2x thumb
Thank you Jason!
    I thought you were just directing me to the main data conversion.  Sorry!
   That sounds like exactly what I need.

Thanks, again and sorry