The Client Tracker template is useful for predicting a combination of one-off and monthly recurring revenue for up to 50 clients.
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 Client Tracker 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 Client Tracker template requires no hidden settings to be opened and completed. You'll only need to add data to the white boxes.
Start to add the information you'd like to import. The account code you select will determine if it is a cost or revenue that is pulled into Futrli.
You'll need to add figures for the first recurring amount, it is then your choice if you add figures to the second recurring amount or the one-off amounts.
You can add up to 50 rows of data for as many different clients as you'd like.
The Client column will be the prediction name you see in Futrli, set up against the account you select in the Account code column.
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.