Monzo Bank Statement to Excel: Export and Convert

TL;DR Monzo usually lets you download statements from the app or web for a date range you choose, often as a PDF and sometimes as a spreadsheet-friendly export. For bookkeeping, start from the format that's easiest to convert, but keep the PDF as your reference for opening and closing balances. Convert everything to one row per transaction with a single signed Amount column, decide how you'll treat money moving to and from Pots, and check that opening balance plus all activity equals the closing balance before you do anything else. Once the numbers tie out, the file is ready for Excel analysis, Xero, QuickBooks, FreeAgent or your Self Assessment workings.

Monzo is one of the most widely used app-based banks in the UK, both for personal current accounts and for sole traders and small limited companies on Monzo Business. Its app is good at showing you what you spent last week. It's less obvious how to get a year of transactions into a spreadsheet that an accountant, a mortgage broker or your own tax workings can rely on.

This guide walks through the whole process: what Monzo statements contain, which export to choose, how to convert a PDF statement into rows, how to handle Pots, a worked reconciliation example, and how to prepare the file for accounting software. Monzo changes its app regularly, so we describe the options in general terms rather than listing exact taps and menu names.

What a Monzo statement contains

A Monzo statement for a current account generally includes the account holder's name, sort code and account number, the statement period, and a list of transactions with dates, descriptions and amounts. Depending on the format and the account type, it may also show a running balance and the balance at the start and end of the period.

A few Monzo-specific features affect how the data looks:

• Pots. Pots are separate pockets of money inside your account. Moving money into a Pot reduces your main balance; moving it back increases it. Depending on the statement type, Pot transfers may appear as individual lines, and Pots may or may not be included in the balance shown.
• Merchant names. Monzo tends to display cleaned-up merchant names in the app. The descriptions in statements and exports may be different from what you see on screen, and may include extra reference text.
• Card payments in other currencies. If you pay abroad, the line usually shows the sterling amount taken from your account. Some exports include the original currency amount in a separate field.
• Business features. Monzo Business accounts may include invoices, tax Pots and integrations with accounting software. The statement logic is the same, but there can be more internal movements to account for.

The key point for spreadsheets is this: you need to know whether the balance you're checking against is the main account balance alone or the main account plus Pots. Get that wrong and your balance check will never work.

Choosing the right export

Monzo has historically offered a few ways to get your data out. What you see depends on your account type and the current version of the app, so check what's available to you.

• PDF statements. These are the formal record. They're what lenders, letting agents and visa officers usually ask for, and they present the period's opening and closing balance in a way you can rely on.
• Spreadsheet exports (such as CSV). These are the easiest to work with in Excel, and often include more columns than the PDF, such as categories, notes, or local currency amounts. But an export focused on transactions may not give you an opening and closing balance, and its column layout may change between app versions.
• Accounting-software formats and integrations. Some accounts can export in formats designed for accounting packages, or connect directly to tools such as Xero, QuickBooks or FreeAgent. Integrations are great going forward but don't help if you need to rebuild or check historic months.

A practical rule: use the export for convenience, the PDF for truth. If the export and the PDF disagree on totals for the same period, trust the PDF and find out why.

If you only have PDFs, for example because someone sent you their statements for a mortgage application, or because you need statements for a closed account, you'll need to convert them.

Converting a Monzo PDF to rows

You have three realistic options.

Copy and paste. For a single page this can work. Select the transactions in a PDF viewer, paste into Excel, then use Text to Columns to split them. In practice, long descriptions wrap onto two lines, amounts lose their signs, and page headers end up in the middle of your data. It's fine for a quick look and painful for twelve months.

Power Query. Excel for Windows can import tables from PDFs through Power Query. It works well when the PDF has a consistent table structure on every page. Our Power Query bank statement guide explains how to combine pages and clean the result.

A dedicated converter. SheetStatement reads the PDF, produces one row per transaction with a signed amount, and checks the opening and closing balance before you export. The free plan covers 3 pages a month, which is enough to test a real statement. Starter ($9), Pro ($19) and Business ($39) monthly plans handle higher volumes.

Whichever route you take, aim for this layout:

