Move from Tally or Odoo

This page is for business owners and accountants switching to NaliSuite from Tally (TallyPrime or Tally.ERP 9) or Odoo (versions 16, 17 and 18, online or on your own server). Instead of typing everything in again, you upload Tally's XML export or connect to Odoo, check what will come across, then import it in one go: customers and suppliers, products with the stock on hand, your chart of accounts, every unpaid invoice and bill (so they can be paid in NaliSuite), and the opening balances on the day you switch. This page covers choosing the cut-over date, exporting from Tally, connecting Odoo, reading and checking the figures, importing, running it again, and how the opening balances work.

Move from Tally or Odoo is a marketplace module. It needs the Contacts app, and brings in the most with Accounting, Invoicing, Purchases, Sales and Inventory switched on. Its screen is Settings → Move from Tally or Odoo.

Note: You need the move_over.manage permission to see Move from Tally or Odoo. Owners and admins have it. Entering the Odoo connection under Settings → Preferences needs core.settings.manage. Set permissions under Settings → Roles.

Switch it on

  1. Open Settings → Marketplace and type Tally in the Search add-ons… box (marker 1).
  2. On the Move from Tally or Odoo card (marker 2), click Start free trial (or Add to subscription) and confirm. Move from Tally or Odoo appears under Settings in the left menu.
Marketplace with the add-on search box and the Move from Tally or Odoo card marked
Marketplace with the add-on search box and the Move from Tally or Odoo card marked

If the card says Not available for purchase yet (as in the screenshot), ask NaliSuite support to switch it on. See Billing and marketplace.

Before you start, switch on the apps you want to fill (see What comes across), and set up your company's currency and taxes under Settings. Everything comes across in your company's currency.

The Move from Tally or Odoo page

Open Settings → Move from Tally or Odoo (marker 1). How it works (marker 2) sums up the four steps. At the top are Read Tally files (marker 3), Read from Odoo (marker 4) and Odoo connection (marker 5), which opens Settings → Preferences for the Odoo details. Below, each reading is shown as a card, newest first (the last ten).

Move from Tally or Odoo page with the menu item, How it works, Read Tally files, Read from Odoo and Odoo connection marked
Move from Tally or Odoo page with the menu item, How it works, Read Tally files, Read from Odoo and Odoo connection marked

Choose a cut-over date

The cut-over date is the last day you keep your books in the old system. From the next day you work in NaliSuite only.

Balances are brought in as they stood at the end of the cut-over date, and every opening entry, invoice and bill brought in is dated on or before it.

Tip: Print or export the old system's trial balance, list of customers' outstanding bills and suppliers' outstanding bills, and stock summary for the cut-over date. You will compare them with what NaliSuite reads.

Export from Tally

You need two XML files from Tally: the masters (your ledgers, groups and stock items, with their opening balances) and the Day Book (every voucher since your books begin). Do this in the Tally company you are leaving, on the computer where Tally runs.

The masters

