The templates used to import data into a forecast in Futrli need the Master Sheet to be able to link with your accounts. If you update your chart of accounts, you’ll need to create a new Master Sheet:
When you first set up your Master Sheet, it takes a snapshot of every account that exists in the organisation's chart of accounts. Because the Master Sheet isn’t connected to your organisation, changes to your chart of accounts won’t update automatically.
📌TIP: You won't need to start fresh with your templates. You can move existing predictions from the previous Master Sheet to the new Master Sheet.
Create a new Master Sheet
Before you can create a new Master Sheet, you need to remove the existing Master Sheet.
Click the Forecasting tab, then view the relevant forecast.
Once in the forecast, click New prediction in the top right, then click Import templates.
If you need to copy the existing templates to the new Master Sheet, click Open Master sheet.
Click the trash can icon
at the top to remove the Master Sheet.
Note: This won't delete the file from your Google drive, it will only disconnect it from your Futrli account.
Once deleted, the option to create a new Master Sheet will now display.
Follow the steps in our guide to Set up your Master Sheet.
Move existing predictions into a new Master Sheet
After you create a new Master Sheet, you can move existing templates from the old Master Sheet to the new one.
Go to your old Master Sheet.
Tip: If not already open, you can access it from Google drive > My drive > Futrli Sheets integration.
For any sheets with predictions you want to keep, right-click on the tab.
Click Copy to and then Existing spreadsheet.
Select the new Master Sheet.
When you open the new Master Sheet, you now see the new tab added as a copy.
To bring it into Futrli, add the name of the tab to step three in the Control sheet. You can then head into Futrli and sync the import.