Transactions
This tab is protected by a PIN
Incoming Invoices
This tab is protected by a PIN
Credit Card
This tab is protected by a PIN
📊
Upload BMO CSV Transactions
Drag & drop BMO CSV or QBO/OFX exports here, or click to browse · Multiple files supported
✅ Safe to re-upload: If you download an updated CSV for the same month,
only new transactions will be added. Your categorizations stay untouched.
only new transactions will be added. Your categorizations stay untouched.
Total Incoming
—
credits in view
Total Outgoing
—
debits in view
Net Cash Flow
—
incoming − outgoing
Transactions
—
in current view
Transactions
—
Total Invoices
—
all invoices
Total Amount
—
across all invoices
Paid
—
marked as paid
Unpaid
—
outstanding
Incoming Invoices
—
| Sr. | Partners | Invoice # / Order # | Client | RP Case # | Received | Amount | Currency | Status | PDF / Link | Task |
|---|
💳
Upload BMO Credit Card CSV
Drag & drop BMO credit card CSV or QBO/OFX exports here, or click to browse · Multiple files supported
✅ Safe to re-upload: Only new transactions will be added — your notes and tax entries stay untouched.
Total Spent
—
debits in view
Total Credits
—
credits in view
Net Balance
—
credits − spent
Transactions
—
in current view
Credit Card Transactions
—
❓
Help & Feature Guide
Everything the BMO Dashboard can do, in one place.
🆕 Recently Added
- ✨ AI Suggest — Learns from your past annotations and proposes Tax %, Account, and Type for unfilled rows. One-click approve or approve all at once.
- Account column — A new "Account" field on every transaction row (bank & CC) for categorising expenses (e.g. Office, Travel, Legal).
- Row completeness colouring — Rows turn 🟢 green when all four fields (type, note, account, tax %) are filled; 🟡 yellow when partially done; 🔴 red when empty. Hover a row to see exactly what's missing.
- QBO / OFX import — Upload BMO .qbo or .ofx files directly alongside CSV files. Both bank and credit card upload zones accept them.
- 🔁 Remove Duplicates — Cleans up duplicate transactions that may appear after uploading both CSV and QBO for the same month. Notes and categories are preserved.
📂 Uploading Transactions
CSV filesExport from BMO Online Banking → Accounts → Download Transactions → CSV. Drag & drop or click the upload zone.
QBO / OFX filesAlso supported. BMO provides these under the same download flow. Both bank and credit card zones accept .qbo and .ofx.
Multiple filesUpload several months at once — files are merged and deduplicated automatically.
🔁 Remove DuplicatesIf you uploaded both CSV and QBO for the same period, click this to clean up extras. Your notes and categories are preserved.
📝 Annotating Transactions
＋ / － buttonsMark a transaction as Incoming or Outgoing. Used by the summary totals and revenue tracker.
Note fieldFree-text note for the transaction — client name, purpose, anything useful.
Account fieldExpense or income category (e.g. Office, Travel, Legal, MacRae). Exported to Excel and used by AI Suggest.
Tax % fieldEnter the applicable tax rate. The Tax Amount column calculates automatically.
Revenue checkboxMark incoming transactions as revenue. They appear in the Revenue section with monthly totals.
Row colours🟢 Green = all four fields filled (complete). 🟡 Yellow = partially done. 🔴 Red = nothing filled. Hover a row for a tooltip listing exactly what's missing.
✨ AI Suggest
How it worksThe AI scans all your already-annotated rows and builds a pattern library keyed on description keywords. It then finds incomplete rows whose descriptions match known patterns.
What it suggestsTax %, Account category, and Type (Incoming / Outgoing) — only for fields that are currently empty.
Confidence scoreEach suggestion shows a % confidence based on how consistently past rows with the same keywords were annotated the same way. Only suggestions above 40% are shown.
ApprovingClick ✓ Approve on individual rows or Approve All to apply everything at once. You can un-approve before closing the panel.
Getting startedAI Suggest needs at least a few annotated rows to learn from. The more rows you've filled in, the better it gets — especially for recurring vendors like MacRae or Raja Technologies.
🔍 Filtering & Search
Month filterFilter the table to a single month. Summary cards update to reflect only the filtered transactions.
File filterShow transactions from a specific uploaded file.
Type filterShow only Incoming, Outgoing, or Uncategorized rows.
SearchLive search across all transaction descriptions.
📤 Exporting
⬇ Export ExcelDownloads a full .xlsx workbook with all transactions, annotations, tax amounts, and a Revenue by Month summary sheet.
⬇ Export QBOExports transactions in QBO/OFX format compatible with accounting software.
☁ Google Drive Sync
ConnectClick the ☁ Drive button in the top toolbar. You'll need a Google OAuth Client ID in Drive Settings.
Auto-syncChanges sync to Drive automatically within a few seconds. If you're offline, changes are queued and synced when you reconnect.
Shared accessTeam members can load the same state file from Drive, keeping everyone in sync.
BackupsSnapshots are saved automatically to a Backups subfolder. Restore any previous version from Drive Settings.
🧾 Invoices & 📎 Attachments
Incoming Invoices tabTrack invoices with client, amount, status (paid/unpaid), and a Drive link. Filterable by partner and status.
Attach InvoiceOn any bank transaction row, click 📎 Attach Invoice to upload a PDF or image to the corresponding month folder in Drive and link it to that row.
✅ Tasks
Creating tasksClick the task cell on any transaction row to open the task dialog. Assign to team members by email.
NotificationsAssignees receive an email notification via EmailJS. Configure EmailJS in Drive Settings.
ResolvingClick ✓ Resolve on a task. The creator receives a resolution email.
💾 Sessions & Snapshots
💾 Save SnapshotDownloads a full .json snapshot of all transactions, annotations, and tasks. Use this to back up or share the full session.
📂 Load SnapshotRestores a previously saved .json snapshot. Merges with existing data — does not overwrite.
🔒 PIN Protection
Tab PINsSet a PIN for Transactions, Invoices, or Credit Card tabs in Drive Settings → Security. Share the PIN only with the right team members.
Admin PINProtects Drive Settings itself. Set this first so team members can't change the configuration.
BMO Dashboard · Questions? Annotations and data are stored locally in your browser and synced to your own Google Drive — nothing leaves your account.