We turn your Monzo statement PDF into a spreadsheet with the columns the statement prints. We check every balance, the account's and each pot's, and keep the pots apart from the account.
What a Monzo statement looks like
- A Monzo statement has four columns: Date, Description, (GBP) Amount and (GBP) Balance. Money out is a negative amount.
- The newest transaction comes first.
- The account's own transactions come first. After them, each pot has a section of its own, headed Pot statement, with its own running balance. A pot with no transactions in the period adds no rows.
- Moving money into a pot shows up twice: as Transfer to Pot in the account, and as a deposit in the pot.
- A card payment in another currency has the original amount and the conversion rate in its description.
What your spreadsheet looks like
An Account column names the account each row belongs to: Personal Account or Business Account, or the pot's name. We check each pot's balance against its own rows, so the step from the account's rows to a pot's is never counted as a break.
In the Excel download, each account has a sheet of its own. When you add up a column on one sheet, you get that account's money only, so a move into a pot is not counted twice.
| Date | Description | (GBP) Amount | (GBP) Balance | Account | Ledger |
|---|---|---|---|---|---|
| 21/03/2024 | Card payment, online store | -5.99 | 597.89 | Personal Account | ok |
| 17/03/2024 | Transfer to Pot | -100.00 | 603.88 | Personal Account | ok |
| 17/03/2024 | Deposit | 100.00 | 128.00 | Holiday | ok |
The rows above are an example, not a real statement.
How we test it
We test against five Monzo statements, personal and business, with 464 transactions in all across the accounts and their pots. In four of the statements, the Ledger column flags none of their 328 transactions. The fifth was changed in a PDF editor after Monzo issued it, and the Ledger column flags the 7 rows where the changed figures no longer add up.
Convert a Monzo statement
- Drop the PDF in the box on this page, and we show you its first page converted.
- Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
- To convert every page, choose a plan on the pricing page.
To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.
Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.