Step-by-step guides written by the Rowvert team. No fluff: exact menus, exact CSV formats, exact checks.
A converted or retyped bank statement is only right if opening balance + money in − money out equals the closing balance. How to run that check in Excel in 60 seconds, find the row that breaks it, and spot edited statements.
Xero imports bank statements as CSV, OFX or QIF — never PDF. The exact Xero CSV columns, the date and amount rules, how to get the file from a PDF statement, and why "Your file couldn't be imported" happens.
QuickBooks Online only imports CSV, QBO, QFX or OFX — not PDF. Here is the exact 3-column CSV format it accepts, how to get it from a PDF statement, and the errors that make the upload fail.
Dozens of tools promise "PDF bank statement to Excel". Most are generic PDF converters with a new landing page. The seven questions that separate a tool you can trust for accounting from one that just produces a spreadsheet.
Paper statements, phone photos and "print to PDF" scans have no text layer, so Excel and copy-paste read nothing. How OCR converts them, the five errors it makes on bank statements, and how to catch every one of them.
The four ways to turn a PDF bank statement into an Excel spreadsheet — copy-paste, Excel's PDF import, Adobe Acrobat and a dedicated converter — with what each one gets wrong and how to check the result.
Where to find Chase statements as PDF (and why the CSV option often isn't enough), how the Chase statement layout converts to Excel, and the two quirks — date format and "Beginning/Ending balance" — to watch for.
A practical workflow for bookkeepers and accountants who receive twelve months of PDF statements and no bank feed. Convert, reconcile month by month, merge into one workbook, categorise, and import — in an afternoon rather than a week.
UK Student and Skilled Worker visas require money held for 28 consecutive days, with the balance never dipping below the threshold. How to convert your statements and verify the rule yourself before you apply.