Guides
Academy — Guides, How-Tos & Deep Dives
In-depth how-to guides, deep dives and data-driven studies on converting, reading and reconciling bank statements.
PDF to Excel Converter: The Complete Guide
How PDF to Excel conversion actually works, why bank statements are the hardest case, and how to verify the output before you trust it.
Read the guideOFX & QFX Converter: From PDF Statement to Quicken
What OFX and QFX files are, why Quicken and older accounting software still need them, and how to convert a bank statement into either format.
Intelligent Document Processing for Bookkeepers
What intelligent document processing is, which documents it reads in a bookkeeping practice, and how to evaluate document AI tools for finance work.
Bank Statement OCR: How It Works, and Where It Breaks
How bank statement OCR actually works — text layers, true OCR and vision-model extraction — and the specific ways it gets transactions wrong.
Convert a Scanned PDF to Excel: A Practical Guide
How to convert a scanned PDF to Excel, even from a rough phone photo — what makes a scan usable, what OCR gets wrong, and the steps to a clean result.
How to Extract Data From a Bank Statement
How to pull clean date, amount and balance fields from a bank statement PDF — by hand with formulas, or automatically with OCR and an API.
Preparing a Bank Statement for a Mortgage Application
What lenders look for in a bank statement for mortgage applications, how many months they ask for, and how to turn PDFs into a lender-ready spreadsheet.
Bank Statement Reconciliation: A Practical Guide
What bank reconciliation is, why it matters, and a step-by-step process for matching your books to a bank statement — including how to reconcile a statement you've converted from PDF.
How to Read a Bank Statement: Every Field, Explained
A plain-English guide to every part of a bank or credit-card statement — opening and closing balance, debits and credits, running balance, and how to check the numbers add up.
Bank Statement Parsing for AI Agents: What a Bookkeeping Agent Actually Needs
Why handing a raw PDF to an LLM is a bad way to parse a bank statement, and what a proper tool call for statement extraction looks like — with a balance check and structured output.
How to Convert a Bank Statement to Excel (3 Ways)
Three practical ways to get a bank statement PDF into an Excel spreadsheet — from manual copy-paste to an automated converter — with the tradeoffs of each.
PDF Bank Statement to CSV: A Practical Guide
Why CSV is often the right format for bank statement data, what columns a good conversion should include, and how to go from PDF to a clean CSV file.
Is It Safe to Convert Bank Statements Online?
What to check before you upload a financial statement to any online converter — encryption, file retention, and what happens to your data after processing.
How to Import a Bank Statement into QuickBooks (Without a Direct Feed)
What to do when a bank account isn't connected to QuickBooks bank feeds — converting a PDF statement into an import-ready CSV, step by step.