How to export statements from Monzo (PDF, CSV and QIF)
2026-09-06 · 5 min read
Monzo is one of the easiest UK banks to get data out of: statements are generated in the app for any date range you choose, in PDF, CSV or QIF, rather than fixed monthly documents. The catch isn't finding the export — it's what's inside the file once you open it, because Monzo's CSV is richer and stranger than a traditional bank's.
The export, step by step
- Open the Monzo app and go to Home in the menu bar.
- Tap the three dots underneath your card.
- Select Bank statements.
- Choose the date range you want.
- Pick the format — PDF, CSV or QIF — and download or share.
QIF is a genuine rarity among UK banks and a gift if you run an older accounting package like Quicken or Microsoft Money. Business accounts add a web export plus automatic monthly exports to Google Drive or OneDrive.
One reassurance worth knowing: Monzo statements are original documents that shouldn't need stamping or signing for mortgage or visa applications — and if a caseworker insists, Monzo provides stamped, signed copies on request via a form. Our guide to statements for mortgage applications covers what lenders actually check.
What surprises people inside the file
- Pots are in there. Transfers between your main balance and Pots appear as transaction lines, so any spending analysis needs those internal movements filtered out first — they aren't spending.
- Pot lines carry IDs, not names. In the CSV, pot transfers are identified by Monzo's internal IDs — strings starting
pot_— rather than the pot's human-friendly name. A well-known snag when importing into accounting tools. - Extra columns. Monzo's CSV is enriched with app metadata — spending categories, notes — so it carries more columns than a traditional bank CSV and may need trimming before an import that expects date/description/amount.
- Closed accounts arrive locked. Statements from a closed Monzo account come password-protected, with the password sent by SMS. Any converter or parser needs the password removed first — most tools can't open encrypted PDFs at all.
Getting it into a spreadsheet or accounting tool
For recent periods, Monzo's own CSV is exact — start there, filter the pot_ lines, trim the extra columns, and import. Where the PDF is what you have (a closed account, a stamped copy, a range someone emailed you), the Monzo statement converter reads it directly, reconciles every line against the statement's printed balances, and outputs clean CSV, Excel, QIF or OFX with merchants named — including sorting the Pot transfers from the actual spending.