Every figure is calculated from the selected project's rows in the accounts transaction ledger. Work streams are inferred from billing narrations; collection remains an aggregate project-account balance.
Source. This dashboard is rebuilt only from the selected project's rows in fatrans.
Account 4101 is treated as work billed; 1481 and
1482 as GST output; 2952 as retention; 2922,
2936 and 2937 as tax deducted at source; 3234
as water charges; and 2441 as the receivable/collection control account.
Collection is project-level. Receipts on account 2441 are not assumed to settle a particular
RA bill unless the ERP itself provides a reliable one-to-one link. The outstanding figure is therefore the selected
project's aggregate receivable balance.
Work-stream classification. Civil, plant & equipment, design & engineering, building structures, supply and
milestone categories are inferred from the narration on the 4101 billing line; unrecognised
narrations remain Unclassified rather than being guessed.
Read-only. Nothing is entered or stored in this HTML. Re-run the Python builder whenever a new ERP CSV is supplied.