Tally to Odoo Migration: A Step-by-Step Plan for UAE Businesses

Step 2: Move Parties, Stock Items and Prices

Customers and suppliers become contacts. Clean the list first, because every duplicate becomes a duplicate statement, aging line and follow-up. For each contact, bring across:

• the legal name, address and emirate, which Odoo stores as the state;
• the TRN, in the contact's VAT, or tax ID, field;
• payment terms, credit limits and bank details;
• the Tally ledger name as a reference.

Stock items become products, with category, unit of measure, barcode, prices, cost and VAT treatment.

Odoo's import tool reads Excel and CSV files, offers templates and has a Test button that checks a file before anything is written. Give every record an External ID built from its Tally name or code, so later files, such as open invoices and opening stock, can refer to it without ambiguity. Odoo's import documentation covers the options.

Step 3: Map UAE VAT before You Load a Single Invoice

In Tally, VAT behavior comes from details on ledgers and stock items, such as taxability, nature of transaction and rate, plus the TRN and emirate on each party ledger. In Odoo, it comes from taxes and fiscal positions. Map every combination you use to an Odoo tax, and test it with transactions from your last VAT period.

Odoo's UAE localization already includes the taxes the return needs: standard-rated sales taxes per emirate, because the return reports those supplies emirate by emirate, plus zero-rated, exempt, export, import and reverse charge taxes. Fiscal positions pick the sales tax from the emirate in the customer's address, and the Non-UAE position switches sales to zero rate and purchases to reverse charge. On the return, however, each supply is reported in the emirate of your establishment most closely connected to it, so check the emirate mappings against where your establishments are.

Two rules follow. A UAE customer imported without an emirate falls back to the Non-UAE fiscal position, so its sales are zero-rated instead of taxed at 5%; make the emirate a required column. And never charge VAT again on migrated documents: the VAT on open Tally invoices already sits in Tally's VAT ledgers and reaches Odoo through the opening entry.

Step 4: Choose the Cut-over Date

The cleanest cut-over is the first day of a financial year, then the first day of a VAT period. Splitting a VAT period means one return draws figures from two systems. The Federal Tax Authority (FTA) assigns each business its tax periods, and quarterly periods do not always follow calendar quarters, so check yours.

Then plan a short freeze around the date:

• Agree the last day for entries in Tally and the first day in Odoo.
• Pause new customers, suppliers and products for a few days, or log them for re-entry.
• Count stock on the cut-over date, with no movements during the count.
• Reconcile every bank account in Tally to the last day, including uncleared checks.
• Book closing adjustments in Tally first, such as accruals and depreciation.

You do not need an audited trial balance to go live. Load provisional balances, and post agreed audit adjustments later, on the same date as the opening entry.

Step 5: Load Opening Balances and Open Items

Opening balances come from Tally's trial balance at the close of the day before go-live. Enter them in the Chart of Accounts step of Odoo's Accounting onboarding, which offers opening debit and credit columns until an opening entry is posted and builds that entry for you, or import them as one journal entry dated the day before go-live.

Receivables and payables need more than a balance: Odoo must know each open invoice and bill, so payments, aging and follow-ups work from day one. Load one document per pending bill, with the partner, original number, invoice date, due date and amount still due in its original currency, against receivable and payable clearing accounts. In the opening entry, use the same clearing accounts in place of the receivable and payable balances, so both sides net to zero.

A Worked Example: One Customer, Four Open Items

Say Tally's ledger outstandings for one customer show three pending bills of AED 10,500, AED 4,200 and AED 2,100, the last one part-paid with AED 1,050 left, and an on-account receipt of AED 1,000. The customer owes AED 14,750.

In Odoo, that becomes three customer invoices for AED 10,500, AED 4,200 and AED 1,050, each with its Tally number and due date, and a journal entry crediting AED 1,000 to the customer's receivable against the clearing account, which Odoo shows as an outstanding credit on the open invoices. The balance is AED 14,750 in both systems, and the next receipt matches the right invoice.

Stock follows the same logic. Set each product's cost, then import the opening count by product, location and lot through the physical inventory screen. If Odoo values stock automatically, applying the count posts the stock value, so book that value once: through the count, with its counterpart pointed at a clearing account, or in the opening entry, never both.

If you used that onboarding step, look for an "Automatic Balancing Line" in the opening entry. Odoo adds one, on an Undistributed Profits/Losses account, when debits and credits do not balance. If it exists, something was missed.

Step 6: Tie out the Numbers before Go-Live

Go-live is a finance sign-off, not an IT milestone. Before anyone posts a new transaction, check each point and keep the evidence:

• Odoo's trial balance matches Tally's at cut-over, account by account.
• Receivables and payables match in total and partner by partner against Tally's ledger outstandings.
• Stock quantities match the count by product, location and lot.
• Stock value in Odoo's valuation report matches the inventory accounts and the figure finance approved.
• Input and output VAT balances match Tally's VAT ledgers.
• Each bank journal starts from the reconciled balance on the bank statement.
• Every clearing account is at zero, with no automatic balancing line.

Check stock value inside Tally too. If "Integrate Accounts with Inventory" was switched off, the closing stock in Tally's balance sheet was entered by hand and can differ from the stock summary. Settle the right figure, normally after the count.

Once finance signs off, set a lock date in Odoo Accounting at the day before go-live. An accounting administrator can still grant an exception for a late audit adjustment, so leave the irreversible hard lock date for later.

Step 7: Train Your Team on Odoo's Way of Working

Experienced Tally users are fast on the keyboard, so start training from what people already do:

• Sales and purchase vouchers become customer invoices and vendor bills, usually created from orders, deliveries and receipts rather than typed in.
• Receipts and payments become payments, matched to invoices and bank statement lines.
• Contra and journal vouchers become transfers between bank and cash journals, and miscellaneous journal entries.
• Credit and debit notes become credit notes and refunds linked to the original invoice or bill.

Train each team on its own process and data in the rehearsal database, give accountants extra time on bank reconciliation and plan support for the first month-end.

How Star Bit Solutions Can Help

Our OdooStar team moves businesses from Tally and other systems to Odoo within a full implementation. We extract and clean your Tally masters, map ledgers, parties, stock items and VAT, test-load everything into a copy of your database and reconcile the opening balances with your finance team before go-live, with a parallel run where it is worth it.

For a business moving up from Tally, Odoo Enterprise is usually the shorter road, with full Accounting and VAT reporting on top of Odoo's UAE localization. If Odoo Community covers your needs, we implement that too, and our Enterprise vs Community guide explains the difference. Trading companies can see our approach on the Trading and Commerce page.

Tell us which Tally product you run and when you want to go live, through the contact page, on +971 55 973 4524 or at [email protected], and we will outline a migration plan.