It can be difficult to budget for overdraft interest, since it is dependent on your Cashflow Forecast, and your Cashflow Forecast is also dependent on your budget. With the use of a custom KPI, Calxa can make this process much easier. This help note will outline the steps and assumes you have some basic knowledge in creating account groups and custom KPIs, running KPI reports and editing budgets.
- Nominate the bank accounts used for Cashflow Forecasting if not already done, as described in the Bank & Equity help note.
- Create a new KPI Formula for Overdraft Interest.
- Name: Overdraft Interest
- KPI Type: Number
- Decimal places and Display Format: Set as preferred
- Target type: Lower is better
- Formula: IF([Default Bank] < 0, -[Default Bank] * 0.10/12, 0)
Note: The above formula checks if the projected Bank balance is negative, and if so multiplies it by the interest rate. In this example the annual interest rate is 10% and we divide by 12 to get the monthly rate.
- Run a P&L with Projected Total (12 Months) report.
To view the Overdraft Interest KPI only, click on the Show accounts toggle in Report Filters to turn accounts off. Click on Show KPIs to turn it on and then select Overdraft Interest from the list via the cog at right.
Note: This report will show the budgeted overdraft interest. Please note this report will generate different results until the Last Actuals period surpasses the starting period. This is because until that point the closing bank balance for each month is being projected forward from a forecasted beginning of year opening balance, which may be different to the actual beginning of year opening balance when this becomes available.
If you wish to reforecast your Overdraft Interest part way through the year, simply select the option to Use actuals up to as shown in the example report filters above, and the forecast values will then be calculated based on your actual bank closing balance rather than your original budgeted bank balance at that period.
- Enter the values from the report into your budget for interest expense.