Convert Monzo statements to Excel and CSV
If you have Monzo statement PDFs (often the case when a client shares statements, or a lender asks for them), upload them to statement.work to get every transaction as a row with date, description, signed amount and running balance. Transfers to and from Pots come out as their own rows to categorize as transfers.
Not affiliated with Monzo. statement.work is an independent tool. Monzo is a trademark of its owner and is named here only to describe the statements this page is about.
About Monzo statements
Monzo is a UK app-based bank, founded in 2015, with personal and business accounts managed almost entirely through its mobile app. App-based banks tend to give account holders good digital exports, so the main reason to convert Monzo statements is a different one: the statement has reached you as a PDF.
When you’ll still have PDFs
- Accountants and bookkeepers often receive statements from clients as PDFs rather than having access to the account.
- Lenders, landlords and agencies ask for PDF statements, and those are the files people keep.
- Mixed-bank work is simpler when every bank, app-based or not, ends up in the same columns.
What the statements typically contain
- Account details and the statement period.
- A list of transactions with date, description, amount and balance.
- Transfers to and from Pots, where used, alongside card payments, bank transfers and direct debits.
Check your own statements for the exact layout, which can change as the app evolves.
Common conversion problems
- Pot transfers. Moving money into a savings Pot looks like money leaving the account. Categorize it as a transfer, not spending.
- Many small transactions. App-banking customers often have long statements full of small card payments. Manual entry is especially slow here.
- Merchant names. Descriptions are usually cleaner than on traditional bank statements, which helps categorization.
How to convert it
- Use the PDF statement you have, or download one from the app.
- Upload it to statement.work.
- Review the transactions, marking Pot movements as transfers.
- Export to CSV or Excel. The CSV vs XLSX guide helps you choose.
- Check the closing balance.
Related
Starling is another UK app-based bank with similar considerations. For sole traders and small businesses, app accounts are often the main business account.
Questions
Can't I just export from the Monzo app?
If you hold the account and the app's export gives you what you need, use it. statement.work is most useful when what you have is a PDF statement, such as statements a client has sent you, or when you want every bank in the same columns.
How should I treat Pot transfers?
Money moved between your main account and your own Pots is a transfer, not spending or income. Categorize those rows as transfers so they don't distort totals.
Is statement.work affiliated with Monzo?
No. statement.work is independent and is not affiliated with or endorsed by Monzo Bank.