In this guide · 11 sections
- Excel is not the problem. For a handful of simple, recurring clients, a well-kept Excel template with a sign-off sheet can meet the documentation requirements. The question is where Excel starts to cost you time or control.
- The real differences are in control, not arithmetic: which trial balance version the statements came from, whether mapping carries forward, whether ties are checked every time, and whether the file shows who did what and who reviewed it (SA 230).
- Software does not change the law or the standards. Schedule III changes, applicability tests and file assembly within the time limit (ordinarily not more than 60 days after the report — SA 230, SQC 1) are your responsibility either way.
- Confidentiality is a professional duty under Clause (1), Part I, Second Schedule to the CA Act — whichever tool holds the data. Ask any vendor where data is stored, who can see it and how it is deleted.
- No software exercises professional judgement: materiality, the response to a risk, whether an explanation is good enough, and the opinion stay with the partner.
Try SignReady: Keep your Excel. Add mapping that carries forward, revised TB compare and FinalCheck.
Start freeMost small CA firms finalise accounts in Excel, and most of them do it well. A partner who has used the same template for fifteen years knows every formula in it. So when someone suggests "finalisation software", the honest question is not whether Excel is bad — it is what actually changes, what does not, and at what size of practice the change is worth the effort. This is a fair comparison, dimension by dimension, ending with a checklist you can apply to your own firm.
1. Trial balance versions
The first trial balance is rarely the last. The client's accountant passes provisions, reclassifies a loan, books depreciation — and sends a "revised TB", sometimes three times.
- In Excel: each version is a new file or a new sheet. Someone has to compare it with the earlier one, ledger by ledger, and carry the changes into the statements. With a few dozen ledgers this is manageable; with several hundred it is where a changed balance gets missed — or the statements quietly stay linked to the old file.
- With software: the usual approach is to upload the revised TB and list only what changed — new ledgers, removed ledgers, changed balances — and to rebuild the draft from the current version.
Where Excel is fine: small TBs, one revision, and a firm habit of naming files with dates and noting on the lead sheet which version the statements were drawn from.
2. Mapping, year after year
Mapping ledgers to Schedule III lines is mostly the same work every year for a recurring client. In Excel, it usually lives in a lookup column or a mapping sheet copied from last year's file. That works until the client renames ledgers, adds a new group in Tally, or the staff member who built the lookup leaves.
Software that remembers the mapping per client — including for renamed ledgers — turns year two onwards into reviewing the exceptions rather than re-mapping everything. The gain is small in the first year and grows with each recurring client.
3. Tie-outs and formula errors
Spreadsheet errors are a well-known risk in any finance work, and finalisation files are no exception. The common forms are familiar to anyone who has reviewed a junior's file:
- a typed number over-writing a formula in a note;
- a SUM range that misses a row inserted later;
- a link to last year's file or an old TB;
- a "difference" parked in other current liabilities to make the balance sheet balance;
- a note reference on the face pointing to the wrong note after renumbering.
Excel can catch these — with check cells (note total minus face figure, balance sheet difference, profit vs movement in surplus) that someone actually looks at. The difference with software is mainly consistency: the same checks run on every file, every time, instead of depending on whether this year's template still has its check row.
SignReady works alongside Tally and Excel: upload the TB, keep last year's mapping, compare a revised TB, raise review points and client queries, and get an editable Excel draft of the statements linked by formulas. First 3 finalisations free.
4. Applicability decisions
Is the company small this year? Does CARO 2020 apply? Is a cash flow statement required? Can the IFC reporting exemption be used? Does Rule 11(g) need reporting? These depend on thresholds and facts that change — the small company limits themselves changed from 1 December 2025.
In Excel, applicability is usually a checklist or a memory. Software can work out the tests from the trial balance and your answers and show the reason. Either way, the decision is the partner's, and the file should show what was decided and why — the facts behind a "not applicable" are as much a judgement as anything else in the audit.
5. When the format changes
Schedule III is amended from time to time. The amendment by G.S.R. 207(E), effective from 1 April 2021, is the clearest example: it added, among other things, ageing schedules for receivables and payables, the shareholding of promoters, and ratios with explanations for large variances. Firms working in Excel had to rebuild their templates that year — and an old template can easily carry the old format into the next season.
With software, someone else updates the format, but you still have to check that the update has been made and that it is correct for your client. Neither approach removes the need to read the amendment.
6. Review trail, queries and file assembly
This is where the difference is largest, because it is about documentation rather than arithmetic.
| Requirement | What it asks | Excel | Software |
|---|---|---|---|
| SA 230, para 9 | Record who performed the work and when it was completed, and who reviewed it, when and the extent of review | Initials and dates typed on each sheet or a sign-off sheet — works if done consistently | Usually recorded when a step is completed or reviewed |
| SA 220, para 17 | The engagement partner, on or before the report date, reviews the documentation and is satisfied the evidence supports the report | Partner reviews files and emails | Partner reviews open points and sign-off in one place |
| SA 230, para 14 and A21; SQC 1, para 75 | Assemble the final file on a timely basis — ordinarily not more than 60 days after the report date | Collect workings from desktops, emails and WhatsApp | Much of the file is already in one place, but you still assemble and keep it |
| SQC 1, para 79 | Controls that show when and by whom documentation was created, changed or reviewed, and prevent unauthorised changes | Hard to show for Excel files passed around by email or pen drive; possible with a shared drive that keeps version history and access rights | Depends on the product — ask |
Client queries are the same story. In Excel and WhatsApp, a query list is usually re-typed, and replies come back across chats and email threads; tracking which are open takes effort. Software that turns review points into a query list and brings replies back into the file mainly saves chasing — the query still has to be well framed, and the reply still has to be evaluated.
7. Data security and confidentiality
A chartered accountant in practice is guilty of professional misconduct under Clause (1), Part I of the Second Schedule to the Chartered Accountants Act, 1949, if he discloses information acquired in the course of a professional engagement to anyone other than the client without the client's consent, or otherwise than as required by law. SQC 1 also asks firms to maintain the confidentiality, safe custody, integrity, accessibility and retrievability of engagement documentation.
That duty is the same for an Excel file on a laptop and for data in a cloud service. Excel files emailed to personal accounts, saved on pen drives or shared in WhatsApp groups carry their own risk. For any software, ask: where is the data stored, who at the vendor can see it, can a client's accountant see your materiality and review points, and how is data deleted when you stop using it?
The Digital Personal Data Protection Act, 2023 is relevant where client files contain personal data about individuals. The Act and the DPDP Rules were notified in November 2025 and come into force in phases; most obligations of a Data Fiduciary, including section 8, are due to apply only after an 18-month period, from May 2027. Under section 8, a Data Fiduciary stays responsible for processing done on its behalf by a Data Processor and may engage one only under a valid contract — so check what the vendor offers before you upload.
8. Cost, learning curve — and what software will not do
Excel costs nothing extra, and everyone already knows it. Software costs a subscription and some learning time, and it is only worth it if the team actually uses it on every file. A tool that sits alongside Tally and Excel and keeps the output editable is easier to adopt than one that requires moving all work into a new system.
Be clear about the limits. No software decides materiality, judges whether a management explanation is supported by evidence, evaluates a going concern doubt, chooses between a qualified and an unmodified opinion, or takes responsibility for the report. It can make the file cleaner and the review faster; it cannot make the judgement better. A drafted CARO clause or audit report is a draft until the partner has decided every answer.
A decision checklist
| Excel is usually enough when… | Software usually pays off when… |
|---|---|
| You finalise a small number of files a year, mostly yourself | Staff prepare and the partner reviews many files in the same season |
| TBs are short and rarely revised | Revised TBs are routine and ledgers run into hundreds |
| Your template has working check cells and someone reviews them | Ties and note totals are checked only when someone remembers |
| The file already records who prepared and who reviewed, with dates | The review trail lives in emails and memory |
| Client queries are few and handled in one thread | Queries are chased across WhatsApp, email and calls |
| Your template is updated when the law changes | Templates differ from staff to staff and year to year |
A practical way to decide: run three real files of different sizes through a tool alongside your Excel process, and compare the time spent, the errors caught and how easy the partner's review was. If nothing changes, stay with Excel — and make sure the template has its check cells and sign-off sheet. If the review gets faster and the file tells its own story, the subscription is cheaper than the partner's time.
Try SignReady: Review points, client queries and Partner sign-off in one file per client and year.
Start freeFrequently asked questions
Is Excel acceptable for audit working papers and financial statements?
Yes. SA 230 allows documentation on paper or in electronic form. What matters is that the file is sufficient for an experienced auditor with no previous connection to understand the work, shows who performed and reviewed it with dates, and is assembled and retained as SA 230 and SQC 1 require.
Does finalisation software reduce the auditor's responsibility?
No. The auditor's responsibility for the work and the opinion is the same whatever tool is used. Software can check arithmetic, carry forward mapping and organise the file; materiality, risk responses, evaluation of evidence and the opinion remain the partner's judgement.
Is it safe to upload client trial balances to cloud software?
Confidentiality is your professional duty under Clause (1), Part I, Second Schedule to the CA Act, whichever tool you use. Before uploading, check where the data is stored, who can access it, whether it is encrypted, what contract applies and how it is deleted.
Within how many days should the audit file be assembled?
SA 230 requires the final audit file to be assembled on a timely basis after the report date; its application material and SQC 1 say an appropriate time limit is ordinarily not more than 60 days after the date of the auditor's report.
When does software pay off for a small CA firm?
Usually when several staff prepare files for partner review, trial balances are revised often, recurring clients make mapping reuse worthwhile, and the review trail and client queries are currently spread across email and WhatsApp.
Sources
- ICAI — SA 230 Audit Documentation
- ICAI — SA 220 Quality Control for an Audit of Financial Statements
- ICAI — SQC 1 Quality Control for Firms
- Schedule III amendment — G.S.R. 207(E), 24 March 2021 (Gazette)
- Small company limits — G.S.R. 880(E), 1 December 2025 (Gazette)
- The Chartered Accountants Act, 1949 — Second Schedule, Part I, Clause (1)
- PIB — Government notifies DPDP Rules (14 November 2025)
- The Digital Personal Data Protection Act, 2023 (MeitY)
- PIB — DPDP Rules, 2025 notified
In SignReady, the TB, mapping, CY vs PY review, client queries, draft statements, FinalCheck, CARO and report drafts and Partner sign-off sit in one finalisation — and the output is still Excel and Word you can edit. First 3 finalisations free, no card.
Audit and accounts updates, practical tips and knowledge: join the Audit and Accounts Update group on WhatsApp.
Version history: 14 Oct 2026 — first published.
