StatementDecoder

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

  1. Open the Monzo app and go to Home in the menu bar.
  2. Tap the three dots underneath your card.
  3. Select Bank statements.
  4. Choose the date range you want.
  5. 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.