Car Wash Sales Forecast Template

Start with the Assumptions sheet — it's the only place you enter inputs. Fill in your current daily wash volume, average retail ticket, active membership count and average fee, and your seasonal adjustment percentages by month. If you're a new location or just added a membership program, use conservative estimates: most operators underestimate churn and overestimate new member sign-ups in the first year. The Monthly Revenue Forecast and Membership Model sheets update automatically as you fill in the Assumptions.

Once the assumptions are set, review the Monthly Revenue Forecast sheet to check whether the projections look realistic. Compare the revenue per bay figure against industry benchmarks — a single express tunnel typically generates $600,000–$1.2M+ annually at healthy volumes. If you have multiple bays or a full-service tunnel, adjust the daily volume and ticket inputs to reflect each revenue center. The Membership Model sheet lets you stress-test churn: try moving churn from 5% to 8% and watch what happens to annual recurring revenue — the difference often runs into five figures.

Update the Actual vs Forecast sheet monthly as you close each period. Enter real revenue numbers by channel — your POS system should be able to give you retail wash revenue and transaction count, and your membership platform will have recurring billing totals. The variance tracking shows you quickly if retail volume is off because of weather (expected, seasonal) or because of a competitive issue (worth investigating). Car wash operators who review this monthly catch pricing opportunities — like when detailing attach rate is running above forecast and suggests there's room to raise the price.

Car wash revenue is more predictable than most small businesses realize — but only if you're modeling it the right way. Retail wash sales are volume-driven: cars per day times average ticket. Membership revenue is subscription-driven: members times monthly fee minus churn. Fleet accounts are contract-driven: scheduled visits billed monthly. When you break revenue into these three channels and forecast each separately, you stop lumping everything together and start seeing which part of the business is actually growing — and which is masking a decline somewhere else.

Membership revenue has changed the economics of the car wash industry significantly. A well-run unlimited membership program can generate 40–60% of a site's total revenue with near-zero marginal cost per wash once members are enrolled. But the forecast math only works if you're honest about churn. Industry-average monthly churn for car wash memberships runs 6–10%, which means you're replacing 72–120% of your member base over a year. A forecast that assumes 2% churn will dramatically overestimate recurring revenue — and most acquisition spend decisions get made off that number.

Seasonality is one of the most underplanned variables in car wash forecasting. In cold-climate markets, January and February can run 30–40% below peak months; spring and fall often represent 35–40% of annual revenue combined. Failing to account for this creates a forecast that looks right on an annual basis but generates cash flow problems in winter when actual revenue drops below what the spreadsheet shows. This template's seasonality adjustment row lets you tune each month independently so your forecast reflects what actually happens at your location — not what a generic annual average would imply.