KUWAIT / EXECUTIVE REPORT
Operations overview
Rental performance, invoicing and collections in one view.
Revenue follows Asala invoice date. Uninvoiced work follows rental end, then rental start.
How figures are calculated
Asala Invoice Amount $ is gross revenue. KHUFF commission is 5% of this gross amount, and net revenue is the remaining 95%. The recorded commission amount is checked against 5% and differences are flagged. Revenue dates use Asala Invoice date. Missing invoice dates are shown as exceptions and appear only with All years and All months.
Collected amounts require an explicit Paid status to Asala. A value in Amount Paid with a blank status is flagged for confirmation and counted as awaiting confirmation. For Paid rows, a blank Amount Paid uses net Asala billed value as an estimate. Outstanding amounts use the remaining net Asala billed value. These are operational estimates until reconciled to the bank.
Pipeline includes work without an Asala invoice. KHUFF invoice numbers separate partner-invoiced work from work with no invoice reference. Pipeline uses Invoice Amount in USD and estimated 5% commission. The direct SINOPEC job is flagged for billing-route confirmation and uses the same 5% estimate.
No-charge status or remarks exclude a job from chargeable pipeline estimates, including rows with conflicting positive amounts. A missing PO is flagged for follow-up. Rental days use the recorded Days Operations field. Products are grouped: every reamer (Shuriken, Ledgebuster, Roller, Stiletto Under Reamer and UR blocks, including the tracker types Gauge, Eccentric and Under Reamer) is in the Reamer group. All bits are in the Bits group. Any other new product gets its own group from its inventory category. The job register shows each job's detailed product. Tracker Type remains available in the job register.
All source currency amounts are USD unless marked KWD. KWD display divides USD by the workbook KWD → USD rate. Client payment status and payment to Asala are separate fields. Blank client payment status means unknown. Prior-year comparisons display unavailable when the source contains no comparable invoices.