Migrating to Zoho Books from your existing system

If you are migrating data from your existing accounting system to Zoho Books, this page will guide you on how to enter the opening balances into our accounting system. Before you actually start using Zoho Books, you will have to pull out the trial balance report from your existing system and enter the appropriate account balances into Zoho Books. Follow the steps mentioned below to get started with your migration.

In Zoho Books you have the option to import data from your computer to speed up the data collation process inside every module. You can also export data from Zoho Books for your reference or other purposes.

Importing Data


You have the option to download a sample file to compare it to the file you are importing to ensure that the import is quick and efficient. Click on sample file to download it to your computer.

Opening Balances

To enter the opening balance in Zoho Books,

Opening Balances

Points to remember during migration

  • We don’t directly support importing your journals, deposits, fund transfers etc., from your existing accounting system. But you can enter or update the entries in Zoho Books accordingly so that all your accounts match.

  • Please ensure that you map the fields properly and also get rid of unnecessary commas, blank columns etc.,

  • If you have imported all your invoices or bills, ensure that appropriate statuses are maintained even after the migration.

  • Please note while you import your files into Zoho Books, the value in the field should match with the data type supported by Zoho Books. There will be unmapped fields in your import file that would not have been mapped to any Zoho Books field. Hence, if you want these fields to be imported, the column header(s) should be mapped properly.

  • If you need further support regarding entering any of your business transactions in Zoho Books, please contact us anytime, our support folks will touch base with you soon.

Was this document helpful?
Thank you for your feedback!