How to Split Data in Tally Prime – Step-by-Step Guide

Call CA Tally HelpDesk +91 9205471661, 8368262875

As your business grows, the size of your Tally Prime data also increases. Over time, large data files can slow down your system and make day-to-day operations less efficient. To maintain performance and ensure smooth accounting, Tally Prime offers a powerful feature called “Split Company Data.” This feature helps divide your company data into smaller, more manageable parts without losing any important information. Let’s explore how data splitting works, why it’s important, and the exact steps to perform it safely in Tally Prime.

Why Should You Split Data in Tally Prime?

There are several reasons why splitting company data can be useful:

1. Improved Speed and Performance: Large data files can make reports and ledgers load slowly. Splitting them improves response time.
2. Better Organization: You can maintain yearly data separately, such as 2023–24 and 2024–25, making it easier to find and analyze old records.
3. Reduced Risk of Corruption: Smaller data files are less likely to become corrupted or damaged compared to large data sets.
4. Compliance and Audit Convenience: It’s easier to provide specific financial year data to auditors or departments when each year is stored separately.

When to Split the Data

Generally, businesses perform a data split at the end of a financial year (31st March) before starting transactions for the new financial year (1st April). This ensures that all entries of the completed year are properly closed and the new year begins with clean, updated balances.

Tip: Always take a full backup before performing the split process. This precaution helps prevent accidental data loss.

Steps to Split Company Data in Tally Prime

Follow the steps below carefully to split data safely:

Step 1: Backup the Data

1. Open Tally Prime.
2. Go to Company → Backup.
3. Choose the drive and folder where you want to store the backup.
4. Press Enter to confirm.

Backing up ensures that your data is safe in case something goes wrong during splitting.

Step 2: Verify Data Before Splitting

1. Go to Gateway of Tally → Display More Reports → Statements of Accounts → Exception Reports.
2. Check for Unadjusted Forex Gains/Losses, Pending Bills, and Unlinked Vouchers.
3. Resolve all issues before proceeding.

This step ensures that the data is clean and error-free.

Step 3: Open Split Company Data Option

1. Go to Gateway of Tally → Alt + Y (Data) → Split Company Data → Select Company.
2. Select the company whose data you want to split.

Tally will now ask you to enter the period for which you want to split the data.

Step 4: Define Split Period

• Example: If your current financial year is 2023–24, then enter the split date as 31-03-2024.
  This will divide the data into two companies:
  • Company 1: From the start of the financial year to 31-03-2024
  • Company 2: From 01-04-2024 onwards

Step 5: Confirm and Execute Split

After confirming, Tally Prime automatically creates two separate companies with all ledger balances carried forward correctly. You can verify this by opening both companies and checking opening balances and reports.

Post-Split Verification

After the split:

1. Open both companies one by one.
2. Compare key reports like Trial Balance, Balance Sheet, and Profit & Loss Account for accuracy.
3. Check the new company’s opening balances—they should match the previous company’s closing balances.

Important Notes

• Splitting does not affect your original data; Tally creates new folders for each split part.
• Each split company can be used independently for accounting and reporting.
• Always maintain regular backups even after the split.

Conclusion

Splitting data in Tally Prime is an essential maintenance step that helps keep your accounting system optimized and organized. By dividing data based on financial years, you ensure faster processing, reduced risks, and cleaner records. Just remember to verify and back up your data before starting the split. With these simple steps, you can efficiently manage multi-year accounting records without compromising accuracy or performance.

Powered by Binarysoft Technologies
Authorized Tally Partner
Location : 1626/33, 1st Floor, Naiwala, Karol Bagh, New Delhi – 110005, INDIA
Contact us : +91 7428779101, 9205471661
Email us :  tally@binarysoft.com (10:00 AM – 6:00 PM, Mon–Fri)