assureOffice Financials: Checks after Import and before Export
Importing data is the start of financial statement preparation. Follow a controlled review from client and period selection to final output.
AI Summary
Scope: Practical workflow checked against assureOffice guidance and available product functionality. Company Schedule III requirements and ICAI non-corporate guidance remain separate. Verification date: 11 October 2026.
Start with the correct client and financial period
A successful import does not establish that the financial statements are ready. The first control is identity: confirm the client, legal entity, reporting framework, current period and comparative period. This prevents technically correct numbers from appearing under the wrong year or entity.
In this workflow, financial records are organised under a client and financial period. Check that destination before importing. For Excel financials, the import panel displays current and previous period dates; an existing destination's dates are not silently replaced by the workbook.
Choose the appropriate source route
Use the relevant trial-balance or Excel financials import route for the source you actually have. A completed set of financial statements and a raw TB are different inputs. Record the source filename, extraction date and control totals in your working file.
For direct Tally connectivity, follow assureOffice's connector instructions. The web application does not require a desktop financials utility, but the local Tally connection has its own connector setup. Alternatively, use a supported exported file after checking the public walkthrough.
Reconcile the import before reviewing presentation
Compare imported balances with the approved source. Check current and comparative figures independently, including whether debits, credits or signed amounts have been interpreted correctly. When importing Excel financials, examine the available comparison information and investigate differences instead of proceeding because the import completed.
For example, suppose the source shows receivables of ₹24 lakh and the imported statement shows ₹21 lakh. Trace the missing ₹3 lakh to a ledger, source row or classification before editing the displayed total. A manual display change can conceal the underlying cause.
Review mapping and unusual signs
The financials tools include Ledger Names & Mapping, Match CY/PY and Check Signs. Use mapping to inspect the relationship between source ledgers and statement presentation. Use the CY/PY comparison to examine differences in grouping, approving changes only after review.
Check Signs helps identify heads appearing on an unexpected side. An exception is an investigation prompt, not an instruction to reverse the accounting balance. A debit supplier, customer advance or overdrawn bank may need a different presentation supported by the facts.
Complete notes and disclosure inputs
Read the notes as a connected document. Check accounting policies, supporting schedules, comparatives and applicable disclosures. A TB alone cannot establish ageing, security terms, commitments, related-party relationships or the reason for a ratio movement.
Obtain those inputs from responsible people and supporting records. Keep corporate Schedule III requirements distinct from the ICAI guidance relevant to non-corporate entities. Selecting a convenient format does not determine the entity's legal reporting obligations.
Control later source changes
If the client sends a corrected Excel file, first identify what changed and retain the previous approved source. The available tools include Excel Refresh and a Re-run action for automatic steps. Review their effects on the relevant financial period before relying on the updated output.
Repeat the control-total and classification checks affected by the change. If a debt balance changes, revisit its supporting note and connected ratios. A change log in the engagement working file helps explain why the new output differs from the version previously circulated.
Review the actual export
- Confirm company name, period, comparatives and reporting units.
- Agree the balance sheet and P&L with the reviewed working totals.
- Check note references and all applicable supporting schedules.
- Inspect headings, negative figures, rounding and page breaks.
- Open the final PDF or Excel export and retain the approved delivery copy.
Where the Signed & Closed workflow is used, complete approval before closing the financial period. An independent revision should follow the intended revision process rather than overwriting the signed original.
assureOffice's Schedule 3 financial builder is most useful when automation and review operate together: import once, inspect the structured records, complete disclosures and deliver a checked output.
Related articles
- Trial Balance Tallies, but Financial Statements Do Not: How to Find the Difference
- Tally Ledger Hygiene before Financial Statement Preparation
- Schedule III Financial Statements Made Easier with assureOffice’s Web-Based Builder