How to Merge Two Tally Companies Data (Complete SOP)
How to Merge Two Tally Companies Data (Complete SOP)
Learn how to combine two Tally Prime company files. Create Group Companies for consolidated reports or export/import XML data without errors.
Who is this for: Tally Prime & Data Ops
Quick Answer: How to Merge Two Tally Companies into a Single File?
To permanently merge two Tally companies: (1) Take full backups of both companies. (2) From Source Company, export Masters (List of Accounts) and Transactions (Daybook) to XML format. (3) Load Target Company, go to Import > Masters (select 'Combine Opening Balances'), then Import > Transactions.
- Always import Masters XML before Transactions XML to prevent missing ledger errors.
- Group Company is recommended if you only need consolidated financial reports.
- Enable 'Retain Original Voucher No.' to prevent voucher numbering sequence conflicts.
- Run Alt+Y > Repair in Tally Prime if duplicate GUID or master errors occur during import.
Decision Guide: Group Company vs Permanent Data Merge
Keeps individual company files completely separate. Generates consolidated Profit & Loss, Balance Sheet, and Trial Balance reports. Ideal for separate branches or sister concerns with different GSTINs.
Combines all masters, ledgers, and transactions into a single Tally company file. Recommended when consolidating multiple legacy company files under the same GSTIN into a unified Tally Prime database.
3-Phase Standard Operating Procedure (SOP) to Merge Tally Data
Take a full data backup of both companies. Align F11 features (GST settings, inventory, multi-currency) between source and target companies.
Open Source Company. Go to Display > List of Accounts > Alt+E (Export) > XML format to export Masters. Go to Display > Daybook > Set period (Alt+F2) > Alt+E > XML format to export Transactions.
Open Target Company. Go to Import > Masters > Select XML path > Choose 'Combine Opening Balances'. Then go to Import > Transactions > Select Daybook XML path.
Compare Trial Balance and Daybook totals between merged target company and source files. Run Alt+Y > Repair if any orphan vouchers or duplicate GUID errors appear.
Automate Purchase Bill Booking in Your Merged Tally Company
Post verified vendor PDF invoices directly into Tally Prime via Port 9000 local sync.
After merging company data, TrulyInvoice AI keeps your consolidated purchase workflow fast and error-free. Upload vendor PDF invoices or WhatsApp scans. AI auto-extracts line items and posts verified F9 Purchase Vouchers directly into Tally Prime in 15 seconds.
Founder & Chief Architect of TrulyInvoice