Demo kit: Weekly branch reconciliation pack
===========================================

FICTIONAL DEMO DATA. Not a real document. Any resemblance to real organisations or people is coincidental.

Scenario: https://hmarofiq.github.io/copilot-scenarios-asean/scenarios/bfsi-branch-recon-002/

CONTENTS
  - FICTIONAL_GL_export_week38.xlsx (GL + Control sheets)
  - FICTIONAL_teller_cash_position_week38.csv
  - FICTIONAL_ATM_switch_settlement_week38.csv
  - ANSWER_KEY_breaks.xlsx (presenter only)

SETUP (demo tenant only, never a customer or production tenant)
  1. Upload the three data files to OneDrive in the demo tenant.
  2. Open the GL workbook in Excel for the web and import the two CSVs as new sheets, each formatted as a table.
  3. Follow the scenario steps.

PRESENTER ANSWER KEY (what the seeded data should surface)
  - 14 breaks: 6 timing, 4 reversal pairs, 4 to investigate.
  - Leading zeros: GL refs keep them (000412xx), the teller system drops them (412xx). The scenario prompt says "ignoring leading zeros". To demo the "When it goes wrong" case, run it once without that phrase: every teller row shows as unmatched.
  - Investigate items: two transposed amounts (1,250,000 vs 1,520,000 and 3,470,000 vs 3,740,000), one GL-only withdrawal of 2,000,000, one GL-only ATM withdrawal of 1,500,000.
