If you have an overdraft facility on your bank account, you can enable the automatic overdraft calculation in Figured for your forecasts. The tool will look at your forecasted closing bank balance and your interest rate, and calculate the interest based on that.

The interest payments will be automatically added to your planning grid and financial reports, and will change as your forecasts go up and down. 

NOTE: The calculated interest payments will be put into a Figured only system account which is automatically categorised to the Non-operating Expenses > Interest category of your reports.

Enabling interest on overdraft

In order to have your interest payments calculating, you'll need to enable the tool and configure a few settings.

To access the overdraft settings, head to Planning > Planning Grid > Tools > Overdraft settings.

This will open up your overdraft settings for your selected year.

You'll need to enable the calculation, and enter your interest rate and overdraft limit.

You will also have the option of linking the new overdraft account against an existing Xero overdraft account! Please note, if the account is not appearing here, you'll need to change the account type to overhead.

Go to Accounting > Chart of accounts, and search for your interest account it will come up in the CoA list. Click on the name of the interest account from Xero, and change its type to overhead. The account will now appear in the drop down.

Once happy with your settings, hit Save settings.

Your planning grid will reload, and you'll see those calculated values flow through (if you're in overdraft that is!).

Did this answer your question?