In TallyPrime:

  1. From the Gateway of Tally, press Alt+E (Export) and choose Masters.
  2. Set File Format to XML (Data Interchange) and Type of Masters to All Masters. Note the Folder Path and File Name shown (usually Master.xml in Tally's folder).
  3. Press Send (or E) to export.

In Tally.ERP 9:

  1. Go to Gateway of Tally → Display → List of Accounts.
  2. Press Alt+E (Export). Set Format to XML (Data Interchange) and Type of Masters to All Masters.
  3. Note the Output File Name and press Enter (or Yes) to export.

The Day Book

In TallyPrime:

  1. From the Gateway of Tally, open Display More Reports → Day Book.
  2. Press F2 (Period) and set From to the first day of your books in Tally (shown as Books beginning from on the company; usually the start of the financial year) and To to your cut-over date.
  3. Press Alt+E (Export) and choose Current. Set File Format to XML (Data Interchange) and press Send. The file is usually DayBook.xml.

In Tally.ERP 9:

  1. Go to Gateway of Tally → Display → Day Book.
  2. Press Alt+F2 (Period) and set the same period: from the first day of your books to the cut-over date.
  3. Press Alt+E (Export), set Format to XML (Data Interchange) and export.

Both files can be large; each may be up to 50 MB. Tally's own Unicode export (UTF-16) is fine.

Important: Export the Day Book for the whole period from the first day of your books in Tally. The masters only hold the balances on that first day; NaliSuite adds every voucher in the Day Book on top to reach the balances on the cut-over date. A Day Book that starts later leaves the balances short.

Read the Tally files

  1. Click Read Tally files.
  2. The window repeats where the files come from in Tally (marker 1).
  3. Drag both files into Tally XML files (marker 2), or click Browse. Up to five files.
  4. Set the Cut-over date (marker 3): the last day in Tally.
  5. Click Submit (marker 4).
Read Tally files window with the instructions, Tally XML files, Cut-over date and Submit marked
Read Tally files window with the instructions, Tally XML files, Cut-over date and Submit marked

NaliSuite reads the files, works out the balances on the cut-over date and shows "Read from Tally. Check it below, then import.", with the number of customers, suppliers, products and accounts. Nothing is added to your books yet. The uploaded files are deleted once read.

How Tally is read:

If you see "That file is not a Tally XML export." or "No ledgers or stock items found…", export again with XML (Data Interchange) as the format, and All Masters for the masters.

Connect Odoo and read from it

NaliSuite reads Odoo through its API with an Odoo user's API key. It only reads; nothing is changed in Odoo.

Get an API key in Odoo

These steps happen in Odoo.

  1. Sign in to Odoo as a user who can see accounting, contacts and products (an administrator is simplest).
  2. Click your name at the top right, then My Profile (or Preferences), and open the Account Security tab.
  3. Click New API Key, confirm your password, give it a name such as NaliSuite and copy the key. Odoo shows it only once.
  4. Find your database name: on Odoo's sign-in page under Manage databases, or for Odoo Online and Odoo.sh in your Odoo address (for example mycompany in mycompany.odoo.com).

Enter the connection in NaliSuite

  1. Click Odoo connection on the Move page, or open Settings → Preferences, and click the Move from Odoo tab (marker 1).
  2. Fill in the fields and click Save preferences (marker 6).
Preferences on the Move from Odoo tab with Odoo address, Database, User (email), API key and Save preferences marked, filled with example values
Preferences on the Move from Odoo tab with Odoo address, Database, User (email), API key and Save preferences marked, filled with example values
Setting What to enter
Odoo address (marker 2) The address you open Odoo at, with https://, for example https://mycompany.odoo.com.
Database (marker 3) The database name.
User (email) (marker 4) The login of the user the API key belongs to, usually their email address.
API key (marker 5) The key from Account Security. It is stored encrypted.

Until all four are filled in, Read from Odoo is greyed out and the page says "To read from Odoo, add its address, database, user and API key under Odoo connection first."

Read from Odoo

  1. Click Read from Odoo.
  2. Set the Cut-over date (marker 1).
  3. Set Financial year started on (marker 2): the first day of your current financial year. Income and expenses are brought in from this date; the results of earlier years go to retained earnings, because Odoo never closes a year itself.
  4. Click Submit (marker 3). Reading a large Odoo database can take a few minutes; keep the page open.
Read from Odoo window with Cut-over date, Financial year started on and Submit marked
Read from Odoo window with Cut-over date, Financial year started on and Submit marked

How Odoo is read:

Unpaid documents and stock quantities are read as they stand in Odoo when you click Submit, not on the cut-over date. Read from Odoo on the cut-over date or just after, before anyone records new payments or stock moves there.

Message What to do
Odoo did not accept the user name and API key. Check them under Settings → Preferences → Move from Odoo. Check the User (email) matches the key's user, or make a new key.
Could not reach Odoo at … Check the Odoo address, and that your Odoo server can be reached from the internet.
Odoo answered with HTTP …. Check the address. The address is wrong, or is not the Odoo server itself.
Odoo said: … Odoo's own reason, often a wrong Database name or a user without access to accounting.

Check what will come across

Each reading is a card headed with the source, the company name in the old system and the cut-over date (marker 1). Under it is the status, when it was read and by whom (marker 2). A reading waiting to be imported says Ready to import.

A reading ready to import with its heading, status, Owed by customers, Owed to suppliers, Debits, Credits and Import marked
A reading ready to import with its heading, status, Owed by customers, Owed to suppliers, Debits, Credits and Import marked

Compare the figures with the reports you printed from the old system for the cut-over date:

Figure Compare with
Customers, Suppliers, Products The number of customers, suppliers and stock items you expect.
Accounts The ledgers or accounts other than customers and suppliers.
Owed by customers (marker 3) The total of customers' outstanding bills (Tally) or unpaid customer invoices (Odoo).
Owed to suppliers (marker 4) The total of suppliers' outstanding bills or unpaid supplier bills.
Stock value The closing stock value in the stock summary.
Debits (marker 5) and Credits (marker 6) The totals of the trial balance on the cut-over date. They should be equal.

Warnings

Warnings are listed in orange under the figures. Read each one before you import:

Warning What it means
No Day Book in the files, so these are Tally's opening balances at the start of its books. … Only the masters were uploaded. Read again with the Day Book too.
The Day Book has no vouchers on or before the cut-over date. The Day Book is for the wrong period, or the cut-over date is too early.
Tally's opening balances do not add up by … Tally shows this as Difference in opening balances. The amount is put on Opening balance equity; ask your accountant where it belongs.
Could not tell what kind of account … is; it comes across as a liability to check. The ledger is not under any of Tally's reserved groups. Correct its type in NaliSuite's chart of accounts after importing.
… is below zero in Tally (…); it comes across with none in stock. Tally allowed negative stock. Count it and adjust the stock in NaliSuite.
Receivables (or Payables) in Odoo's books are … but the unpaid … add up to … Payments not yet matched to invoices in Odoo, or opening entries there. The difference goes to Opening balance equity.

If the figures are wrong, fix them in the old system and read again. A new reading replaces the one waiting: the old card shows Stopped and "Replaced by a newer reading." (see Run it again).

Import

  1. On the card that is Ready to import, click Import (marker 7 in the screenshot above).
  2. Read the window (marker 1): "Customers and suppliers, products and stock, accounts, unpaid invoices and bills, and the opening balances are added on the cut-over date. Anything brought in before is not added again."
  3. Click Confirm (marker 2).
Bring this in? confirmation with the description and Confirm marked
Bring this in? confirmation with the description and Confirm marked

When it is done you see "Brought in from Tally." (or Odoo), and the card shows Imported (marker 1) and what was added under Brought in: (marker 2): new contacts, new products, products with stock, new accounts, unpaid invoices, unpaid bills and opening balance lines.

An imported reading with the Imported status and the Brought in line marked
An imported reading with the Imported status and the Brought in line marked

Everything is added in one go. If anything fails, nothing at all is added: the card shows Stopped and the red message "The import stopped and nothing was added: …" gives the reason. Fix the cause, read again and import.

What comes across

From the old system Becomes in NaliSuite Needs
Customers and suppliers Contacts, marked customer and/or supplier, with email, phone, tax number and address, and the note "Brought over from Tally" (or Odoo). A contact you already have with the same email, tax number or name is used instead, and marked customer or supplier as needed. Contacts
Stock items and products Products with their code, unit, selling price and cost. A product you already have with the same code, barcode or name is used instead. Sales
Stock on hand An Opening stock receipt into your default warehouse on the cut-over date, at cost. Sales and Inventory
Ledgers and accounts Accounts in your chart of accounts. An account you already have with the same type and name (or code) is used instead. New accounts keep their Odoo code when it is free; otherwise they get the next free number from 900 within their type, for example 1900 for an asset or 3900 for equity. Accounting
Unpaid customer bills or invoices Issued invoices, numbered in your own series and dated as in the old system, with one line "Balance owed on … from Tally", the old number as the Customer reference and the due date. They stay open to be paid in NaliSuite. Invoicing
Unpaid supplier bills Posted bills with the old number as the Vendor's invoice number, open to be paid in NaliSuite. Purchases
Every other balance One opening journal entry on the cut-over date (see How opening balances work). Accounting

Invoices brought in are not sent to the customer, not submitted to the tax authority and not checked against credit limits: they only record what is still owed. A customer's credit or a supplier's debit (money you owe a customer, or that a supplier owes you) goes on the opening entry against that customer or supplier instead of becoming a document.

If an app is off, its part is skipped and the card warns you, for example "Products were not brought in because the Sales app is off." or "… unpaid invoices or bills were not brought in: turn on Invoicing, Purchases or Accounting to bring them in."

Nothing else comes across: no paid invoices or bills, no history of sales, purchases or payments, and no employees, projects or attachments. Keep the old system (or a backup of it) to look up history.

How opening balances work

On the cut-over date, NaliSuite records:

The opening balances entry with its date and lines marked
The opening balances entry with its date and lines marked

So, on the cut-over date, your receivables and payables in NaliSuite are exactly the unpaid documents, and every other account matches the old trial balance. If the old books balanced, Opening balance equity ends at zero. If something is left on it, the card warns "… was left on Opening balance equity. Check it with your accountant and move it where it belongs." Move it with a journal entry (see Accounting basics).

Income and expenses come across for the current year so far, so your profit and loss for the year is complete. With Tally, a change in stock value over the year is recorded as Change in stock since the start of the year, a cost of sales account.

Important: Do not record opening balances by hand as well, and do not import from two systems into the same company. Compare the trial balance on the cut-over date (see Financial reports) with the old one before you start working.

Run it again

You can read and import again as often as you need, for example after correcting something in the old system. NaliSuite remembers where every contact, product, account, invoice and bill came from, so nothing comes across twice:

A second import with nothing new brought in and the opening balances warning marked
A second import with nothing new brought in and the opening balances warning marked

Only the latest reading can be imported. Reading again marks the reading that was waiting as Stopped (marker 1) with "Replaced by a newer reading." (marker 2); its figures and warnings (marker 3) stay on the card for reference.

A replaced reading with the Stopped status, Replaced by a newer reading and its warning marked
A replaced reading with the Stopped status, Replaced by a newer reading and its warning marked

To change an opening balance after importing, post a journal entry in NaliSuite rather than importing again.

Good to know

How long does it take? Reading Tally files takes seconds to a minute. Reading Odoo and importing can take a few minutes for a large business. Keep the page open until the message appears.

Which company does it go into? Your default company.

What about multi-currency invoices? Amounts come across in your company's currency, as the old system holds them in its books.

Are VAT and other taxes split out? No. Unpaid invoices and bills come across as one line for the amount still owed, already including tax. The tax account's balance on the cut-over date comes across on the opening entry.

Can I undo an import? Not automatically. Reverse the opening entries and cancel the invoices and bills brought in. If you are unsure, try the move first in a test workspace.