Importing data from previous accounting package when transferring to ClearBookq

Question asked by Liz Pearce 9 years ago

Is there any particular order in which data needs to be imported (using CSV files) when transferring data from a previous accounting package (Quickbooks Online). I want to test ClearBooks before committing myself.

2 Replies

Hi Liz - Generally you do it in this order:

Import customers & suppliers Import customer Invoices & supplier bills Import bank transactions Import any opening TB by importing a journal entry.

If all you need to do is set up customers and suppliers names, without all the other standing data, like addresses etc, then you can skip the first import as importing the invoices & bills will set these up for you. Not much help though if you decide to go ahead with CB, as you then have to setup the contacts' standing data manually.

If you are importing historic invoices & bills that have been paid off by bank transactions, there's an Import "Sales payments" and "Bills payments" where you just list the inv/bill number, date and amount and they pay off the invoices/bills, you can then import the other bank transactions as normal.

Hope that helps?

By the way, there's a video on other, non-numbers setup you might find useful: https://youtu.be/Y0kZ-fJKTNE

Weird the options should have listed down the page, sorry

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are