The Recurring Revenue template is useful for predicting up to 10 streams of recurring revenue based on growth and churn assumptions.
Before you add data to this template to import, you must:
Once you've done this, we explain below how to add data to the Recurring Revenue template in your Master Sheet.
⚠CAUTION:
Don't delete any rows or columns from the sheet
Don't add any additional rows or columns. If you require additional rows, use a separate template
If you accidentally do any of the above, you may corrupt the sheet. If this happens, you will need to open a new template, copy it to your Master Sheet again, and restart the process of adding data.
Click the Forecasting tab, then view the forecast you want to import predictions into.
Once in the forecast, click New prediction in the top right, then click Import templates on the dropdown.
Click Open Master Sheet.
Unlike some other templates, the Recurring Revenue template requires no hidden settings to be opened and completed. You only need to add data to the white boxes. You'll find an explanation of what to input for several of the cells.
⚠CAUTION: Only paste values if you're pasting data from another source. This is because the sheet has underlying formulas.
Latest actuals - When are these predictions starting from? Use the dropdown to select the last month of actual data you have available, remembering that actual data will replace forecasted data when available
User count - If you're going to be basing your recurring revenue on users, enter the number of users you have to base your numbers on moving forwards
Monthly revenue - This doesn't need to be specific, this number will be from what future increases or decreases will be based on
Growth, Expansion, Churn and Contraction - Set the amount and select if this will be a value, a per cent, or a number of users per month
Account - Which account is this recurring revenue going to be set against?
VAT/GST/sales tax - Set the VAT/GST/sales tax
Payment days - From the date the invoice is raised, how many days will the customer in question take to pay
Prediction name - This is what you'll then see in Futrli once the sheet has synced
You have up to ten predictions available to add to this sheet. Scroll down and open out the rows to set up further recurring revenue predictions.
When finished, you'll have a green tick at the top of the page. This means you can continue to sync the import template to Futrli.
If this isn't green, you'll be able to open the rows to see which information is missing.