How to Split Company Data in TallyPrime

Splitting company data in TallyPrime creates a new independent company from an existing one, copying selected masters and transactions. Always back up before splitting via Gateway of Tally > Backup, then use Gateway of Tally > Company Info > Split Company to begin the process.

What Is Splitting Company Data in TallyPrime?

Splitting company data is a feature in TallyPrime that allows you to separate one company's financial records into two independent companies. When you split, TallyPrime copies the original company's chart of accounts, cost centers, ledgers, and transaction history to a new company entity. The original company remains unchanged, giving you a complete duplicate to work with. This is different from creating a brand-new company from scratch, because the new company inherits all the masters and historical data you select.

When Should You Split Company Data?

There are several real-world scenarios where splitting company data makes sense. If your business divides into two separate legal entities, you can split the data to give each entity its own accounting records. If you need to test changes or reorganize your chart of accounts without affecting live data, splitting lets you work on a copy. Partnership splits, branch separations, and subsidiary formations all benefit from this feature. You might also split if a company restructures and needs to isolate certain divisions into independent profit centers with their own books.

Backup Your Data Before Splitting

Before you split any company data, create a full backup. This is non-negotiable. A backup protects you if something goes wrong during the split process, and it gives you a recovery point if you need to undo changes. In TallyPrime, go to Gateway of Tally > Backup or press Alt+B. Choose the company you want to split, then select the backup location. TallyPrime will create a .xml or .bak file with all your data. Store this backup on an external drive or cloud storage. If you use Tally data backup regularly, you already have a safety net; if not, start now. After the split is complete, back up again to preserve both the original and the new company.

Understanding the Split Company Data Menu Path

To split company data in TallyPrime, follow this exact menu path: Gateway of Tally > Company Info > Split Company. Some versions may show this under Gateway of Tally > Utilities > Split Company. If you cannot find it, press F1 (Help) and search for "Split Company" in the Troubleshooting section. The menu structure depends on your TallyPrime version and whether you are running Silver (single user) or Gold (multi-user on LAN). If you are unsure of your version, go to Gateway of Tally > Help > About TallyPrime to confirm.

Step-by-Step: How to Split Company Data

Here is the exact process to split company data in TallyPrime:

1. Open TallyPrime and select the company you want to split from the company list.
2. Press Alt+G (Gateway of Tally) or click the Gateway menu.
3. Navigate to Company Info > Split Company (or Utilities > Split Company, depending on version).
4. Enter the name of the new company you are creating.
5. Confirm the financial year start date and closing date for the new company.
6. Review the masters and transactions that will be copied. TallyPrime will show you a list of ledgers, cost centers, and stock items to include.
7. Select which ledgers and masters to copy to the new company. You can exclude certain items if they should not appear in the split company.
8. Choose whether to copy opening balances and transaction history. Most users copy everything to maintain a complete historical record.
9. Click Proceed or Confirm. TallyPrime will begin the split process.
10. Wait for the process to complete. Do not close TallyPrime or interrupt the operation.
11. Once complete, back up both companies immediately using Alt+B.

Worked Example: Splitting a Trading Company

Let's say you own Global Traders Ltd., a wholesale business with annual turnover of Rs 50 lakhs. Your company has 15 ledger accounts (suppliers, customers, bank, cash, capital, loan), 3 cost centers (Delhi, Mumbai, Bangalore), and 2 years of transaction history (2023-24 and 2024-25). You decide to split the business: Delhi branch becomes an independent entity called Global Traders Delhi Pvt Ltd.

Data Element	Original Company	Split Company (Delhi)
Company Name	Global Traders Ltd	Global Traders Delhi Pvt Ltd
Financial Year	2024-25 (Apr 2024 - Mar 2025)	2024-25 (Apr 2024 - Mar 2025)
Ledger Accounts Copied	All 15	All 15 (with adjusted opening balances)
Cost Centers	Delhi, Mumbai, Bangalore	Delhi only (or all, then filter)
Transactions Copied	All 2023-24 and 2024-25	All 2023-24 and 2024-25 (filtered by cost center)
Opening Balance (as on Apr 1, 2024)	Rs 25,00,000	Rs 8,50,000 (Delhi share only)

You go to Gateway of Tally > Company Info > Split Company, enter "Global Traders Delhi Pvt Ltd" as the new company name, confirm the financial year, and select all masters. TallyPrime copies all ledgers, cost centers, and transactions. You then manually adjust the opening balances in the new company to reflect only Delhi's share of assets and liabilities. After the split, both companies are independent: Global Traders Ltd continues with all three branches, and Global Traders Delhi Pvt Ltd operates as a standalone entity with its own books.

Choosing Which Masters and Transactions to Copy

When you split company data, TallyPrime asks which masters (ledgers, cost centers, stock items, units) and transactions to include in the new company. You have flexibility here. If you want a complete duplicate, copy everything. If you want a partial split, you can exclude certain ledgers or cost centers. For example, if you are splitting a company and one division should not have access to certain supplier accounts, you can leave those ledgers out of the new company. Transactions are usually copied in full to preserve audit trails and historical accuracy. If you copy only recent transactions, you lose opening balances and prior-year data, which complicates GST reconciliation and financial reporting.

