BankStatementMate

BankStatementMate turns your bank statement into a ready‑to‑use spreadsheet. The conversion happens entirely in your browser, so your data never leaves the computer or the cloud. Once a PDF, PNG or JPG file is loaded, the tool detects the table and extracts the standard five columns: Date, Description, Debit, Credit and Balance.

First, you add a statement by dragging the file into the browser or choosing it from disk. The file size limit is 10 MB and, for PDFs, only the first five pages are processed. The interface immediately shows a preview: each row is shown in a table with the five columns, and any running‑balance mismatches are flagged with a warning. If a column is missing or the layout cannot be resolved, the export stops and a message tells you the problem so you can adjust the source file or try a different bank format. The preview lets you scroll horizontally to see all columns; numbers appear in clear, numeric form and the Balance column is kept for quick validation against the original statement.

When you click “Convert”, you choose either a workbook or a plain‑text file. The Excel (.xlsx) export keeps the five headers and writes amounts as numeric cells, with two decimal places displayed. Blank debit or credit cells stay blank, and dates that include a year appear as YYYY‑MM‑DD text; dates without a year keep their original text and trigger a review notice. The workbook is meant for further editing: you can filter rows, add notes, or both. The CSV (.csv) export contains the same five columns in comma‑separated plain text, useful when another application requires tabular input. No QBO, OFX or other accounting‑system formats are produced, so you must import the CSV into the target system according to its rules.

The service is geared toward individuals or small business owners who regularly receive PDF or scanned bank statements and need a quick way to check transactions in a spreadsheet. It works well with clear scans and digital PDFs from banks whose layouts match the Date‑Description‑Debit‑Credit‑Balance structure. It is less suitable for password‑protected documents, blurry or low‑resolution images, or statements that use non‑standard column headings. The tool does not connect to banks, categorize spending, or import data into accounting software automatically.