Amazon seller reconciliation in Excel without settlement workbook sprawl

Marketplace sellers and e-commerce finance teams matching Amazon settlements, orders, fees, and payouts.

Teams comparing files exported from banks, ERPs, CRMs, payment processors, marketplaces, or spreadsheets.

Excel-heavy users who want less formula maintenance and a clearer review output.

Amazon reconciliation often uses settlement IDs, order IDs, fees, reimbursements, reserves, and payout deposits.

Users usually add helper columns, normalize text and dates, run XLOOKUP or SUMIFS, then filter the remaining exceptions.

The workbook becomes harder to hand off when logic is hidden across copied formulas, pivot tables, or Power Query steps.

One payout can contain hundreds of orders, fees, refunds, and adjustments that do not match one row at a time.

Duplicate keys, timing differences, messy descriptions, and gross-vs-net amounts create false exceptions.

Grouped or fuzzy matches are difficult to document when every reviewer sees a different workbook view.

FireLookup helps compare Amazon-style exports with grouped matching and clearer exception buckets.

FireLookup keeps source files unchanged, lets you select matching rules, and separates matched from unmatched rows.

Exact, fuzzy, one-to-many, and many-to-many matching options help when the files are not simple one-row lookups.