Python-Access-Excel Reconciliation

I need to turn a tangle of monthly transaction files into one clean, consistent source of truth. The job touches three tools:

• Python – Write well-structured scripts (pandas, openpyxl, maybe pyodbc) that handle data cleaning, exploratory analysis, and the recurring automation needed to pull from / push to my databases and workbooks.
• MS Access – Build and fine-tune queries, keep the tables organised, and set up ready-to-run reports that mirror the logic in the Python workflow.
• MS Excel – Craft the right formulas, dynamic pivot tables, and clear visualisations so stakeholders can slice the data without touching code.

The core flow should be: ingest raw Excel dumps, clean and reconcile them in Python, store the harmonised tables in Access, then surface summary pivots and charts back in Excel. I’d like reusable code, a version-controlled Access file, and an annotated Excel dashboard. Brief documentation (or a quick hand-off call) to walk me through your logic will round off the project.