RBC Royal Bank (Chequing & Avion Visa) → Monarch Money Reconciliation Guide

Import & Reconcile RBC PDF Statements into Monarch Money (Without Duplicates)

Why This Breaks in Monarch Money:

RBC cuts off standard CSV transaction downloads at 90 days, so anything older is trapped in multi-page eStatement PDFs. Worse, when RBC reconnects through Plaid or MX after a 2FA reset, pending restaurant or Presto charges that took 4 days to post often get dropped—or if you convert the PDF yourself, RBC Avion Visa lists purchases as positive numbers, which Monarch imports backwards as income.

How the Local Parser Fixes It:

Reads your RBC eStatement PDF locally in the browser, flips Avion Visa purchases to negative numbers (-58.12) and payments to positive (+58.12), verifies Previous Balance - Net Activity = New Balance to the cent, and diffs against your Monarch CSV so you only upload the missing rows.

3-Step Workflow: 1. In Monarch Web, open your RBC account -> click Edit -> Download transactions (CSV).2. Drop your RBC eStatement PDF and that Monarch CSV into the reconciler above.3. Download the "Missing-Only Backfill CSV" and upload it via Edit -> Import transactions -> "Prioritize Monarch" so existing categorized rows stay untouched.
Built for Monarch Money, YNAB & Actual Budget•Canadian & US Banks

When your budget app doesn't match your bank. Find every dropped transaction in 10 seconds.

Drop your bank statement PDF and your Monarch or YNAB CSV. We catch every transaction Plaid dropped, fix flipped credit card signs, and balance your books to the penny. 100% in your browser. Your statement never touches our servers.

Reconcile My Statement↓Explore Interactive Demo→
✓Free 25-row audit•Zero bank logins required•Paid passes from $12 (no monthly lock-in)
✓ 100% In-Browser Privacy✓ ±$0.00 Exact Math Checksum✓ Fixes Inverted Credit/Debit Signs✓ 1-Click Monarch & YNAB Re-Import
1

Bank or Card Statement (PDF)

CA & US .PDF

Parsed locally in your browser memory. Zero cloud uploads. Your financial data stays 100% private on your machine.

Click to select or drop statement PDF
Works with all major Canadian & US checking and credit card PDF statements
Automatic checksum verification100% Client-Side
2

Monarch / YNAB Export (CSV)

.CSV EXPORT

Fuzzy matches within a ±4 day posting window, identifies missing transactions, and flags flipped signs.

Click to select or drop Monarch CSV export
Exported from Monarch Web: Accounts → Edit → Download transactions
Monarch Web: Accounts → Edit → Download transactions±4 Days Window
1. Missing Rows Backfill CSV

Catches transactions dropped by Plaid/Finicity using a ±4 day posting window so you never import duplicates.

2. Inverted Sign & Bulk-Edit CSV

Fixes backward credit card +/- signs and updates 1,000+ existing rows via Monarch Transaction IDs with 0 API writes.

3. Net Worth Balance History CSV

Generates a deduplicated daily running balance file so your Monarch Net Worth graph updates without "Invalid DateTime" errors.

💡Don't have a bank statement right now?
Open Interactive Demo→
Pay Once or Subscribe•Zero Lock-in

Simple, transparent pricing.

Never pay a monthly subscription just to fix a multi-year backfill. Pay once for a clean slate, or get Pro for automated monthly peace of mind.

Free Diagnostic
$0

Inspect statements client-side and export your first 25 missing rows free.

✓100% Client-Side RAM Parsing
✓Math Checksum Verification (±$0.00)
✓First 25 Missing Rows Exported
✓Transaction-ID Sign Fix CSV Export
Most Popular
20-Statement PassPay Once
$12 one-time payment

Perfect for fixing 12 to 24 months of dropped Tangerine, Wealthsimple, RBC, Amex, or Chase history.

✓20 Statement Credits (Never expire)
✓All Missing Rows Unlocked (No 25-row cap)
✓Transaction-ID Sign Inversion Fix CSV
✓Deduplicated Daily Balance History CSV
✓Bank of Canada Exact Date FX
Pro Annual
$29 / year

For households managing multiple US & Canadian bank accounts every month without broken aggregators.

✓Unlimited Statements All Year
✓Canadian TSX Portfolio Balance CSVs
✓Priority AI Self-Heal on Complex PDFs
✓Unlimited Multi-Statement Backfill Exports
View full feature comparison breakdown matrix & FAQ→