Monzo Statement to CSV: Pots, Closed Accounts and Proof

You need Monzo transactions in a spreadsheet, and you need them complete — every card payment, every Pot transfer, every incoming salary, in the right direction. Maybe you are assembling a mortgage file, answering a visa caseworker, handing a tax year to an accountant, or reconciling a business that runs through a Monzo account.

The honest answer first: Monzo's own export is good and you should use it when you can. This post covers when that is the right call, what to do when only a PDF exists, and how to prove the CSV you end up with matches the statement.

Quick answer

There are two ways to get Monzo transactions into CSV:

1. Monzo's in-app export. Monzo will export your transactions, including Pots, as PDF, CSV or QIF for a date range you choose. If you have app access, this is the fastest and cleanest route.
2. Convert the PDF statement. Sometimes only the PDF exists. Monzo says its statements are accepted as original documents for mortgage and visa applications, so a lot of Monzo PDFs get generated for formal purposes and then need to be read as data. Closed accounts, and statements other people send you, land in the same place. Upload the PDF to a converter like BankStatementKit, which reads the transactions and balance-checks the output against the statement's own printed figures.

Rule of thumb: if you can open the app, export natively. If what you are holding is a PDF, convert the PDF.

Turn a Monzo PDF into a verified CSV

Option 1: Monzo's built-in statement download

If you still have app access, do this first — the data comes straight from Monzo.

1. Open the Monzo app and go to Home.
2. Tap the three dots beneath your card.
3. Select Bank statements.
4. Choose your date range, then pick your format — PDF, CSV or QIF — and export.

Business customers have an equivalent path, and can also opt in to have Monzo drop last month's statement into a Google Drive or OneDrive folder on the first of each month.

Where the built-in download stops

Monzo's export is genuinely good, and it still runs out in familiar ways:

• Closed accounts. Once the account is closed the in-app export is gone. Monzo emails a password-protected statement instead, with the password sent separately by text — a PDF, not a spreadsheet.
• Formal documents are PDFs. The statement a mortgage underwriter, letting agent or visa caseworker asks for is the PDF. That is the document you submit, and it is not the file you can analyse.
• Statements you did not generate. A client's or a partner's Monzo statement arrives as their PDF, not as access to their app.
• Long histories mean repeated exports. Building a two-year picture from date-range exports is a filing exercise either way.
• The CSV still needs shaping. Native exports commonly need header cleanup and column retyping before an accounting tool will import them.

Most of those cases end in the same place: a PDF.

Option 2: Convert the Monzo PDF statement to CSV

1. Open the statement PDF. A closed-account statement emailed by Monzo will ask for a password.
2. Upload it. Supply the password when prompted — the file is decrypted in memory and never written to disk.
3. The transactions are read into standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance, with Pot movements kept as their own rows.
4. Check the verification label, then download the CSV.

Convert a Monzo statement

Why Monzo PDFs trip up generic converters

Monzo statements look tidy, which is exactly what makes naive extraction overconfident.

Pot transfers are real transactions. Monzo statements include Pots activity, and money moved into a savings Pot is a genuine debit against the main balance. Converters that treat internal movements as noise and filter them out produce a file whose running balance drifts away from the statement by exactly the amount you saved — a plausible-looking difference that is easy to miss and unpleasant to trace weeks later. Every Pot movement the PDF prints has to land in the CSV.

Descriptions are merchant-enriched and variable length. Monzo replaces raw acquirer strings with clean merchant names, often with extra context such as a category or a note. That means description length varies a lot from row to row and can wrap onto more than one physical line. A converter that reads line by line turns a single wrapped transaction into several partial rows with no amounts attached. Rows have to be assembled around the date and amount columns, with continuation lines folded back into the transaction they belong to.

Closed-account statements are encrypted. The PDF Monzo emails for a closed account is password-protected, and a converter that cannot accept a password simply fails on the file — which is frustrating, because the closed-account case is the one where conversion is most often the only option available.

Prove the CSV matches the statement

This is the step most people skip, and the one that matters when a lender or an accountant is going to read the file.

1. The running balance chain. For each row, the previous balance minus the debit plus the credit must equal the printed balance. A dropped Pot transfer or a duplicated row breaks the chain at exactly the point it went wrong.
2. The period's opening and closing balances. The statement states where the account started and ended for the period. Opening plus total credits minus total debits must equal closing.

Doing this by hand is ten to fifteen minutes per statement. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pinpointing the row where the numbers stop reconciling. There is more on the layout on the Monzo statement converter page.

FAQ

The bottom line

If your Monzo account is open and you can reach the app, use Monzo's own export — PDF, CSV or QIF, free and immediate. Convert the PDF when the PDF is all there is: closed accounts with their password-protected email, statements already produced for a mortgage or visa file, and statements other people send you. Whichever route you take, check that the Pot movements are still there, because that is where the balance quietly stops agreeing.