Importing a Budget from a Spreadsheet
You can upload Budgets you’ve created outside of into FUTRLI via CSV. Once imported into FUTRLI these can then be edited, copied and reported upon just like any forecast created in FUTRLI.
Importing the Budget
FUTRLI provides an example template containing the appropriate formatting for your Budgets. We recommend downloading and using this template, either when creating your Budget from Scratch or to format your existing Budget for use with FUTRLI. To download the Budget template, first navigate to the Scenarios section of FUTRLI:
In the Scenarios section, click the ‘New’ button adjacent to the Organisation you will be uploading data to. If this is the first time you’ve attempted to create a scenario in FUTRLI, you’ll be prompted to enter the Organisation’s default Settings at this point. These must be entered in order for FUTRLI to perform its time-saving automation for you. Once entered, you’ll be taken to the Scenario Creation screen. Here you can select your Scenario Creation method:
Select Import under Create from a CSV import. Enter a name for your Scenario and then select its duration and Start date:
After clicking Next, the CSV upload Wizard will display. Here you’ll find the option to Download Template. Select Download Template:
We now need to enter our budget into the downloaded template.
There are only two required fields which have to be entered in the template. The name of the Account line, which would be entered under Account, and the Budgeted value of the line entered under the appropriate date.
When pasting values from another spreadsheet, simply paste Account Names under Accounts and then your values under the appropriate Date. You can add as many dates as you wish within the confines of your Scenario’s length. Dates should be formatted MMM-YY and should not begin prior to your Scenario’s Start Date.
Once you’ve entered your data and are happy with it, simply export it to CSV. Then navigate back to FUTRLI, press the Select File button and upload it into FUTRLI: