What a converted Monzo statement looks like
We tested the converter on a 24-page Monzo Business Account statement covering a full year. With Tables only, Normal PDF and Merged output, it produced one sheet with Monzo's own four column headings:
| Date | Description | (GBP) Amount | (GBP) Balance |
|---|---|---|---|
| 14/03/2025 | Card payment, merchant name and town | -86.40 | 1412.75 |
| 12/03/2025 | Faster payment, sender name | 650.00 | 1499.15 |
On that statement:
- All 427 transactions came through on one sheet, under a single header row, even though the PDF repeats the header on every page.
- Dates were written as real Excel dates.
- Amounts and balances were numeric. Money out is negative and money in is positive, the way Monzo prints it, so
=SUM()of the amount column gives your net movement. - Merchant descriptions that wrap onto two lines in the PDF were joined into one cell.
Two things to tidy up
The test also showed what to fix by hand, which takes a minute:
- The account summary at the top. Monzo's first page shows your name, address, account balance, balance in Pots, total outgoings and total deposits. These lines appear as text rows above the Date header. Delete the rows above the header before you sort or import the sheet.
- Note lines. Monzo sometimes prints a line such as "This relates to a previous transaction" under a refund or adjustment. It comes through as a row with a description but no date or amount. Filter the Date column for blanks and delete those rows, or copy the note into the row above if you want to keep it.
Everything else (dates, signs, balances) needed no cleanup on our test file.
How to get your Monzo statement as a PDF
- In the Monzo app, open the account, tap the account name or the menu, and choose Statements (in Monzo Business it is under the account's settings).
- Pick the period you need. A custom range lets you export a whole tax year in one PDF.
- Choose PDF as the format and save or share the file to your computer.
Monzo also offers a CSV export for some date ranges. If you can get CSV directly, that is the most accurate source. The PDF route is useful when you have only been sent a PDF, for example by a client, accountant or landlord, or when you need an older statement that is only available as PDF.
Convert it
- Drop the Monzo PDF on the converter on this page.
- Keep Tables only and Normal PDF selected. Monzo statement PDFs have a real text layer, so OCR is not needed.
- Choose Merged, convert, and download the
.xlsxfile. - Delete the summary rows above the header and any blank-date note rows.
- Check that the final Balance matches the balance shown on the statement.
Using the sheet
With dates and amounts as real values you can:
- Total spending by merchant with a pivot table on Description.
- Split by month with
=TEXT(A2,"yyyy-mm")in a helper column. - Separate money in and out with
=SUMIF(C:C,">0")and=SUMIF(C:C,"<0"). - Import into bookkeeping software by saving as CSV and mapping Date, Description and Amount. Use DD/MM/YYYY as the date format.
Other UK banks lay statements out differently, but the same process applies. See the general bank statement PDF to Excel guide.