Quick Fix Summary
Need a sales forecast fast? Pull last year’s sales → add 5–10 % for inflation → subtract 3–5 % for expected churn → set monthly targets in a free CRM like Zoho. Re-run the numbers on the first of every month and adjust as you go.
What’s a Sales Forecast—Really?
A sales forecast is your best educated guess about future revenue. It’s not some crystal-ball prediction. Instead, it’s built from real data like past sales numbers, what’s in your sales pipeline right now, seasonal trends, and outside factors such as inflation or local economic shifts.
How do I build my first monthly sales forecast?
Start with the table below. Swap out the example numbers with your own 2026 data.
| Step | Action | Example (2026) |
|---|---|---|
| 1 | List top 5 products or services (Pareto rule: 20 % of items = 80 % of revenue) | Premium dog treats, grooming packages, retail leashes, membership club, boarding add-ons |
| 2 | Gather 2023–2025 monthly sales data | 2023: $62 k, 2024: $68 k, 2025: $74 k |
| 3 | Apply a 7 % inflation bump for 2026 | $74 k × 1.07 = $79.18 k |
| 4 | Subtract expected customer churn (assume 4 %) | $79.18 k × 0.96 = $76 k |
| 5 | Split annual forecast into monthly buckets (70 % of sales in Q4) | Jan $4 k, Feb $4 k, Mar $4.5 k, …, Dec $14 k |
| 6 | Subtract variable costs (COGS) to get gross profit | Average COGS 45 % → $41.8 k gross profit |
| 7 | Save the file as “2026_Sales_Forecast_v1.xlsx” and upload to Google Sheets for team access | https://sheets.google.com/yourcompany/2026_Sales_Forecast_v1 |
I tried the basic method and my forecast is way off—what now?
Three proven fallback methods can save your forecast. First, lean on your CRM’s pipeline data. If deals have clear stages with win probabilities, multiply each deal by its probability and sum them up. Second, smooth out spikes with a moving average—just average the last three or twelve months of revenue. Finally, let AI do the heavy lifting if your software supports it. These tools blend your past sales with outside signals like social buzz or search trends to fine-tune your numbers.
- CRM-Powered Pipeline Model
If your CRM (HubSpot, Salesforce, Pipedrive) tracks deal stages and probabilities, switch to a weighted pipeline forecast. Set probabilities: Contract signed 90 %, Proposal sent 60 %, First call 10 %. Multiply each deal value by its probability and sum. Update probabilities monthly based on recent close rates. - Moving-Average Smoothing
Use a 3-month or 12-month rolling average of past revenue to dampen spikes. In Excel, the formula is =AVERAGE(SalesJan:SalesMar). Apply the same 7 % inflation bump and 4 % churn adjustment as above. Great for businesses without granular product data. - AI-Augmented Forecasting
If you use NetSuite, Odoo, or Zoho Analytics, enable the built-in AI engine. These tools ingest your historical data, social-media sentiment, and Google Trends keywords to nudge forecasts up or down. In NetSuite 2025.2+, go to Reports → Sales → Forecast → Enable AI Suggestions. Expect a 10–15 % accuracy boost over manual methods, but always sanity-check the AI’s outliers with your sales reps.
How do I stop my forecast from drifting off track all year?
Lock in monthly reviews and tighten your assumptions. Schedule a quick 30-minute “forecast reality check” on the 1st of every month. Compare what actually happened against what you predicted and note the gap. Anything over 15 % off target deserves a closer look. Also, only finalize inventory buffers after the forecast is set—use a safety-stock formula like (Lead-time demand × Service-level) + (Review period demand × Service-level). For pet supplies, aim for a 95 % service level; too much stock means wasted treats, too little means missed sales. Keep a rolling 13-month view by adding a new month each update and dropping the oldest one—this keeps seasonality front and center. Finally, jot down every assumption right in your spreadsheet (“Assumes 5 % new customer growth, 3 % price increase, no recession”). When things go sideways, you’ll know exactly which lever to pull next time.
- Schedule a 30-minute “forecast review” on the 1st of every month. Compare actual vs. projected revenue and log the variance. A deviation >15 % triggers a deeper dive.
- Lock inventory buffers only after the forecast is locked. Use safety-stock formulas: (Lead-time demand × Service-level) + (Review period demand × Service-level). Service level for pet supplies is typically 95 %. Over-ordering leads to expired treats; under-ordering leads to lost sales.
- Build a rolling 13-month view. Extend your forecast one month forward and drop the oldest month each time you update. This keeps seasonality visible and prevents “forecast drift.”
- Document assumptions. Write a one-sentence note next to each forecast cell: “Assumes 5 % new customer growth, 3 % price increase, no recession.” When reality differs, you’ll know which lever to adjust next time.
