Forecasting revenue-only streams

Revenue-only includes scenarios where a source of revenue is based on and scaled from another source of revenue. For example, if you have a catering business, you can forecast your drink sales as a percentage of your food sales. Similarly, if you offer a software subscription, you can forecast downloadable content per subscription. Using a revenue-only stream can help you model this type of revenue projection easily.

Adding a revenue-only stream to your forecast

  1. In the Forecast section, select Revenue:
    forecast section detail with forecast and revenue highlighted.png

  2. Click Add Revenue Stream:
    add revenue stream button highlighted.png

  3. Enter a name for this revenue stream:
    revenue_only.png

  4. For the type, select Revenue only:
    revenue_only_highlighted_new.png

  5. Click Next:
    next button detail.png

  6. Select how you want to enter the revenue. This can either be a constant amount each month or varying amounts over time:
    revenue-only constant or varying amount detail.png
    Note: If you have numbers from a spreadsheet, select the Varying amounts over time option, and then you can easily copy and paste from your spreadsheet.
    • Constant amount: Indicate the amount of revenue, whether you receive it monthly or annually, and when the revenue stream will start:
      revenue_amount_and_month.png
    • Varying amounts over time: Plot the revenue stream by month:
      revenue stream varying amounts over time entry example.png
  7. Click Create & Exit:
    create and exit.png

Revenue based upon a % of another revenue stream

Revenue-only includes scenarios when a some of your revenue scales in direct proportion to another revenue stream. 

  1. In the Forecast section, select Revenue:
    forecast section detail with forecast and revenue highlighted.png

  2. Click Add Revenue Stream:
    add revenue stream button highlighted.png

  3. Enter a name for this revenue stream:
    revenue_only.png

  4. For the type, select Revenue only:
    revenue_only_highlighted_new.png

  5. Click Next:
    next button detail.png
  6. Select % of specific revenue stream. This can either be a constant percentage each month or varying percentages over time:
    revenue-only % of revenue detail.png
  7. Choose the revenue stream that this revenue will be directly scaled from. Revenue-only which revenue.png
  8. Set the percentagerevenue-only % revenue constant amount.pngConstant amount: Indicate the percentage of the revenue stream that this revenue will will be based from.revenue-only % revenue varying amount.png
    Varying amounts over time: Plot the percentage by month:
  9. Click Create & Exit:
    create and exit.png
  •  

Editing or deleting a revenue stream

To edit an existing revenue stream:

Click on its name in the Revenue table:

revenue_streams_highlighted_new.png

The edit overlay will appear. You can click on any of the steps across the top that you wish to edit. Make your desired changes, and click Save & Exit. For more details, see How do I edit or delete forecast entries?

revenue_stream_steps_highlighted.png

Note: The step names will vary depending on the type of revenue stream that you are editing.

To delete a revenue stream:

Three dots will appear when the cursor is moved over a revenue stream. Click on the dots, then select Delete:

delete_highlighted_revenue_.png

Click Delete to confirm:
confirm delete forecast item.png

Where does this entry appear in the financial statements?

Your revenue streams will be used to calculate the highlighted lines in the Profit & Loss, Balance Sheet, and Cash Flow table shown below:

pandl_revenue_highlighted.png

 

balance_sheet_cash_highlighted_new.png

 

net_profit.png

Was this article helpful?
8 out of 12 found this helpful