Financial Planning Model
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
(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 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
(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 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.
This is a “BETA” flow - what does that mean?
A “BETA” flow works just like any other flow, but it is different in that it is something that we at gini are offering to our users to also test, get feedback on, and gauge general value and interest. As a result, they may be subject to changes and updates more than regular flows.
Can I make edits to this model?
This model has many complex interdependencies between its sheets. Rearranging sections, moving cells, and adding new rows or columns can easily break the model.
We recommend only making edits to the cells designed to be changed based on your input, which include:
- Input cells indicated by blue text
- Dropdown cells
- Expandable sections indicated by the blue ◄ icon
If you are looking for additional functionality on this model, please reach out to us at firstname.lastname@example.org for feature suggestions.
Can I make copies of this model?
While you can make copies of the model to a new spreadsheet by using Google Sheet’s copy spreadsheet or copy sheets features, the newly generated copy will not sync with subsequent updates from your accounting app. Only the original model sheets in your gini spreadsheet will sync with your accounting app.