Skip to main content

How to populate an Excel template for a forecast

How to fill the template when uploading predictions via Excel in Futrli.

Matthew avatar
Written by Matthew
Updated this week

When you’re adding predictions into a forecast from an Excel upload, make sure to follow the instructions below.

You can use this template to either create the forecast for the first time or to add to an existing forecast.

The following cells will populate automatically

B1 - Import Type

The import type must be 'P&L budget/forecast'.

Make sure not to change this.

B2 - Organisation Name

The name of the organisation will show by default.

Make sure not to change this as it must be exactly the same as the organisation name.

B3 + B4 - From and To Dates

The predictions dates will automatically be the same as the forecast start date and duration.

Row 5, column G and beyond

The months will populate automatically depending on the start date and duration set.

To add more months to either the start or the end of the forecast, amend the dates in either cell B3 or B4.

Columns A and B

All accounts in the organisation's Profit & Loss will populate automatically. Add you predictions against any of the existing accounts. If an account requires multiple predictions, you can add a new row to the spreadsheet in the appropriate section.


Cells to populate

Column C

Every prediction will require a name, and that name must be unique from all other predictions.

Column D

You can set the VAT/GST/Sales Tax rate here. Futrli will automatically build all VAT/GST/Sales Tax calculations from this setting. Leaving this column blank will default to 0%.

Column E

You can apply here any payment days required for cash flow treatment. Leaving this column blank, or setting the number as 0 will result in a same day payment.

Column F

You can store the prediction on any day of the month. Leaving this column blank will default to the first day of the month. Use the dropdown to select the required option.

Column G onwards

Finally add the predicted figures into the cells in column G onwards. These values must but net of VAT/GST/Sales taxes.

Futrli will calculate automatically the gross values from the rate set in column D.

Did this answer your question?