Workflow

1. Import your bank transaction CSV and processor refund CSV files.
2. Map columns if the headers don't match the expected format.
3. Review the Dashboard for summary stats and data quality warnings.
4. Use Run Matching on the Dashboard to auto-match refunds to charges.
5. Review ambiguous matches in the Review Queue tab.
6. Manually match remaining items from the Bank Transactions or Refund Records tabs.
7. Export reports for finance review.

Matching Rules (applied in order)

1. Exact ID match: Order ID, Invoice ID, ProcessorRef, or Claim ID found in bank description matches a refund record.
2. Exact amount + date window: Same absolute amount within 45 days, with optional account/card constraint.
3. Amount + merchant similarity + date window: Fallback using merchant name similarity (conservative, flagged for review).

Partial Matching

Multiple refunds can be applied to one charge. One refund can be split across charges. Remaining balances are tracked automatically.

Data Safety

All data stays in your browser. Nothing is sent to any server. Save/Load Project uses local JSON files.