How Inflows Are Projected in the Forecast
An explanation of the methodology AskBiz uses to project weekly cash inflows in the Rolling Cash Forecast, including historical patterns, seasonal adjustments, and receivables.
Key Takeaways
- Projected inflows start from a rolling average of your recent weekly revenue, then adjust for identified trends and seasonality.
- Outstanding receivables you have entered are added as point-in-time inflow spikes in the week they are expected to be paid.
- The projection is not a commitment — it is a statistically informed estimate that improves as you log more revenue history.
Step One: Establishing the Baseline Revenue Pattern
The first stage of inflow projection is establishing a weekly baseline from historical data. AskBiz looks at your revenue data for the previous 90 days and calculates the average weekly revenue over that period. This becomes the starting baseline projection for each future week. If your business has been generating an average of 6,000 in revenue per week over the last 90 days, each forecast week begins with 6,000 as its base inflow figure. The 90-day window is long enough to smooth out short-term noise but short enough to remain responsive to recent business performance.
Step Two: Applying a Trend Adjustment
If your revenue has been growing or declining over the 90-day window, the forecast engine applies a trend adjustment to each future week. A linear trend is calculated by comparing the average revenue in the first 30 days of the window against the average in the most recent 30 days. If your average weekly revenue grew from 5,000 in the first month to 7,000 in the most recent month, the engine infers a growth trend and projects that each successive future week will be slightly higher than the baseline. A declining trend works in reverse. The trend adjustment is modest and bounded — the engine does not extrapolate extreme growth rates into the future without dampening them.
Free — no card needed
See this in action for your business
AskBiz tracks these metrics automatically — just connect your data and start asking questions.
Start for free →Step Three: Seasonal Pattern Recognition
For businesses that have been using AskBiz for more than one annual cycle, the forecast can identify seasonal patterns — predictable recurring variations in revenue tied to time of year. A retail business that sees a 40 percent lift in revenue in December will have that December uplift incorporated into the forecast for future December weeks. Similarly, a business with quiet summer months will see those weeks projected with lower inflows. Seasonal adjustment requires at least 52 weeks of revenue history. If you have less than 52 weeks of data, the forecast uses only the recent trend without seasonal overlay.
Step Four: Adding Outstanding Receivables
In addition to the pattern-based projection, you can add outstanding receivables — invoices you have issued to customers that have not yet been paid. When you enter a receivable with an expected payment date, AskBiz adds that amount to the Projected Inflow for the week in which the payment is expected to arrive. This creates a spike in the forecast on the appropriate week. If the payment does not arrive on time, you can update the expected payment date in your receivables record, and the forecast adjusts accordingly.
Confidence and Limitations
Weeks one and two of the forecast carry the highest confidence because they are close in time to the current data and the pattern-to-reality gap is small. Week twelve carries the lowest confidence because many things can change over three months. Inflow projections can be significantly off if your business has: an irregular payment structure such as large annual contracts; a recent pivotal change in pricing or product mix; an external event such as a major customer churning; or inadequate revenue history in AskBiz. Treat the forecast as a decision-support tool that helps you identify risk, not as a precise prediction of the future.