Covenant Liquidity Tracker
30-day rolling average available liquidity vs. the $12.5M minimum. Standalone and consolidated (incl. ROWCAL).
Daily Cash Snapshot
Cash position and receipts by brand — yesterday, week-to-date, month-to-date. Same numbers as the morning Daily Cash Report in Google Drive.
13-Week Cash Flow (TWCF)
Forward view — the last completed week of live actuals, then 13 forecast weeks, line item by line item.
Annual Cash Flow
The TWCF line items rolled from weeks into calendar months, with a full-year total. Settled months are measured from daily bank activity; forward months come from the weekly forecast, prorated by business days within each week.
2027 Plan
The next fiscal year built a quarter at a time, opening on the prior year's closing cash position. The rollover is recomputed on every load, so changing a 2026 week moves 2027's opening and every ending balance below it. Saving writes only plan-year weeks — it cannot touch 2026.
Plan vs Forecast
The full year measured against a frozen anchor. The bridge splits the change into what has already banked — closed weeks that came in differently — and what we have re-forecast for the weeks still ahead. A single variance cannot tell those apart, and they mean opposite things.
Forecast Entry — TWCF
Maintain the weekly forecast (ending cash + line items) that overlays live actuals on the TWCF tab. Whole dollars, Friday week-endings. Saved to Postgres — survives redeploys, every edit audited.
Weekly Cash Flow Review
Actual vs. forecast vs. prior week, Saturday–Friday. All values in $000s.
Spend Pace — Outflows by Category
Month-to-date cash out vs. prior month through the same day. Bank-lens categories from WF debits, vendor spend by GL band from Sage AP; ties to the WF debit control total. Click a category for detail.
AP Forecast — Vendors & Subs by Week
Projected AP cash out for the next 13 weeks, built from the open bill ledger (scheduled by each bill's own due date) plus bills not yet entered (from the measured arrival run-rate and bill→pay curve). Compared against the stored forecast; push the projection into Forecast Entry from here. Below: DPO by category and vendor, with measured terms and payment adherence.
Customer Receipts Forecast
Projected cash in by day, week or month, built from the open AR ledger (scheduled by each invoice's own due date) plus work not yet invoiced (from the trailing invoicing run-rate, seasonally adjusted, run through the measured invoice→cash curve). Cut by brand, with DSO and a collection-speed lever. Compared against the stored Collections forecast; push it into Forecast Entry from here.
Daily Cash Recon — Bank vs. Book
Wells Fargo credits vs. Sage cash applied by brand over the recent window.
Receipts / Collections Pace
Month-to-date receipts vs. back-loaded pro-rata target.
SQL Diagnostics
Run a read-only SELECT through the live CData connection to verify new catalog / table / view references before changing production queries. Requires the diagnostic token.