← Sales & Refund Reconciliation
Lesson 4 of 4
Reconcile the handoff
Publish checked totals with over-refund exceptions.
Do the work
- Gross minus applied refund cents must equal net cents.
- Negative net is a useful exception; clipping it hides an over-refund.
- Deliver the query alongside the CSV so a reviewer can reproduce the scope.
See the method
Order-level checks protect against an aggregate total that happens to match.
Read every demonstration step
- Order-level checks protect against an aggregate total that happens to match.
- Compare the count of the ledger to the initial cohort.
- Then group the ledger by region and reconcile the sum.
Practice independently
Exercise 1
Find over-refunded orders
Open practice →Exercise 2Reconcile one company total
Open practice →Take it further
Document that tax, currency conversion and chargebacks are outside this fictional policy.