Uploading CSVs into Futrli – A Guide on Populating the Templates
Written by Matthew Cawthra
To import data for Manual Organisations, Non-Financial data and for Budgets created from a spreadsheet, you’ll be using Futrli’s CSV importer. In this guide, we’ll run through how to smoothly get your CSV into Futrli!
Anytime data needs to be imported via a CSV, a helpful template will be provided. This pre-formatted file will be your base for getting data uploaded.
When first creating a Manual Organisation, you will need to download the CSV template. During the process of first creating the Manual Organisation, you’ll automatically be directed towards downloading the template:
There are six fields on the CSV that will need to be completed:
Account Category (Column A, Row 2): The Account being uploaded will need to sit in one of the five Profit & Loss or seven Balance Sheet categories within Futrli (Income, Cost of sales, Expenses, Other income, Other expenses, Bank accounts, Current assets, Non current assets, Fixed assets, Current liabilities, Non current liabilities or Equity). If you do not enter a valid Account Category, you’ll be required to manually map during the upload process.
Account (Column B, Row 2): The name of the Account is how the Account will be presented in Reports and Scenarios on Futrli. Examples of Account names are ‘Food Sales’, ‘Wages’, ‘Advertising’ etc. The spelling of the Accounts will have to match future CSV uploads, otherwise new Accounts will be created. There is a maximum of 150 characters available for the Account name.
Opening Balance (Column C, Row 2): Carried forward balances for new (to Futrli) Accounts. Please note, the date of the Opening Balance cannot be after any uploaded months. For example, if the first month of data being uploaded for is April 2017, the Opening Balance must be set for March 2017 or before. You can amend the Opening Balance date in the Chart of Accounts if needed (once the Organisation has been created and the first set of data has been uploaded). Locate the Account in question, then hit Edit:
Date (Column D, Row 1): Data is uploaded in monthly periods. The format of the date must be the first three letters of the month, followed by the last two digits of the year, separated by a hyphen (‘MMM-YY’). For example, ‘Apr-17’.
Debit Values (Column D, Row 2) and Credit Values (Column E, Row 2): All data uploaded to Futrli needs to be positive. This is because Futrli takes into account the default Debit/Credit behaviour of each Account Category. For example, Cost of Sales should be entered as a positive figure in the Debit column. Data can have a maximum of two decimal points and does not require a currency symbol.
You’re able to bring in Non-financial data into Futrli. Again, we have a template to make life easy for you when using the CSV uploader that can be found anytime Non-financial data is uploaded:
In this template, there are four columns that need to be populated correctly for the CSV to upload without issue:
Date (Column A, Row 1): The date in this CSV needs to be all numbers in the format ‘YYYY-MM-DD’. For example, ‘2017-05-25’.
Parent (Column B, Row 1): The Parent category is the umbrella group that the Child Accounts will sit under. For example, ‘Customers’.
Child (Column C, Row 1): The Child category is therefore the individual Account, for example ‘Bar’.
Result (Column D, Row 1): The result can be only in number form. If there have been 193 customers in the bar that day, you’d simply add ‘193’ in this column.
Budgets on spreadsheets can be uploaded onto Futrli using the CSV uploader. Of course, we have a helpful template available to again make your life easier! Once you’ve selected to ‘Create from a CSV import’, you’ll see the option to download the template:
This template contains a minimum of six columns that need populating:
Account Category (Column A, Row 1): You are able to bring through Profit and Loss Accounts through on the CSV (Income, Cost of sales, Expenses, Other income and Other expenses). If one of these five are not selected, you’ll be asked to map during the upload process.
Account (Column B, Row 1): The Account you enter here will need to match the Account within the Chart of Accounts exactly. If it doesn’t, you’ll be required to map it to the correct Account during the upload process.
Forecast Name (Column C, Row 1): This column is for a further breakdown to the Account, for example ‘Drink Sales’ could be broken down into a Forecast for ‘Lemonade’.
Credit Terms (Column D, Row 1): The number of payment days added to a Forecast.
Sales Tax % (Column E, Row 1): Any figures entered here will override the defaults already set up, but if left blank, the import will assume this is 0. If we leave this column blank on the CSV it assumes 0 instead of using the scenario defaults
Date (Column F, Row 1): The date itself needs to be entered in the same format as the CSV upload for a Manual Organisation ‘MMM-YY’. For example, ‘MAY-17’.