Demo: reconciling payments between the gateway, platform, and ERP
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
run a reconciliation design and walk through a mismatch; prepares ARC-032-LAB1.
Draft outline details
Step by step
- Define the three sources: gateway settlement file, platform payment records, ERP cash postings.
- Match on payment reference and amount per day; classify results: matched, missing in one source, amount difference, duplicate.
- Investigate a sample: platform shows captured, gateway shows nothing; cause was a timeout treated as failure.
- Planned mistake: fix the one record by hand and move on. Fix: correct the cause (state handling for "unknown"), add an automated check, and route exceptions to a named finance owner.
- Report daily match rate and aging of unresolved items.
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.