BMO Harris: how to export your statements (web & mobile)

Downloading a clean transaction file from BMO Harris takes only a minute. On desktop, sign in to BMO Digital Banking and open the account you want to analyze. Look for Download activity, Export, or a similar link in the activity view. Select a date range—last six or twelve months shows a balanced picture—and choose CSV as the file type. CSV preserves headers and values in a format our analyzer can map reliably. If CSV is not available for your account type, try OFX or QFX. These financial interchange formats carry standardized fields and also parse well. After the file downloads, drag it into the uploader above or use the file picker. On mobile, the steps are the same: navigate to the account, select your range, export as CSV, and save the file to your device or a cloud drive so you can upload it from your browser.

PDF statements can work if they are text-based (not scanned images). Banks sometimes generate PDFs that embed a selectable text layer; those are readable. If your PDF is a scan or photo, the data must be recognized by OCR, which can introduce mistakes such as missing minus signs or merged columns—problems that lead to inaccurate totals. Whenever possible, favor CSV for the highest precision. If you must use PDFs, preview the table rows in our analyzer and spot-check a handful of entries against the original statement before you rely on the totals.

What the analyzer detects automatically

Once your statement is loaded, the analyzer normalizes every row to a standard structure—date, amount, currency, description, type, balance—and applies a series of quick checks to improve data quality. Duplicate detection removes the same transaction repeated through overlapping date exports. Refund pairing associates positive entries with matching negative outflows by amount and merchant string, which makes category totals more representative. The categorizer uses a mix of merchant keyword rules and amount patterns to assign entries to top-level buckets such as Groceries, Dining, Transport, Shopping, Bills & Utilities, Fees, and Income. You can edit category names in the table and the rollups will update instantly. Recurring charge detection looks for monthly or weekly cadence from the same merchant and flags items that act like subscriptions, which are easy to overlook on busy accounts.

BMO Harris CSV mapping & typical column names

BMO Harris CSV exports commonly include columns like Date, Description, Amount, Type, and sometimes Balance. In some accounts, credits and debits are represented by signed amounts (negative for outflow, positive for inflow). In others, CSVs include separate Debit and Credit columns. The analyzer preset shown below handles both situations. If your export looks different, you can still upload the file—the parser will attempt to infer which column is the amount and which is the description. Make sure dates are consistent and that the decimal separator is a period; commas in amounts can be misread if they appear without surrounding quotes.

If your file includes Debit and Credit as separate columns, the analyzer converts them into a single signed amount by subtracting debit values and adding credits. If the CSV already has a single Amount field, we use that and ignore any empty debit/credit columns. When both amount styles appear, a short inspection step determines which field is populated in more than 80% of rows—that field wins as the canonical amount. The goal is to keep the workflow simple and reduce pre-processing steps for you.

Known quirks & quick fixes

• Pending vs. posted: If your download includes pending items, those may appear twice when they post. Export a date range that ends at the last posted day to avoid duplicate pending rows.
• Reversals and corrections: Reversal entries can carry short descriptions. If a refund pairs incorrectly, edit the category on that row or remove the pairing in your spreadsheet after export.
• Checks and transfers: Checks are often marked as withdrawals with check numbers in the description; these default to Bills & Utilities unless the amount pattern suggests Rent or another category you pick.
• Balance-only files: Some monthly PDF statements list daily balances without line-item activity. Use CSV for detailed analysis.

Insights you’ll get in minutes

With a single upload, you’ll see a clear picture of where your money goes. The top category table shows your biggest spend areas by total and by count, which makes it easy to spot overspending patterns or one-off spikes. The recurring charge detector highlights potential subscriptions—streaming services, app memberships, and utility add-ons—so you can decide what to keep and what to cancel. You can filter and edit category labels, then export a clean CSV or Excel file for budgeting apps, tax software, or reimbursement reports. Because every calculation runs locally in the browser, you maintain control over your data from start to finish.

Use cases: personal, taxes, and business claims

For day-to-day budgeting, the analyzer offers a quick way to identify leaks and redirect spending toward goals. For tax time, the cleaned CSV separates out income, business expenses, and fees you might deduct, and gives you a record of refunds and chargebacks. If you use BMO Harris for side-business activity, exports help you prepare schedules, reimbursements, and audit trails without giving an app full access to your accounts. This light-touch workflow is also useful if you need to share a subset of transactions with a partner, advisor, or accountant—export the exact range you want to disclose and nothing more.

Privacy & security

MoneyToolsHQ is privacy-first. Your uploads are processed locally using browser APIs; we don’t store, transmit, or log your statements. If you refresh the page or click Clear, the data disappears. For additional peace of mind, remove the file from your device or temporary folder after exporting. If at any time you prefer automated bank connections, we plan to add optional connectors that require explicit consent and still allow offline uploads for users who want to stay fully local.

FAQs

Do you store my BMO Harris statement?
No. Files are processed in your browser only.

Which formats work best?
CSV first, OFX/QFX second, PDF last (only if text-based).

What if my CSV has separate Debit and Credit columns?
The preset merges them into a single signed amount automatically.

Can I change categories?
Yes—edit category cells before exporting the cleaned CSV.

How do I avoid duplicates?
Export a date range without pending items and avoid overlapping ranges when combining files.

Does this work for savings, checking, and credit cards?
Yes, as long as the export includes line items with dates and amounts.

Can I use the cleaned CSV in other tools?
Absolutely. Import it to spreadsheets, budgeting apps, or tax software.

Will the analyzer detect fees and interest?
Yes—entries containing typical fee or interest keywords are flagged accordingly.

Is there a cost?
The web tool is free. Future premium features may be optional.

Changelog

• v1.0 — Initial release with CSV/OFX parsing, PDF text extraction, category editor, recurring detector, and clean CSV/Excel export.