Migration from Tally to Zoho Books

In this guide, you’ll learn about migrating all your data from Tally to Zoho Books for UAE users. Let’s see how you can bring in all your data including the Chart of Accounts, Contacts, Items, Opening Balances and other modules into Zoho Books.

In this page:


Terminology

Let us take a look at the accounting terms in Tally and its equivalent in Zoho Books.

Tally Zoho Books
Account Masters Chart of Accounts
Sundry Debtors Accounts Receivables
Sundry Creditors Accounts Payables
Quotation/Proforma Invoice Estimate
Receipt Vouchers Payments Received
Payment Vouchers Payments Made
Debit Note Vendor Credits

Chart of Accounts

In Tally, you’ll find the Account Masters which consists of many sub-accounts or ledgers.

In Zoho Books, the Chart of Accounts is the equivalent of the Account Masters. The Chart of Accounts consists of various accounts and its types.

You can also create a new account for tracking different sources of income or expense. Some standard account types present in Zoho Books include:

Under each of these account types, we have a list of accounts. For example, the Expense account type includes the Meals and Entertainment, Fuel/Mileage and Other Expenses accounts.

You can import your Chart of Accounts in bulk by following the steps below:

Import Chart of Accounts

Choose File - Chart of Accounts

Map Fields - Chart of Accounts

Preview - Chart of Accounts

Note:
The Account Masters in Tally is the equivalent of Chart of Accounts in Zoho Books.


Contacts

Contacts are the customers or vendors you deal with in your business.

Learn how to import contacts.

You can also enter other contact details like the Billing and Shipping Addresses which will reflect in the transactions for your customers and vendors. Adding these details will certainly benefit you in the long term.

Note:
Before you import your contacts’ opening balances into Zoho Books, you must import your contacts.


Items

As a business, you will have goods or services that you sell to your customers or buy from your vendors. These goods or services are called items in Zoho Books.

You can import all the items in Tally into Zoho Books.

Learn how to Import Items.

Some important fields that need to be filled in while importing items are:

You have the option to track inventory for each of these items in Zoho Books. For this, you have to fill in the following fields during the time of import:

The Opening Stock that you enter for each item will affect the Inventory Reports.

Note:
Ensure that you enable inventory for items before importing them by going to Settings > Preferences > Items and selecting I would like to enable Inventory.


Sales Transactions

Similarly, you can import all your open sales transactions in Tally before the Opening Balance Date, i.e. 31st March into Zoho Books. This will help you to set up your contacts’ opening balances properly. Various sales transactions in Zoho Books include:

During import, it is essential that the following condition is met:
All the mandatory fields in the file to be imported must be filled and mapped correctly with the fields in Zoho Books.

Note:


Purchase Transactions

You can also import a variety of purchase transactions into Zoho Books including:

During import, it is essential that the following conditions are met:
All the mandatory fields in the file to be imported are filled and mapped correctly with fields in Zoho Books.

Note:


Opening Balances

Before you started accounting with Zoho Books, you would have already performed transactions in Tally. Due to this, you would have your Accounting “Balances”, which are also called as the “Opening Balances” for your business.

To know the accounting balances of your previous financial year in Tally, run the Trial Balance Report as on 31st March. From here, you can find the Debits and Credits of various accounts.

To enter these opening balances in Zoho Books:

Enter Opening Balances

Import Opening Balances for Contacts

In Tally, there are separate accounts for individual customers. However, in Zoho Books, we have a single account for all of them.

The two major accounts in Tally are:
Sundry Debtors - This account tracks the money that you are to get from your customers.
Sundry Creditors - This account tracks the money that you are to pay your vendors.

In Zoho Books, the Accounts Receivable and the Accounts Payable are equivalent to the Sundry Debtors and the Sundry Creditors respectively.

To enter opening balances for your customers and vendors:

You can enter the various opening balances for your customers and vendors under the following accounts in Zoho Books:

For customers

Enter the Debit or Credit value under Sundry Debtors in the Accounts Receivable according to your Trial Balance report. This is the amount that you are yet to receive from your customers (open invoices). After this, click Save.

Accounts Receivable

Enter the Credit value under Advance Received in the Credit side of Unearned Revenue. This is the advance payments that you have received from your customers.

For vendors

Enter the Credit value under Sundry Creditors as a negative value in Accounts Payable. This is the amount that you are yet to pay your vendors (pending bills). For example, if the amount in the Credit side in Sundry Creditors is 1000, then enter -1000 in the Accounts Payable in Zoho Books. After this, click Save.

Accounts Payable

If you have vendor advances, you can enter it in the Debit side of Prepaid Expenses. This is the advance you have paid your vendors.

Note:

Import Bank Opening Balances

To enter the opening balances you have for your bank account:

Note:
You can also manually add a bank account under the Banking module. Learn more

Import Loan Opening Balances

To enter the opening balances you have for your loan account:

Finally, there are two ways to ensure that you’ve entered your Opening Balances correctly:


Manual Journals

You can also import manual journals into Zoho Books.The debit and the credit value should remain the same and the necessary account is to be selected while making transfer entries.

To import manual journals into Zoho Books:

Choose File - Manual Journals

Map Fields - Manual Journals


Bank Feeds

You can also import all your bank feeds into Zoho Books. If you wish to bring in all your previous financial year’s transactions (which includes both open and closed transactions) into Zoho Books, you’ll have to ensure that the amount in bank account is the same as the amount in Zoho Books (you can find both of these amounts on top of the page in the Banking module).

After performing this step, you can import your Bank Feeds into Zoho Books.

Bank Feeds

You can verify that all the balances are entered correctly by checking your Trial Balance report in Zoho Books.


If you face any difficulty during the migration, feel free to drop us a mail at support.me@zohobooks.com or give us a call on 80004440824 (Saturday - Thursday, 9:00 AM - 8:00 PM).

Was this document helpful?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial
Zoho Books

VAT compliant accounting
software for small
businesses.

Maybe Later