Payment gateway reconciliation for payouts, fees, and refunds

Finance and operations teams reconciling Stripe, PayPal, processor, and bank payout exports.

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.

Teams usually compare charge IDs, payout IDs, fees, refunds, and bank deposit rows in several tabs.

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.

Gross-vs-net amounts, chargebacks, reserves, and payout timing make one-to-one formulas unreliable.

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 reconcile gateway exports to payout or accounting files with grouped matching and reviewable exceptions.

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.