Each metric on its own scale, tracked week by week, so the movement is actually visible. Profit/loss shows a W4 Jun point derived from revenue minus budget (not a reported figure). Cash collection mixes source definitions across weeks (within-30-days at W4, aged recovery after), so read it as directional.
Signed revenue against annual target, with the RM3.96m budgeted-expense line.
Built from ten source reports: the W4 Jun 2026 ReCoIn scorecard and the 9, 17, 24, 31 Jul, 7, 14, 21, 28 Aug and 25 Sept 2026 Turnaround Plan Summaries, plus the BD pipeline tracker and client recovery sheet. From 25 Sept, cash health is pulled from Xero. No intermediate weekly data has been invented.
BD pipeline — Shown by stage from the BD tracker (as at 23 Jul): 52 deals, RM31.76m total, RM11.29m weighted. Open pipeline (Lead + Proposal + Negotiation) is RM18.69m; Won year-to-date holds at RM2.08m — 83% of the RM2.5m BD target. Weighted values are as given in the tracker. Won/Lost/Dropped are closed outcomes, not current opportunities.
Runway basis — Runway is computed everywhere as cash in hand ÷ RM330,000 monthly burn, not the printed scorecard figure. This corrects W4 Jun from the printed 0.71 to 0.59 mo. The 9 Jul (0.88), 17 Jul (2.33), 24 Jul (1.44), 31 Jul (2.61), 7 Aug (2.61), 14 Aug (1.44), 21 Aug (2.44), 28 Aug (1.85) and 25 Sept (1.57) figures already matched.
Cash not re-measured since 28 Aug — The 25 Sept summary shows in-hand of RM518,233 still dated "as at 28/8/2026" — the cash line carries an old date, giving runway of 1.57 mo. Treat it as roughly a month old; refresh the in-hand balance for a live runway. Prior in-hand swung RM860k (23 Jul) → RM475k (13 Aug) → RM807k (21 Aug) → RM609k (28 Aug) with the monthly burn cycle.
Runway swings within the month — Readings are cash snapshots dated ~23 Jul, so they move as payroll and collections land. Judge direction over several weeks: the path 0.59 → 0.88 → 2.33 → 1.44 → 2.61 → 2.61 → 1.44 → 2.44 → 1.85 → 1.57 zig-zags with the monthly burn cycle; the mid-month lows are rising but cash still swings in a wide band, not a smooth line.
Collection basis changed to Xero (25 Sept) — Through 28 Aug the sheet measured "% of the June-aged block recovered", which climbed past 200% (RM1.20m against a fixed RM526,731 block) and stopped being meaningful. From 25 Sept, collection is pulled from Xero on a full-year 2026 basis and reads 41% (RM2.13m recovered in 2026, as at 31 Aug). The step down in the collection line is a change of basis, not a fall in collections; the two series are not comparable. Invoice runway is now 1.00 mo (Xero pending RM331,185 as at 24 Sept, down from RM547,858).
Client sheet vs summary pending — The refreshed client recovery list (invoiced RM1,585,561 · paid RM553,604 · outstanding RM1,031,957 · 34.9%, printed "as at 9 Jul" but reflecting collection since — KTMB now 75% paid) shows more outstanding than the summary's RM547,858 pending. The two run on different bases (client list from the 1 Jun baseline; the summary now counts Xero currently-due invoices, RM331,185), so the runway-lever projections are held back until aligned. The client list is now over six weeks old; a fresh client-by-client sheet would restore the per-client levers. The zero-paid clients (Mesiniaga RM308k, RAC RM437k, ABEAM PNB RM83k, REDtone RM7k) remain the collection priority.
Revenue metric — "Overall Revenue Value FY2026" (scorecard) and "Amount Locked for 2026" (summaries) are treated as one signed-revenue metric. It rose RM703,561 to RM4.73m on 31 Jul, held for three weeks, rose again RM491,400 to RM5.22m on 21 Aug, then rose again RM19,550 to RM5.24m on 28 Aug, then eased RM8,000 to RM5.23m on 25 Sept (minor adjustment). Profit RM1,274,144 (24%); gap to target RM1.27m (19%).
Derived P/L — W4 Jun profit/loss (−RM10,411) is derived as revenue locked − budgeted expenses; all later figures are as reported.
To add next week: open this file, find the REPORTS array near the top of the script, copy the last object, change label/dateLabel/dateISO and the figures, and save. Every card, delta, chart and comparison recomputes automatically. Leave a field null if a metric was not reported that week.