Financial Planning Model

Overview

The Financial Planning Model flow is a simple model that you can use to help you plan the next 12-months with a rolling forecast. The model imports your Xero/QuickBooks data and your accounting data will also update daily, so that your model is always up-to-date.

With this flow you will be able to:

• Map your chart of accounts to custom revenue and expense categories

• Set custom revenue and expense forecasts for each unique category

• Compare your rolling forecasts against actual values month-to-month

• Visualize the differences between your forecasted and actual financials

Included Sheets

FPM (Mapper)

The (FPM) Mapper sheet is where you will be able to map your chart of accounts to more specific categories. This includes:

• Creating custom revenue and expense categories

• Distributing more complex expense accounts like salaries to different categories using “breakdown categories”

• Accessing a visual breakdown of your revenue and expense categories for the last year (year-to-date)

The “Step 2” section of this sheet gives you the ability to accommodate more complex accounts that may map to several different expense categories. For example, if you have an account for “Payroll”, you can create a breakdown category and distribute the expenses across multiple expense categories based on a percentage distribution.

(FPM) Overview

The (FPM) Overview is where you will be able to see a bird’s eye overview of your account-mapped-financials for the last (trailing) 12-months.

Use this sheet to double-check that your mapped categories and revenue/expense totals look correct.

(FPM) Forecast Input

The (FPM) Forecast Input sheet gives you the ability to set your forecast assumptions for your revenue and expense categories. These values will be the basis for your rolling forecast.

If you are not sure how to make realistic forecasts for your revenue and expenses, please contact us to get help on making granular forecasts.

(FPM) Tracking

The (FPM) Tracking sheet is where you will be able to keep track of your company’s financial performance over time. As time passes, you will be able to compare your company’s actual revenue and expenses against your forecasted revenue and expenses.

Creating the model

To create the model, find the “Financial Planning Model” flow in the gini webapp. Ensure you have connected the required apps - this flow requires at least one accounting app (either Xero or QuickBooks) and Google Sheets.

Then from the flow page, select the organisation you want to create the model for and click the “Create Model” button.

Once your flow is created, you will be able to find it in the “My flows” section of the dashboard. Click on the “Open flow” button to see the model in Google Sheets.

FAQ