pdftoexcel

Convert your Monzo statement to Excel

Monzo Personal, Joint, and Business statements with Pots reconciled. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

BankPDFtoXLS is an independent service. We are not affiliated with, endorsed by, or sponsored by Monzo Bank. The name "Monzo Bank" is used only to describe compatibility with statements you have legally obtained from your own account. See our trademarks policy.

From Monzo PDF to verified spreadsheet

  1. 1. Drop your Monzo Bank PDF — digital or scanned, monthly statement or a combined multi-month export, up to 50 MB (or batch up to 25 files). Password-protected PDFs and image-only scans both work: scans go through vision OCR automatically.
  2. 2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
  3. 3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

Inside a Monzo statement: format details

Sections in the PDF
Account Summary · Transactions · Pots Activity · Direct Debits and Standing Orders · Fees
Transaction date format
DD/MM/YYYY
Products we've parsed
Monzo Personal Current Account, Monzo Joint Account, Monzo Premium / Plus, Monzo Business Pro / Lite, Monzo Pots (Easy Access, Instant Access Savings, Cash ISA)

Monzo statements use the British DD/MM/YYYY date format and list amounts in pence-precision sterling. The activity block carries a richer description column than legacy UK banks — merchant logo URLs, category tags, location strings — but the printed PDF strips the visual elements and keeps only the textual content. The parser preserves all of it including the category tag, which the export surfaces as a separate column for budget-categorisation work.

Pots are named sub-balances under the main current account, with each Pot having its own running balance. The PDF lists Pot transfers (auto-Pot allocations from salary, manual moves, IFTTT-triggered transfers) in their own block. The parser keeps each Pot on its own sheet in the XLSX export so per-budget tracking stays clean while the main current account reconciles independently.

Joint accounts and Business Pro statements use the same template as personal accounts — the only difference is the masthead account name and the appearance of multiple cardholder identifiers in the Direct Debit block. The parser handles all three identically, with the cardholder tag preserved in metadata for split-tracking workflows.

Supported Monzo statement types

We handle checking, savings, and business PDFs from Monzo Bank.

  • checking
  • savings
  • business

Where Monzo PDFs trip up manual conversion

Format-specific quirks that break naive PDF parsers — and how the reconciliation pipeline handles each one.

Pot auto-transfers from salary cluster on payday

Customers with salary-sorter rules enabled get multiple auto-allocations into Pots on payday — typical setups have 3-7 simultaneous transfers (Bills Pot, Tax Pot, Savings Pot). Each transfer posts as a separate debit on the main account and a matching credit on the destination Pot. Manual reconciliation that sums everything fails because internal transfers double-appear across sections. The parser pairs each transfer with a shared transfer-ID and the XLSX export adds an 'internal transfers' summary tab so per-account running balances stay clean while the salary-sorter pattern remains auditable.

Direct Debit block lists upcoming alongside completed

Monzo statements include a Direct Debit and Standing Order block that lists both completed payments for the period AND upcoming scheduled payments due before the next statement. Naive parsers that include all rows in the running-balance check end up with a future-dated debit pulling the ending balance lower than the printed figure. The parser detects upcoming-payment rows by their date being after the statement-period end and excludes them from reconciliation while preserving them in a 'scheduled payments' metadata tab.

Premium subscription rebate posts as separate row

Monzo Premium and Plus subscribers get a monthly fee debit and, when qualifying criteria are met, a partial rebate posted as a separate credit row mid-cycle. The two rows share the same description prefix ('Monzo Premium') but with different signs. Parsers that aggregate by description string lose the net cost. The parser keeps the fee and rebate as distinct rows and adds a derived 'net subscription cost' metadata column so per-month value-tracking works without manual netting.

Frequently asked questions

How are Monzo Pots represented in the export?
Each Pot ends up on its own sheet in the XLSX export with its own running balance. Auto-Pot allocations from salary, manual top-ups, and IFTTT-triggered moves are tagged with a shared transfer-ID so cross-Pot flows can be netted without losing the budget-allocation trail.
Will Monzo Business Pro statements convert?
Yes. Business Pro and Lite use the same multi-section layout as personal accounts — the parser handles them through the same pipeline and the QBO exporter tags business-relevant rows for a clean QuickBooks Online import.
Are categories preserved in the export?
Yes. Monzo's per-transaction category tag (Eating Out, Groceries, Transport) is preserved as a separate column in the XLSX export, separate from the description, so QuickBooks chart-of-accounts mapping doesn't need manual cleanup.
Can I batch a year of Monzo PDFs?
Drop up to 10 monthly PDFs in a single upload — Personal, Joint, and Business statements can be mixed in the same batch and you get separate XLSX/CSV/QBO files in the downloaded ZIP.

Further reading

Engineering notes

Why your bank statement balance doesn't match: 7 specific causes and how to track each one down

When the sum of transactions doesn't equal the printed ending balance, the cause is almost always one of seven specific patterns. A field guide to identifying which one you have, and what to do about each.

11 min read

Engineering notes

Password-protected bank statement PDFs: how to convert them safely without uploading the password to a stranger

Most banks ship encrypted statement PDFs by default. The conversion is easy when you have the password and impossible when you don't, but the part that matters most is what happens to the password during the conversion itself.

9 min read

Where Monzo conversions get used

Most Monzo statements that come through us are part of one of these workflows. Each link below explains how the reconciliation guarantee maps to that practice.

Forensic accountants

Discovery packets, multi-year tracing

Divorce attorneys

Opposing-counsel financial disclosure

Bookkeepers

Catch-up & bank-feed gaps

Scanned PDFs

Vision OCR + reconciliation

PDF to QBO

QuickBooks-ready OFX export

For QuickBooks workflows

Verified imports, no duplicates

More banks with the same Verified guarantee