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
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
-
90 Points
Posted 10 months ago
Nitesh Sharma, Employee
-
260 Points
-
90 Points
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.
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.
Jason Hollis, Head of Product
-
9,444 Points
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.
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.
-
90 Points
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
I thought you were just directing me to the main data conversion. Sorry!
That sounds like exactly what I need.
Thanks, again and sorry
Jason Hollis, Head of Product