How to Build and Run a 13-Week Rolling Cash-Flow Forecast in a Texas Trade or Industrial Business: Eliminating Payroll Surprises, Retainage Crunches, and Line-of-Credit Traps
10th-of-the-month statement cutoffs, equipment note principal payments, and Texas Property Code Chapter 53 10% statutory retainage holdbacks collide in the same week. Installing a 13-week rolling cash-flow forecast—updated every Monday morning in 30 minutes using actual customer payment lags rather than accrual P&L revenue—gives the owner a 90-day radar screen that spots cash troughs 5 to 8 weeks early so you never have to scramble for emergency line-of-credit draws.1. Why Trailing Accrual P&Ls Cannot Prevent a Friday Payroll Crunch
Across Houston, Dallas–Fort Worth, Austin, and San Antonio (see our Verified Fact Sheet), owners of $2M–$20M HVAC, plumbing, electrical, commercial roofing, specialty fabrication, and oilfield service companies routinely ask the same question: “How can my QuickBooks P&L show $55,000 of net profit last month when I had to draw $80,000 on our bank line of credit yesterday just to cover Friday payroll?”
As we diagnose in our guide on why your P&L shows a profit while your bank account is empty and our true field labor burden pricing matrix, an accrual Profit & Loss statement measures accounting earnings over a past period—it is completely blind to the four weekly cash-timing collisions that drain a Texas contractor’s checking account:
Collision #1: The 3-Payroll Month + Supply-House 10th Cutoff
Shops that pay technicians bi-weekly (26 pay periods/year) face two months every year with three Friday payroll runs instead of two. When that third $72,000 burdened payroll lands in the exact same week as your 10th-of-the-month supply-house statement cutoff ($115,000 due to keep your 2% 10 Net 30 early-pay discount and account credit terms open), $187,000 leaves the bank in 72 hours.
Collision #2: GC Pay-When-Paid Draws, 10% Retainage & Note Principal
On commercial construction and industrial retrofit work in Texas, you pay W-2 field labor every two weeks and buy rooftop units or switchgear up front—while the General Contractor holds back 10% statutory retainage under Texas Property Code Chapter 53 (often equal to 50%+ of your net profit on the job) until 30 to 60 days after final completion, and your commercial truck/equipment loan principal drafts automatically on the 1st of the month without ever appearing on the P&L.
2. The 4-Block Structure of a Real 13-Week Rolling Cash-Flow Model
A 13-week cash-flow forecast is a single-tab spreadsheet (13 columns for the next 13 Friday dates) that obeys one iron rule: zero accrual accounting. Every row tracks real dollars hitting or leaving your operating bank account on a specific Friday:
| Forecast Block | Line Items Tracked Weekly (Weeks 1–13) | Forecasting Rule (No Wishful Thinking) | Owner Control Trigger |
|---|---|---|---|
| Block 1: Beginning Spendable Operating Cash & Revolver Headroom | Cleared Friday operating checking balance excluding isolated tax/deposit reserve sub-account; available borrowing base on bank Line of Credit (LOC). | Reconcile Week 1 beginning cash to the exact penny on your Friday morning online bank portal. | Establish a hard Minimum Cash Floor equal to 1.5x one bi-weekly burdened payroll + 2 weeks fixed overhead. |
| Block 2: Expected Weekly Cash Receipts (Inflows) | (a) Residential/Service COD & card batch settlements; (b) Commercial PM / MSA recurring ACH runs; (c) Named Commercial Invoices >$10,000; (d) GC Progress Draws & Retainage Releases. |
Slot by actual customer payment habit, never invoice due date: COD = Week 0; Commercial Net-30 = Week 6–7; GC AIA Pay Apps = Week 8–10; 10% Retainage = 45 days post-punchlist. | Any invoice >$15,000 slipping past its slotted Friday triggers a mandatory Monday morning PM/owner call. |
| Block 3: Direct Field Cash Outflows (Variable COGS) | (a) Bi-weekly burdened W-2 field payroll + 941/TWC tax draft; (b) Supply-house 10th/25th batch runs; (c) Major job equipment pre-purchases; (d) Subcontractor progress payments. |
Never release non-bonded subcontractor progress checks until the corresponding GC draw has cleared your bank; match equipment pre-buys to 35% customer mobilization deposits. | Flag any week where material + sub outflows exceed 55% of that week’s collected receipts. |
| Block 4: Fixed Overhead, Debt Principal, Tax Escrows & Owner Draws | (a) Office/management payroll; (b) Shop rent/NNN lease, fleet insurance, fuel cards, FSM software; (c) Truck & SBA loan Principal + Interest drafts; (d) Sales tax & quarterly IRS/Texas Franchise Tax sweeps. |
Enter fixed monthly auto-drafts in the exact calendar week they hit (1st, 15th, or 20th Texas Comptroller sales tax deadline). | Ending Spendable Cash = Beginning Cash + Block 2 Inflows − Block 3 − Block 4 Outflows. |
3. Worked 13-Week Cash-Wall Prevention Example ($5.50M Texas Commercial Trade Shop)
Consider a $5.50M commercial HVAC and plumbing contractor in Dallas–Fort Worth generating $48,000/month in accrual net income. On Monday of Week 1, the owner has $165,000 in the operating bank account and feels comfortable. Yet when we map Weeks 1 through 8 into a 13-week rolling cash-flow forecast, a −$112,000 cash wall appears in Week 6—five full weeks before it hits—because Week 6 combines the third payroll of a 3-payroll month ($68,000), a $140,000 factory chiller pre-purchase, and the 10th-of-the-month supply-house cutoff ($84,000), while GC Progress Draw #2 ($195,000) isn’t scheduled to clear until Week 8:
| Weekly Cash Metric | Weeks 1–4 (Normal Rhythm) | Week 6 WITHOUT 13-Week Radar (The Crash) | Week 6 WITH 5-Week Advance Action (Solved) |
|---|---|---|---|
| Monthly Accrual P&L Net Income (Illusion) | +$48,000/mo paper profit | Still shows +$48,000/mo paper profit | +$49,800/mo profit (with early-pay discount saved) |
| Beginning Operating Cash (Week Start) | $165,000 (Week 1) → $142,000 (Week 5) | $142,000 | $204,000 (+$62K overdue AR collected in Weeks 2–4) |
| Week 6 Cash Inflows (Receipts) | $105,000/wk average | $58,000 (GC Draw #2 delayed to Week 8) | $133,000 (+$75K 50% equipment deposit collected upfront) |
| Week 6 Cash Outflows (3rd Payroll + Chiller + Supply House + Debt) | $110,000/wk average | (−$312,000) ($68K 3rd payroll + $140K chiller + $84K supply house + $20K truck notes) | (−$252,000) ($60K chiller balance aligned to delivery in Week 8) |
| Ending Friday Operating Cash Balance | +$142,000 | −$112,000 OVERDRAFT / PANIC LOC DRAW | +$85,000 CASH POSITIVE ($0 LOC draw required) |
Because the owner saw the Week-6 trough in Week 1, four calm operational moves eliminated the $112,000 deficit without borrowing a dime: (1) collecting $62,000 of 42-day commercial service AR during Weeks 2–4, (2) billing a 50% ($75,000) equipment deposit upon chiller submittal approval in Week 5, (3) splitting the distributor chiller payment into 50% at order and 50% upon Week-8 delivery, and (4) submitting the GC AIA pay application 4 days early with zero paperwork defects (see our guide to unlocking trapped working capital and AR velocity).
4. How to Run the Weekly 30-Minute Cash Huddle Every Monday Morning
- 8:00 a.m. Monday — Reconcile Last Week’s Actuals vs. Forecast (10 Minutes). Before the week begins, your controller or bookkeeper compares last week’s projected cash receipts and outflows against actual Friday bank cleared transactions. Any customer invoice over $10,000 that missed its projected Friday receipt is highlighted in red at the top of the sheet.
- 8:10 a.m. Monday — Roll the Window Forward 1 Week (10 Minutes). Hide completed Week 1, add a new Week 13 on the right edge using current backlog and scheduled crew billings, and update Weeks 2 through 8 with any newly signed mobilization deposits, equipment POs, or revised GC pay-app dates.
- 8:20 a.m. Monday — Inspect the 13-Week Minimum Cash Floor Line (10 Minutes). Look across all 13 Friday ending cash balances. If any future week dips below your Minimum Cash Floor (e.g., $100,000), assign specific collection calls, deposit billings, or non-critical CapEx deferrals that morning—while you still have 4 to 8 weeks of runway.
YOUR NEXT STEP
Stop running a multi-million-dollar shop off today’s bank balance.
Score your profit and cash leaks in 10 minutes for $0, order the 24-page $250 Field Guide, commission a $2,500 Remote Business System Inspection, or book a 1-day on-site Profit Leak Review ($4,750, backed by a $20,000 fee-back guarantee).
Check it yourself ($0)
Take the free 10-minute Busy-But-Not-Profitable Self-Assessment to pinpoint whether your primary leak sits in labor burden, job costing, billing lag, or cash timing.
Take the Free Profit Leak Assessment →$250 Field Guide or $2,500 Inspection
Order our 24-page written $250 Streamlined Field Guide or commission a $2,500 Remote Business System Inspection of your P&L-to-cash gap, AR aging, and job-cost records.
See the $2,500 Remote Inspection →Profit Leak Review ($4,750) or Call
Spend one day at your shop with SweetSpot in a Profit Leak Review (backed by our $20,000 annual findings guarantee), or book a 30-minute working call.
See the Profit Leak Review →13-Week Rolling Cash-Flow Forecast FAQ for Texas Contractors
How is a 13-week cash-flow forecast different from our monthly QuickBooks P&L and budget?
A monthly accrual P&L records revenue when an invoice is created and ignores loan principal payments, inventory pre-purchases, sales tax remittances, and Texas Property Code Chapter 53 10% statutory retainage holdbacks. A 13-week rolling cash-flow forecast tracks only actual cash entering and leaving your operating checking account week by week for the next 90 days—spotting payroll and vendor timing collisions 5 to 8 weeks before they happen.
Why do we model customer collections by actual historical payment lag instead of contract invoice due date?
If a commercial general contractor’s subcontract says “Net 30” on paper, but their actual payment history over the last 6 draws averages 52 days from pay-app submission, plugging that invoice into Week 4 of your cash forecast guarantees a false sense of security and a Friday overdraft. Always slot expected customer receipts into the exact week their historical payment habit dictates.
How long should it take our bookkeeper or controller to update the 13-week cash forecast each week?
Once built, the weekly Monday morning roll-forward takes 30 to 45 minutes: reconcile last week’s projected receipts and disbursements against actual Friday bank cleared balances, drop Week 1 off the left side, add a new Week 13 on the right side, and update any shifted commercial progress draw dates.
Should sales tax, payroll taxes, and customer equipment deposits be included in our Beginning Operating Cash line?
Never treat Texas Comptroller sales tax collected, IRS 941 payroll tax withholdings, or unspent customer equipment deposits as available operating cash. Sweep those funds into a separate restricted tax-and-deposit reserve sub-account every Friday so your 13-week operating cash balance reflects only true spendable liquidity.