Convert Monzo CSV to QBO / QFX / OFX
Drop your Monzo CSV or Excel export below and get a Monzo → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from Monzo
Monzo is app-first. Personal: open the Monzo app > tap the account > 'Statements' (or the 3-dots / 'Export') > choose a date range > select CSV (PDF and QIF also offered). Business: tap the 3 dots on the business card > 'Bank statements' > choose period > CSV. Monzo offers CSV, PDF and QIF only - NO OFX/QFX/QBO download and NO QuickBooks Web Connect / INTU.BID. QuickBooks connects to Monzo only via Open Banking bank feeds (a known pain point is that Open Banking feeds often arrive with no payee/reference). Page value: 'Monzo only gives you CSV; here is how to convert it into a QBO QuickBooks will accept (with payees intact).' CSV has a HEADER ROW. Personal CSV column order: Transaction ID, Date, Time, Type, Name, Emoji, Category, Amount, Currency, Local amount, Local currency, Notes and #tags, Address, Receipt, Description, Category split, Money Out, Money In. Business CSV recently added trailing Balance and Balance currency columns. Quirks: (1) DATE and TIME are SEPARATE columns in the app's CSV export - Date is DD/MM/YYYY (UK), Time is HH:MM:SS; note the Monzo API/'created' field instead uses a combined ISO timestamp (YYYY-MM-DDTHH:MM:SSZ), so a robust parser should accept both DD/MM/YYYY and ISO. (2) Amount is a single SIGNED column (negative = spending) AND there are ALSO separate Money Out / Money In columns - use Amount OR Money Out/Money In, do not double-count. (3) 'Emoji' holds unicode; 'Name' = merchant/counterparty - map Name (+ Notes/Description) to the OFX payee/memo. (4) Multi-currency rows carry Local amount / Local currency.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for Monzo files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “Monzo” in the bank dropdown autofills it.
FAQ
How do I export a CSV from Monzo?
Monzo is app-first. Personal: open the Monzo app > tap the account > 'Statements' (or the 3-dots / 'Export') > choose a date range > select CSV (PDF and QIF also offered). Business: tap the 3 dots on the business card > 'Bank statements' > choose period > CSV. Monzo offers CSV, PDF and QIF only - NO OFX/QFX/QBO download and NO QuickBooks Web Connect / INTU.BID. QuickBooks connects to Monzo only via Open Banking bank feeds (a known pain point is that Open Banking feeds often arrive with no payee/reference). Page value: 'Monzo only gives you CSV; here is how to convert it into a QBO QuickBooks will accept (with payees intact).' CSV has a HEADER ROW. Personal CSV column order: Transaction ID, Date, Time, Type, Name, Emoji, Category, Amount, Currency, Local amount, Local currency, Notes and #tags, Address, Receipt, Description, Category split, Money Out, Money In. Business CSV recently added trailing Balance and Balance currency columns. Quirks: (1) DATE and TIME are SEPARATE columns in the app's CSV export - Date is DD/MM/YYYY (UK), Time is HH:MM:SS; note the Monzo API/'created' field instead uses a combined ISO timestamp (YYYY-MM-DDTHH:MM:SSZ), so a robust parser should accept both DD/MM/YYYY and ISO. (2) Amount is a single SIGNED column (negative = spending) AND there are ALSO separate Money Out / Money In columns - use Amount OR Money Out/Money In, do not double-count. (3) 'Emoji' holds unicode; 'Name' = merchant/counterparty - map Name (+ Notes/Description) to the OFX payee/memo. (4) Multi-currency rows carry Local amount / Local currency.
Is my Monzo data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.