Use a single signed Amount column: money in is positive, money out is negative. If your conversion gives you separate Paid in and Paid out columns, combine them:

=IF(C2<>"", C2, 0) - IF(D2<>"", D2, 0)

where C is Paid in and D is Paid out. Our guide to separating debit and credit columns covers the reverse case and the edge cases.

Keep a Source file column with the name of the statement each row came from. When you later combine a year of statements, that column is how you trace any number back to a page.

Handling Pots

Pots cause more confusion than anything else in Monzo data. There are two common situations.

The statement balance excludes Pots. Money moved into a Pot shows as an outgoing line, and money moved back shows as incoming. Your balance check works on the main account alone. For bookkeeping, these lines are transfers, not spending or income. Tag them with a category like Transfer – Pot so they don't inflate your expense totals.

The statement balance includes Pots, or Pot movements aren't listed. In this case, moving money to a Pot may not appear as a transaction at all, because the total hasn't changed. Your balance check should then use the combined figure.

You can usually tell which situation you're in by checking a month where you know you moved money to a Pot. If a line appears, and the running balance drops by that amount, the main balance excludes Pots.

For budgeting, treat Pot transfers as savings movements. For business bookkeeping, many people treat a tax Pot as part of the same bank account, because it's still the business's money. Some create a separate bank account in their accounting software for each Pot so the balances match. Both work. What matters is that you choose one approach and apply it consistently. If you're unsure which suits your accounts, ask your accountant.

Step-by-step: the balance check

Before you categorise or import anything, prove the data is complete.

Step 1: record the opening and closing balance

Take these from the PDF statement for the period. Put them in two cells, for example H1 (opening) and H2 (closing).

Step 2: sum the amounts

=ROUND(H1 + SUM(D5:D400) - H2, 2)

If the result is 0, every transaction is accounted for. If it isn't, the difference tells you what to look for.

Step 3: check row by row if there's a running balance

If your rows include the running balance, add a check column:

=ROUND(E4 + D5 - E5, 2)

Fill it down. The first non-zero row is where the problem starts: a missing line, a wrong sign, or a duplicated row. Our running balance formula guide explains this check in more detail, including what to do when transactions on the same day are listed in a different order.

Step 4: interpret the difference

• Exactly equal to one transaction: that row is missing or duplicated.
• Twice a transaction amount: a sign is wrong, so a debit was recorded as a credit or the reverse.
• Equal to a Pot transfer: you're mixing a balance that includes Pots with one that doesn't.
• A round number with no obvious match: a page may be missing. Check that every page of every statement is present.

Worked example

Here's a short, illustrative month for a sole trader using Monzo. The figures are made up to show the method.

Opening balance (from the PDF): £1,240.00. Closing balance: £1,605.50.

Sum of amounts: 1,800.00 − 450.00 − 54.99 − 86.40 − 4.60 + 650.00 + 100.00 − 38.51 − 1,550.00 = 365.50.

Check: 1,240.00 + 365.50 − 1,605.50 = 0.00. The month reconciles.

Now look at what the categories tell you. Income is £2,450.00. Business expenses are £179.90 (software, travel, phone). The Pot transfers net to −£350.00 and are neither income nor expense. The £1,550 transfer to a personal account is drawings, and the £4.60 coffee is personal spending that shouldn't go in the business accounts at all. If you'd simply summed all the negative lines and called them expenses, you'd have overstated costs by more than £2,000.

That's why categorising transfers correctly matters more than precision on any single expense. Our guide to separating personal and business expenses goes further on this.

Cleaning the data in Excel

Once the balance check passes, a little cleaning makes the file much easier to use.

Dates. UK statements use day/month/year. If your Excel is set to US format, dates like 03/04 can flip into the wrong month, and dates like 25/03 stay as text. Check by sorting: if 13/03 sits among the text values, your dates didn't convert. Our guide to fixing bank statement dates in Excel has formulas for each case.

Amounts stored as text. If amounts include a pound sign or a thousands separator, Excel may treat them as text. =VALUE(SUBSTITUTE(SUBSTITUTE(D2,"£",""),",","")) fixes most cases.

Descriptions. Monzo descriptions can include the merchant name, a location and reference text in one field. If you want to group spending by merchant, see splitting bank transaction descriptions.

