Financial Documents

Monzo Bank Statement to Excel: CSV, Pots and Closed Accounts

Monzo exports CSV from the app, but feeds back-fill about 12 months and a closed account gets one PDF. How to turn Monzo and Pot statements into Excel.

Published
Updated
Reading time
14 min
Topics:Financial DocumentsBank StatementsUKMonzoPDF conversionMonzo Businessbank feedsMTD ITSA

Monzo lets you download a bank statement as a PDF, a CSV or a QIF file in the app (Home, the three dots under your card, Bank statements) and on Monzo Business for web, for whatever date range you choose. The CSV opens straight in Excel, and customers on Extra, Perks or Max also get an automatic Google Sheets export of their transactions. So for an account you can log into, getting a Monzo bank statement to Excel is an export, not a conversion.

A PDF still has to be converted when it is all you have. That means the statements a client emails you instead of a login, the full-history PDF Monzo sends when an account closes, Pot statements, and Monzo Business history older than the roughly 12 months an accounting feed back-fills when it is first connected. Those PDFs need turning into a spreadsheet with one row per transaction.

Every route Monzo offers, side by side:

RouteWho gets itWhat you getHow far back
Bank statements export, in the app or on the webEvery personal and business customerPDF, CSV or QIFAny range you choose; Monzo states no maximum
Google Sheets exportPersonal customers on Extra, Perks or MaxA Google Sheet updated in real timeNot stated
Xero, FreeAgent or Sage feedMonzo Business Pro or TeamA bank feed into the accounting softwareAbout the last 12 months on connection, or from your FreeAgent or Sage start date
QuickBooks connection through Open BankingNot statedA bank feed, without payments made directly from a PotNot stated
Monthly auto-export to Google Drive or OneDriveMonzo Business Pro or TeamPDF, CSV and QIF statements each monthFrom the month you switch it on
Closed-account statementAnyone who closes an accountOne password-protected PDF, emailedThe account's full transaction history

Downloading a Monzo statement or CSV in the app and on the web

On a personal account, the statement download sits in the app rather than behind a separate online banking login. Go to Home, tap the three dots under your card, choose Bank statements, pick the start and end dates, then choose PDF, CSV or QIF. A CSV export covers every transaction in the app, Pots included.

On Monzo Business, the same screen is under Home, then Manage, then Bank statements. Monzo Business for web has an export statement button that downloads the same statements in CSV, QIF or PDF, which is the easier route when the file needs to land on a laptop with Excel on it.

A few details worth knowing before you ask a client for a file:

  • Formats. There is no OFX, no QBO and no native Excel file. The CSV opens in Excel as it is; QIF is for older personal-finance software.
  • Range. Monzo states no maximum range. Users on the Monzo Community forum report very long all-time exports failing to complete, so a year at a time is the safer request.
  • What the PDF shows. The name and address on the statement are the ones on the account on the last day of the range you chose. Monzo treats its statements as original documents that need no bank stamp, which matters when one goes to a lender, a letting agent or HMRC.

Two routes produce files without anyone remembering to download them. Personal customers on Extra, Perks or Max get an automatic Google Sheets export, a sheet called "Monzo transactions" that updates in real time, with a joint account on its own tab and a column naming the Pot for Pot transactions. For that reader, the transaction history spreadsheet already exists. Monzo doesn't say whether it fills in history from before the export was switched on, so check the earliest date on the sheet before relying on it for a past year. On Monzo Business Pro and Team, monthly statements can be exported automatically as PDF, CSV and QIF to Google Drive or OneDrive, which keeps a client's statements filed from the month it is switched on.

For a live account that you or your client can log into, the CSV or the Google Sheet usually does the job, and nothing needs converting. When a client offers to send statements, ask for a CSV of the period rather than PDFs if they can produce one. Revolut also exports from its app, under rules of its own: see the guide to converting Revolut statements to Excel.

What Monzo's accounting feeds leave out: Lite accounts, the 12-month sync and Pot payments

Monzo Business connects to Xero, FreeAgent, Sage and QuickBooks, but the connections come with rules that decide how much of a client's history arrives on its own.

