Tallyproof Bank Statements

Turn a bank or credit card statement into a spreadsheet of transactions and check that it balances to the cent. Attach a bank or credit card statement (a text PDF from your bank's website, or its CSV or Excel export) and Tallyproof Bank Statements extracts each transaction: date, description, signed amount (money out negative), running balance when printed, and a suggested category.

The key step is reconciliation. It finds the opening and closing balance on the statement and checks opening + money in - money out = closing to the cent. You see PASS, or the difference in dollars and cents and the rows to look at: where the running balance breaks, a likely missing deposit or withdrawal, a duplicated row, or a reversed sign. Deposit and withdrawal totals are compared with the statement's own totals.

It handles real statement layouts: one signed amount column, separate withdrawal and deposit columns, separate deposit and withdrawal sections, CR/DR suffixes, negatives in parentheses, thousands separators, multi-page statements with repeated headers, descriptions that wrap onto a second line, and dates without a year (placed inside the statement period, including December to January). Bank CSV and Excel exports are cleaned into the same format, newest-first or not.

Downloads: an Excel workbook (transactions, reconciliation, totals by month and by category), a clean CSV, and a QuickBooks-ready CSV (Date, Description, Amount). You can also paste or list transactions to reconcile them or total money in and out by month and category.

Good for bookkeepers, freelancers and small businesses doing monthly books or taxes, and anyone preparing statements for a loan application.

Limitations: text PDFs only (scanned or photographed statements need OCR first); up to 60 pages and 20,000 transactions per file. Account numbers are masked to the last 4 digits. Files are read once and downloads expire after about an hour. Categories are keyword suggestions, not accounting or tax advice.