All Collections
Forecasting
Using Import
How to create a new Import Master Sheet
How to create a new Import Master Sheet

If you need to refresh your Master Sheet, here's how

Updated over a week ago

The templates used to import data to a forecast in Futrli are linked to your Futrli account by your Master Sheet.

πŸ“Ž NOTE: If you're yet to create a Master Sheet, this guide runs through how to do that, but if your Master Sheet needs to be refreshed, this guide below will run through how to do that.

Why would you need a new Master Sheet?

When the Master Sheet is created, it takes a snapshot of every account that exists in the chart of accounts for the organisation. But the Master Sheet does not have a live link with your organisation. If your chart of accounts changes, your Master Sheet does not.

If your chart of accounts is updated, you'll need to create a new Master Sheet.

Don't worry though - this doesn't mean you'll need to start fresh with your templates, we can move those from the old Master Sheet to the new Master Sheet - and this guide will explain exactly how to do that.


How do you create a new Master Sheet?

Before a new Master Sheet can be created, we'll need to remove the existing Master Sheet. This can be done first by heading into the forecast in question, then into the import homepage for that forecast via the New prediction and Import templates option.

There you will see the option to delete the Master Sheet, it's a bin icon on the top of the page.

Once deleted, the option to create a new Master Sheet will now display.


How can I keep existing predictions with a new Master Sheet?

So you have created a new Master Sheet - but what about the predictions that were set up on the old Master Sheet?

No problem, we can move these from the old Master Sheet to the new Master Sheet - nothing will be lost.

Step one

Head into the old Master Sheet. Any sheets with predictions you'd like to keep, right click on the tab, then click Copy to and then Existing spreadsheet. You'll then be selecting the new Master Sheet.


Step two

Jump into the new Master Sheet, you'll now see the copy of that tab has been moved over.

To bring it into Futrli, add the name of the tab to step three in the Control sheet, then head into Futrli and sync.

Did this answer your question?