Back to Blog|Tally Prime & Data Ops

How to Merge Two Tally Companies Data (Complete SOP)

July 24, 202610 min readAkib Husain

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

1. Group Company (Reporting Only)

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.

2. Permanent XML Data Merge

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

1
Phase 1: Backup & Feature Alignment

Take a full data backup of both companies. Align F11 features (GST settings, inventory, multi-currency) between source and target companies.

2
Phase 2: Export Masters & Daybook from Source Company

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.

3
Phase 3: Import into Target Company

Open Target Company. Go to Import > Masters > Select XML path > Choose 'Combine Opening Balances'. Then go to Import > Transactions > Select Daybook XML path.

4
Phase 4: Post-Merge Data Verification

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.

A
Akib HusainExpert Reviewer

Founder & Chief Architect of TrulyInvoice

Last Verified: July 24, 2026
TallyPrime FY 2026-27 (v4.0+)
Ready to save time?

Stop Manual Voucher Entry.

TrulyInvoice automates your complete invoice workflow and syncs directly to Tally Prime.

No credit card · 14-day free trial

01

Upload Invoice

Drag & drop PDFs, scans, or photos.

02

AI Extraction

Line items, tax, and ledgers mapped.

03

1-Click Review

Verify extracted details on dashboard.

04

Direct Sync

Vouchers created instantly in Tally Prime.

Chat with us