ReCoIn Turnaround Dashboard
Enter the access password to continue.
Strictly confidential · internal use only
ReCoIn Turnaround Dashboard
Red Reporting: 9 Jul 2026

Cash Runway

0.88 months+0.17
Cash in hand RM 289,187  ·  Monthly burn RM 330,000  ·  Amber floor at 2.0 mo
Red < 2 mo — draw facility, drastic cost plan Amber 2–4 mo — accelerate collections Green ≥ 4 mo — hold discipline
Board KPIs · Recover · Conserve · Inflow

Insights & priority actions

Trends & breakdowns

Weekly progress by metric

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.

Revenue locked vs RM6.5m target

Signed revenue against annual target, with the RM3.96m budgeted-expense line.

What's on our plate — BD pipeline

Open pipeline — still winnableLead · Proposal · Negotiation
Most likely next winshigh probability

Data provenance & notes

Built from nine source reports: the W4 Jun 2026 ReCoIn scorecard and the 9, 17, 24, 31 Jul, 7, 14, 21 and 28 Aug 2026 Turnaround Plan Summaries, plus the BD pipeline tracker and client recovery sheet. No intermediate weekly data has been invented.

BD pipeline — Shown by stage from the BD tracker (as at 23 Jul): 52 deals, RM33.06m total, RM11.77m weighted. Open pipeline (Lead + Proposal + Negotiation) is RM19.98m; a deal moved Proposal Sent to Won this week, taking Won year-to-date to 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) and 28 Aug (1.85) figures already matched.

Cash cycles within the month — In hand has swung RM860k (23 Jul) → RM475k (13 Aug) → RM807k (21 Aug) → RM609k (28 Aug), moving runway 2.61 → 1.44 → 2.44 → 1.85 as collections build then a burn/payroll draw lands. The underlying trend is up; read the runway over several weeks, not week to week. Invoices-pending held at RM547,858 for 14, 21 and 28 Aug — that line has not been re-measured for three weeks, so invoice runway (1.66 mo) is carried over.

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 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.

"Cash recovered since" is volatile — The cumulative recovery figure has moved RM642k (24 Jul) → RM513k (31 Jul) → RM674k (7 Aug) → RM828k (14 Aug) → RM1.16m (21 Aug) → RM1.20m (28 Aug) against a fixed RM526,731 aged block, taking the ratio to 228%. A recovery figure that keeps climbing past 100% of the block is no longer a like-for-like measure. A cumulative measure should not fall, so it is being re-based or reclassified period to period in the source sheet. Read it as directional, not a clean trend, and confirm the baseline.

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; summary counts currently-due invoices), so the runway-lever projections are held back until aligned. The zero-paid clients (Mesiniaga RM308k, RAC RM437k, ABEAM PNB RM83k, REDtone RM7k) are still 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. Profit RM1,282,143 (24%); gap to target RM1.26m (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.