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 to Review, and finally check the Needs Review tab — near-matches the system found but isn't certain about — before marking the reconciliation done.