Level 1
Manual
Spreadsheets
Reconciliations built by hand in spreadsheets each morning. Breaks tracked in email. Evidence rebuilt when the auditor asks.
Where does your firm sit today, from spreadsheets to autonomous, evidenced control? Use the model to benchmark your operations and see what the next level requires.
The model
Level 1
Spreadsheets
Reconciliations built by hand in spreadsheets each morning. Breaks tracked in email. Evidence rebuilt when the auditor asks.
Level 2
Scripts and macros
Some matching automated with scripts or macros. Still person-dependent; exceptions and approvals live outside the system.
Level 3
Reconciliation tool
A reconciliation tool flags differences. People investigate and fix them elsewhere; approvals and evidence are partly recorded.
Level 4
Daily control layer
Reconciliation performed on versioned rules, every fix approved by a named person, evidence recorded and replayable, controls attested daily.
Level 5
Agent-run, human-signed
AI agents explain and resolve low-risk breaks within limits the control owner set; people review exceptions and sign off. The audit pack is a download.
Self-assessment
Answer for your most important daily reconciliation. Nothing is stored or sent.
1.Are your daily reconciliations produced without anyone building a spreadsheet?
2.Is every match made on written, versioned rules that someone approved?
3.Is every break explained with the source records that disagree?
4.Does a different, named person approve each fix before it is posted?
5.Can you replay any past day's reconciliation and get exactly the same result?
6.Are inputs and decisions kept in a record that cannot be edited afterwards?
7.Are client-money or safeguarding checks attested by a named owner every day?
8.Could you hand an auditor the evidence for any date range within an hour?
9.Do automated agents explain or resolve routine breaks within approved limits?
Dawn
Open the morning report and make a few decisions yourself. Or send us one night of source files and we will run your reconciliation in front of you.
skhan@03vc.com