/generate-workbook

Purpose

Single-pass Excel working papers for human review and client packs.

Uses openpyxl (Python). Does not require Microsoft Excel to generate. Formulas are written as strings — values appear when the file is opened/recalculated.

See shared/excel_deliverables.md. Ledger SoR after finalisation: Beancount (export-beancount), not this xlsx.

Script

pip install openpyxl # or: pip install -r requirements.txt
python3 scripts/generate_workbook.py <input.json> <output.xlsx>

Expected sheets (minimum)