Revenue Forecasting by Sales Channel
A single revenue number for next year hides more than it shows. Your website, your shop counter, a marketplace and a handful of wholesale accounts all grow, shrink and peak at different times. Revenue forecasting by sales channel splits that one number into parts you can understand, track and actually manage, month by month.
Key takeaways
- Forecast each sales channel separately, then add them up. Each one has its own drivers, seasons and margins.
- Build each forecast from drivers such as visitors, conversion rate, order value and number of accounts, not from a guessed growth rate.
- Use last year's monthly pattern for each channel to shape the year ahead.
- Show net revenue after channel fees, returns and discounts, because channels keep very different shares of each sale.
- Compare forecast to actual every month and update the drivers, not just the totals.
December is a natural time to build next year's forecast. Most of your year's data is in, you can see how this holiday season is landing, and you have a few quiet days between peaks to think. Even a rough channel forecast finished before January gives you a far better footing for stock orders, hiring, marketing spend and conversations with your bank or investors.
You do not need forecasting software. A spreadsheet and your sales history are enough. The method below works for a small shop with two channels and for a growing brand with six.
A quick note: this article is general information about planning and business finance, not financial or investment advice. For lending or investor projections, ask your accountant or adviser to review your assumptions.
Why forecast by channel at all?
A total revenue forecast usually starts with something like "last year plus 10%." That is quick, but it hides the important questions. Where will the extra 10% come from? Which channel is slowing? Which one needs more stock in March?
Splitting by channel helps in several practical ways:
- Different drivers. Website revenue depends on traffic and conversion. Wholesale depends on the number of accounts and their reorder habits. Lumping them together blurs both.
- Different seasons. A physical shop may peak in December, while a wholesale channel peaks months earlier as retailers stock up.
- Different margins. Marketplace fees, wholesale discounts and payment costs mean a dollar of revenue is worth a different amount of profit in each channel.
- Clearer decisions. When one channel falls behind forecast, you know exactly where to look and what to fix.
Common mistake
Forecasting gross revenue for marketplaces and net revenue for your own website, then adding them together. Pick one definition, ideally revenue after returns and discounts, and show channel fees as a separate line so totals compare like with like.
Step 1: map your channels and gather history
Start by listing every way money reaches your business. Keep the list practical: a channel should be big enough to matter and behave differently from the others.
Common small business channels include:
- Your own website or online store
- A physical shop, studio or market stall
- Online marketplaces
- Wholesale or trade accounts
- Subscriptions, memberships or retainers
- Services, workshops, events or consulting
Then pull monthly revenue for each channel for at least the last 12 months, and ideally 24. Your bookkeeping software, point of sale system, store platform and marketplace reports will usually let you export this. If your books do not separate channels yet, set up tracking codes or classes now so next year's numbers are cleaner.
Pro tip
Group tiny channels into "Other" rather than forecasting each one. If a channel brings in only a sliver of revenue, the time spent modeling it rarely pays off. Give it its own row once it grows.
Step 2: choose the drivers for each channel
A driver-based forecast breaks revenue into the few numbers that cause it. Instead of guessing "website revenue will be $X," you estimate visitors, conversion rate and average order value, then multiply. When a result looks wrong, you can see which assumption to question.
Useful drivers by channel
| Channel | Revenue formula | Drivers to track |
|---|---|---|
| Website | Visitors x conversion rate x average order value | Traffic sources, email list size, promotions |
| Physical shop | Footfall x conversion rate x average transaction | Opening hours, local events, season |
| Marketplace | Orders x average order value | Listings, reviews, ad spend, platform changes |
| Wholesale | Active accounts x orders per account x average order | New accounts, reorder rate, lost accounts |
| Subscriptions | Active subscribers x monthly price | New sign-ups, cancellations, price changes |
Use the drivers you can actually measure. If you do not track shop footfall, use transactions times average transaction instead. A simpler formula with real data beats a clever one built on guesses.
Step 3: build the monthly forecast
Now combine your history and your drivers. Work one channel at a time.
- Find the baseline. For each driver, look at last year's monthly values. These show the natural seasonal shape of the channel.
- Adjust for known changes. New products, a price change, a new wholesale account already signed, a marketplace you are leaving or a shop refit that closes you for two weeks.
- Set modest growth assumptions. Decide how much each driver might realistically move, and write down why. "Email list up 20% because of the new sign-up offer" is better than "growth."
- Multiply the drivers. Calculate revenue for each month in the channel.
- Subtract channel costs. Deduct marketplace fees, payment processing, expected returns and wholesale discounts to get net revenue per channel.
- Add the channels together. Your total is now a sum of parts you understand.
Example
Ana sells handmade ceramics. For next March, her website forecast is 6,000 visitors x 2% conversion x $55 average order, which is $6,600. Her marketplace forecast is 80 orders x $40, or $3,200, before fees. For wholesale, she has 12 active stockists, expects 4 of them to reorder in March, at about $600 each, so $2,400. Her March total before fees is $12,200. When March comes in at $10,500, she checks the drivers and sees only 2 stockists reordered. That tells her to call her wholesale accounts, not to spend more on website ads. (All figures are made up for illustration.)
A copyable channel forecast template
Set up one tab per channel with its drivers, and one summary tab that pulls the totals together. The summary might look like this. All amounts are made-up examples:
| Channel | Jan | Feb | Mar | Channel fees and returns | Net Q1 | Key assumption |
|---|---|---|---|---|---|---|
| Website | $5,200 | $5,000 | $6,600 | $1,100 | $15,700 | Example: email list grows after holiday sign-ups |
| Marketplace | $2,800 | $2,600 | $3,200 | $1,300 | $7,300 | Example: steady orders, fees unchanged |
| Wholesale | $1,200 | $3,000 | $2,400 | $0 | $6,600 | Example: 12 stockists, spring reorders |
Keep the "Key assumption" column honest and short. When you review the forecast later, it reminds you exactly what you believed and why.
Add scenarios, not false precision
Forecasts are always wrong in detail. What makes them useful is a sensible range. Build three versions:
- Base case. Your realistic expectation using the drivers above.
- Cautious case. Lower conversion, a lost wholesale account, a slower marketplace.
- Strong case. A successful launch, a new stockist or a better-than-expected season.
Plan your fixed costs and stock commitments around the cautious case, and keep a short list of what you would do if the strong case appears, such as reordering popular items faster.
Pro tip
Change only one or two drivers between scenarios. If you tweak everything at once, you cannot tell which assumption is doing the work, and the scenarios become hard to explain to a lender or partner.
Step 4: review forecast against actuals every month
A forecast you never revisit is just a wish list. The real value comes from comparing it with what actually happened and learning from the gap.
- Set a monthly review. Early each month, record actual revenue and actual drivers for each channel next to the forecast.
- Look at drivers first. If website revenue missed, was it fewer visitors, a lower conversion rate or smaller orders? Each points to a different fix.
- Update the rest of the year. Roll forward what you learned. If conversion is consistently lower than planned, adjust the remaining months instead of hoping it bounces back.
- Track channel mix. Note what share of revenue each channel brings. A shift toward a high-fee channel can lower profit even when total revenue grows.
Common mistake
Treating the holiday peak as the new normal. Strong December numbers in your shop or on your website can tempt you to raise January assumptions. Use the same month from previous years to set expectations, and let the seasonal shape guide you.
Connect the forecast to the rest of your plan
Your channel forecast should feed other decisions. Use it to plan stock by channel, schedule staff around shop peaks, set marketing budgets where drivers can move, and build your cash flow forecast, remembering that wholesale customers on payment terms pay later than website customers.
Your channel forecast action checklist
- List every sales channel and group tiny ones into "Other"
- Export 12 to 24 months of monthly revenue by channel
- Choose two or three measurable drivers for each channel
- Build a monthly forecast for each channel from its drivers
- Subtract fees, returns and discounts to show net revenue
- Create base, cautious and strong scenarios
- Write one clear assumption next to each channel
- Book a monthly forecast versus actual review in your calendar
Frequently asked questions
How far ahead should a channel forecast go?
For most small businesses, 12 months by month is a good balance. Add a rough second year by quarter if you are planning a loan or investment. Further out, the detail becomes guesswork.
What if I have less than a year of sales history?
Use what you have, plus outside clues: your own traffic and inquiry numbers, the seasonality you expect in your industry and early results from each channel. Keep assumptions conservative and update them monthly as real data arrives.
Should I include a new channel I have not launched yet?
Yes, but keep it on its own row with cautious drivers and a clear start date. That way, if the launch slips, you can remove it without upsetting the rest of your forecast.
Related reading
The bottom line
Revenue forecasting by sales channel turns one hopeful number into a set of clear, testable assumptions. Map your channels, choose a few drivers for each, build the months from last year's pattern, show net revenue after fees and add sensible scenarios.
Then review it every month. Within a quarter or two, you will know which channels to feed, which to fix and where next year's growth is really coming from.
