All features/Trial balance & FSA mapping
Phase 2 · The hinge of the fileImport the trial balance. Map it once. The file builds itself.
Phase 2 is the hinge of the whole platform. The trial balance comes in, AuditBot maps it to financial-statement areas — and the moment mapping completes, the system generates the working papers, lead sheets and client request list for the entire audit.
PDF, CSV or Excel — parsed and validated.
Upload the client's trial balance in whatever format it arrives. The importer auto-detects account code, description and debit/credit columns (plus prior-year balances for first-year files), then validates the lot: does it balance, are there duplicate or missing codes, did anything mis-parse. You review the grid and correct reading errors before anything proceeds.
- Totals must balance before the file moves on — unbalanced TBs are flagged line by line.
- Prior-year columns import alongside for first-year engagements.
| Code | Account | Debit | Credit |
|---|---|---|---|
| 1001 | Cash at bank | 184,320 | — |
| 1100 | Trade debtors | 612,940 | — |
| 2000 | Trade payables | — | 298,110 |
| 4000 | Revenue | — | 3,910,500 |
The opening balance test, automated to the decision point.
Prior-year closing balances are compared to current-year opening balances account by account, with the difference calculated for every line. Each difference walks a short decision path — mapping or reclassification only? corrected in the current year? does it affect retained earnings? — and the system determines from the answers whether a journal is required, pre-filling the standard conclusion for the auditor to confirm.
- A first-year verification program covers files with no prior-year audit.
- Conclusions are pre-populated, never pre-signed — the auditor confirms.
AI maps every account — and remembers it next year.
AuditBot classifies each account to a financial-statement area from its code, description and prior-year logic. You override anything with drag-and-drop. The mapping is memorised per client, so next year the same accounts land in the same areas automatically — the file genuinely rolls forward.
- Suggestions are exactly that — every mapping is auditor-confirmable.
- Mapping memory is per client, so industry-specific charts of accounts stick.
Lead sheets that are always current.
Each financial-statement area gets a lead sheet derived in real time from the trial balance plus any adjusting journals — post an adjustment and the lead sheet and draft financial statements move with it. Drill from any line down to the transactions behind it. Before sampling can run, the general ledger must reconcile to the lead sheet within performance materiality — the platform enforces it.
- Adjusting journals flow through to lead sheets and draft financials instantly.
- Every figure drills down — no “where did this number come from”.
See it on your own engagements.
Start your firm free, or book a demo and we will walk you through the platform on a real audit file.
No credit card to start · Australian-resident data · Cancel anytime