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
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
Comments
Post a Comment