All Collections
Building budgets and forecasts
Dynamic planning using the auto calculation tool
Dynamic planning using the auto calculation tool
Expenses as a percentage of sales, cost per hectare, dollar per stock unit
Genevra Scott avatar
Written by Genevra Scott
Updated over a week ago

What is dynamic planning?

Dynamic (formula-based) planning can be used for planning expenses and/or income as percentages of a particular account, as a dollar per hectare, dollar per Milk Production unit or stock unit allowing you to plan more efficiently and accurately. This means that your forecast will dynamically change each month as these on farm metrics change throughout the season.

Choosing the dynamic planning option

Choose the account you wish to enter the transactions against by clicking the name of the account and flicking over to the Auto Calculation option.

NOTE: To enlarge images, right click and open in new tab

Any transactions entered using the Auto Calculation tool will be cleared if you choose to begin entering manual transactions in this account again.

Dollar per KgMS

You can enter the dollar amount and select the KgMS option from the dropdown.

Then you can choose which milk tracker you wish to pull the KgMS from for the calculation.

e.g. if you're entering the transactions from the 2023 year this will choose the KgMS for each month that you have in your 2023 milk season.

NOTE: If your Figured planning season dates differ to the typical milk tracker season this will only calculate the amounts for the months that sit within that year in the planning grid (see image below)

Dollar per hectare, per stock unit (SU) or per head

For dollar per hectare transactions this is based off either the milking platform set in the milk tracker OR the farm area set in your properties and fields OR off a particular Crop Season area. Simply select the area you want the transactions to calculate off.

Dollar per stock unit and per head will be based off the stock units and per head of livestock in your livestock trackers. As the quantity on hand changes in each of these trackers your forecast will automatically adjust accordingly.

As a percentage of another linked account code

You can choose a linked account to add transactions as a percentage of another account.

For example if you're wanting a 2% bonus payment forecast added for a contract milker as a percentage of total milk income each month you can choose the milk production account and the transactions will calculate 2% of each months income.

You can also choose to calculate a percentage based on a total of several different account codes, just select as many accounts as you like from the drop down.


When setting up the automatic calculations you must select the frequency that you want the calculations to occur. You have the following options available to you:

  • Monthly - Transactions will be automatically created monthly.

  • Bimonthly - Transactions will be automatically created every 2 months.

  • Quarterly - Transactions will be automatically created every 3 months.

  • Biannually - Transactions will be automatically created every 6 months.

  • Annually - A transaction will be automatically created every 12 months.

  • Custom - Select the months you want transactions to be automatically created in. This option defaults to the month within the Profit date. The Cash date of those transactions will depend on that account’s payment period.

Note: When selecting the frequency of automatic calculations the start month will be from the highlighted cell in the planning grid that you are entering the values into.

Did this answer your question?