Flex Reserve funding: reconstruct in-red Overview balancesReconciliation & Settlement

Task prompt

Flex Reserve is fully rolled out and the PM needs a launch-health audit before Thursday's review. Start from the Flex Reserve page in Confluence for how Overview bill-reserve balance is defined (active Smart + Flex reserves, and when Overview should show in red vs on-target). The account balance history is huge — for each account use only its most recent Overview reading, and please do the heavy counting in the warehouse rather than exporting the full history. Please: (1) for every account with at least one active (not archived) bill-reserve balance, reconstruct the reserve from those active pieces and reconcile it to that latest Overview snapshot; (2) among accounts that do have such a snapshot, count how many should show in-red, how many are adequately reserved, and how many have no recorded target; (3) separately count accounts that have active bill-reserve balances but no Overview snapshot at all — keep those as no_snapshot, not as no_target or a recon mismatch; (4) flag accounts whose aggregate bill-reserve target still looks set even though they have no active bill-reserve balances left (stale targets). When you've got it: open a Slack channel called "flex-reserve-in-red-audit", post a summary with the headline numbers and pin it; file a Jira Bank Operations ticket titled "Flex Reserve in-red overview reconcile" (Jira, not Freshdesk); and reply with audited_accounts, recon_match_accounts, in_red_accounts, adequately_reserved_accounts, no_target_accounts, no_snapshot_accounts, and stale_target_accounts.