We have more than 1,000 active customer balance sheets—covering roughly 3,000 individual contracts—sitting in their original Excel workbooks. For each customer I hold two key data groups: • customer balances and their related payments (all registered as one-time payments rather than monthly instalments) • contract details that link every payment to a specific apartment unit My goal is to move everything into the standardized Excel import template required by our new SAP environment without typing line-by-line. I would like an automated solution—preferably a lightweight AI-assisted script or model—that can: 1. read the existing Excel files, 2. map each column to the exact fields SAP expects, and 3. export a clean, ready-to-upload template with zero data loss. Python (pandas / openpyxl), VBA, or a low-code Power Query setup are all acceptable as long as the end result is fast and repeatable for future batches. Built-in data checks for duplicates, negative balances, or mismatched contract IDs will be essential so we catch issues before the SAP import stage. Deliverables • Reusable script or macro with clear in-line comments • One sample run that processes at least 100 records and generates the SAP-ready file • Quick start guide: where to drop raw Excel files, how to launch the tool, and how to add new mapping rules if our template changes I’m available to share the current workbook structure, the SAP template, and a handful of anonymized sample contracts as soon as we begin. Let me know if you need any further technical details.