Key answer: one export action still needs one controlled release
Generate each format from the same approved financial-statement dataset and identify the resulting files as one release. Formula-linked Excel, editable Word and print-ready PDF serve different purposes. A correct spreadsheet total does not prove that a Word table uses the latest figure or that a PDF includes the complete note. An export button can reduce preparation work, but it cannot establish the reliability of an independently edited copy.
This article focuses on the handoff between formats for an Indian company applying Schedule III Division I. It does not claim that a specific software version currently provides every format, live links between exported files or identical pagination. Sources were checked on 22 October 2026. The controls below are practical preparation procedures, not additional statutory forms or a substitute for the applicable accounting and audit work.
Separate the reporting requirement from the file format
Schedule III governs the content and presentation of the financial statements. Its statutory text includes note cross-references, comparative information and a consistent measurement unit. Excel, Word and PDF are delivery formats; none is, by extension alone, a declaration that the statements are complete. The statutory Schedule III text is reproduced in Annexure A of the ICAI Division I publication. Establish the applicable financial statements and notes before defining the export package.
Use a release register recording company, year-end, division, standalone or consolidated scope, currency, rounding unit, adjustment cut-off, preparation version and filenames. Choose one approved source for the numbers and retain a change log. If a recipient changes a Word figure or an Excel input after release, assess the change and regenerate all affected outputs from the controlled source.
Test a formula-linked workbook as a calculation file
A workbook is formula-linked when relevant totals depend on supporting inputs or workings through functioning formulas. A pasted value can be accurate on export day but does not respond to a later input change. In a disposable copy, change a relevant input and trace the effect through the note, main statement and applicable checks. Restore the file or discard the test copy. A formula count alone cannot show that the formulas point at the correct accounts or year.
Microsoft explains Excel recalculation as dependency-based calculation and describes manual and automatic triggers. Confirm calculation settings and recalculate before treating displayed values as the release values. Updating an input without updating dependent results can produce a visually plausible but stale export. These Excel behaviours do not mean an independently exported Word or PDF updates automatically.
Review the editable document and the rendered PDF separately
Inspect actual tables, comparative columns, note numbering, policies, page headers, footers and signature areas in the editable document. A text change can alter wrapping and move a signature or table onto another page. Then inspect the rendered PDF page by page for omitted rows, clipped columns, unreadable text and unintended blank pages. Match content and amounts; do not treat equal page counts as proof of agreement.
Use a compact release comparison containing total assets, total equity and liabilities, profit before and after tax, key note totals and the closing cash-flow balance where applicable. Add a sample of sensitive details, such as a related-party disclosure or signing date. Differences must be explained as authorised content changes, intentional formatting or genuine display rounding, rather than dismissed as an export issue.
Worked illustrations
The following cases use fictional figures and stated assumptions. Amounts are Indian rupees unless a different unit is expressly shown. They illustrate preparation controls and do not represent real client results.
Illustrative example 1: an adjustment updates only one format
The approved profit before tax is ₹18,00,000. A supported additional expense of ₹1,25,000 reduces it to ₹16,75,000 before consequential tax effects. If Excel shows ₹16,75,000 while the Word and PDF copies show ₹18,00,000, their stale difference is ₹1,25,000. Recalculate and regenerate the affected package. This case does not calculate the company's tax charge.
Illustrative example 2: a pasted PPE value fails the change test
A simplified PPE working has opening carrying value ₹20,00,000, additions ₹5,00,000 and depreciation ₹2,00,000, with no disposals or other movements. Closing carrying value is ₹23,00,000. In a test copy, increase additions by ₹50,000 while holding the stated depreciation assumption fixed. The result should become ₹23,50,000 wherever linked. A main-statement value remaining ₹23,00,000 identifies a broken or absent dependency.
Illustrative example 3: the comparative year is copied incorrectly
Current-year revenue is ₹72,00,000 and the approved comparative is ₹60,00,000. An export copying the current-year column into both years overstates the comparative by ₹12,00,000. The correct increase is ₹12,00,000 ÷ ₹60,00,000 = 20%. A zero-growth comparison indicates the duplication even though each statement may still balance.
Illustrative example 4: a unit mismatch creates a hundredfold error
An exact bank balance of ₹8,40,000 is 8.40 lakh or 840.00 thousand. Copying 840.00 into a column labelled ₹ lakh represents ₹8,40,00,000, which is 100 times the intended balance. Preserve both the number and its unit when comparing exports.
Illustrative example 5: a note total is not the displayed line sum
Three independently rounded note lines are 1.23, 2.34 and 3.46 lakh, totalling 7.03 lakh. A main statement showing 7.30 lakh differs by 0.27 lakh, or ₹27,000. First reconcile the exact underlying amounts; the discrepancy is not automatically justified by the fact that the files use rounded units.
Illustrative example 6: a duplicated export page duplicates an amount
The approved payable note contains three supplier-group totals of ₹4,00,000, ₹3,00,000 and ₹2,00,000, totalling ₹9,00,000. If a copied Word row repeats the ₹2,00,000 group and the document total is recomputed, the result becomes ₹11,00,000. The ₹2,00,000 excess is a document duplication, not a new accounting liability.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Freeze the approved numerical dataset and adjustment cut-off. | Dated source version and adjustment list. |
| 2 | Identify company, year, division and reporting scope. | Matching particulars in all files. |
| 3 | Check exact-amount statement and note reconciliations. | Reconciled working totals. |
| 4 | Recalculate Excel and inspect material formula dependencies. | Recalculation result and a restored/disposable change test. |
| 5 | Review external links and retained source references. | List of intentional links and resolved missing references. |
| 6 | Match current and comparative figures across formats. | Release comparison with approved prior-year figures. |
| 7 | Match units and documented rounding. | Consistent labels and explained display differences. |
| 8 | Review Word notes, policies and signatures after editing. | Complete editable-document review. |
| 9 | Inspect every PDF page at readable scale. | Resolved clipping, omission and pagination findings. |
| 10 | Archive and distribute one identified release. | Versioned filenames and release record. |
Sixteen practitioner FAQs
1. Does one-click export mean every file remains linked?
No. Establish the actual software behaviour. A generated Word or PDF is commonly a snapshot unless the product expressly provides a maintained link.
2. How can I distinguish formulas from pasted totals?
Inspect the relevant cells and trace their references. Test a meaningful input change in a disposable copy rather than relying on a formula-count badge.
3. Is recalculating Excel enough to refresh Word?
No. Verify how Word was created. Recalculate the workbook and regenerate or deliberately update the document through its supported process.
4. Can a client edit the Word file?
Editability permits changes, but a changed financial figure should go back through the controlled preparation and review process before a replacement release is issued.
5. Must all three files have identical page counts?
No. Workbook print settings and document layouts can differ. The released content, amounts, notes and intended presentation must agree.
6. Can I accept equal balance-sheet totals as proof?
No. Equal totals can hide a missing disclosure, a duplicated comparative, wrong units or offsetting errors.
7. Should I compare rounded or exact values?
Reconcile exact source values first and then compare their displayed units and precision. Keep a reasoned explanation for any display-only difference.
8. What if the PDF looks right but the Word file clips a column?
Correct and rerender the editable file if it forms part of the deliverable. One good format does not repair the other.
9. Can I hide an unfinished note before export?
Determine whether it is applicable and complete it where required. Hiding a page is a layout action, not a conclusion that the disclosure is unnecessary.
10. How should last-minute adjustments be handled?
Update the approved source, assess related tax and disclosure effects, and regenerate all affected formats under a new identified version.
11. Does this require macros?
No. The controls can be implemented with ordinary formulas, a release comparison and document review. Do not enable a macro merely because a file requests it.
12. Can a PDF be the master for the next revision?
Retain the approved preparation source as the controlled working. Editing a PDF independently can make later reconciliation harder.
13. Should signatures be checked only on screen?
Check the final rendered pages too. Wrapping, a font substitution or an extra row can move the signature area.
14. Are spreadsheet error cells acceptable if the PDF shows numbers?
Investigate them. A rendered number can be stale or disconnected from the affected calculation. Resolve relevant source errors before release.
15. Does the checklist establish statutory compliance?
It checks the consistency of the export package. Completeness, recognition, measurement and applicable statutory requirements need their own work.
16. What is the minimum useful release record?
Record the entity, period, source version, approval cut-off, units and actual output filenames, together with any authorised changes after release.
Practical use with assureFinancials
Use this working alongside assureFinancials and the assureOffice tools. Confirm the import fields and export options actually available in your version before selecting the workflow. A file-based handoff does not itself establish a native integration, automatic legal compliance or the completeness of the supporting disclosures.
Conclusion
Release the Excel, Word and PDF as one reconciled package. Keep the calculation source traceable, rerun affected outputs after changes, and inspect the final rendered document before it is used or signed.