Convert Monzo CSV to QuickBooks (.QBO)
Works with Monzo CSV and Excel exports Nothing uploaded
Monzo is app-first, so you export transactions from the app or web: open an account, tap into statements, and download a CSV (PDF statements are also available). There is no .QBO, .QFX or Web Connect option, Monzo gives you a spreadsheet and leaves the accounting format to you.
The Monzo CSV is actually one of the cleaner UK exports, but it is wide. It uses an ISO Date (YYYY-MM-DD), a single signed Amount column (spends negative, credits positive), plus a stack of extra fields QuickBooks doesn't want, Monzo's own Category, Notes and #tags, Address, Emoji, currency columns, and (on business accounts) a running Balance and Balance currency. QuickBooks Online's importer only accepts a slim 3- or 4-column layout, so all those extras cause mapping errors or a rejected file.
QBO Maker strips the file down to what matters, date, description (built from name plus notes), and the signed amount, then writes a valid .QBO for QuickBooks Web Connect. The ISO date is handled natively, so nothing shifts. It runs entirely in your browser; your Monzo data never leaves your device. Convert your Monzo CSV now.
.QBO QuickBooks accepts. For Monzo, its dates are usually YYYY-MM-DD, and amounts arrive as a single signed column (debits negative, credits positive), both detected automatically.A typical Monzo export has columns like Date, Time, Type, Name, Emoji, Category, Amount, Currency, Local amount, Local currency, Notes and #tags, Address, Receipt, Description, Category split, Money Out, Money In and uses YYYY-MM-DD dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Monzo statements into QuickBooks
- Export your transactions from Monzo online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Monzo-specific things to watch for
- Lots of extra columns. Monzo exports category, emoji, address, notes, receipt and currency fields QuickBooks can't use. QBO Maker keeps only date, description and amount and drops the rest.
- ISO date format. Dates are YYYY-MM-DD rather than UK DD/MM/YYYY, clean, but the converter still normalises it to the format the .QBO spec requires.
- Business accounts add a balance. Monzo Business CSVs include
BalanceandBalance currencyat the end; these are ignored on conversion since QuickBooks recalculates the running balance. - Multi-currency rows. Foreign spends show both
Amount(GBP) andLocal amount; QBO Maker uses the GBP figure to match your account ledger.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Can I import Monzo transactions into QuickBooks without a bank feed?
Yes. Export a CSV from Monzo, run it through QBO Maker to get a .QBO file, and import that via QuickBooks Web Connect. It is the reliable way to backfill history or work around a broken feed.
Does Monzo export a QBO file directly?
No. Monzo only offers CSV and PDF. The CSV is well structured but contains far more columns than QuickBooks accepts, so converting it to .QBO removes the extra fields and the mapping headaches.
Will the Monzo category and notes carry into QuickBooks?
The .QBO standard carries a transaction memo, so QBO Maker folds your Monzo notes into the description where useful. Monzo's own category labels aren't part of the .QBO spec, you'll categorise in QuickBooks, but the merchant name and notes give you plenty to match on.
Is converting my Monzo statement private?
Completely. Everything runs in your browser with no upload. Check the output on the validator before importing if you want to be sure.