Guides
Bank statement PDFs, QuickBooks Online and Xero: what works, step by step.
- How to import a bank statement PDF into QuickBooks OnlineTwo ways to get a PDF bank statement into QuickBooks Online: its own PDF upload, or a 3-column CSV checked against the balances first. Steps for both.
- Xero bank statement CSV import: columns, rules and stepsThe columns Xero expects in a bank statement CSV, the rules that make the import work, and the exact steps to import it, including from a PDF statement.
- How to convert a bank statement PDF to Excel (including scans)Four ways to get bank statement transactions from a PDF into Excel, what each one gets wrong, and how to make sure nothing is missing.
- How to check a converted bank statement against its balancesOne equation catches missing, doubled and sign-flipped rows in a converted bank statement. How to run it in Excel, and how to read the difference to find the bad row.