diegosouzapw 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