Financial statements from messy books
3 balance breaks found automatically3 cancelled or missing cheque rows flagged
Problem
Bank registers and the accountant's book rarely agree, and posting often stops part-way through the year.
Solution
Builds a reconciled P&L and balance sheet from a bank register plus the accountant's book export, and refuses to build on a ledger that doesn't reconcile.
Stack
- Claude skills
- Python
- Excel
Engineering
- Walks the running balance row by row and reports every break
- A frozen balance marks the book's cut-off date
- Unpresented cheques carried as a timing difference
- Reference for SRB sales tax and withholding gross-up
- Never shows a balance sheet as balanced unless the check is zero