The practical guidebook
From bank statement
to usable data.
Clear steps for converting your files, checking the numbers, and getting them into your accounting software. Start with the task in front of you.
Start here · 4 min read
Your first PDF to Excel conversion, step by step.
Choose the right method, understand the two workbook sheets, and use a simple checklist to verify the result.
Read the conversion guideA workbook you can check
Illustrative example
| Description | Debit | Credit |
|---|---|---|
| Client payment | 500.00 | |
| Office supplies | 200.00 |
Always compare your export with the original.
Chapter 01
Conversion essentials
Start with the right file, choose an output, and check your results.
4 min read
How to download a bank statement as a PDF
Find your bank-issued statement, save the original PDF on a computer or phone, and check it before conversion.
Read guide4 min read
How to convert a PDF bank statement to Excel
Choose a conversion method, understand your spreadsheet, and check the numbers before you use them.
Read guide2 min read
Convert a scanned bank statement to Excel
Prepare a readable PDF, recognise OCR limitations, and check dates and amounts after conversion.
Read guide2 min read
CSV vs QBO: choose a bank statement export
Compare editable CSV files with QBO exports and choose a format that fits your destination account.
Read guide4 min read
How to convert a PDF bank statement to CSV
Download a five-column transaction CSV, open it correctly in Excel, and prepare it for your accounting software.
Read guide4 min read
Categorise bank transactions in Excel
Download a categorised workbook, review keyword-based labels, and rebuild category totals after making changes.
Read guide
Chapter 02
Accounting imports
Prepare transactions for QuickBooks, Quicken, and Xero with fewer surprises.
4 min read
How to convert a PDF bank statement to QBO for QuickBooks
Create and review a QBO file, check QuickBooks import requirements, and resolve common account and duplicate issues.
Read guide2 min read
Troubleshoot a QuickBooks bank statement import
Check columns, date formats, amount signs, duplicate rows, and the destination account before retrying.
Read guide2 min read
Prepare and import a bank statement into Xero
Use a signed Amount column, match the date format, and review the statement before reconciliation.
Read guide3 min read
Prepare a bank statement QFX file for Quicken
Create a QFX export, check its account and institution details, and understand Quicken Web Connect import limitations.
Read guide
Chapter 03
Data & ERP workflows
Work with JSON, MT940, and CAMT.053, from export fields to import checks.
4 min read
Convert a bank statement to JSON for data workflows
Understand the statement object, read its transactions in Python, and handle null values and validation results correctly.
Read guide3 min read
Convert a PDF bank statement to MT940 for ERP import
Understand the generated MT940 fields, check account and balance defaults, and test the file against your ERP's import rules.
Read guide4 min read
Convert a bank statement to CAMT.053 XML
Check the camt.053.001.02 version, understand generated entries and references, and validate the XML before ERP import.
Read guide
Chapter 04
Bank walkthroughs
Know what to check when working with statements from your bank.
2 min read
Convert a Chase statement to Excel
Prepare a Chase PDF and check account sections, transaction dates, and wrapped payment descriptions.
Read guide2 min read
Convert a Bank of America statement to Excel
Check deposit and withdrawal sections, combined accounts, and the final workbook before importing.
Read guide2 min read
Convert a Wells Fargo statement to Excel
Review transaction rows, check-image summaries, and balances without mixing statement sections.
Read guide2 min read
Convert an HSBC statement to Excel
Check regional dates, account sections, and currencies before using an HSBC conversion.
Read guide
Chapter 05
Privacy & access
Handle sensitive documents and protected PDFs with care.
2 min read
What to check before uploading a bank statement
A practical checklist for permissions, data handling, retention, and downloaded files.
Read guide2 min read
Prepare a password-protected bank statement for conversion
Open an authorised statement locally and save an unlocked copy before uploading it.
Read guide