Convert BMO statements to Excel or CSV

BMO issues a separate PDF statement for each chequing, savings and credit card account. Upload one here to get the transactions as a CSV for Excel or Google Sheets, or a full report on where the money went.

Drop your bank statement PDF here, or choose it

PDF, up to 10 MB. Nothing is stored.

Where to find your BMO statement PDF

  1. Sign in to BMO Online Banking.
  2. Select the account, then Statements.
  3. Click the month to open the PDF, then save it.

How BMO statements are read

Card credits are marked CR

A BMO Mastercard statement prints CR after any amount that is a credit, both on transaction rows and on the balances in the summary. The converter reads the marker, so a refund or a payment comes out as money back rather than as a purchase.

Your own e-Transfers are transfers

An Interac e-Transfer you send prints as INTERAC e-Transfer Sent whether it went to somebody else or to your own account at another bank. Upload that other account's statement as well and the spending report matches the two halves by amount and date, so moving your own money is counted as a transfer.

Parse BMO statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

{
  "object": "document",
  "issuer": {
    "name": "BMO",
    "domain": "bmo.com"
  },
  "currency": "CAD",
  "period": {
    "year": 2026,
    "month": 8
  },
  "accounts": [
    {
      "type": "credit_card",
      "last4": "2208",
      "primary": true,
      "totals": {
        "credits": 600,
        "debits": 123.65
      },
      "transactions": [
        {
          "date": "2026-07-29",
          "description": "SOBEYS #4471 CALGARY AB",
          "amount": 92.15,
          "direction": "debit",
          "category": "groceries"
        },
        {
          "date": "2026-08-06",
          "description": "CINEPLEX 7114 CALGARY AB",
          "amount": 31.5,
          "direction": "debit",
          "category": "entertainment"
        },
        {
          "date": "2026-08-12",
          "description": "PAYMENT RECEIVED - THANK YOU",
          "amount": 600,
          "direction": "credit",
          "category": "card_repayment"
        }
      ]
    }
  ],
  "verification": {
    "reconciled": true,
    "issues": []
  }
}

Statements from other banks

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Three simple steps

01

Download your BMO PDF

Sign in to BMO Online Banking. Select the account, then Statements. Click the month to open the PDF, then save it.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in under a minute and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your statement for a spending score, category breakdown and honest AI feedback.