← Sales & Refund Reconciliation
Lesson 3 of 4
Keep exceptions visible
Find orphan receipts and calculate one refund total per eligible sale.
Do the work
- A refund with no matching order belongs in an exception report.
- Summing refunds before joining avoids multiplying gross sales.
- Refunds for pending or out-of-month orders are not applied to this report.
See the method
One order with two partial refunds still has one gross sale.
Read every demonstration step
- One order with two partial refunds still has one gross sale.
- A LEFT JOIN can preserve a paid sale with no refunds.
- COALESCE applies a zero refund default only after the join.
Practice independently
Exercise 1
List canonical orphan refunds
Open practice →Exercise 2Build a per-order refund ledger
Open practice →Take it further
Reconcile applied refunds separately from all posted source money.