Skip to main content

Import a forecast from an Excel template

Import a P&L budget or 3-way forecast into Futrli using an Excel template.

Written by Futrli Support

You can use an Excel template to create a new forecast in Futrli. You can also use an Excel template to update an existing forecast.

Create the forecast

  1. Click the Create option.

  2. Select the type of forecast to create:

    • P&L budget

    • 3-way forecast

  3. Complete the forecast details.

  4. Select Upload predictions from an Excel spreadsheet.

Download the Excel template

Download the Excel template and save it to your computer. Complete the template before importing it back into Futrli.

Complete the Excel template

Complete the required fields using the format shown below.

B1 - Import type

Leave this as P&L budget/forecast.

C1 - Organisation name

Enter the organisation name exactly as it appears in Futrli.

C3 - From date

Enter the forecast start date. This also updates the date in G5.

C4 - To date

Enter the forecast end date.

Column A - Category

Select one of:

  • Income

  • Cost of Sales

  • Expenses

  • Other Income

  • Other Expenses

Column B - Account name

Enter the account name exactly as it appears in your chart of accounts.

Column C - Prediction name

Enter a unique name for the prediction.

Column D - VAT/GST/Sales Tax rate

Enter the tax rate as a percentage. For example, enter 20 for 20%.

Column E - Cash flow treatment (payment days)

Leave blank or enter 0 for a same day payment.

Column F - Store on day

Enter the day of the month to store the prediction. Leave blank to use the first day of the month.

Columns G onwards

Enter the prediction values for each period.

Import the completed template

  1. Save the completed Excel template.

  2. Return to the Upload forecast window.

  3. Drag the file into the upload area, or browse to select it.

  4. If validation errors appear, correct the issues in the template and upload it again.

  5. When the upload completes successfully, select Create.

Review the imported forecast

Open the new forecast to review the imported predictions. Predictions that you import from Excel display an icon to indicate you created it using an Excel import.

📌 TIP: You can continue adding manual predictions or import more predictions after you create the forecast.

Related Articles
Did this answer your question?