Tally accounting

I would have tried tally gateway-> display-> day books & inventory books to get condensed reports. 

Creating a consolidated financial manually is a nightmare. Not just efforts but potential risk of incorrect details due to omissions, errors etc. during data consolidation. This why most businesses have started using accounting software that allows you to manage the business efficiently and generating all the reports including consolidated financial statement automatically.

If you are using TallyPrime, consolidation of financial statements is an easy task at all times. Not just financial statement, you can consolidate complete books of accounts using group company feature. The concept is simple yet powerful that allows you to consolidate the accounts of any number of companies at any time and maintain them separately. All this in a few mins.

You can view consolidated balance sheet, profit & loss a/c, stock summary, ratio analysis, trial balance, cash/funds flow and much more.
Group company function as a single economic entity, where financial reports such as balance sheet, profit and loss a/c and trial balance are consolidated without any impact on the transactions and real-time basis.

Using the group company, you can compare the performance of your subsidiary companies and keep a tab on the overall business.

You should use create group company function by ALT+3 and create group company. After that you can access the consolidated accounts of group company and compare them also

If you consolidate, the output will be in excel I think and no special info on inventory, cost centres will be available. So best to use display menu.

Thank you for your valuable output. But is this feature available in tally erp 9?

 

Yes. I tried it once and the output was excel and just financial statements.

You should try Tally Prime for consolidation entries

the problem is both the tally backups are at different locations and doesn't have a server.

Ok... without server we can work... now I understood it is difficult during reporting.... then next best alternative is to copy data and receive it through mail.