Amazon Order Matcher

Automatically categorize Amazon purchases in Monarch Money by matching against Amazon order history.

How It Works

Scrape Amazon Orders: Browser automation (profile openclaw) extracts order history
Match Transactions: Matches by amount (exact match) with date tolerance (bank posts 1-3 days after order)
Categorize: Auto-assigns categories based on Amazon product descriptions
Update Monarch: Batch updates via Monarch CLI

Quick Start

# Browser must be running with openclaw profile
browser action=start profile=openclaw

# Navigate to Amazon orders (login persisted in profile)
browser action=navigate targetUrl="https://www.amazon.com/your-orders/orders?timeFilter=year-2026"

# Extract orders via JavaScript evaluation (see scripts/extract_orders.js)
# Match to Monarch transactions (see scripts/match_and_categorize.py)
# Batch update (see scripts/batch_update.sh)

Scripts

| Script | Purpose | |--------|---------| | match_and_categorize.py | Match Amazon orders to Monarch transactions, suggest categories | | batch_update.sh | Apply category updates to Monarch | | quick_categorize.py | Amount-based heuristics when order data unavailable |

Category Mapping

| Product Type | Monarch Category | Category ID | |--------------|------------------|-------------| | Baby gates, locks, protectors | Baby formula | 225123032227674020 | | Health supplements | Household | 162959461244237526 | | Home appliances | Household | 162959461244237526 | | Cables, tools, work equipment | Business expense | 178462006985127548 | | Electronics, gadgets | Jeremy Spending Money | 162782301949818821 | | Car accessories | Transportation | 162777981853398770 | | Gifts | Gifts | 162777981853398756 |

Data Files

data/amazon_orders_2026.json - Scraped order data with dates, amounts, products
Order data persists between sessions for re-matching

Browser Session

Amazon login is persisted in the openclaw browser profile:

No MFA needed on repeat visits
Session survives browser restarts
Target ID may change between sessions (get fresh via browser action=tabs)

Cron Schedule

Weekly reconciliation runs Sunday 8pm ET:

Scrapes new orders from Amazon
Matches to uncategorized Monarch transactions
Applies categories automatically
Reports summary to Telegram

Limitations

Amount matching only (no order ID correlation with bank data)
Multi-item orders may match incorrectly if total matches another order
Refunds/returns need manual review
Amazon Store Card transactions processed separately

First-Time Setup

Start browser: browser action=start profile=openclaw
Navigate to Amazon and log in manually
Complete MFA verification
Login persists for future sessions