Guides and notes

Practical notes on statements, formats and how we test.

Twelve statement pages fanned in an arc, converging into one clean grid of table cells

· 6 min read

Year-end bookkeeping from bank statements

Rebuilding a year of books from statements for tax time: gather, convert, reconcile, assemble, categorize, review. Where the time goes and what to check.

A statement whose direct route is blocked by a bar, taking a second route through a small node and arriving as a table

· 4 min read

Xero PDF import: UK and Australia

Xero's direct PDF import covers the US and Canada only. What the UK, Australia, New Zealand and South Africa do instead, step by step.

A year drawn as twelve segments where only the last three carry any writing, the nine empty ones marked with a bracket

· 5 min read

QuickBooks Online stops at 90 days

Why the QuickBooks Online bank feed reaches back only 90 days, why reconnecting does not help, and the upload route with no date limit.

Four identical file cards side by side with different rulings inside, one picked out in petrol

· 6 min read

QBO vs OFX vs QFX vs QIF: which one to use

What each bank-import format is, which software reads it (QuickBooks, Xero, Quicken, Sage, Wave, GnuCash), the INTU.BID quirk, and how to import.

A sheet of paper feeding into an application window where the top row has just arrived

· 6 min read

Import a statement into QuickBooks Online

QBO file or CSV, the Upload from file path, what to check first, and fixes for rejected QBO files, bad dates, flipped signs and duplicates.

A payment card beside a statement page whose last column is drawn as an empty dotted outline

· 5 min read

Credit-card statements to Excel and QBO

Sign conventions, why most card statements have no running balance, how to verify the totals instead, and importing into QuickBooks or Xero correctly.

A flatbed scanner with a statement on the glass and a clean table of cells coming out of it

· 5 min read

Scanned bank statements: what works

How scans and phone photos are read, what makes a page readable (resolution, skew, light), what to check afterwards, and why scans get a balance check.

A paper bank statement beside a clean spreadsheet grid with one column picked out in petrol

· 6 min read

Bank statement PDF to Excel: 4 methods

Retyping, Excel's PDF import, a general chatbot and a dedicated converter: what each costs in time, where it falls short, and how to check the result.

Two columns of paired bars with one pair that does not match, marked out in petrol

· 6 min read

What a reconciliation check really catches

The running-balance identity, four errors it catches (dropped row, duplicate, wrong sign, wrong digit), what it misses, and how to read a flagged row.

A statement page with a shield drawn over it and a short checklist beside it, two items ticked

· 5 min read

Privacy checklist for statement converters

Questions to ask before uploading client statements to a converter: retention, sub-processors, model training, encryption, logs, account deletion, DPAs.