Import Tally Exports Or Excel
Bring in current and previous year trial balance data exported from Tally or kept in Excel. Almost 90% of routine ledgers map automatically; the share varies by company.
All products
Excel Tool
Advanced Corporate Balance Sheet Tool
Company financial statements, straight from the trial balance.
Preparing accounts for a proprietorship or partnership firm? See the Non-Corporate Entity Balance Sheet Tool
Notes
Profit and loss
Balance sheet
Import Tally exports or Excel
Mapping you review
Corporate disclosure inputs
Validated before export
PDF or Excel
- Import Tally exports or Excel
- Mapping you review
- Corporate disclosure inputs
- Validated before export
- PDF or Excel
Capabilities
From trial balance to the full report pack
Prepare a company's Balance Sheet, Statement of Profit and Loss, notes and fixed asset schedule from trial balance data exported from Tally or kept in Excel, with comparative figures and export to PDF or Excel.
Mapping You Review And Correct
Every ledger's current and previous year mapping stays visible, with sign and validity checks, so exceptions are corrected before any statement is built.
Shareholders' Funds And Fixed Assets
Share capital and reserves come from the mapped trial balance with the profit movement linked, and each asset class takes its opening gross block, additions, deductions and depreciation.
Corporate Disclosures
MSME status for each supplier, trade receivables ageing and borrowings due within one year, each in its own input screen and carried into the notes.
Two Notes Layouts
Ledger detail inside each note, or Balance Sheet notes at subgroup level with a separately numbered grouping annexure. Only notes with a balance are numbered.
Snapshot And Validation
Major figures with year on year movement, and checks for the Balance Sheet difference, equity, fixed asset and depreciation tie-ups and unmapped ledgers before export.
Saved Settings, PDF Or Excel
A divisor from rupees to crores, a one page or multi page Balance Sheet, current year or comparative figures and Final or Provisional headings, applied to every export.
Screenshots
A look inside
Screens6
Inputs & disclosures5
Reports & print output8
FAQ
Frequently asked questions
Who is the Advanced Corporate Balance Sheet Tool for?
CA firms, audit teams and corporate accounts departments that prepare financial statements for companies, starting from a trial balance exported from Tally or kept in Excel. For proprietorships and partnership firms, the Non-Corporate Entity Balance Sheet Tool is the one to use.
Does it work with Tally?
Yes, through Tally's exported data. It does not connect to Tally directly: export the current and previous year trial balance from Tally, or use an Excel trial balance, and import that. Ledgers are then mapped to the corporate statement heads, and you review and correct the mapping before reporting.
How much of the mapping is automatic?
Almost 90% of routine ledgers, such as bank, debtor, creditor and tax ledgers, are classified automatically. That is an indicative level, not a guarantee: it varies with each company's ledger names and trial balance structure, and unusual ledgers, statutory balances and disclosure categories still need your review.
What does it produce?
The Balance Sheet and Statement of Profit and Loss with comparative figures, the notes, the fixed asset schedule with gross block, depreciation and net block, and optionally a separately numbered Balance Sheet grouping annexure, exported to PDF or Excel. A Financial Snapshot and validation checks help you review it before issue.
Does it calculate depreciation?
No. You enter each asset class's opening gross block, additions, deductions and depreciation in the fixed asset input, and the tool builds the schedule from them and checks that the net block and depreciation agree with the Balance Sheet and Profit and Loss.
Can I choose the presentation?
Yes. Report settings cover the reporting divisor from rupees to crores, ledger detail inside the notes or a separate grouping annexure, a one page or multi page Balance Sheet, current year only or comparative figures, and Final or Provisional headings, and every export follows the saved settings.
Is it an ICAI product?
No. It supports the preparation and presentation of corporate financial statements, but it is not an ICAI product, certification or endorsement, and it does not replace the Accounting Standards, Schedule III requirements or professional judgement.
What are the requirements and licensing?
Windows with Microsoft Office. A single-PC perpetual license that works fully offline after a one-time activation.
Buying more than one?
Save on every product, plus an extra 10% off orders of ₹24,999 or more.