Sales Data Reconciliation & Reporting Tool

Brief
Client has monthly sales data spread across multiple Excel exports from different regional offices. They
need a system to consolidate, clean, and reconcile this data against a master SQL database, then
auto-generate a formatted Excel report.
Requirements
• SQL: Design a normalized schema (sales_master, regions, products tables); write queries to detect
duplicate or missing entries across monthly uploads
• Python: Script to read multiple Excel files using pandas, validate against the SQL schema, push clean
data via SQLAlchemy, and flag mismatches in a log file
• Excel: Auto-generated pivot-style summary report (openpyxl or xlsxwriter) with monthly totals,
region-wise breakdown, and a variance column vs. the previous month
Deliverables
• SQL schema and seed script
• Python ETL script (CLI-runnable)
• Sample output Excel report
• 1-page usage README