Uploading your first Manual Organisation / Trial Balance

You can create Organisations within FUTRLI using data from any accountancy platform via CSV. In this guide we’re going to walk through creating a manual organisation in FUTRLI for the first time and then importing data to.

Written by Ross MacLeod

About

You can create Organisations within FUTRLI using data from any accountancy platform via CSV. In this guide we’re going to walk through creating a manual organisation in FUTRLI for the first time and then importing data to.

Step One

Before we can start importing our data, we first need to create an Organisation to import that data to. To do that we need to navigate to the Organisations section within FUTRLI. Here we’ll find an overview of all of the Organisations which we have access to as well as the options to manage those Organisations, to upload data to them, delete them and to add new ones:

Screen Shot 2017-01-20 at 10.40.50

Step Two

To add a new Organisation, click the Add Organisation button:

Screen Shot 2017-01-20 at 10.41.44

Step Three

You’ll be asked to select what type of Organisation you wish to create. Select Manual Organisation:

Screen Shot 2017-01-20 at 10.43.02

Step Four

You’ll be asked to give your new Organisation a name, to select the Industry Category, to select your default currency and the last month in your financial year. The latter allows FUTRLI to perform accurate financial year to date and financial year total calculations. Once happy hit Create:

Screen Shot 2017-01-20 at 10.44.18

Step Five

Your Organisation will now have been created and will sit in your Organisations list. After selecting create you will be automatically redirected to the Manual Organisation Upload wizard where you can import your financial data. The data you import should be structured in accordance with FUTRLI’ financial data guidelines, otherwise you’ll receive an error message when importing. An overview of these guidelines can be found in the bottom right of the wizard. You’ll also find the option to download an import template. If you are importing your financial data for the first time we would recommend selecting this now and then pasting your data into the appropriate fields. Select Download Template to do so:

Screen Shot 2017-01-20 at 10.45.34

Step Six

Open the downloaded file. First we’re going to add the Accounts which we wish to import into FUTRLI. Account lines can simply be pasted under the Account heading. Please note, you do not need to import Account Categories, this will be generated for you automatically. The default Account Categories within FUTRLI are Income, Cost of Sales, Expenses, Other Expenses, Other Income, Bank Accounts, Current Assets, Non current Assets, Fixed Assets, Current Liabilities, Non current Liabilities and Equity. We would recommend ensuring that you enter the appropriate FUTRLI Account Category adjacent to each Account. Please note, Current Year Earnings should not be uploaded into FUTRLI as these will be generated automatically for you:

Screen Shot 2016-04-09 at 21.15.59

Step Seven

Next to each Account line you can enter an opening balance. Doing so is optional. The opening balance will be the year to date figure for Profit & Loss lines and the balance of Balance Sheet lines for the month from which you wish to begin importing data. The appropriate Credit and Debit behaviours will be applied automatically based upon the Category in which the line sits. Values entered for Incomes, Liabilities and Equity lines will be treated as Credits and values entered for Costs of Sales, Expenses, Bank Accounts and Asset lines as debits. If you have a negative balance for a line, for example, if your Bank Accounts balance was in the red, simply add a minus symbol in front of the figure to indicate this:

Screen Shot 2016-04-09 at 21.20.58

Step Eight

Finally, enter the monthly figures you wish to import for each line below the appropriate date. Dates should be formatted MMM-YY and each should have DR directly below and CR below and to the right. Debits should be entered under DR and Credits under CR. You can import data for as many periods as you wish. Once happy export your file to CSV:

Screen Shot 2016-04-09 at 21.31.10

Step Nine

In the Upload wizard click the Select File button and then select the file you wish to upload:

Screen Shot 2017-01-20 at 10.46.48

Step Ten

Provided your data has been formatted correctly your file will then be successfully uploaded. Click Next:

Screen Shot 2017-01-20 at 10.51.03

Step Eleven

Provided the appropriate Account Categories have been entered no further mapping should be required. If any mapping is required, simply select the appropriate category using the dropdown and then Create New to create a new Account line. Please note, Retained Earnings lines should be mapped to the system generated Retained Earnings line. Do not select Create New. Press Next to continue:

Screen Shot 2017-01-20 at 10.52.18

Step Twelve

In the next steps, Opening Balances and YTD Balances, you’ll see an overview of the balances you have entered. These can be changed here if you decide to alter a figure before completing your import:

Screen Shot 2017-01-20 at 10.53.59

Step Thirteen

Pressing Next again will move us to Conflicts. As this is the first time you’ve uploaded data for the Organisation there will be no conflicts displayed. If however you performed a subsequent upload containing data for already uploaded months, this is where you could select whether to replace the existing data in the system which conflicts with your new upload, or whether to not import any conflicting data. As there are no conflicts, you’ll also find nothing displayed in the Review Stage. Press Next on both and then Done in the final step to complete your import. Your new Organisation will now have data for the periods uploaded, and you can start reporting, forecasting and setting alerts for it:

Screen Shot 2017-01-20 at 10.55.09