We are your reliable technology Partner.
Have any questions? Call Now: +971 4 325 8361 / +971 55 347 5870
Have any questions? Call Now: +971 43 258 361
How to Split Company Data in TallyPrime: Manage Financial Years & Opening Balances
At the end of every financial year—whether concluding a 31st December calendar year common among UAE businesses, or a 31st March fiscal year for regional subsidiaries—finance managers and accountants face the critical question: what should we do with our historical company data in Tally? Handle this transition carelessly, and you risk corrupted opening balances, sluggish system responsiveness, audit friction, and tax discrepancies. Handled properly, your accounts transition into the new financial year clean, verified, and reconciled.
At year-end, businesses operating TallyPrime have three operational choices: continue within the same company and adjust the reporting period, create a clean company and import audited balances, or utilize Tally’s native data-split feature. If you are wondering how to split company data in Tally, this comprehensive technical guide explains every step of the process, complete with pre-split checklists, balance carry-forward rules, and vital troubleshooting tips.
10 Practical Sections
1. What Does “Split Company Data” Mean in TallyPrime?
The Split Company Data feature in TallyPrime divides a single company database containing multiple years of accounting history into distinct, self-contained company databases based on a selected split date.
For example, if your existing company contains transaction data spanning from 1st January 2024 to 31st December 2026, splitting the company on 1st January 2026 cleanly isolates FY 2024–2025 into an archived historical company while producing a fresh operational company for FY 2026 onwards.
In current releases (TallyPrime 6.0, 7.0 and modern releases), Tally gives you three splitting outputs:
- From Split Date: Creates a new company containing only records from the split date forward.
- Before Split Date: Creates a closed historical database containing transactions prior to the split date.
- Into Two Companies: Automatically produces both pre-split and post-split companies simultaneously.
2. Do You Need to Split Every Financial Year? (Decision Matrix)
A widespread misconception among accounting teams is that company data must be split at the end of every financial year. In reality, TallyPrime is designed to support seamless multi-year continuous accounting without forcing a data split.
Review this decision matrix to determine whether splitting is appropriate for your business:
| Operational Scenario | Recommended Approach | Strategic Rationale |
|---|---|---|
| Statutory audit is pending or in progress | Stay in the same company | Prevents having to back-port auditor adjustments into two distinct files. |
| Auditor year-end adjustments still expected | Change period (Alt+F2) | Maintains continuous ledger links while allowing adjustments. |
| Cross-year comparative reports needed | Keep continuous data | Enables immediate multi-year P&L and sales comparison screens. |
| Previous year books finalized & tax returns filed | Split company data | Archives completed records and locks historical books. |
| Database size large (>50,000 vouchers/year) | Split by financial year | Optimizes system speed, backup durations, and report rendering. |
| Management demands separate yearly entities | Split by financial year | Establishes clean yearly isolation for compliance and audits. |
3. Pre-Split Accounting Checklist & Groundwork
Splitting company data is not an alternative to closing your books. All statutory closing adjustments and ledger reconciliations must be finalized before initiating a split:
Book fixed asset depreciation, expense accruals, prepaid adjustments, bad debt provisions, and tax liabilities to lock accurate closing balances.
Ensure debit and credit totals match and verify that no unexplained “Difference in Opening Balances” exists.
Clear all unlinked cheque entries and ensure bank ledger balances precisely match audited bank statements.
Settle open purchase and sales bills. Resolve all unallocated “On Account” payments using Against Reference (Agst Ref).
Match book stock with physical warehouse counts and confirm closing stock valuation methods across all godowns.
Take a verified local and cloud backup (Alt+Y > Backup) to guarantee an immediate restore point before splitting.
4. How to Split Tally Company Data: Step by Step
In modern releases of TallyPrime (Release 6.0 and later), follow this standard procedure:
Take Full Backup
Go to Alt+Y (Data) > Backup. Store the company backup file on a secure secondary drive or cloud repository.
Verify Data Integrity
Navigate to Alt+Y (Data) > Split > Verify Data. Let Tally scan for voucher errors or orphan masters, and resolve any flagged issues.
Configure Split Date
Select Alt+Y > Split > Split Data. Choose your company, set the split date (e.g. 01-Jan-2026 or 01-Apr-2026), and pick your split mode.
Audit Opening Balances
Open the resulting child company. Open Trial Balance and Balance Sheet to verify opening numbers match previous closing figures.
5. How to Carry Forward Opening Balances in Tally
When you split data, TallyPrime automatically transfers closing balances from the old period into the new company as its opening balance figures across all balance sheet accounts:
- Asset & Liability Accounts: Cash, bank accounts, sundry debtors, sundry creditors, loans, and statutory duties automatically transfer their net closing balances into the new period.
- Profit & Loss Balance: Net profit or loss from the previous period is carried forward automatically into TallyPrime’s built-in Profit & Loss A/c ledger, which can subsequently be transferred to Capital or Retained Earnings via journal entry.
- Bill-Wise Outstanding Dues: Individual unpaid invoices are carried forward with their original voucher numbers, pending amounts, and agreed credit due dates.
6. Option 2: Start the New Year Without Splitting (Alt+F2)
If your statutory audit is still incomplete or your data volume is relatively modest, the simplest approach is to remain within the same company and simply update the accounting period:
- From Gateway of Tally, press Alt+F2 (Period).
- Enter the new financial year parameters:
- From:
01-01-2026(or01-04-2026) - To:
31-12-2026(or31-03-2027)
- From:
- Press Enter to apply.
TallyPrime automatically rolls all closing balances forward into the new period. You can configure fresh voucher numbering sequences for the new year (via Alter Master > Voucher Type > Restart Numbering on 1st January/April) without disturbing previous records.
7. Option 3: Create a New Company and Import Balances
For organizations seeking complete database renewal—such as companies migrating to a revised chart of accounts, restructuring cost centres, or implementing major ERP modifications—you can start a fresh company and import audited figures:
- Export Closing Masters & Balances: Export ledgers and closing balances from the historical company in XML format via Alt+E.
- Create Clean Entity: Create a new company master in TallyPrime with the new financial year start date.
- Import Data: Navigate to Alt+O (Import) > Masters and import the XML file.
- Review Configuration: Manually re-check company features (F11), VAT TRN parameters, corporate tax configurations, bank details, and voucher prefixes.
8. Things a Split Will NOT Carry Forward Automatically
A data split is a balance sheet carry-forward mechanism, not an unedited mirror copy. Be aware of these native operational constraints:
Orders are tracking vouchers that do not alter accounts or physical inventory balances. They do not carry forward post-split. Review and close open orders prior to splitting.
Cost centres serve purely as revenue/expense allocation tools rather than ledger accounts. Tally requires journal adjustments if opening cost-centre positions are required.
Depending on the reconciliation start date, historical un-reconciled bank transactions can be dropped. Always complete bank reconciliation before splitting.
Certain perpetual stock valuation methods (such as FIFO Perpetual) can calculate variances when disconnected from historical purchase batches. Verify stock valuations thoroughly.
9. Essential Year-End Closing Adjustments & Entries
There is no automated single “Year-End Button” in TallyPrime. Sound financial accounting requires recording standard closing adjustments before final balance freeze:
- Depreciation Posting: Debit Depreciation Expense and credit Accumulated Depreciation to write down fixed assets for the fiscal period.
- Prepaid Expenses & Accruals: Transfer prepaid commercial rent, insurance, and software subscriptions into current expense ledgers, while accruing unbilled utility or audit fee liabilities.
- Bad Debt Provisions: Assess your aged debtors report (over 90/180 days) and record provisions against non-recoverable accounts.
- Corporate Tax Provision: Calculate taxable net income under UAE Corporate Tax law and debit Corporate Tax Expense while crediting Corporate Tax Payable.
- Foreign Currency Revaluation: Run unadjusted forex gain/loss valuations on outstanding foreign currency bank and supplier balances.
10. Post-Split Audit Checks & Mistakes to Avoid
After executing a company split, conduct an immediate audit across the following areas to guarantee accounting continuity:
Confirm that total debit opening balances equal total credit opening balances with zero unallocated difference.
Verify each individual bank account and petty cash register against the audited closing statements.
Run Alt+G > Bills Receivable and Bills Payable to confirm every pending bill reflects its exact open balance and due date.
Avoid confusion by renaming entities immediately (e.g. ABC Trading LLC – FY 2024-25 (Archived) and ABC Trading LLC – FY 2026).
No. You can continue working in the same company by pressing Alt+F2 to update the reporting period. Tally carries forward opening balances automatically.
Use the first day of your new financial year. For calendar year businesses, that is 1st January; for April–March fiscal cycles, use 1st April.
No. It is best practice to complete statutory audits and post all audit adjustments first. Splitting before audit completion forces adjustments across two separate datasets.
Yes. Both when updating the period via Alt+F2 and when splitting data, Balance Sheet figures carry over automatically. Always verify them against closing reports.
Yes. Unsettled invoices are transferred as opening bill balances with their original voucher numbers, pending amounts, and due dates intact.
Yes. You can select the required historical split dates and execute the split process progressively to separate multiple fiscal years into distinct archives.
Need Expert Assistance with Year-End Closing or Data Splitting?
Chaturvedi Software House (CSH LLC) is an Official 3-Star Tally Partner in Dubai. Our certified team helps UAE businesses execute safe year-end splits, carry forward verified balances, and maintain audit-proof accounts.
Chaturvedi Software House (CSH) established in 2006 has been a trusted name in software solutions across the GCC region. Team CSH specializes in offering industry-specific software solutions that solve actual problems you are facing. Over the years, with a huge track record of our prestigious clients we have built a solid presence.
Quick Links
Contact Us
- Address: 513 Al Khaleej Centre, Bur Dubai Dubai U.A.E
- Call Us: +971 4 325 8361/ +971 55 347 5870
- Email Us: inquiry@ca-eim.com
- Copyright © 2024 Chaturvedi Software House LLC
- All Rights Reserved.