Can I transfer my data to a new accounting program?

CosmoLex Team

You are here:

The process of transferring financial data from one accounting program into a different program is called data migration. The detailed steps for migrating financial data into a new accounting program are as follows:[1][2]

  1. Pick a cut off date – a date before which you will not make any further changes
  2. Decide whether you want to transfer your cleared transactions, your historical data, into the new accounting program (most bookkeepers and accountants recommend that you leave the historical data in the old system or in a backup file and only transfer the uncleared transactions to the new system[3])
  3. Reconcile all of your accounts up to the cut off date
  4. Back up your data in your old system
  5. Export all uncleared transactions from your old system into a CSV file
  6. Create a map, a key, by matching each column in the CSV file to a specific field found in the new accounting program (data mapping). If this is done properly, the data will import quickly, and accurately into the new system
  7. Verify the accuracy of the data in the CSV file and remove any duplicate entries
  8. Upload the CSV file into the new accounting program
  9. Print the trial balance from the old accounting program as of the cut-off date, and use  journal entries to enter the balances from each general ledger account into the new system (keep in mind that the new program may require you to enter the client trust liability accounts in a different way than you did in your old accounting program).[4]

References

1. Accounting Software Data Migration
2. 7-Step Accounting System Migration Checklist
3. Best Conversion Practices When Moving Data to a New Accounting System
4. Financial Data Migration Guide