Adjusting Opening Balances After Splitting

After the split is complete, the new company inherits the original company's opening balances. These balances may not be correct for the split entity. For example, if you split a company into two divisions, each division should have only its share of assets and liabilities. You will need to adjust the opening balances in the new company to reflect this division. Go to Gateway of Tally > Ledger Masters > Alter, select each account, and update the opening balance as of the split date. This ensures the new company's financial statements are accurate from day one.

GST Implications of Splitting Company Data

If your company is GST-registered, splitting company data has GST implications. The new company is a separate legal entity and may need its own GST registration, depending on Indian tax law. Before you split, consult your CA or tax advisor about GST registration requirements. In TallyPrime, you can enable GST separately for each company by pressing F11 (Features) and enabling GST under Tax. Once GST is enabled, you can file GSTR-1 (outward supplies) and GSTR-3B (monthly return) for each company independently. If you need help with Tally data synchronization across multiple GST-registered entities, contact a Tally 3 Star Certified Partner.

Handling Multi-User Scenarios with TallyPrime Gold

If you are using TallyPrime Gold (unlimited users on LAN, ~Rs 67,500 + 18% GST), splitting company data works the same way, but all users on the network see the split immediately. When you split a company in Gold, the new company appears in the company list for all connected users. Ensure all users log out before you start the split process to avoid conflicts. After the split, users can select either company from the login screen. If you need to split data across multiple offices or remote locations, consider TallyPrime on Cloud, which offers secure RDP access from Windows, Mac, Linux, Android, and iOS with ~99.9% uptime and daily backups.

Verifying the Split Was Successful

After splitting company data, verify that both companies are intact and correct. Log out and return to the company list. You should see both the original company and the new split company. Open each company and check the following: opening balances match expectations, all ledgers and cost centers are present, transaction count is correct, and GST settings (if applicable) are enabled. Run a trial balance in each company to ensure debits equal credits. If anything looks wrong, restore Tally data from the backup you created before the split, then try again.

When to Use Data Repair After Splitting

In rare cases, a split operation may leave data inconsistencies, such as orphaned transactions or broken ledger links. If you notice errors after splitting, use TallyPrime's data repair feature. Press Alt+Y (Data) > Repair, or go to F1 (Help) > Troubleshooting > Repair. Back up first, then run the repair. The repair tool scans for and fixes common data issues. If repair does not resolve the problem, contact a Tally 3 Star Certified Partner who can perform deeper Tally data repair or help you migrate Tally ERP9 to TallyPrime if you are upgrading from an older version.

TSS and Support for Split Company Operations

Tally Support Services (TSS) is a yearly subscription that keeps your TallyPrime installation updated with the latest features, bug fixes, and regulatory changes. If you are planning to split company data, ensure TSS is active. TSS costs Rs 4,500 per year for Silver (single user) and Rs 13,500 per year for Gold (multi-user), plus 18% GST. Every new TallyPrime licence includes 1 year of TSS free. Early TSS renewal adds approximately 1 free month; 2-year renewal offers approximately 10% discount. After TSS expiry, TallyPrime continues to work, but you will not receive updates or access to connected services like e-invoicing and GST reconciliation. For split company operations involving GST or e-invoicing, active TSS is essential.

Best Practices for Splitting Company Data

Follow these best practices when splitting company data: (1) Back up before and after the split. (2) Inform all users that a split is happening; schedule it outside business hours if possible. (3) Document which ledgers and cost centers belong to which split company. (4) Adjust opening balances immediately after the split to ensure accuracy. (5) Run trial balances and reconcile GST data (if applicable) in both companies. (6) Test reports and exports in the new company to confirm everything works. (7) Keep the original company as a reference or archive if needed. (8) Use auto-backup in Tally to protect both companies going forward.

Cloud Hosting for Split Companies

If you have split companies across multiple locations or want centralized management, TallyPrime on Cloud is an option. Bring-your-own-licence hosting starts from approximately Rs 175-290 per user per month; hosting with licence included is approximately Rs 899-1,299 per month. Cloud hosting includes secure RDP access from any device, ~99.9% uptime, and daily automatic backups. You can manage multiple split companies from a single cloud instance, and all users access the same data in real time. This is ideal for companies that have split geographically or organizationally.

Splitting company data in TallyPrime is a powerful way to separate financial records when your business grows or restructures. The process is straightforward if you follow the menu paths, back up before and after, and adjust opening balances correctly. Whether you are using TallyPrime Silver (single user, ~Rs 22,500 + 18% GST) or Gold (unlimited users on LAN, ~Rs 67,500 + 18% GST), the split feature works the same way. If you need expert guidance on splitting company data, managing multiple entities, or ensuring GST compliance across split companies, contact Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, serving businesses since 2010. Reach out via WhatsApp at +91 75469 00951 to discuss your split company requirements and get a free consultation.