Categories. If you've used Monzo's own categories, an export may include them. They're useful for budgeting but rarely line up with accounting categories. For bookkeeping, map them to your chart of accounts with a lookup table, or build your own rules as shown in Excel formulas to categorise transactions.

Combining a year of Monzo statements

For a tax year or a mortgage application, you'll often need twelve months of data. The approach:

1. Convert each statement to the same layout.
2. Run the balance check on each one individually.
3. Confirm each statement's closing balance equals the next statement's opening balance. A gap means a missing period.
4. Stack them into one table, keeping the Source file column.
5. Remove any duplicates at the boundaries if your date ranges overlapped.

Our guide to combining multiple bank statements in Excel covers this with Power Query and with plain copy-and-paste.

Remember that the UK tax year runs from 6 April to 5 April. If you're preparing a Self Assessment, filter on that range rather than on calendar months.

Importing into accounting software

Once the data is clean, importing it is straightforward. The general pattern:

• Xero accepts CSV bank statement files with a date, amount and description at a minimum. See the Xero CSV import format guide, and the Xero import errors guide if the upload fails.
• QuickBooks Online accepts CSV files in a three-column or four-column layout. See importing bank statements into QuickBooks Online.
• FreeAgent accepts CSV and other formats. See importing a bank statement into FreeAgent.

If you already use a live bank connection, import only the periods that are missing, otherwise you'll create duplicates. Check the date of the earliest transaction your bank feed brought in, and import only what comes before it.

Using Monzo statements for applications

Monzo statements are often requested for mortgages, rental applications and visas. In those cases:

• Send the official PDF statements. A spreadsheet you made is useful for your own preparation but usually won't be accepted as evidence on its own.
• Make sure the statement shows your name and account details. Some requests specifically need these, and screenshots from the app often don't include them.
• Cover the full period requested, with no gaps.

Requirements vary, so check exactly what's asked. Our guides to bank statements for mortgage applications and bank statements for a rental application cover what's commonly expected.

Common problems and fixes

The balance check is off by a Pot transfer. You're mixing a balance that includes Pots with one that doesn't. Decide which balance you're reconciling and use matching figures.

Foreign card payments look wrong. Use the sterling amount that left your account, not the original currency amount. If there are separate fee lines, include them.

Refunds appear as positive amounts in expense categories. That's correct. A refund reduces the expense. Keep it in the same category as the original purchase so totals net off.

Pending transactions. An export made mid-month might include transactions that haven't settled yet. Statements are usually based on settled transactions. If the export and the PDF differ by a few recent lines, this is likely why.

Duplicates after combining files. Overlapping date ranges produce repeated rows. See removing duplicate bank transactions safely.

Convert your Monzo statements

Upload your Monzo PDF statements to SheetStatement, check that the balances tie out, and export to Excel or CSV ready for Xero, QuickBooks or your own spreadsheet. Start with the free plan's 3 pages a month.

FAQ

Can I download Monzo statements as Excel?

Monzo generally offers PDF statements and, depending on your account and app version, a spreadsheet-friendly export such as CSV, which Excel opens directly. If you only have PDFs, convert them to rows with Power Query or a converter.

Do Monzo statements include Pots?

It depends on the statement type. Check a month where you moved money to a Pot: if a line appears and the running balance drops, the main balance excludes Pots and those lines are transfers.

Should Pot transfers count as expenses?

No. Moving money to or from a Pot is a transfer within your own money. Tag those lines as transfers so they don't inflate spending or income totals.

Why doesn't my export match my PDF statement?

Common causes are pending transactions included in an export, different date ranges, or Pots being included in one balance and not the other. Trust the PDF for opening and closing figures.

Will a mortgage lender accept a spreadsheet instead of statements?

Usually not. Lenders typically ask for official statements showing your name and account details. Use the spreadsheet for your own preparation and send the PDFs.

How do I handle the UK tax year?

Filter your combined data from 6 April to 5 April. This is general information, not tax advice; check your situation with an accountant or HMRC guidance.

Is it safe to upload bank statements to a converter?

Read the provider's security policy first. SheetStatement explains how files are handled on its security page.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.