Customer → Canonical → Branch Mapper
ISO 20022 MAPPING WORKBENCH · pain.001 · pain.002 · pain.008 · pacs.002 · pacs.008 · pacs.009
V7 · AI AUTO-MAPPING
1 · Upload
Excel Mapping Workbook
📂 Load Workbook
2 · Worksheets
Target Worksheet (has XML tags)
Source Branch Mapping Worksheet
Key Column (branch field names)
3 · Column Overrides
(auto-detected — adjust if needed)
Field Name column
Canonical XML Tag column
Definition column
Branch Mapping column
Comments / Remarks column
Source sheet Definition column
Definitions and remarks feed the AI matcher — the closer these point to the right columns, the better the suggestions.
🏗️ Build Mapping Sheet
≥ 70% strong match
50–69% review
< 50% low confidence
📤 Export Data