Banks

Convert Monzo Bank Statements to Excel

Convert Monzo statement PDFs to Excel and CSV, with each pot on a sheet of its own and every balance checked, the account's and each pot's. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

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

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. 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.
  3. 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.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.