WeavrCRMWhy 13 Weeks and Not a Monthly Budget
Monthly budgets smooth over the timing problems that actually hurt detailers. If payroll hits on the 1st and 15th but most of your collections land mid-month, a monthly view makes that look fine even when you're short on the 1st. Thirteen weeks gives you a quarter of visibility at a granularity where timing matters.
The 13-week horizon is also short enough that your estimates stay meaningful. Forecasting cash 12 months out requires guessing too many variables. At 13 weeks you know which recurring clients are booked, which deposits are already collected, and which fixed bills are definitely coming. You update the forecast weekly, dropping the past week and adding a new week at the far end.
Related resource: Detailing Break-Even: How Many Jobs Cover Your Costs?
Opening Cash: Your Starting Point Each Week
Every week starts with one number: the cash actually in your business checking account on Monday morning, or whatever day you anchor the forecast. This is not your Stripe balance, not your outstanding invoices, not your PayPal holding balance. It is the spendable amount your bank shows after any overnight settlements.
If you have a business savings account or tax reserve account, track those separately. Do not blend them into operating cash or you will spend money you've mentally reserved for quarterly estimated taxes. Opening cash for week two is always equal to closing cash from week one, so any error in one week carries forward through all 13.
Expected Collections: Bookings Are Not Cash
Write down every dollar you expect to physically collect that week, not jobs you expect to complete. If you invoice on completion and clients typically pay within a few days, those payments land in a future week. Deposits collected at booking land in the week you receive them, not the week of the appointment. The distinction sounds pedantic until you realize you've planned to pay a supplier based on a job that hasn't paid you yet.
Separate your collection sources by type: card payments collected at job completion, deposits already received and sitting in your account, and any outstanding invoices you expect to collect. Do not include a booking as a collection unless you have already received the funds or the client pays on the spot. Overestimating collections is the most common reason forecasts look fine but checking accounts go negative.
Cash Out: Payroll, Supplies, Fixed Costs, Tax Reserves
List every dollar leaving the account that week, grouped into four buckets. Payroll and contractor payments go first because they are usually date-certain. Supplies and chemicals go in the week the card actually charges or the check clears, not the week you order. Fixed costs include insurance premiums, equipment payments, van payments, and any software subscriptions. Tax reserves are an internal transfer to a separate account, not a real expense yet, but treating them as a cash outflow in the forecast prevents you from spending that money.
The failure case here is forgetting irregular but predictable costs: annual registration fees, a quarterly insurance audit, a seasonal equipment service. Go through the last 12 months of bank statements before you build the first forecast and add every irregular item to the week it will likely recur. A cost you forgot is more dangerous than one you slightly overestimated.
Related resource: Build a Slow-Season Budget Before Detailing Demand Drops
13-Week Forecast Table
Copy this table into a spreadsheet. Fill in Week 1 from real numbers, then estimate weeks 2 through 13. Update every Monday. The table uses a hypothetical solo operator with one recurring fleet client and variable retail work as an illustration of how rows interact, not as a benchmark for your business.
DETAILING 13-WEEK CASH FLOW FORECAST All figures hypothetical. Update weekly. Replace estimates with actuals as weeks close. ROW DEFINITIONS Opening Cash = Prior week closing cash (Week 1: actual bank balance) Collections In = Cash physically received this week (deposits + card payments + invoice settlements) Total Cash Available = Opening Cash + Collections In Payroll/Contractors = Wages, subcontractor payments due this week Supplies/Chemicals = Card charges or checks clearing for products Fixed Costs = Insurance, van payment, equipment, software subscriptions Fuel/Travel = Actual fuel spend or estimated weekly average Tax Reserve Transfer = Move to separate savings account (estimate 25-30% of net, adjust with your accountant) Debt Service = Loan or credit line payment if applicable Miscellaneous = Buffer row; do not leave blank Total Cash Out = Sum of all outflow rows Closing Cash = Total Cash Available minus Total Cash Out WEEK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 Opening Cash Collections In Total Cash Available Payroll/Contractors Supplies/Chemicals Fixed Costs Fuel/Travel Tax Reserve Transfer Debt Service Miscellaneous Total Cash Out Closing Cash COLOR GUIDE (apply manually in your spreadsheet) Red: Closing Cash below your minimum safe balance (set your own floor) Yellow: Closing Cash within $200 of your floor Green: Closing Cash comfortably above floor NOTES COLUMN Add one sentence per week explaining the biggest assumption in that week's estimates.
| Row | Source / Timing Rule | Common Mistake |
|---|---|---|
| Opening Cash | Monday bank balance, not Stripe or PayPal pending | Including unsettled processor funds |
| Collections In | Deposits received + card payments settled + invoices paid this week | Counting scheduled appointments as collected |
| Payroll/Contractors | Date payroll runs or contractor invoice is due | Estimating by pay period instead of actual bank debit date |
| Supplies/Chemicals | Week card charges or check clears, not week ordered | Logging by order date and missing timing by 3-5 days |
| Fixed Costs | Exact due dates from subscriptions, insurance, loan | Forgetting annual or quarterly items |
| Fuel/Travel | Actual or realistic weekly average | Using best-case mileage weeks as the estimate |
| Tax Reserve Transfer | Weekly or after each large collection | Skipping weeks and then facing a large quarterly bill |
| Debt Service | Exact payment date from lender | Treating as a monthly average instead of actual date |
| Miscellaneous | Buffer; $50-$150 typical for a solo operator | Leaving at zero and having no room for small surprises |
| Closing Cash | Total Cash Available minus Total Cash Out | Not reconciling to actual bank balance each Monday |
Hypothetical Worked Scenario
This is an explicitly hypothetical example. Imagine a solo mobile detailer, Marcus, with one recurring fleet account and retail walk-in bookings. On Monday of Week 1, his checking account shows $1,840. He collected a $150 deposit Friday for a ceramic coating job next week, which is already in the account. This week he expects to complete four retail washes at $120 each paid by card on the day, and the fleet client pays a $480 invoice he sent last week. His expected collections for Week 1 are $150 (deposit already received) plus $480 (fleet invoice settlement on Tuesday) plus $480 (four retail jobs at $120 each) = $1,110. Total cash available: $1,840 + $1,110 = $2,950.
His Week 1 outflows: $0 payroll (solo), $95 supplies order clearing Monday, $310 van payment, $140 insurance installment, $65 fuel, $80 tax reserve transfer, $0 debt service, $50 miscellaneous. Total cash out: $740. Closing cash Week 1: $2,950 - $740 = $2,210. That $2,210 becomes Week 2's opening cash. In Week 2, the ceramic coating job completes and the client pays $900 by card, but Marcus also has a $600 chemical order arriving, so collections look healthy while cash actually tightens. Without the weekly view he might not notice the pinch until it hits.
Tradeoffs and Failure Cases
The biggest tradeoff is time versus accuracy. A 13-week forecast done in 20 minutes with rough estimates is still more useful than no forecast, but it can create false confidence if you treat estimates as certainties. The main failure cases are overestimating collections from clients who pay late, underestimating the tax reserve because a good week tempts you to skip the transfer, and forgetting that a large supply purchase shifts cash out a week earlier than you expected.
Another failure case: if you track recurring appointments in your scheduling system, be careful not to let confirmed bookings in your calendar translate directly into the Collections In row. Recurring clients cancel, pause, or pay late. The forecast should reflect a realistic expectation of what will actually settle in your account that week, including a mental discount for clients who historically run 5 to 10 days late on invoices. Budget projections in your scheduling or CRM tool can inform your estimates, but the forecast itself lives in a spreadsheet you reconcile against your bank every Monday.
Maintaining the Forecast Weekly
The forecast only works if you update it. Each Monday, fill in Week 1 actuals from your bank statement and compare them to what you predicted. If collections were $200 less than expected, find out why before estimating the next 13 weeks. If a fixed cost came in higher than predicted, update the recurring row. The gap between predicted and actual in Week 1 tells you how trustworthy your Week 6 estimates are.
Set a recurring calendar block of 20 to 30 minutes every Monday morning for this task. Weavr's budget projection and reporting features can help you pull together completed job data to cross-reference against your cash forecast, but the forecast itself is a separate working document. Do not mix forecast columns with accounting records or tax documents; this is a planning tool, not a financial statement.
Related resource: Build a Detailing Expense Baseline Before Setting Growth Goals
The practical takeaway
Start this Monday: pull your actual bank balance, list every dollar you expect to collect this week by source, list every dollar leaving the account by due date, and calculate your closing cash. Do the same for the next 12 weeks with your best estimates. Update every Monday. The discipline of reconciling predictions against actuals is what makes the tool useful.
Explore the relevant WeavrCRM workflow · Review integrations and requirements