Marketplace Reconciliation

Overview

• Marketplace Reconciliation is an Advanced business-level aggregate comparison between marketplace recognised orders and settlement records.
• The UI explicitly labels this a low-confidence aggregate comparison; it does not claim individual order-to-settlement matching.
• Rows compare Order net, Settlement gross, Signed fees, Net deposit, Gross variance, fee percentage, and settlement sync states.
• Signed fee values can be negative when adjustments/refunds make the aggregate deduction negative.
• Financial totals include READY, SYNCING, SYNCED, and FAILED settlement records; DRAFT amounts are displayed separately.
• Only settlement periods exactly aligned to the report's full local-date range are included; overlapping non-aligned settlements are excluded.

When to use this

• Use this as a high-level check that marketplace order revenue and provider settlement records are broadly consistent.

Step-by-step

1. Choose exact full local dates.
2. Review Order net versus Settlement gross.
3. Review signed fees and Net deposit.
4. Check Gross variance.
5. Review excluded/non-aligned settlement count.
6. Open individual Marketplace Settlements for Store/order context.

Common mistakes

• Do not call a zero aggregate variance proof that every order was settled correctly.
• Do not mix partial-day/timestamp ranges with settlement date-only periods.
• Do not treat DRAFT settlement values as final financial totals.

Troubleshooting

• If expected settlements are excluded, check exact period alignment.
• If variance is large, inspect Store assignment, marketplace channel/order period, refunds/adjustments, and the individual settlement record.