S. K. Samanta & Co. (P) Ltd. · Project Controls

Client Billing & Collection

Weekly review · — · Client Billing Portfolio
Key messages this week
    Project
    —Project —
    Client
    —Accounts ledger
    Scope
    Client billingRA bills & collection
    Reporting week
    ——

    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.

    Exhibit 01

    Billed against collected

    cumulative, net of deductions

    Receivable raised · billed net of deductions Collected · money actually received
    Source: ERP fatrans account 2441 — debits are the receivable raised on each RA bill, credits are money received · ERP export —
    Exhibit 02

    Where each rupee billed ends up

    invoice face value to cash in hand

    Source: ERP fatrans — 4101 work billed · 1481 / 1482 GST output · 2952 retention · 2922 income tax at source · 2936 / 2937 GST TDS · 3234 water charges · 2441 receivable and receipts · ERP export —
    Exhibit 03

    Billing by work stream

    click a stream to filter the register

    Work streams are read from the narration the accounts team types on the 4101 line — RECV 37TH RA BILL AG CIVIL ENGG is civil, RECV 34TH RA BILL AG DSGN & ENGG is design. They are not a field in the ERP. Bills whose narration names no stream are left unclassified rather than guessed at.
    Source: ERP fatrans.narr on account 4101, one line per RA bill · ERP export 2026-09-03
    Exhibit 04

    Billing rhythm

    what was billed each month, by stream

    Source: ERP fatrans account 4101 by bill date and narrated work stream · ERP export —
    Exhibit 05

    Ledger exceptions

    click a bill to see its journal

    Source: each RA bill's journal tested against its own arithmetic and against the rates its narration states · ERP export —

    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.