Covenant Liquidity Tracker
30-day rolling average available liquidity vs. the $12.5M minimum. Standalone and consolidated (incl. ROWCAL).
Covenant Tracker 2.0
The liquidity covenant the way the credit agreements measure it: the average daily cash balance across the business days of the calendar month, Allstar and Rowcal together, against the $12.5M minimum. Where the month stands, what each remaining business day needs to close at, and whether holding the last close gets there. Rowcal's daily balance comes from treasury's Liquidity Covenant Tracker workbook, loaded at the bottom of this tab.
Daily Cash (to be deprecated)
Where the sweep closed yesterday, what moved it, how this week is tracking against forecast, and what needs attention. The brand table at the bottom matches the morning Daily Cash Report.
Daily Cash 2.0
The week at a glance: receipts and disbursements day by day against the weekly forecast, the ledger on its side, and the week summed up. Receipts forecast bars are the week's forecast spread flat over its business days; disbursement bars are weighted by the measured weekday share of outflows, with payroll placed whole on its usual day (Thursday), for whichever forecast version is chosen. The measured weekday pattern beside each chart says where the real week runs heavy or light. Both weeks, every forecast version and the pattern ride one mirrored payload, so the controls swap without loading. Everything else from Daily Cash is in the appendix.
Working Capital
Days sales outstanding today against the last month-end close, and whether that close improved on the month before. AR is the Sage trial balance (12000 + 12900 + 12999), the same AR the leadership working-capital slide reports; revenue is the Sage 4xxxx accounts, on the prior month's revenue by default or the trailing three months. Cash impact prices each change in DSO at the current revenue per day: a falling DSO releases cash, a rising one ties it up in receivables. The brand table at the bottom cuts the same measurement by Sage entity, so a mid-month reading shows which brands are gaining or losing ground against the last two closes.
13-Week Cash Flow (TWCF)
Forward view — the last completed week of live actuals, then 13 forecast weeks, line item by line item. Pick a scenario to see it chained off the same bank close beside base.
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. Scenarios are sandbox copies of the base forecast: edit one here, compare it on the 13-Week TWCF tab, and nothing outside it moves until you promote it.
Weekly Cash Flow Review (to be deprecated)
Actual vs. forecast vs. prior week, Saturday–Friday. All values in $000s. Export PDF prints the view on screen — the single-week readout adds a written performance summary against prior week and forecast.
Weekly Review 2.0
The week's actual against the week's forecast, line by line, Saturday–Friday, in $000s. Add the prior week and the change against it from the Columns control; pick which forecast version to measure against from Compare against. Both are client-side — the versions ride the payload — so they swap without a load. Export PDF prints the week against the default version.
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.
Collections Plan
Collections planned on the AR identity rather than on a collection curve: opening AR + invoicing − closing AR − write-offs. Closing AR is DSO against that month’s own invoicing rate, so a month that invoices less carries less receivable. It rides the Customer Receipts engine’s invoicing forecast and replaces only the AR treatment, so there is one invoicing forecast in the app. Levers for DSO, write-off rate, bookings and production cycle slip, with a sensitivity grid ranked by what each risk actually moves.
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.