The plan. The Xero, FreeAgent and Sage feeds need Monzo Business Pro or Team. A client on Monzo Business Lite has no feed into any of those three. QuickBooks is different: it connects through Open Banking and is set up from inside QuickBooks, and Monzo's help gives no plan rule for it.

Pot payments and QuickBooks. Monzo's help says that any payments made directly from a Pot will not sync to QuickBooks. A client who pays a supplier or a subscription straight out of a Pot will have gaps in the QuickBooks feed that only the Pot's statement fills.

How far back the sync reaches. When a feed is first connected, Monzo says it syncs "as far back as the start of your Monzo Business transaction history, 12 months ago", or, for FreeAgent and Sage, as far back as the start date set in that software. The wording can be read more than one way, so plan on the feed bringing in about the last 12 months and no more.

Anything older. Monzo's own advice is to export the bank statement as a CSV and upload it to the accounting software, and not to re-sync transactions that have already been uploaded, because that creates duplicates. In practice, find the earliest date the feed has brought into the software, then end the uploaded history on the day before it. Nothing is double-counted, and the import step itself follows the usual routine for importing bank statements into Xero or its equivalent in FreeAgent or Sage.

That leaves four clients whose history has to come from statements or the export rather than the feed:

  • A Lite client moving onto Xero, FreeAgent or Sage. There is no feed, so every month comes from a file.
  • A Pro or Team client who connected late. Everything from before the sync window comes from a file.
  • Any catch-up job reaching back past about 12 months, such as two years of unfiled Self Assessment or a VAT enquiry.
  • A QuickBooks client whose Pots pay bills directly. Those payments come from the Pot statements.

Where the client can still log in, Monzo's CSV covers all four. Where they can't, or they have already sent PDFs, the statements have to be converted.

A closed Monzo account leaves one password-protected PDF of its whole history

When a Monzo account is closed, Monzo emails the customer a bank statement covering the account's full transaction history. The PDF is password-protected, and the password arrives separately, by text or by email. Not every bank sends a file at all: TSB, for one, posts a closed account's statement history on paper, which then has to be scanned before it can be converted.

If that email has been lost, more copies can be requested at monzo.com/closed-account-statements for UK accounts. Monzo asks for a selfie holding photo ID, or holding a piece of paper with today's date written on it, and says it replies within 2 working days, though it can take up to 7 working days.

This is the Monzo document a bookkeeper inherits from a client who has switched banks. There is no app left to export a CSV from, and everything from the day the account opened to the day it closed is in that one file: a year's VAT quarters, the last Self Assessment period, or the full history an enquiry asks for.

Before it can be converted, the password has to come off. Open the PDF with the password the client was sent and print it to a new PDF (in a browser, Print, then Save as PDF), which gives a copy without the password. The unlocked copy is the one to convert.

Once unlocked, the whole history converts into a single sheet, which can then be filtered down to the tax years or quarters the job needs rather than being split up by hand first.


Converting Monzo and Pot statements to Excel

For most bookkeepers the PDFs aren't the closed-account file. They are the statements a client emails over at year end instead of sharing a login or working out the CSV export. Converting what has arrived is usually quicker than another round of asking.

Pot statements are often part of the same pile. In the app, a Savings Pot has Pot documents, then Pot statement, a PDF to share or save. On Monzo Business, statements can be requested for Pots from the same Bank statements screen as the main account. A client who keeps tax money or pays bills from Pots should send one for each Pot as well as the main account's.

None of Monzo's own routes help once the files are already PDFs. With Invoice Data Extraction you upload them as they arrived and convert Monzo PDF statements into Excel or CSV: a year of monthly statements, a main account with its Pots, or the unlocked closed-account file go in together as one task, which takes up to 6,000 files. Bank statements come back as one row per transaction, from downloaded PDFs or scanned ones.

You say what the spreadsheet should look like in plain words. The ready-made bank statement prompt asks for one row per transaction, and you can add to it: an Account/Pot column so every row says which statement it came from, a column marking transfers between the main account and a Pot, or a category for each transaction. The download is Excel, CSV or JSON. In Excel, amounts come through as numbers and dates as dates, so totals and pivot tables work straight away.

