Connecting the dots
“You can’t connect the dots looking forward; you can only connect them looking backward.”
— Steve Jobs
Hardi Jain · AI and SaaS product manager
I converted an auditor’s repeated reconciliation logic into a reusable system, so auditors could focus on investigating exceptions rather than performing the same calculations manually.
01 · THE OLD WAY
Investment registers contained thousands of transactions that had to be tested through a series of reconciliations and account mappings.
For each sample, auditors had to reconstruct the expected closing position, validate purchases and sales against the relevant accounts, and verify other income such as dividends and interest.
02 · THE RECONCILIATION WEB
The work wasn’t a single calculation. Each transaction had to connect to the right financial evidence and ultimately reconcile back to the financial statements.
The challenge was doing this consistently across large transaction populations while still identifying the exceptions that required auditor judgment.
03 · THE QUESTION
The underlying audit logic was repeatable.
If the rules could be defined once, the system could perform the calculations and reconciliations consistently, leaving the auditor to investigate what didn’t reconcile.
04 · DEFINE THE LOGIC
We defined the underlying audit logic at the backend.
The system could calculate the expected closing balance, map transactions to the relevant accounts, calculate profit or loss on sales, incorporate dividend and interest income, and identify differences against the expected balances.
05 · THE USER EXPERIENCE
The user’s job became simpler: upload the required data, review the automated output, investigate the differences, and document the conclusion.
The auditor moved from calculation to investigation, rather than simply from manual to automated.
06 · THE EXCEPTION BECOMES THE PRODUCT
Instead of spending time performing the same calculations across samples, auditors could focus their attention on the transactions where the system identified a difference.
07 · THE INVESTIGATION
When the expected closing position did not agree with the financial statements, the system surfaced the difference rather than resolving it.
Deciding what the difference meant stayed with the auditor.
08 · THE SCALE
The workflow was standardised across 50 client engagements and more than 150 auditors, contributing to a 40–50% reduction in audit cycle time.
The numbers are the proof, not the story.
Product Manager · AI and SaaS
Connecting the dots
“You can’t connect the dots looking forward; you can only connect them looking backward.”
— Steve Jobs