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.
Fake and edited bank statements are cheap to make and hard to see. Nine checks a landlord, lender, employer or adviser can run on a PDF in ten minutes — the arithmetic, the dates, the numbers' statistics and the traces editing software leaves in the file — and what to do when one fails.
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.
ChatGPT and image generators have made fake bank statements cheap, and "AI detectors" are not the answer. What a generated statement actually looks like, why the file itself carries no AI signature, and the seven content and file checks that still catch it.
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.