Who asked: Amara Osei, finance controller at Fenwick Pay (a fictional card payments firm).
Why: Every morning someone compares the card network's settlement file with Fenwick's ledger in a spreadsheet, merchant by merchant. It takes an hour, and a mismatch found late means a merchant is paid the wrong amount.
The data: fenwick.py (the settlement files, the ledger per merchant, the merchants in a day's file, and save_results, which replaces a day in recon_results) and chat.py (the finance channels).
Done looks like: fenwick_recon runs at 05:00 UTC for the business day before; reconciles each merchant in its own task; stores the day's results; posts mismatches to #finance; waits for a late file instead of failing; and updates the recon_results asset so the finance pack is built.
In this project you build the reconciliation that Fenwick Pay's finance team checks every morning, one step at a time. Each step starts from your previous answer. The card network drops each business day's settlement file at 04:30 UTC the next morning; the clock is 06:00 UTC on 9 November unless a step says otherwise. On 7 November everything matched; on 8 November one merchant does not.