Importing a Budget from a Spreadsheet

About

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

Step One

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:

Step Two

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:

Screen Shot 2017-01-19 at 14.31.30

Step Three

Select Import under Create from a CSV import. Enter a name for your Scenario and then select its duration and Start date:

Screen Shot 2017-01-19 at 14.32.30

Step Four

After clicking Next, the CSV upload Wizard will display. Here you’ll find the option to Download Template. Select Download Template:

Screen Shot 2017-01-19 at 14.33.22

Step Five

We now need to enter our budget into the downloaded template.

Screen Shot 2016-04-22 at 09.39.57

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.

Screen Shot 2016-04-22 at 09.42.48

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.

Step Six

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:

Screen Shot 2017-01-19 at 14.36.26