← Sales & Refund Reconciliation
Lesson 1 of 4
Define the reporting cohort
Select the reporting month and keep money in integer cents.
Do the work
- Declare the start inclusive and next month start exclusive.
- Filter sale status independently from refund status. A requested refund is not posted money.
- Keep the order ID with each sale so a later join can be reconciled.
See the method
2026-09-01 belongs to September; 2026-10-01 does not.
Read every demonstration step
- 2026-09-01 belongs to September; 2026-10-01 does not.
- An order can be paid even when one of its refunds is only requested.
- Integer cents avoid display rounding during this exercise.
Practice independently
Exercise 1
Select September paid orders
Open practice →Exercise 2Inspect raw posted refunds in the month
Open practice →Take it further
Compare the eligible order count before and after each join.