Bank statement to Excel (version 1)
This ran inside a cloud AI chat, so it is not the privacy-first product. Its limits led to the Digital Accountant.
725 transactions reconciled to the paisa204 on a second bank's statement
Problem
Each bank lays out its statements differently, and month-end analysis needs every transaction categorized and reconciled.
Solution
A reusable Claude skill that turns bank statement PDFs into an Excel workbook with a formula running balance, a category on every row and a monthly category analysis.
Stack
- Claude skills
- Python
- pdfplumber
- openpyxl
- Excel formulas
Engineering
- Closing balance must match the bank's own figure before the workbook is accepted
- Custom extractor written for a two-date-column layout
- Every category is a dropdown the accountant can change