Add to Favourites

Split Data in TallyPrime

If you are currently handling a large volume of transactions in TallyPrime, it can be difficult for you to manage and share data. With the Split feature, you can create one or two new companies, as per your business needs to manage your data efficiently. 

Before proceeding with the Split feature in TallyPrime, it is recommended to verify your data and resolve the errors after data verification. 

Best Practices Before Splitting Data

For seamless splitting of your data in TallyPrime, you are recommended to follow certain best practices before splitting your data. 

• Ensure that the company books are finalised before proceeding with data split.
• If you are using multi-currency, make sure that all unadjusted forex gains/losses have been fully adjusted by recording journal entries.
• Check the Profit & Loss A/c and inventory statements and make sure that your purchase/sales bills are not pending. You have to account for them in the respective party ledgers or in the Sales Bills Pending report.
•  If you have tax compliance requirements,
  • Ensure that the complete transaction cycle, including the payments and filing of returns (TDS/TCS), is completed. Cross-check tax-related ledgers and reports for pending items.
  • Ensure that GST returns are filed and reconciled. Clear any mismatched entries in GSTR reports before splitting.
• After splitting your company, the original company will remain as it is. However, you can also take  backup of your data as required.
• Verify the company data to ensure that no errors occur during splitting.

Verify Company Data

1. Press Alt+Y (Data) > Split > Verify Data. 
   
2. Select the required company, and press Enter or select Yes to proceed.
   If any errors are identified, TallyPrime will prompt you to resolve the errors. You can refer to the List of Errors screen to resolve those errors. 
   

After completing the verification process, you can now proceed to split your data in TallyPrime.

Split Company Data

1. Press Alt+Y (Data) > Split > Split Data. 
   You will see a prompt to verify your data before splitting.
   
2. Press S or select Split to split data, if you have already completed your data verification.
3. In the Split Company Data screen, confirm the Split from date or enter a new date. 
   
4. In the Split Company field, select the appropriate option.
   1. From Split Date: To create a new company with data from the split date to the last entry date.
      
   2. Before Split Date: To create a new company with data from the first date of entry in the company till one day before the split date.
   3. Into Two Companies: To create one new company with data from the first date of entry in the company up to the day before the split date, and another new company with data from the split date to the final entry date.
5. Select Yes to accept.
   

During the data split, you can briefly see the progress bar. After the completion of data split, you can see the companies appearing under the NAME OF COMPANY in Gateway of Tally.