M
Moonbridge SystemsPortfolio
← Back to Python Excel Automation

Excel · Case study

AutoLedger — Automated Financial Reporting

FP&A uploads sales CSV via Streamlit; Pandas validates data and XlsxWriter builds presentation-ready Excel with charts.

Walkthrough

Video · 1/4

Project screens

AutoLedger — Automated Financial Reporting screenshot 1
AutoLedger — Automated Financial Reporting screenshot 2
AutoLedger — Automated Financial Reporting screenshot 3

What this project solved

The problem

Monthly reporting took hours of copy-paste, formula fixes, and formatting before leadership could review numbers.

What we built

AutoLedger cleans and validates uploads, computes metrics and exceptions, and exports native Excel workbooks with charts.

Result

Roughly two hours of reporting compressed to seconds, with editable detail sheets for analysts.

PythonPandasXlsxWriterStreamlitExcel