Tally Trial Balance Consolidation Utility in excel

Hello Friends,
Financial Year has ended recently and many of the accounts & finance professionals are ready for preparing the Balance Sheets.

Many companies have operations at multiple locations and they prepare the accounts accordingly and at the end consolidate the data and prepare the Final Accounts.

Normally the trial balances of each locations are consolidated and on that basis the Profit & Loss Accounts & Balance Sheets are prepared.

Sometimes, the consolidation of Trial Balance is lengthy, tricky and difficult part for the accounts professionals although its a simple process of summarizing the transactions.

So I am sharing an excel utility where upto 10 nos of Trial Balances (Tally Generated) can be consolidated within a minute.


The Excel utility is self explanatory, but some basic points are mentioned here: -
1. You need to export Group Names of each locations from tally and paste in this file.
2. You need to export Trial Balance of each location from tally and paste here.
3. You need to ensure that the Net Value should be Zero (0) .
    Because Debit = Credit, i.e. Debit-Credit = 0 (Otherwise there are some diff in the Trial Balance)


Hope this excel file be useful for your accounts work.


Click Here the download the Excel File

Splitting the Data in Tally

Dear Friends,

One of my friend Piyush called me to know how to split the data. While telling him the ways to split the data, I thought that even if this is small and common thing for tally users, but then also there are so many peoples out there who find it difficult to split the same.

So here is the steps to split your tally data in easy ways: -

1. Open Tally

2. Select Company and login in the Company whose data needs to be splited.

3. At gateway of tally: - press Alt+F3,

4. Select "Split Company Data"

5. Then again select the Company

6. In option "Split from": "Select the data from which the data will be separated, usually, 1st of April YYYY"

7. After splitting the data, you will have 3 nos. of tally data files for that company. (i.e. 1st one will be your original data file, 2nd one will contain the data before the date of splitting and the 3rd one will contain the data on and after the date of your splitting)

Please note that you will not able to split the data for the data from which there is not transactions are entered.

Hope the above steps are easy to understand and useful to us.

In case of any query you can mail me at sharma.ctc@gmail.com