DocsRevenues

How to fix a blank revenue forecast

tl;dr, Check your acquisitions and conversions.

A common question from users is some variation of:

Why isn't the Revenues sheet generating any actual revenue figures given my revenue assumptions?

The reason is usually very simple: to generate revenue figures, you have to input your assumptions regarding prices and revenues and forecast acquisitions and conversions. Usually, people have input their pricing assumptions, but haven't used the acquisition or conversion assumptions, thus there aren't any units (e.g. users, customers, subscribers, clients) flowing in to generate revenues. In a generalized manner, calculating revenues per time period can be simplified to:

Revenues = Units per period * Price per unit per period

For example,

Subscription revenues = # of active subscribers that month * monthly subscription price

Transaction revenues = # of orders * average order value

When it comes to the revenue forecast in the Foresight models, if you are not seeing any revenues show up in your Forecast, usually you have input the prices but there aren't any units flowing through to generate revenues. If you're experiencing this, first look at the Revenues sheet in the Growth section, and check to see if you're generating any acquisitions. Then look at the conversion percentage assumptions on Get Started and the detailed forecasts of users, customers, subscribers etc. on Revenues to see if you are seeing any converted sales flowing through.

That usually solves the issue; if it does not, the next easy thing to check is that the line where the revenues are linking into the Forecast sheet is using a revenues category (in the dropdown, column D, where you can select the accounting treatment for each line).

If that still does not solve it, then review the assumptions on Get Started and track through Revenues to see where in the Growth -> Conversion -> Retention -> Revenues build to see what is not flowing through correctly.

Full details on the default revenue model ›