refund-radar

Scan bank statements to detect recurring charges, flag suspicious transactions, identify duplicates and fees, draft refund request templates, and generate an interactive HTML audit report.

Triggers

• - "scan my bank statement for refunds"
• "analyze my credit card transactions"
• "find recurring charges in my statement"
• "check for duplicate or suspicious charges"
• "help me dispute a charge"
• "generate a refund request"
• "audit my subscriptions"

Workflow

1. Get Transaction Data

Ask user for bank/card CSV export or pasted text. Common sources:

• - Apple Card: Wallet → Card Balance → Export
• Chase: Accounts → Download activity → CSV
• Mint: Transactions → Export
• Any bank: Download as CSV from transaction history

Or accept pasted text format:
CODEBLOCK0

2. Parse and Normalize

Run the parser on their data:

CODEBLOCK1

Or for pasted text:
CODEBLOCK2

The parser auto-detects:

• - Delimiter (comma, semicolon, tab)
• Date format (YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY)
• Amount format (single column or debit/credit)
• Currency

3. Review Recurring Charges

Tool identifies recurring subscriptions by:

• - Same merchant >= 2 times in 90 days
• Similar amounts (within 5% or $2)
• Consistent cadence (weekly, monthly, yearly)
• Known subscription keywords (Netflix, Spotify, etc.)

Output shows:

• - Merchant name
• Average amount and cadence
• Last charge date
• Next expected charge

4. Flag Suspicious Charges

Tool automatically flags:

5. Clarify with User

For flagged items, ask in batches of 5-10:

• - Is this charge legitimate?
• Should I mark this merchant as expected?
• Do you want a refund template for this?

Update state based on answers:
CODEBLOCK3

6. Generate HTML Report

Report saved to INLINECODE0

Copy template.html structure. Sections:

• - Summary: Transaction count, total spent, recurring count, flagged count
• Recurring Charges: Table with merchant, amount, cadence, next expected
• Unexpected Charges: Flagged items with severity and reason
• Duplicates: Same-day duplicate charges
• Fee-like Charges: ATM fees, FX fees, service charges
• Refund Templates: Ready-to-copy email/chat/dispute messages

Features:

• - Privacy toggle (blur merchant names)
• Dark/light mode
• Collapsible sections
• Copy buttons on templates
• Auto-hide empty sections

7. Draft Refund Requests

For each flagged charge, generate three template types:

• - Email: Formal refund request
• Chat: Quick message for live support
• Dispute: Bank dispute form text

Three tone variants each:

• - Concise (default)
• Firm (assertive)
• Friendly (polite)

Templates include:

• - Merchant name and date
• Charge amount
• Dispute reason based on flag type
• Placeholders for card last 4, reference number

Important: No apostrophes in any generated text.

CLI Reference

CODEBLOCK4

Files Written

Privacy

• - No network calls. Everything runs locally.
• No external APIs. No Plaid, no cloud services.
• Your data stays on your machine.
• Privacy toggle in reports. Blur merchant names with one click.

Requirements

• - Python 3.9+
• No external dependencies

Repository

https://github.com/andreolf/refund-radar