A few things make reconciliation go smoothly:
- Upload one statement at a time — don't merge several months into one file by hand. (The full-year AMEX CSV download is fine, because it's one continuous export, not separate files stitched together.)
- Overlap is handled. If a transaction appears in two files you upload, the deduplication logic catches it — matching on merchant + amount + date within ±1 day.
- Keep dates close. For the best matches, the expense dates in your sheet should be within a day or two of the statement's posting date — the system allows ±1 day tolerance.
- Merchant name variations are automatic. "DELTA" vs "DELTA AIR LINES 016" still match; partial-name matching is built in.
- Work the tabs in order: start with Missing Receipts (statement charges with no matching expense row), then review Credits & Refunds (money that came back to the card), and use Matched to confirm the totals line up before marking the reconciliation done.
- Near-matches live inside Missing Receipts, not in a separate tab. When the system finds a probable pair but isn't certain, the row appears in Missing Receipts with a ⚠ Needs review badge and an inline comparison of the receipt against the charge, so you confirm or reject it in place.