Convert a Monzo CSV for Xero or QuickBooks

Monzo · CSV export from the app or web

Monzo's export is the opposite problem to most banks: instead of too little, you get far too much. Transaction IDs, emoji, categories, local currency amounts, notes, addresses, receipt links. Almost all of it is noise for bookkeeping, and the width alone is enough to confuse an import.

Exporting from Monzo

In the Monzo app, open the account, go to the statements or export area, choose your date range and export as CSV. The web app offers the same. Monzo does not offer OFX, so CSV conversion is the route into most accounting software.

What the export looks like

A wide file that commonly includes transaction ID, date, time, type, name, emoji, category, amount, currency, local amount and local currency, notes and tags, address, receipt, and description. Dates are day-first. The amount column is signed, so you do not need the separate money in and money out columns if both are present.

Field	Map it to
Date	Date
Amount	Amount
Name	Payee
Notes and #tags, or Description	Description
Category	Reference, if you want to keep it
Everything else	Leave unmapped

Convert it

Drop the file into the converter. It is processed in your browser, never uploaded.
Auto-detection will pick most of it up. Set anything it misses by hand, and set the columns you do not want to (none).
Check the preview, then download Xero CSV, QuickBooks CSV or OFX (currency GBP).

Convert your Monzo CSV free

Foreign spending: map the plain Amount column, not the local amount column. Local amount holds the original foreign currency figure, which would import at the wrong value.