Turning PDF statements into clean data, explained.
Field-tested workflows, security guidance and reconciliation tips for the accounting, finance and legal teams that convert bank statements at volume.
Search the guides
Making Tax Digital for Income Tax (April 2026): how bank statement records need to change
From April 2026, sole traders and landlords over the £50,000 threshold need transaction-level digital records. Here is what that means for bank statement workflows.
Convert an American Express bank statement for litigation discovery
A practical guide to converting American Express statements for litigation discovery, covering the category summary block, foreign transaction lines, and how to verify the result.
DR/CR suffixes, parentheses and split columns: normalizing the bank statement debit credit sign convention
Every bank encodes debits and credits differently. Here is how to convert DR/CR suffixes, parentheses and split columns into one sign convention before combining statements.
The month-end close checklist for statement reconciliation
The concrete sequence of checks that takes a set of bank statements from raw document to a closed, reconciled ledger.
How long should you keep converted bank statement records?
A practical guide to how long bookkeeping, accounting and legal professionals should keep converted bank statement records, and when longer holds apply.
How to convert a PDF bank statement to Excel (2026 guide)
How to convert a PDF bank statement to Excel using Excel's built-in import tool and a dedicated converter, plus the balance checks that catch a misread row.
Converting multi-currency bank statements for QuickBooks and Xero without breaking reconciliation
Multi-currency sources like Wise need one ledger account per currency in QuickBooks and Xero. Here is how to split statements and import them correctly.
How OCR accuracy is measured, and why it matters for bank statements
OCR accuracy is a property of the specific statement in front of you, not a fixed number. Here is how it is measured and how the misreads get caught.
QuickBooks Desktop bank feeds discontinued: how to keep books current without live sync
QuickBooks Desktop 2023 lost bank feeds on May 31, 2026. Here is the QBO-based workflow that keeps transactions current without live sync.
What to check before using a free online statement converter
Five checks that separate a free converter you can defend to a client from one you cannot: retention, training use, sub processors, region, and deletion.
Your bank feed stopped syncing and you need to backfill by hand
A broken bank feed leaves a gap that reconnecting often will not fill. Measure the gap precisely, backfill from the statements, and handle the overlap so nothing duplicates.
Bank feeds versus statement conversion: what a feed cannot prove
Check the bank's CSV or OFX export first. Then read what a feed still cannot do: reach history before the connection, survive a closed account, or check its own amounts against the statement's balances.
Amounts import as text and SUM returns zero
A left aligned amount column that will not sum has one of four causes. Here is how to identify which one you have and the exact fix for each.
Bank statement dates import as text or in the wrong order
DD/MM or MM/DD cannot be resolved from the data alone below the 13th. Here is where the statement declares it, and how to force the correct reading in a spreadsheet.
Producing bank statements as numbered exhibits
Numbering attaches to pages or to whole documents depending on the convention in play, and never to individual transactions. How to stamp a statement bundle and carry the page reference into the converted rows.
Bank statements as proof of a deduction: payment versus purpose
Why a bank statement establishes payment but not purpose, where merchant descriptors stop being useful, and how to turn a converted statement into a checklist for the documents you are missing.
Bank statements as proof of income for a rental application
A landlord asked for three months of bank statements. Here is what to send, what is safe to redact, and the redaction that quietly destroys your own evidence.
Bank statements for a business loan: what the lender is checking
Twelve months of business statements get read for whether revenue is steady, whether the account carries a buffer, and whether another lender is already paid out of it. All three are computable before you submit.