What the file contains
Finalise writes the standard trial-balance import workbook (.xls) that CompuTax and CompuBal read. It has the same sheets and columns as the import format, filled in for you:
| Sheet | Filled with |
|---|---|
| Accounts | The trial balance: every ledger with current-year and previous-year amounts, each split into Dr and Cr. |
| Ledger | Every ledger with its parent group, matched to a group name CompuTax recognises. |
| Groups | Your company's own groups and where each one sits, on top of Tally's built-in groups. |
Why the group matching matters
CompuTax only understands its own list of built-in group names, and Tally companies spell them in different ways ("Duties & Taxes" or "Duties and Taxes", renamed or nested groups, custom groups under primary ones). Finalise walks each ledger up its group tree and writes the group name CompuTax expects, so the import doesn't stop on an unknown group.
Both years, already checked
The amounts come from the same pull as the financial statements, so every ledger has already been proved against Tally's own closing balance. Previous-year figures come from the previous year in Tally (or from the separate company you chose for it), not from last year's spreadsheet.
How to make it
- Open the client's company in TallyPrime.
- In Finalise, choose the company and pull. This takes minutes even for large books.
- Go to Export and choose CompuTax. Save the .xls file.
- Import it in CompuTax or CompuBal as you normally would.