Two columns follow the ones you asked for. Source File gives the file and page each row came from, so a figure can be checked against the right statement. Review Needed flags a value or a row the panel of AI agents cannot agree on, with what to check. The output doesn't include QIF, so software that only takes QIF needs Monzo's own export.

Plenty of clients bank in more than one place. A sole trader with Monzo Business for trading and a high-street current account for everything else can send both banks' PDFs into the same task. Whether the other bank needs a PDF at all depends on its own export rules: see Nationwide's CSV, midata and PDF statement limits and the guide to Lloyds bank statement to Excel.

Worked example: a sole trader's main account and two Pots for one MTD quarter

A freelance designer trades through Monzo Business. Every time a client pays, she moves a fifth of it into a Tax Pot. A second Pot, for expenses, gets a monthly top-up from the main account and pays her design software subscription directly. Her bookkeeper is preparing the first Making Tax Digital quarter, 6 April to 5 July 2026, and the designer sends three PDF statements for those dates: the main account, the Tax Pot and the Expenses Pot.

All three go into one task with this prompt:

One row per transaction. Date as DD/MM/YYYY, description, money in, money out, balance. Add an Account/Pot column with the name of the account or Pot the statement is for. Add a Transfer column: Yes if the transaction is a move between the main account and a Pot. Add a Category column: Sales, Software, Travel, Office or Other, left blank for transfers.

An invented extract of the rows that come back:

DateDescriptionMoney inMoney outBalanceAccount/PotTransferCategory
08/04/2026HARTLEY DESIGN LTD1,800.004,210.55Main accountSales
08/04/2026Tax Pot360.003,850.55Main accountYes
08/04/2026From main account360.002,960.00Tax PotYes
01/05/2026Expenses Pot150.003,700.55Main accountYes
01/05/2026From main account150.00212.40Expenses PotYes
03/05/2026ADOBE CREATIVE CLOUD56.98155.42Expenses PotSoftware
12/05/2026TRAINLINE42.603,657.95Main accountTravel

Each move into a Pot appears twice: as money out on the main account's statement and as money in on the Pot's. The £360 to the Tax Pot and the £150 to the Expenses Pot are neither income nor expenses, and each pair sums to zero across the sheet. Left in, they would inflate both the money in and the money out for the quarter.

There are two ways to handle them, depending on the job:

  • For the quarter's figures, filter out every row marked Yes in the Transfer column. In these rows, what remains is £1,800 of sales and £99.58 of expenses, with a category on each.
  • For reconciling the statements, keep the transfers and build a pivot table by Account/Pot. Each Pot's rows should run from its opening balance to the closing balance printed on its statement, and the main account's the same. A Pot that doesn't reconcile points to a missing statement or a missing page, and the Source File column, which names the PDF and page behind every row, shows where to look.

The Adobe payment is the row that would go missing most easily. It left from the Expenses Pot, not the main account, so converting only the main account's statement would have dropped it, and a QuickBooks feed would not have carried it either.

Can a converted Monzo sheet be your MTD record?

Making Tax Digital for Income Tax from April 2026 applies to sole traders and landlords with qualifying income above £50,000, and it requires digital records of each transaction and a quarterly update to HMRC.

A spreadsheet can be those records. ICAEW's Tax Faculty guidance on MTD for Income Tax says a taxpayer could create the digital records in a spreadsheet based on bank information, provided each record carries at least the amount, the date and the category. The condition is that the spreadsheet must be linked to a bridging product that submits the information to HMRC quarterly.

The same guidance says the category has to be one of those set out in HMRC's quarterly update direction, or simply income or expense for someone eligible for three-line accounts, which includes self-employment income under £90,000. So the worked example's sheet meets the first part once its Category list in the prompt is changed to whichever of those applies: every row already has its date and amount, and the Transfer column keeps the Pot moves out of the figures. What it still needs is bridging software linked to it to send the quarterly update.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours