Scenarios

How to eliminate Accounts from a Consolidated Organisation

Written by Matthew Cawthra

How to view Eliminated Accounts

You can view Accounts which have been eliminated in Eliminations tab of your Consolidated Organisation’s Chart of Accounts

Written by Ross MacLeod

Benchmarking Cards

If you create a consolidated organisation, combining multiple entities into one group, you can assess performance of these organisations, side by side.

Written by Hannah Dawson

How to drill into Forecast Data

Written by Ross MacLeod

Set the rules for when your Consolidated Organisation’s Chart of Accounts updates

After creating a Consolidated Organisation, you can choose to manually or automatically manage the Organisation’s Chart of Accounts independently

Written by Ross MacLeod

How to create a Consolidated Organisation

Futrli allows you to consolidate multiple Organisations into one entity. Once consolidated, you can report on these Organisations as a single entity using any Card Type or custom metric that you wish.

Written by Ross MacLeod

Creating a Group of Organisations

Written by Andy Tyrrell

Choose when Actual data replaces Forecast data in Scenarios

Within Futrli Forecasting engine you can view the future of your business, but sometimes you also may want to view its past as well. You can choose when Actual data is displayed within the Scenario section using the Actual/Forecast Crossover dropdown, You’ll find this sat in the top right of every Scenario you create.

Written by Ross MacLeod

Converting a Forecast item to On-the-Fly

You can convert Forecast items that have been created using the Forecast Formula or Monthly Growth methods to On-the-Fly using the Convert to On-the-Fly option. This allows you to quickly create forecasts using any forecasting method and then convert the results to On-the-Fly in order to easily make adjustments. Please note, converting to On-the-Fly is permanent and cannot be undone.

Written by Ross MacLeod

Creating a Forecast for the first time is easy if you follow these 3 simple steps!

Why create something from scratch when your previous results can be used as insights to power your assumptions? Basing your forecast on last year’s data is the perfect starting point as you are saving valuable time while making sure that the seasonality of your business is also reflected in your forecast.

Written by Hannah Dawson

Entering your Organisation settings before creating your first Forecast

Before you can build a forecast for an Organisation in Futrli, you’ll first need to enter the Organisation’s Settings. These allow Futrli to automatically calculate your Sales Tax obligations and map your Accounts Receivable, Payable and Bank Account movements.

Written by Ross MacLeod

How do I extend the length of a Forecast, Budget or Scenario?

You can extend the length of your Scenarios using Futrli Advanced Copy option. This allows you to change the Start Date or the length of existing Scenarios.

Written by Ross MacLeod

How do I View/Hide Forecast Items Created Against an Account Line of a Scenario?

Written by Matthew Cawthra

How does Futrli handle Brought Forward Balances?

Written by Ross MacLeod

How to build a Business Forecast in seconds

With Futrli Last Years Actuals method you can create a business forecast in seconds based upon existing trends in your business over the last twelve months. Learn how to quickly project forward and get a clearer picture of the road ahead.

Written by Ross MacLeod

How to Create a Scenario Based on Actual Data

Written by Matthew Cawthra

How to enter Payment Terms to your forecast

You can apply Payment Terms to any Forecast Item you create. These will dictate when the item in question will impact upon your Cash Flow. Futrli gives you the flexibility to control when payments hit your account using flexible Payment Profiles.

Written by Ross MacLeod

How to rename forecast lines

Written by Ross MacLeod

How to Show/Hide Individual Forecast Lines

Written by Ross MacLeod

How to use the On the Fly Quick Edit forecast options

You can use our Quick Edit options to make bulk changes quickly and simply when using the On the Fly forecasting method. This allow you to perform bulk edits to the values which have been entered for all periods, an individual period or for multiple selected periods within your forecast. Using the Quick Edit options you can split the allocation of forecasted figures across a range, increase and decrease values by a percetange, or add or subtract values by an amount.

Written by Ross MacLeod

Overview of Scenarios – this is where you’ll build your budgets and forecasts

Within Futrli’s Scenario Builder you can view, create and edit forecasts for an Organisation which you have access to. This is an overview of its interface

Written by Ross MacLeod

Quick Guide to forecasting your Business goals for the year ahead

In this Quick Start Guide we’re going to look at how we can tailor our projections so that they tally with our expectations for the future.

Written by Ross MacLeod

The Scenarios page in Futrli – your first step to building a forecast or budget

Within this guide we’re going to walk through the basic interface within the Scenarios section. When first navigating to the Scenarios section you’ll find yourself greeted by a list of the Organisations which you have synced with your account. If you have no Organisations synced, then your Organisation list will be blank and you’ll need to add an Organisation first before you’ll be able to start forecasting.

Written by Futrli Support

What are Credit Terms? (use them in Scenarios)

Credit Terms are the number of days in duration between an item being invoiced and that item being paid for.

Written by Ross MacLeod

What’s the Difference Between a Budget and a Forecast?

Budgeting and Forecasting are two financial functions that are critical if you want to drive your business and not let it take you for a ride. However, there’s often some confusion surrounding Budgets and Forecasts, they are clearly linked, but it’s important to distinguish the differences. They’re not the same and they should be used differently, as intended, to give you a different perspective of whether your business is on the road to success or not.

Written by Hannah Dawson

Why can I not see the Scenario Section?

The Scenario section of Futrli is only displayed for Admins and Owners. User accounts do not have access to the Scenario section. Please contact your Account Owner if you wish to be granted access to the Scenario section.

Written by Ross MacLeod

Creating and Editing Forecasts

Creating a new forecast line

Forecast items can be created against any Profit & Loss and Balance Sheet line within Futrli. To create a Forecast Item, simply press the + button adjacent to the line you wish to enter forecast data for.

Written by Ross MacLeod

How do I create a new Budget? An overview of the four main methods you can use

Written by Matthew Cawthra

The Scenario Section Set Up

The Workings Tab in Scenarios

Written by Ross MacLeod

The Profit & Loss Tab in Scenarios

Written by Ross MacLeod

The Cash Flow Tab in Scenarios

Written by Ross MacLeod

Advanced Options

Advanced forecasting options (journals & no cash)

Futrli Advanced Options allow you to override the Forecast Item’s default behaviours. You can use the Advanced Options to change an entry from a Debit to a Credit, or from a Credit to a Debit, to change the Bank Account, Accounts Receivable or Accounts Payable line the item will impact, or to enter an item as a No Cash entry.

Written by Ross MacLeod

Forecasting Loans

Using Futrli advanced options we can create new Loans and enter payments for existing ones.

Written by Ross MacLeod

How Can I set a Forecast to a Nominal Account rather than a Bank Account?

Written by Matthew Cawthra

How do I Change the Journal Movements to Either Debit or Credit

Written by Matthew Cawthra

How to automate Stock Movements in your forecast

In this guide we’re going to walk through how we can automate our stock movements by combining Futrli’ Formula Forecast Method and Advanced Options. This will involve us forecasting Stock purchases on the Balance Sheet and then using a Formula to decrease the value of our Stock as Sales are made.

Written by Ross MacLeod

How to perform multiple Wage Payments on the Balance Sheet

Written by Ross MacLeod

Giving Others Access

Reporting on Forecasted Data

Alerts based on Forecasted Data

Importing Data onto a Scenario

Exporting Scenarios

5 steps to success with Futrli : Step 1 – Creating your first dashboard

You’ll create your first dashboard in 5 easy steps

Written by Futrli Support

5 steps to success with Futrli : Step 4 – Building a forecast

What does the next 12 months look like? An introduction to forecasting & the power of a Dashboard that looks ahead

Written by Futrli Support

Creating alerts in Futrli

Alerts are automated monitoring that give you complete control, in app, via email and now with Xero HQ. With our daily syncing of your data, they will trigger the minute something changes in your business.

Written by Ross MacLeod

Get your Forecasts linked with ‘What-If Scenarios’

Written by Matthew Cawthra

Importing a Budget from QuickBooks

You can upload Budgets you’ve created in QuickBooks into Futrli via CSV. Once imported into Futrli these can then be edited, copied and reported upon.

Written by Ross MacLeod

Adding your first Formula

You can create your own custom KPIs and formulas using Futrli’ Formula Builder. Build complex calculations or simply select an individual line – financial or otherwise – to report upon. It’s up to you.

Written by Ross MacLeod

Benchmarking Cards

If you create a consolidated organisation, combining multiple entities into one group, you can assess performance of these organisations, side by side.

Written by Hannah Dawson

Can I display a nominal code (account) individually?

Yes you can. You can pull out individual nominal codes/account lines using Futrli’ Formula Builder and add them to your report.

Written by Ross MacLeod

Can I do a Report that compares Income and Cost of Sales by Tracking category?

The graph of a tracking card only displays one item of data at a time. However, by using a formula, you can perform calculations that enable you to see the relationship between multiple items in one graph.

Written by Matthew Cawthra

Can non-financial data be imported into Futrli?

Non-financial data can be imported into Futrli using Futrli’ Non-financial importer. This allows you to import data from any source via CSV and then report on it, reference it when building forecasts or use it to create simple or complex KPIs.

Written by Ross MacLeod

Collaborating with your team, advisor or investors

Using the Share this Board option, you can share the Reports you’ve created in a live format. Any content that is shared as a Live Board will automatically update as changes are made to it by the Board Owner or by any User who has Write access to the Board

Written by Ross MacLeod

Comparison Cards

These gems give you comparative insight into how you are performing against last year, forecast, budget, or two scenarios.

Written by Hannah Dawson

Creating an Actual vs Budget Report with a Comparison Card

You can view your Business Performance versus your Budget using a Comparison Card. A Comparison Card allows you to view performance across any account category, line or formula comparatively, so you can see if you’re ahead or behind target or over or under your budget.

Written by Ross MacLeod

Exporting a Card to Excel

Written by Matthew Cawthra

Exporting options for Boards, Cards, Scenarios (PDFs, Excel, CSV)

You’ve got some insights, reports, forecasts, scenario comparisons and you need to send them to a team member

Written by Hannah Dawson

Forecast Cashflow Cards

Drill into even more detail than you can on the Cash Flow area of Scenarios

Written by Hannah Dawson

How Can I Export a Table and Chart on the Same PDF Page?

Written by Matthew Cawthra

How Can I Import Non-Financial Data to a Card (Report)?

Written by Matthew Cawthra

How Can I Show VAT Liability for an Organisation on a Card?

Written by Matthew Cawthra

How do I compare Year vs Year results?

You can compare Year vs Year results using a Comparison Card. Comparison Cards allow you to view your data comparatively, X vs Y, so you can view differences in performance from one year to the next, variances between budgets and actuals, or the projected divergence between two different scenarios you’ve created in Futrli.

Written by Ross MacLeod

How do I report on Tracked Data in Futrli? (Departments, Regions, Jobs etc)

You can report on tracked data in Futrli using a Tracking Card. This allows you to view data you’ve applied a track to in Xero. You can view tracked data on it’s own or collectively.

Written by Ross MacLeod

How to add Non-financial data to a Report at a Category level

Once you’ve imported Non-financial data into Futrli, you can reference it in your Reports either at an Account Category level or by creating a formula. In this guide we’re going to walkthrough adding Non-financial data at an Account Category level to a Report.

Written by Ross MacLeod

How to eliminate Accounts from a Consolidated Organisation

Written by Matthew Cawthra

How to switch Comparison Card Columns

When displaying your data on a Comparison Card, you can choose which column data displays in using the Column 1/Column 2 dropdown options. This gives you the flexibility to decide whether you wish to display your Actual data vs your Scenario or your Scenario data vs your Actual data. The choice is yours!

Written by Ross MacLeod

How to view Eliminated Accounts

You can view Accounts which have been eliminated in Eliminations tab of your Consolidated Organisation’s Chart of Accounts

Written by Ross MacLeod

Including custom account groups within a Report (Card)

Written by Matthew Cawthra

Proportion Cards

Used sparingly you’ll get some clear insight over key metrics with these

Written by Hannah Dawson

Report Cards

The workhorse card that you will use A LOT!

Written by Hannah Dawson

Setting a KPI/Formula’s Display Type

Written by Ross MacLeod

Snapshot Cards

How are you performing up until today?

Written by Hannah Dawson

Text Cards – annotate your findings

Great for communication and collaboration as well as your note taking!

Written by Hannah Dawson

The importance of non-financial business drivers

Your current and future business operations will be affected by a whole range of variables, variables that are rarely set in stone. Often these will be driven by a non-financial element.

Written by Hannah Dawson

Tracking Cards

If you tag your transactions by job, region, department, sales person etc, you can get insights in Futrli beautifully

Written by Hannah Dawson

Uploading Non-financial Data for the first time

Written by Ross MacLeod

Video Cards

If you want to make a kick-ass presentation using your Dashboards in presentation mode, you can include video content too!

Written by Hannah Dawson

What are Current Year Earnings? (Balance Sheet)

Current Year Earnings are the net profits a business has made throughout the current Financial Year. These are recorded under Equity.

Written by Ross MacLeod

What are Liabilities? (Balance Sheet)

Liabilities are debts held by the business. These can either be short-term debts, referred to as Current Liabilities, or long-term debts, referred to as Non-Current Liabilities.

Written by Ross MacLeod

What are Net Assets? (Balance Sheet)

Net Assets are the difference between your total Liabilities and your total Assets.

Written by Ross MacLeod

What are Retained Earnings? (Balance Sheet)

Retained Earnings are profits which were earned in a previous Financial Year, which have not been distributed as Dividends. These are recorded under Equity.

Written by Ross MacLeod

What is a Board?

A Board is a blank canvas that holds your reports together. Think of it like a Chapter heading. It could concentrate on anything from recent financial performance to 12 month projections and so much more besides. It’s up to you. You can create Boards in the Boards section of Futrli.

Written by Ross MacLeod

What is a Card?

A Card is a customisable report which brings your data to life. Each Card can be tailored to show the information which matters most to you. Use Cards to look at the future, the present or the past. Concentrate on your key financial data, analyse trends or report non-financials – it’s up to you.

Written by Ross MacLeod

What is a Current Liability? (Balance Sheet)

A Current Liability is a short-term debt which is expected to be paid within the next 12 months.

Written by Ross MacLeod

What is a non-current Liability? (Balance Sheet)

A non-current Liability is a long-term debt which is not expected to be paid within 12 months of taking on the debt.

Written by Ross MacLeod

What is a Prepayment?

A Prepayment is an amount which is paid in advance of receiving services or goods in full.

Written by Ross MacLeod

What is Accounts Payable? (Balance Sheet)

Your Accounts Payable line is a Liability line, which sits on the Balance Sheet. Your Accounts Payable contains the balance of moneys owed to external suppliers and individuals.

Written by Ross MacLeod

What is Accounts Receivable? (Balance Sheet)

Your Accounts Receivable line is an Asset line, which sits on the Balance Sheet. Your Accounts Receivable contains the balance of moneys owed to you by customers, clients and individuals.

Written by Ross MacLeod

What is Depreciation?

Written by Ross MacLeod

What is Net Profit?

Net Profit is the total amount of profit the business has earned after all incomes and expenses within a reporting period have been accounted for.

Written by Ross MacLeod

How to add a new Dashboard

Your insights start here!

Written by Hannah Dawson

The Workings Tab in Scenarios

Written by Ross MacLeod

Creating a new board

Your insights start here!

Written by Andy Tyrrell

Adding new Cards – an overview

The big overview reports that you need for your business are 3 clicks away.

Written by Futrli Support

The Profit & Loss Tab in Scenarios

Written by Ross MacLeod

Adding your first Card (Report)

In this guide we’re going to be walking through how to add a Card in Futrli for the first time. Cards are the building blocks for every report in Futrli. Each is a unique, custom report which can be tailored to suit your reporting needs.

Written by Ross MacLeod

The Balance Sheet Tab in Scenarios

Written by Ross MacLeod

Top tips for Cards and Boards (Adding Boards & Cards, Bulk editing, Presentation mode & Duplication)

There are always top tips for using a nifty piece of software and here are a few!

Written by Hannah Dawson

The Cash Flow Tab in Scenarios

Written by Ross MacLeod

Adding and Editing Card Templates

Futrli Card Templates allow you to quickly add one of many pre-configured reports and tailor them to your Organisation’s needs. In this Guide, learn how to select Cards from the Card Library and edit them to display your data.

Written by Futrli Support

How to delete a Card

Written by Ross MacLeod

How to find a Board from the My Boards section

Any Boards that you create or which are shared with you will be stored within your My Boards area. You can select a Board to view or to make changes to it by selecting My Boards and then the Board you wish to access.

Written by Ross MacLeod

How to rename a Board

Written by Ross MacLeod

How to view a Card in Full screen mode

Using Futrli’s Full Screen Viewer you can view a Full Screen version of your report without needing to adjust your Board’s layout. This allows you to focus in on the details of your business more clearly.

Written by Ross MacLeod

How to use Presentation Mode

Presentation is everything. This display style really focuses the audience and will change how you hold board meetings forever.

Written by Matthew Cawthra

What data can be imported into Futrli?

Futrli allows you create Organisations using data from Xero, Quickbooks or your accountancy platform of choice. You can also import additional non-financial data and upload budgets created elsewhere via CSV.

Written by Ross MacLeod

What does a (T) or (C) after an account line represent?

Futrli allows you to display data either Transactionally or Cumulatively. When Transactional data is being referenced you’ll see a (T) after the account name. When Cumulative data is being referenced you’ll find a (C).

Written by Ross MacLeod

How Do I Calculate Cumulative Data from the Start of a Report Rather Than The Start of an Organisation’s Data

Written by Matthew Cawthra

How do I display Forecast or Budget Data on a Card?

Written by Matthew Cawthra

How to drill into Forecast Data

Written by Ross MacLeod

Change how your data is displayed: transactional or cumulative

Written by Ross MacLeod

Set the rules for when your Consolidated Organisation’s Chart of Accounts updates

After creating a Consolidated Organisation, you can choose to manually or automatically manage the Organisation’s Chart of Accounts independently

Written by Ross MacLeod

Reporting on a 4-weekly Period

Using Futrli’s flexible date options you can quickly and simply select the appropriate date range for your report. In this guide, we’re going to walkthrough how we would display 4 weeks worth of data for a specific period, week-by-week, and then how we can display four weeks worth of data collectively in one report.

Written by Ross MacLeod

Sharing your dashboards with your team or stakeholders

Once you’ve started building reports in Futrli, you can share that content with invited Users as a live or static Dashboard, or externally as a PDF or as a CSV.

Written by Ross MacLeod

Sharing a Board as Read-Only: How to share a Board and ensure no changes can be made

Futrli allows you to share Boards in an editable or Read-Only format. Read-Only Boards can be viewed but not altered or re-shared by the recipient.

Written by Ross MacLeod

Sharing your first Board

Once you’ve added your first User you can start collaborating and sharing Boards. Anything you share will be instantly shared with the recipient, ready for them to view when they next login. Find out how to start sharing content now.

Written by Ross MacLeod

What are Credit Terms? (use them in Scenarios)

Credit Terms are the number of days in duration between an item being invoiced and that item being paid for.

Written by Ross MacLeod

Uploading your first Manual Organisation

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

Advanced forecasting options (journals & no cash)

Futrli Advanced Options allow you to override the Forecast Item’s default behaviours. You can use the Advanced Options to change an entry from a Debit to a Credit, or from a Credit to a Debit, to change the Bank Account, Accounts Receivable or Accounts Payable line the item will impact, or to enter an item as a No Cash entry.

Written by Ross MacLeod

Can I give a client access to forecasts or scenarios without giving them access to other Client’s Data?

Written by Ross MacLeod

Choose when Actual data replaces Forecast data in Scenarios

Within Futrli Forecasting engine you can view the future of your business, but sometimes you also may want to view its past as well. You can choose when Actual data is displayed within the Scenario section using the Actual/Forecast Crossover dropdown, You’ll find this sat in the top right of every Scenario you create.

Written by Ross MacLeod

Converting a Forecast item to On-the-Fly

You can convert Forecast items that have been created using the Forecast Formula or Monthly Growth methods to On-the-Fly using the Convert to On-the-Fly option. This allows you to quickly create forecasts using any forecasting method and then convert the results to On-the-Fly in order to easily make adjustments. Please note, converting to On-the-Fly is permanent and cannot be undone.

Written by Ross MacLeod

Creating a Forecast for the first time is easy if you follow these 3 simple steps!

Why create something from scratch when your previous results can be used as insights to power your assumptions? Basing your forecast on last year’s data is the perfect starting point as you are saving valuable time while making sure that the seasonality of your business is also reflected in your forecast.

Written by Hannah Dawson

Creating a new forecast line

Forecast items can be created against any Profit & Loss and Balance Sheet line within Futrli. To create a Forecast Item, simply press the + button adjacent to the line you wish to enter forecast data for.

Written by Ross MacLeod

Creating a Predictive Alert for the first time

Predictive Alerts allow you to create alerts based upon whether you will trigger an event, based upon your current, actual performance combined with that forecasted in your scenarios, budgets or forecasts. Take charge of the future and learn how to create your first Predictive Alert.

Written by Ross MacLeod

Entering your Organisation settings before creating your first Forecast

Before you can build a forecast for an Organisation in Futrli, you’ll first need to enter the Organisation’s Settings. These allow Futrli to automatically calculate your Sales Tax obligations and map your Accounts Receivable, Payable and Bank Account movements.

Written by Ross MacLeod

Forecasting Deferred Income

Deferred income is any revenue which is received in advance of a service being rendered or a product delivered to the purchaser. Deferred Income can be forecasted in Futrli using the Advanced Options.

Written by Ross MacLeod

Forecasting Loan Interest Payments

Using Futrli Formula Method, we can quickly and simply forecast Loan Interest payments. In this guide we’re going to walkthrough entering a simple Loan Interest payment.

Written by Ross MacLeod

Forecasting Loans

Using Futrli advanced options we can create new Loans and enter payments for existing ones.

Written by Ross MacLeod

How Can I set a Forecast to a Nominal Account rather than a Bank Account?

Written by Matthew Cawthra

How do I Change the Journal Movements to Either Debit or Credit

Written by Matthew Cawthra

How do I create a new Budget? An overview of the four main methods you can use

Written by Matthew Cawthra

How do I extend the length of a Forecast, Budget or Scenario?

You can extend the length of your Scenarios using Futrli Advanced Copy option. This allows you to change the Start Date or the length of existing Scenarios.

Written by Ross MacLeod

How do I View/Hide Forecast Items Created Against an Account Line of a Scenario?

Written by Matthew Cawthra

How does Futrli handle Brought Forward Balances?

Written by Ross MacLeod

How to automate Stock Movements in your forecast

In this guide we’re going to walk through how we can automate our stock movements by combining Futrli’ Formula Forecast Method and Advanced Options. This will involve us forecasting Stock purchases on the Balance Sheet and then using a Formula to decrease the value of our Stock as Sales are made.

Written by Ross MacLeod

How to build a Business Forecast in seconds

With Futrli Last Years Actuals method you can create a business forecast in seconds based upon existing trends in your business over the last twelve months. Learn how to quickly project forward and get a clearer picture of the road ahead.

Written by Ross MacLeod

How to create a non-cash forecast that doesn’t touch your bank (a journal)

Using Futrli Advanced Options you can override the default behaviour of a Forecast Item and set it to No Cash. This will remove the Cash Flow element of the Item.

Written by Matthew Cawthra

How to Create a Scenario Based on Actual Data

Written by Matthew Cawthra

How to edit a Forecast Item

Written by Ross MacLeod

How to enter Payment Terms to your forecast

You can apply Payment Terms to any Forecast Item you create. These will dictate when the item in question will impact upon your Cash Flow. Futrli gives you the flexibility to control when payments hit your account using flexible Payment Profiles.

Written by Ross MacLeod

How to forecast a Rent Prepayment

You can forecast the Prepayment of Rent using Futrli’ Advanced Options. In this guide we’re going to be representing our Rent as being paid monthly on our Profit & Loss, but we’re actually going to be paying our Rent Quarterly, on the first day of each Quarter.

Written by Ross MacLeod

How to Forecast Depreciation

Written by Ross MacLeod

How to Forecast Invoice Factoring with Recourse

Written by Ross MacLeod

How to Forecast Invoice Factoring without Recourse

Written by Ross MacLeod

How to forecast with Brought Forward Balances

In this guide we’re going to walkthrough creating a forecast item against an Accounts Receivable line, in order to account for the expected payment of a Brought Forward Balance.

Written by Ross MacLeod

How to perform multiple Wage Payments on the Balance Sheet

Written by Ross MacLeod

How to rename forecast lines

Written by Ross MacLeod

How to Show/Hide Individual Forecast Lines

Written by Ross MacLeod

How to turn your Xero Budget into a Cashflow Forecast

The Xero Budget Manager is a useful introductory tool to business forecasting, which allows you to enter your monthly budgets for each of your Profit & Loss accounts. In this guide, we’re going to look at how you can apply payment terms to your Xero Budget so that you can transform it into a Cash Flow Forecast.

Written by Ross MacLeod

How to use the On the Fly Quick Edit forecast options

You can use our Quick Edit options to make bulk changes quickly and simply when using the On the Fly forecasting method. This allow you to perform bulk edits to the values which have been entered for all periods, an individual period or for multiple selected periods within your forecast. Using the Quick Edit options you can split the allocation of forecasted figures across a range, increase and decrease values by a percetange, or add or subtract values by an amount.

Written by Ross MacLeod

Importing a Budget from a Spreadsheet

Written by Ross MacLeod

Importing a Budget from Xero

You can upload Budgets you’ve created in Xero into Futrli via CSV. Once imported into Futrli these can then be edited, copied and reported upon.

Written by Ross MacLeod

Overview of Scenarios – this is where you’ll build your budgets and forecasts

Within Futrli’s Scenario Builder you can view, create and edit forecasts for an Organisation which you have access to. This is an overview of its interface

Written by Ross MacLeod

Quick Guide to forecasting your Business goals for the year ahead

In this Quick Start Guide we’re going to look at how we can tailor our projections so that they tally with our expectations for the future.

Written by Ross MacLeod

The Scenarios page in Futrli – your first step to building a forecast or budget

Within this guide we’re going to walk through the basic interface within the Scenarios section. When first navigating to the Scenarios section you’ll find yourself greeted by a list of the Organisations which you have synced with your account. If you have no Organisations synced, then your Organisation list will be blank and you’ll need to add an Organisation first before you’ll be able to start forecasting.

Written by Futrli Support

What is a Cash Flow forecast?

A Cash Flow forecast projects how much Cash will move in and out of your business over a specified period of time. This allows you to see how much money you will need to set aside for payments and to estimate the impact on your Bank Balance.

Written by Ross MacLeod

What is a Forecast?

A forecast is a projection of future business performance based upon a set of assumptions as to how events will unfold.

Written by Ross MacLeod

What is Invoice Factoring?

Invoice Factoring is the process of selling your unpaid invoices to a third party for an upfront free – usually a percentage of the value of the invoices.

Written by Ross MacLeod

What is the maximum length of a Scenario in Futrli?

Written by Ross MacLeod

What’s the Difference Between a Budget and a Forecast?

Budgeting and Forecasting are two financial functions that are critical if you want to drive your business and not let it take you for a ride. However, there’s often some confusion surrounding Budgets and Forecasts, they are clearly linked, but it’s important to distinguish the differences. They’re not the same and they should be used differently, as intended, to give you a different perspective of whether your business is on the road to success or not.

Written by Hannah Dawson

Why can I not see the Scenario Section?

The Scenario section of Futrli is only displayed for Admins and Owners. User accounts do not have access to the Scenario section. Please contact your Account Owner if you wish to be granted access to the Scenario section.

Written by Ross MacLeod

Applying a Period Offset in Formulas (KPIs)

By default any account line, category or non-financial line you add to a formula will reference its transactional or cumulative value for the reporting or forecasting period selected in the Card’s settings or in the forecast formula. Applying a Period Offset allows you to reference past periods instead, enabling you to create calculations such as Opening Bank Balance and Monthly Growth in Revenue.

Written by Ross MacLeod

Adding your first Organisation

We’ll be guiding you through adding your first Quickbooks or Xero Organisation so that your data can start syncing with Futrli. Once your data has been added you’ll be able to start using it.

Written by Ross MacLeod

Uploading CSVs into Futrli – A Guide on Populating the Templates

Written by Matthew Cawthra

Giving your new Users and Admins access to your Futrli Demo Organisations

Written by Matthew Cawthra

User Roles Overview

Futrli’s flexible permissions allow for three possible user roles – Owners, Admins and Users. Every account has an Owner whom can invite an unlimited number of Admins and Users to share content with. Learn the difference between each role and the permissions each has within Futrli.

Written by Ross MacLeod

Creating a new printed report

Learn how to start creating beautiful, scaleable management reports in Futrli’s Report Builder.

Written by Ross MacLeod

Adding pages to a report and editing page layouts

Find out how to add blank or prebuilt Pages to a report, rename Pages and edit the layout of Pages you’ve already created.

Written by Ross MacLeod

Adding templates, charts, tables and text to a page

Start adding eye-catching Charts, informative Tables and inspiring Text elements to your Report Pages and wowing your clients and colleagues.

Written by Ross MacLeod

Configuring charts & tables in a printed report

Configure your Charts and Tables to your business needs with our guide on setting Report Types, Date Ranges, Data Sources and picking delightful Titles and Subtitles.

Written by Ross MacLeod

Adding data to charts and tables

Make your Reports insightful by adding Data, from Accounts, Groups and Non-financials to Formulas and custom KPIs.

Written by Futrli Support

Controlling how data displays in a chart

Personalise your Charts and make them beautiful with our guide on setting default and individual Chart Types, and choosing what displays on a Graph

Written by Ross MacLeod

Adding commentary and printing your report

Add commentary to your Charts and Tables to discuss the numbers in more detail and longer conversations to Text elements. Once you’re happy, save and print!

Written by Futrli Support

Controlling how data displays on a table

Find out how to control how your data displays on a table, from setting Rounding options and adding Column Formulas, to adjusting Table Cell Widths, Data Sets and more.

Written by Ross MacLeod

Addings rows to cards

Make your Reports insightful by adding Data, from Accounts, Groups and Non-financials to Formulas and custom KPIs.

Written by Andy Tyrrell

Customising Chart display on Cards

Personalise your Charts and make them beautiful with our guide on setting default and individual Chart Types, and choosing what displays on a Graph

Written by Andy Tyrrell

Setting up multiple y-axis and customising y-axis options

Personalise your Charts and make them beautiful with our guide on setting default and individual Chart Types, and choosing what displays on a Graph

Written by Andy Tyrrell

Configuring columns for Comparison cards

Personalise your Charts and make them beautiful with our guide on setting default and individual Chart Types, and choosing what displays on a Graph

Written by Andy Tyrrell

Filtering cards by Xero Tracking Categories and Options

Personalise your Charts and make them beautiful with our guide on setting default and individual Chart Types, and choosing what displays on a Graph

Written by Andy Tyrrell

Adding Column Formulas to your cards

Written by Futrli Support

Customising Tables on Dashboards

Find out how to control how your data displays on a table, from setting Rounding options and adding Column Formulas, to adjusting Table Cell Widths, Data Sets and more.

Written by Andy Tyrrell

5 steps to success with Futrli : Step 5 – The final report

The final report – which scenario is the best for your business’s future? Let’s look at your cash…

Written by Futrli Support

Adding your first Organisation – An overview

Learn how to connect a QuickBooks, Xero or MYOB Online Organisation to Futrli for the first time and start creating beautiful reports, building three-way forecasts and setting up alerts to manage your business on auto-pilot

Written by Hannah Dawson

What is an Alert?

Futrli Alerts allow you to monitor your business data on auto-pilot. You can use them to create notifications for all of the key metrics and KPIs that matter to you, enabling you to always stay abreast of performance, good or bad. Want to know when your Cash Flow goes above a certain figure? Or when your Gross Profit % is too high? With Alerts you can.

Written by Ross MacLeod

5 steps to success with Futrli : Step 3 – Am I bank for my customers?

Are you on top of your customers? Find out by using our Report Cards

Written by Futrli Support

Forecasting new loans

Written by Futrli Support

Forecasting existing loans (amortisation)

Written by Andy Tyrrell

How do I manually sync an Organisation? (Bring new data in)

You can Manually sync an Organisation within the Organisations section of Futrli. Simply navigate to the Organisations section and click the ‘Sync Now’ button adjacent to the Organisation in question:

Written by Ross MacLeod

How to recategorise a Chart of Accounts line

Futrli allows you to alter the Chart of Account categorisation of a nominal code line at anytime. You can do this within the Chart of Accounts section of the Organisation.

Written by Ross MacLeod

Resending an Invitation

Written by Ross MacLeod

How to Search for Users in the Users section

Written by Ross MacLeod

How to upgrade a User to Admin

You can upgrade a User to Admin within the Users section of Futrli. This can only be performed by the Account Owner. This will give them access to the Scenarios section for the Organisation in question and allow them to add new Organisations to your account. They will also be able to edit the permission settings of Users with the User role, whom they share Organisation access with.

Written by Ross MacLeod

Resetting your password

Written by Ross MacLeod

Can you export to PDF?

Subscribed Users can export either individual Card Reports or entire Boards to PDF. You’ll find a Print button located in the top right of every Card and on every Board. Clicking the Print button will export the Card or Board to PDF.

Written by Ross MacLeod

5 steps to success with Futrli : Step 2 – Snapshots

Creating the Dashboard and getting 5 essential insights from a Snapshot card

Written by Futrli Support

How can I Add an Account Line to a Manual Organisation

Written by Matthew Cawthra

How do I Change the Year-end for my Organisation?

Written by Matthew Cawthra

How to delete an organisation

Sometimes you need to remove an organisation from your account. This is the owner’s job

Written by Ross MacLeod

Getting started with Tracking Forecasting part 1

Tracking forecasts are known by different names depending on what accounting software you are using. MYOB defines this function as “Jobs”, QuickBooks describes it as “Classes”. The good news is that regardless of the terminology, all Xero and some MYOB and QuickBooks organisations support tracking.

Written by Andy Tyrrell

Providing advanced detail to support

Make your Reports insightful by adding Data, from Accounts, Groups and Non-financials to Formulas and custom KPIs.

Written by Futrli Support

Getting started with Tracking Forecasting part 2

Tracking forecasts are known by different names depending on what accounting software you are using. MYOB defines this function as “Jobs”, QuickBooks describes it as “Classes”. The good news is that regardless of the terminology, all Xero and some MYOB and QuickBooks organisations support tracking.

Written by Andy Tyrrell

I’m on Chrome and it’s running slowly – how do I fix this?

Slowdown when using Futrli on Google Chrome has affected a handful of users. Our team are investigating the cause of this slowness and believe that it is due to a Chrome plugin. If you follow the short steps to reset Chrome, Futrli will be A-ok again! Please let us know what Chrome extensions you have available as it helps us to pinpoint the cause.

Written by Ross MacLeod

Adding an image to a PDF – A beginners guide

Let’s have a look at how you might go about including an image, and how you can get that into a PDF.

Written by Futrli Support

Uploading your data from a CSV for non-cloud users

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 Andy Tyrrell

Creating a Futrli Account

Welcome to Futrli. In this Getting Started guide we’re going to be explaining how to create a Futrli account for the first time. How exciting!

Written by Ross MacLeod

How do I remove an Organisation in Futrli?

Organisations can be removed in the Organisations section of Futrli. Organisations can only be removed by the Account Owner. When an Owner deletes an Organisation, that Organisation will also be deleted for all Admins and Users.

Written by Ross MacLeod

How to create a Consolidated Organisation

Futrli allows you to consolidate multiple Organisations into one entity. Once consolidated, you can report on these Organisations as a single entity using any Card Type or custom metric that you wish.

Written by Ross MacLeod

How to create a Custom Account Group

Futrli allows you to create Custom Groups within your Chart of Accounts. This allows you to group Chart of Accounts items in order to view your data in the manner which is most meaningful to you. The groups you create will influence how your data is displayed when running Profit & Loss & Balance Sheet reports on a Card or within the Scenarios section of Futrli.

Written by Ross MacLeod

The User Invites Area

You can see an overview of invites which you have sent out in the Invites area of the Users section. Here you can also remove and resend outstanding invitations.

Written by Ross MacLeod

Changing a User’s access to a Live Board

If you are the Board’s Owner, you can amend a User’s access to your Live Board at anytime using the Share this Board option and selecting either Read Only or Write Access.

Written by Matthew Cawthra

Futrli Demo Data Explained

To help ensure you get the most out of Futrli, every Accountant who signs up is given industry-specific Demo Boards and Organisations, which you can use as examples with your clients.

Written by Ross MacLeod

How to view your Billing History and download receipts

Subscribed Owners can view their Billing History within the Profile section of Futrli. Here you can view and download past receipts, add VAT information and your address.

Written by Ross MacLeod

What should I do if my Organisation becomes disconnected?

If your Organisation becomes disconnected from Xero or Quickbooks, you will need to reauthorise it for use with Futrli. Navigate to the Users section of Futrli and press the Add Organisation button to reauthorise the Organisation.

Written by Ross MacLeod

How can I Change my Email Address in Futrli?

Written by Matthew Cawthra

Adding your first Organisation: Xero

Learn how to connect a Xero organisation to Futrli for the first time, so that you can start creating beautiful reports, building forecasts and setting up alerts to manage your business on auto-pilot

Written by Andy Tyrrell

Adding your first Organisation: Quickbooks

Learn how to connect a Quickbooks organisation to Futrli for the first time, so that you can start creating beautiful reports, building forecasts and setting up alerts to manage your business on auto-pilot

Written by Andy Tyrrell

Adding your first Organisation: MYOB

Learn how to connect a MYOB organisation to Futrli for the first time, so that you can start creating beautiful reports, building forecasts and setting up alerts to manage your business on auto-pilot

Written by Andy Tyrrell

Creating a folder for your boards

Written by Andy Tyrrell

Adding a card

Written by Futrli Support

Navigating your board

Written by Andy Tyrrell

Creating a Group of Organisations

Written by Andy Tyrrell

How to delete a Board

Written by Andy Tyrrell

How to re-size and reposition cards on your board

Written by Andy Tyrrell

How to update your billing details in Futrli

Written by Andy Tyrrell

What is Futrli? And what can it do?

Written by Hannah Dawson

Adding your first User

Futrli allows you to add an unlimited number of users, so you can share and collaborate with colleagues, clients or investors. In this guide we’re going to walkthrough adding a User for the first time.

Written by Ross MacLeod

How to Reset your Organisation’s Chart of Accounts

Written by Ross MacLeod

How to expand Sub-Group Categories

Written by Matthew Cawthra

Can I use Futrli on my Smartphone?

Futrli is designed responsively, enabling it to be used on Smartphones and Tablets, as well as on your Laptop or Desktop.

Written by Ross MacLeod

Can I use Futrli on my Tablet?

Futrli is designed responsively, enabling it to be used on Smartphones and Tablets, as well as on your Laptop or Desktop.

Written by Ross MacLeod

Can you import data from Spreadsheets?

Yes, spreadsheet data can be imported into Futrli via CSV. You can import financial data and use it to create standalone Organisations; upload non-financial data, which can be displayed in you reports, or used to build KPIs or to create complex forecast projections; and you can pull in budgets you’ve created elsewhere.

Written by Ross MacLeod

Does Futrli work with FreeAgent?

You can export your Financial Data from FreeAgent and import it into Futrli via CSV. We refer to Organisations created in this way as Manual Organisations. Manual Organisations enjoy all of the functionality of a Xero or Quickbooks Organisation, with the exception of automatic syncing.

Written by Ross MacLeod

Does Futrli work with Kashflow?

You can export your Financial Data from Kashflow and import it into Futrli via CSV. We refer to Organisations created in this way as Manual Organisations. Manual Organisations enjoy all of the functionality of a Xero or Quickbooks Organisation, with the exception of automatic syncing.

Written by Ross MacLeod

Does Futrli work with Sage?

You can export your Financial Data from Sage and import it into Futrli via CSV. We refer to Organisations created in this way as Manual Organisations. Manual Organisations enjoy all of the functionality of a Xero or Quickbooks Organisation, with the exception of automatic syncing. Data

Written by Ross MacLeod

How do I add Team Members to Futrli?

You can add Team Members to Futrli in the Users section. Futrli allows you to add an unlimited number of Users and has granular permission settings, allowing you to control what data is shared.

Written by Ross MacLeod

How is data in Futrli stored?

All data within Futrli is stored within the Amazon Cloud service knows as RDS. We employ industry standard SSL and TLS encryption and we regularly undergo security testing.

Written by Ross MacLeod

How many Users can I invite to Futrli?

Futrli allows you to add an unlimited number of Users. Futrli various User Roles and granular permission settings allow you to control what data is shared with those you invite.

Written by Ross MacLeod

How often does Futrli sync with QuickBooks?

Futrli syncs with QuickBooks on a daily basis, pulling through any new data which has been added to your account in that time.

Written by Ross MacLeod

How often does Futrli sync with Xero?

Futrli syncs with Xero on a daily basis, pulling through any new data which has been added to your account in that time.

Written by Ross MacLeod

When creating a Manual Organisation, should data be imported cumulatively or transactionally?

When importing data to a Manual Organisation, all Profit & Loss and Balance Sheet data – with the exception of Opening Balances – should be imported transactionally, i.e. just the movements which occurred within that month.

Written by Ross MacLeod

Leverage the power of automation with Futrli alerts & Xero HQ

Written by Futrli Support

Nail your new way of working with an advisory roadmap

Written by Futrli Support

Changing a User’s Non-financial Permissions

Non-financial permission settings are assigned to Users on a per Organisation basis. There are three Non-financial permission settings which a User can have. Permission Settings can be edited in the Users section of Futrli by Admins and Owners.

Written by Ross MacLeod

Scenario Definitions

What is a Current Liability? (Balance Sheet)

A Current Liability is a short-term debt which is expected to be paid within the next 12 months.

Written by Ross MacLeod

What is a non-current Liability? (Balance Sheet)

A non-current Liability is a long-term debt which is not expected to be paid within 12 months of taking on the debt.

Written by Ross MacLeod

What is a Prepayment?

A Prepayment is an amount which is paid in advance of receiving services or goods in full.

Written by Ross MacLeod

What is Accounts Payable? (Balance Sheet)

Your Accounts Payable line is a Liability line, which sits on the Balance Sheet. Your Accounts Payable contains the balance of moneys owed to external suppliers and individuals.

Written by Ross MacLeod

What is Accounts Receivable? (Balance Sheet)

Your Accounts Receivable line is an Asset line, which sits on the Balance Sheet. Your Accounts Receivable contains the balance of moneys owed to you by customers, clients and individuals.

Written by Ross MacLeod

What is a Cash Flow forecast?

A Cash Flow forecast projects how much Cash will move in and out of your business over a specified period of time. This allows you to see how much money you will need to set aside for payments and to estimate the impact on your Bank Balance.

Written by Ross MacLeod

What is a Forecast?

A forecast is a projection of future business performance based upon a set of assumptions as to how events will unfold.

Written by Ross MacLeod

What is Invoice Factoring?

Invoice Factoring is the process of selling your unpaid invoices to a third party for an upfront free – usually a percentage of the value of the invoices.

Written by Ross MacLeod