# Invoice Balance Aging Report Local source edition 1.0.0. Rebuild invoice balances as of a cutoff date. Download invoice detail and aged balances by customer with later payments excluded. ## Run locally Extract the complete ZIP. Use Python 3.12 from a terminal in the extracted directory. The tool uses the Python standard library. python run.py example.json results Use a new output folder for each run. Start with example.json and replace its synthetic values with your own data. Preserve field names, types and units. Files and reports are processed on your computer. ## Inputs Supply asOf (YYYY-MM-DD), one currency (USD/CAD/EUR/GBP/AUD/MXN), and 1–1000 issued invoices with id, customerRef, issued, due, totalMinor and payments. Each payment needs a reference, date and positive amountMinor. Use anonymous references. Submit only valid invoices and applied payments, with one currency per batch. ## Results INVOICES.csv identifies future issues, settled balances and days overdue. CUSTOMERS.csv separates current, 1–30, 31–60, 61–90 and 91+ days past due. Dates are calendar dates. Review credit notes, write-offs and unallocated cash separately. The results folder includes summary.json and the output files produced by this input. The sample produces: INVOICES.csv, CUSTOMERS.csv. ## Español · Informe de antigüedad de facturas Reconstruye los saldos a una fecha de corte y agrupa por cliente las cantidades pendientes y vencidas. Extrae el ZIP completo y abre una terminal en esa carpeta con Python 3.12. El programa usa la biblioteca estándar de Python. Ejecuta: python run.py example.json resultados Copia example.json para preparar tus datos. Conserva los nombres y tipos de los campos, usa una carpeta de salida nueva y consulta summary.json junto con los archivos generados. La descripción detallada de los campos está en inglés. The included LICENSE covers use and modification for your own personal and commercial projects. This edition includes its source and can run locally after setup.