Prepare a bank CSV you can actually check.
Start with your bank’s CSV download rather than copying a table from a screenshot. Export a single account and currency, and select the exact statement period you want to review.
1. Choose the columns
Use a single header row and map Date, Description and Amount. Positive amounts mean money in; negative amounts mean money out. Alternatively map separate Debit and Credit columns containing positive values. A row with both populated is rejected. Balance is optional.
2. Make dates and decimals explicit
UK mode reads DD/MM/YYYY; US mode reads MM/DD/YYYY; European mode reads DD.MM.YYYY. All modes accept YYYY-MM-DD. Select dot or comma decimal style yourself. Mixed styles in one file must be corrected before import. CSV must be UTF-8, use comma, semicolon or tab delimiters, and contain no more than 2,000 transactions.
3. Reconcile the original order
If the statement is newest first, select reverse order. Supply opening and closing balances to compare closing minus opening against all signed transactions. Running balance checks use the previous known balance. Duplicate candidates remain present: the same merchant and amount can be legitimate repeated purchases.
4. Check and export
Review every row. Labels describe your bookkeeping assessment; they do not establish deductibility. Excluding a transaction changes included cash-flow totals but does not delete its source record or affect the original statement reconciliation. CSV and Excel exports keep all rows and exclusion flags.
Limited PDF support
This release reads text PDFs containing only four aligned columns: Date, Description, Amount, Balance. Column gaps must survive text extraction as two or more spaces. Repeated headers are supported. Logos, page footers, opening-balance lines, multi-line descriptions and unknown layouts cause rejection. Scanned, encrypted and arbitrary bank PDFs are unsupported. Use the supplied synthetic PDF fixture to test the documented format.