13 / 26 Documents and data · Example
Extract statement tables
The bookkeeper gets the quarter’s bank and broker statements as one workbook, every figure traced to its page.
- Who it’s for
- Bookkeeping software whose users retype bank and broker statements into spreadsheets every quarter.
- Why it’s hard
- Stonecrop’s holdings table runs across several pages, with column headings only on the first. A wrong digit in a running balance is hard to spot later.
- You get back
-
- One Excel workbook, with a sheet for each account
- Any sheet whose total misses the closing balance, flagged
How it runs, in your product’s code
At quarter end, your product hands a computer the list of accounts. Kestrel Bank shows statements to account holders only, so your customer signs in to it. Every table goes into the workbook with its page number, Stonecrop’s multi-page one included. Each sheet’s total is compared with the closing balance printed on its statement.