
AutoLedger — Automated Financial Reporting
FP&A uploads sales CSV via Streamlit; Pandas validates data and XlsxWriter builds presentation-ready Excel with charts.
- Python
- Pandas
- XlsxWriter
- Streamlit
- Excel
Problem
Monthly reporting took hours of copy-paste, formula fixes, and formatting before leadership could review numbers.
Build
AutoLedger cleans and validates uploads, computes metrics and exceptions, and exports native Excel workbooks with charts.
Outcome
Roughly two hours of reporting compressed to seconds, with editable detail sheets for analysts.