Demo: reconciling orders against the payment provider
On This Lesson 3 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
build and run a daily reconciliation on the running case; prepares SRC-014-LAB1.
Draft outline details
Step by step
- Load the day's orders, payments, and the provider's settlement file into a staging area.
- Join by provider reference and bucket: matched, orders without charge, charges without order, amount mismatch.
- Inspect the planted discrepancies and decide an automatic repair for each type.
- Planned mistake: compare totals only. Fix: compare per record, since offsetting errors hide in totals.
- Apply repairs and write an audit row for each; re-run to show it is idempotent.
- Produce the report with counts and open items.
Check your understanding
Why compare per record and not just totals?
Show answer
Offsetting errors cancel out in totals.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.