Uploading Non-financial Data for the first time

About

Using FUTRLI’s Non-financial importer you can upload data into FUTRLI from any source. Once uploaded, you can then report on that data, use it to construct basic or advanced KPIs, or as part of your forecast projections. In this guide we’re going to talk through the basics of uploading Non-financial data for the first time.

Step One

First navigate to the Organisations section. This is the area of FUTRLI where you’ll find each of the Organisations you have access to listed. Adjacent to each Organisation you’ll find a button entitled Settings. Clicking this exposes further information on the Organisation and additional options.

Screen Shot 2017-01-20 at 10.31.27

Step Two

You’ll now find yourself on the Organisation’s Chart of Accounts tab which is where you can view the Organisation’s Chart of Accounts and, in the case of Manual Organisations, edit it. The Non-financial Data tab is where you can upload new and download or delete existing Non-financial data. Select the Non-financial tab:

Screen Shot 2017-01-20 at 10.32.30

Step Three

Once you’ve uploaded Non-financial data you’ll find it listed here, from where it can be deleted or downloaded. To add new data select Upload:

Screen Shot 2017-01-20 at 10.34.20

Step Four

Selecting Upload will load the Non-financial Upload Wizard. Here you’ll find an overview of our Upload format, as well as the option to Download an example Template. We would recommend you do so on your first Upload in order to ensure that your data is formatted correctly. To the right of the Download Template button you’ll find the option to Select file. Clicking this will allow you to Select the File you wish to Upload. We’ll be coming back to that later.

Screen Shot 2017-01-20 at 10.35.18

Step Five

In this example we’re going to be uploading Customer data for five days in January. To do so, we need to ensure that our Upload data conforms to FUTRLI Date/Parent/Child/Result formatting. First comes the Date field. Here we’ll enter the Dates for our upload. These should be entered YYYY-MM-DD, so when we put 2016-01-01, we’re actually saying January the 1st 2016. Next we have the Parent field. This is the Group, Title or Main header of our Upload data. As we’re uploading our Number of Customers for a period, we’ve entered this as Customers. In our Child field we can differentiate further – think of this as a sub-group within our main grouping. Whatever we put here will total to form the value of our Customers line. In this example we’ve entered Restaurant and Bar. Finally in our Results field we enter the number of Customers for each day. When you’re happy with your file, export it to CSV.

Screen Shot 2016-04-18 at 14.25.19

Step Six

Back in FUTRLI, click the Select File button and select your CSV. This will upload it into FUTRLI. If there are any errors with your file they will display at this point:

Screen Shot 2017-01-20 at 10.37.21

Step Seven

Click next to review the data you’re uploading into the system. Once you’re happy, click Next again and then Finish to complete your upload.

Screen Shot 2016-04-18 at 14.31.48