Cleanrow
Guides
How to get bank and credit card statements into the file your spreadsheet or accounting app needs with the Cleanrow converter, one format per guide, each with a real example export and the problems to watch for.
From a PDF statement
- Convert a PDF bank statement to CSV: Date, Description, Amount and Balance columns that any spreadsheet or app can read.
- Convert a PDF bank statement to Excel (XLSX): one sheet with real dates and numbers, so nothing is reinterpreted on the way in.
- Bank statement PDF to a QuickBooks Online CSV: the 3- and 4-column layouts Intuit documents for bank uploads.
- Convert a PDF bank statement to OFX or QIF: bank files for finance and accounting apps, with stable transaction ids in OFX.
From a bank CSV
- Clean up a bank CSV export for import: separate debit and credit columns, ambiguous dates, decimal commas and extra header lines.
Checking the result
- The balance check, explained: opening balance plus every transaction must equal the closing balance, to the cent; what that catches and what it can't.