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.

Something you'd like covered, or a statement layout that doesn't convert? Tell us. Reader reports shape what gets written next.
Muhammad Sharif, founder of StatementHarbor

Written by Muhammad Sharif
Founder, StatementHarbor · Last updated October 2026