A trial balance fails to tie to its own general ledger almost always because the two were extracted at different moments in the closing process, not because either one contains an arithmetic mistake — the TB is a snapshot, and if even one adjusting entry, reclass, or late posting lands in the GL after that snapshot was taken, the two will permanently disagree unless someone re-pulls the TB from the exact same cutoff point.
How the gap actually opens up
- Late adjusting entries: a provision or accrual gets posted to the GL after the TB was already exported for review.
- Parallel closing activity: finance keeps correcting entries in the live system while the auditor or reviewer works from a TB pulled earlier that week.
- Multiple extraction points: the TB is exported from a reporting module and the GL detail from the transaction module, and the two modules don't close their periods at identical moments.
- Manual consolidation adjustments: a group-level TB includes elimination or consolidation entries that were never posted to any single entity's GL at all.
- Rounding at the aggregation layer: a TB that rolls sub-ledgers into head accounts can carry rounding differences the line-level GL doesn't show.
The instinct when a TB doesn't tie is to start hunting for a posting error line by line. Before doing that, check the extraction timestamps on both files — a large share of "mismatches" close the moment both sides are re-pulled at the same cutoff, with nothing actually wrong in either one.
Why this matters before relying on either number
A TB that doesn't agree with its GL isn't a minor housekeeping issue — if the figures being audited or reported on were pulled from the stale side of that gap, every downstream schedule built on them inherits the same timing problem. Confirming which extract is current, and re-pulling both from the same point in the close, is what actually resolves it, not reconciling line items that were never going to match in the first place.
This is practical guidance written for audit teams, not an authoritative statement of any standard or statute. Standards, forms and timelines change. Check the current text issued by the ICAI and the relevant authority before relying on anything here in an audit file.
Related resources
- Audit data & extractsTrial balance mapping for audit softwareMapping a client's idiosyncratic ledgers to a standard chart of accounts is the step that decides whether analytics and disclosures work at all, and the one most firms rush.
- Audit data & extractsExtracting a usable general ledger for audit testingDate, voucher type, narration, debit, credit, running balance: what a general ledger extract needs, and why a day-book export and a ledger-wise export are not interchangeable.
- Bank, cash & treasuryBank reconciliation audit procedure for statutory auditWhat a BRS must reconcile, the red flags that separate a timing difference from a cover-up, and how many months you actually need to review.
Free tools, no signup
Each one reads a file entirely in your browser — or, for two of them, just answers a few questions — and nothing is ever uploaded.
- Purchase register checkDuplicate payments, round-sum amounts, weekend-dated invoices, incomplete records.
- GSTR-2B reconcilerMatches your purchase register against GSTR-2B — missing invoices either side, amount mismatches.
- Bank reconciliation checkerMatches your cash book against a bank statement — what's outstanding on each side.
- Fixed asset register checkDuplicate asset codes, missing location or useful life, negative net book value.
- Payroll red-flag scannerBank accounts shared across employees, and records missing an ID, PAN or salary.
- CARO applicability checkerAnswer a few questions about the company and see which CARO 2020 clauses likely apply.
- MSME payment delay checkerMSME-flagged invoices paid — or still unpaid — beyond the 45-day Section 22 limit.
- Related-party transaction screenerTransactions above a threshold you set with no approval reference, grouped by counterparty.
- Depreciation useful life checkerCompares a useful life in use against the Schedule II, Part C indicative figure.
- Materiality calculatorOverall and performance materiality against PBT, revenue, assets or equity, with reasoning shown.
- Sample size calculatorStatistical sample size for a test of controls or a substantive test of detail.