Skip to content
stmtai

Convert Monzo statement PDFs to Excel, Xero and CSV.
Xero, FreeAgent, Excel files from the PDF.

Statements you export from the app are not locked. Monzo produces CSV and QIF alongside the PDF, from the same screen and for the same custom date range, which is unusually generous.

Drop your Monzo statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in GBP.

Last updated

How to download a Monzo statement as a PDF

  1. Open the Monzo app and tap 'Home'.
  2. Tap the three dots under your account card.
  3. Choose 'Bank statements' from the menu that appears.
  4. Set the date range. Monzo lets you choose any start and end dates, not just whole months.
  5. Pick PDF (or CSV or QIF if you want those instead) and confirm. The file goes to your phone's share sheet, from where you can save it or send it to yourself.
  6. For a Pot, open the Pot, tap 'Pot documents', then 'Pot statement'. Pot statements are listed after the main account statement.

Then drop the file above; several months of Monzo statements at once come back as one workbook.

Is the Monzo PDF password-protected?

Statements you export from the app are not locked. The one exception is the final statement Monzo emails when an account is closed, which is password-protected with the password sent by text to your registered mobile.

What Monzo statements look like

App-exported PDF or CSV. PDF has Date, Description, Amount (signed), Balance; CSV has category, notes and tags too.

A Monzo PDF is a single clean table: Date, Description, Amount, Balance, with the amount signed rather than split into in and out columns and a balance on every line. The period and opening and closing balances are stated at the top, and because you chose the dates yourself they can be a tax year or a single week. Monzo Business statements look the same but pull in the invoice or customer reference more often. Pot statements are separate documents showing only transfers in and out of that Pot. Dates are day month year in full and the PDF is generated on request, so the file is dated the day you asked for it.

Why not use Monzo's own export?

Monzo produces CSV and QIF alongside the PDF, from the same screen and for the same custom date range, which is unusually generous. The CSV includes category, notes and tags columns and a signed amount, and there is no history cut-off for open accounts. What it does not have is a running balance on each row, so you cannot see the account position after every transaction, and the description is split across name and reference fields. Convert the PDF when you need the balance column or when a lender or accountant wants the figures to match the statement they were sent.

Where Monzo statements trip up converters

  • Both PDF and CSV are accepted. The CSV keeps Monzo categories in the description for easy rule-based coding in Xero.

Which software Monzo customers import into

Monzo customers most often import into Xero, FreeAgent, Excel.

Monzo questions

Monzo Pots: do I need one statement or several?

The main account statement shows transfers to and from each Pot as single lines but not what happened inside the Pot. If you only need the current account for bookkeeping, one statement is enough. If a Pot earns interest or is used to hold VAT or tax, download that Pot statement separately and convert it as its own account so the interest lines are captured.

Should I upload the Monzo CSV or the PDF?

Both are accepted. The CSV keeps Monzo categories, which can be useful for setting up rules, but it has no balance column. The PDF carries the running balance and is the document most accountants and lenders expect to see. If you are reconciling, use the PDF; if you want categories, use the CSV, or run both and compare.

Monzo's amounts are one signed column. Will they be split into Money in and Money out?

Yes. Negative amounts go to Money out and positive to Money in, and the balance column is carried across unchanged. The split makes the sheet match the layout of the high street banks so several accounts can be pasted together.

How do I convert a Monzo statement PDF to Excel?

Download it from Monzo using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many Monzo statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in United Kingdom

All banks and formats · See a sample result