← Back to portfolio

Visual Demo

Bank Statement Automation Tool

AI-powered bank statement parsing and CRA-compliant transaction categorization — built to cut hours of manual bookkeeping down to minutes.

This is a visual walkthrough, not a live instance. The production tool processes real client statements and runs against a private AI backend, so it isn't connected here — the screens below show exactly how it works.
Bank Statement Automation interface — parsed TD chequing statement with AI-assigned T2125 category chips, confidence scores, category totals, and an Export Excel workbook button

How it works

1

Upload a bank statement PDF

Drop in any Canadian bank statement — TD, RBC, Scotiabank, BMO, CIBC. The parser extracts every transaction with dates, descriptions, and amounts, straight from the PDF.

2

AI categorizes to CRA lines

Each transaction is matched to the right T2125 expense category — fuel, supplies, insurance, meals at 50%, and more — with a confidence score, so anything uncertain gets flagged for review instead of guessed.

3

Export a working-paper-ready Excel file

One click builds a clean multi-sheet workbook a preparer can use immediately — no retyping, no copy-paste, no manual coding of 142 rows.

What the export contains

SHEET 1

Transactions

Every line item with date, description, category, and amount — filterable and audit-ready.

SHEET 2

Profit & Loss

Income and expenses rolled up by T2125 category for the period.

SHEET 3

HST Summary

HST collected and input tax credits, ready for return preparation.

SHEET 4

Trial Balance

Debits and credits by account, tying the statement back to the books.

← More projects Ask me about it