Guides
Practical, plain-language walkthroughs for getting bank statement data out of a PDF and where it needs to go: spreadsheets, QuickBooks, Xero and your own records. Written for bookkeepers, accountants and anyone tidying their own finances.
Getting started
How to convert a bank statement PDF to Excel · 9 min read
Four methods compared (copy and paste, Excel's PDF import, browser converters, OCR), what each costs in time and privacy, and how to check the result.
How to read a bank statement: every section explained · 8 min read
The sections of a statement, the meaning of opening and closing balances, posted versus pending, and a glossary of confusing terms.
CSV vs Excel vs QBO vs OFX: which bank statement format should you use? · 8 min read
What CSV, XLSX, QBO and OFX contain, where each is accepted, and a decision guide for your workflow.
Importing into accounting software
How to import a CSV into QuickBooks Online
The column layouts QuickBooks accepts, where the import button hides, and the mistakes that cause "0 transactions imported".
What is a QBO file? (And when to use one)
QuickBooks Web Connect explained in plain language, and when CSV is actually the better choice.
How to import a bank statement CSV into Xero · 8 min read
Xero's column layouts, regional date format rules, amount formatting and row limits, plus fixes for the errors that block an import.
How to get a bank statement PDF into Google Sheets · 7 min read
Convert the PDF, import the CSV with the right settings, check dates and amounts, and set up balance-check formulas in Sheets.
Accuracy and troubleshooting
How to reconcile a bank statement converted from PDF · 8 min read
The opening-plus-transactions-equals-closing test, how to run it in Excel, and how to find a missing or duplicated row when it fails.
Bank statement PDF won't convert? Nine causes and how to fix them · 9 min read
A symptom-to-fix troubleshooting guide covering scans, passwords, wrapped descriptions, merged columns, signs and dates.
Scanned vs text-based bank statement PDFs: how to tell and what to do · 6 min read
A ten-second test for scanned versus text PDFs, why it matters for conversion, and how to obtain a text-based copy from your bank.
DD/MM vs MM/DD: fixing date formats in bank statement spreadsheets · 8 min read
How ambiguous dates are misread, how to detect a swap in minutes, and safe ways to convert dates in Excel and Google Sheets.
Debits, credits and negative amounts in bank statement spreadsheets · 8 min read
The common ways statements show withdrawals and deposits, and Excel formulas to normalise any layout into one signed amount column.
Working with the data
How to clean up and categorize bank transactions in Excel · 10 min read
Tidy descriptions, spot duplicates, apply category rules with lookups and summarise with a pivot table, using standard Excel features.
A repeatable monthly bank statement workflow for bookkeepers · 9 min read
Collecting, converting, verifying and importing client statements each month, with a folder structure, a checklist and confidentiality rules.
How long should you keep bank statements? · 7 min read
Typical retention periods by purpose (tax, business, loans, disputes), the IRS general rules, and safe storage and disposal.
Privacy and regional formats
Is it safe to upload bank statements to an online converter? · 9 min read
What a statement reveals, where uploaded files can end up, a five-minute test for local processing, and a checklist for handling client data.
Indian bank statement formats explained: dates, Dr/Cr, narration and more · 8 min read
Day-first dates, withdrawal and deposit columns, Dr/Cr markers, narration text and lakh-style numbers, and how each affects conversion to Excel.