We've made a new way of viewing reports - "Actuals to Date (beta)". It is available on Business, Professional and Partner licences.
The Cash Flow and Balance Sheet Actuals to Date reports are in "beta" because they do not yet cover all cases we would like them to.
Please read and understand this article before using them.
We welcome any and all feedback you have.
These reports are designed to show a period of actuals followed by forecast columns influenced by values from the actual columns. The aim is to provide a 'rolling forecast', letting you see year-to-date actual values followed by a forecast.
You can see Actuals to Date (beta) reports by using the dropdown shown here at the top of each report:
What does "beta" mean?
These reports are in "beta". They have been a heavily requested feature - so we are releasing them now to gain feedback. For many purposes they will be suitable to use right away. However, there are some areas which do not reforecast as we would wish them to yet.
How do the reports work?
There are two types of calculation the report makes:
1. Cumulative lines, such as Closing Bank Position and most Balance Sheet lines will adjust figures in future months based on figures in the last actual month. So, for example, this handles our most regular request - to have an up-to-date Cash position based on actuals that carries forward into the forecast.
2. VAT/Sales Tax and GST calculations, and Corporation Tax calculations take into account data from a number of months (the amount of tax owed based on sales activities in a quarter, for example) and then use this information to automatically forecast the amount of tax that is paid. Because some of these periods could contain actual values and some contain forecast values we needed to do some additional work here to feed actual and forecast values into our forecast calculation of tax paid.
There are two ways of entering actual information in Brixx. Either manually, or through an automatic connection to Xero.
Cases we do not yet support or which require extra information:
For Xero-connected plans:
Brixx Cash Flow and Balance Sheet reports can display incorrect forecast figures if tax payments are delayed in Xero
If any VAT/Sales Tax/GST is paid after the month in which it is due, Xero puts this amount into its Accounts Payable account, without labelling this separately as a delayed tax payment.
This means that for Xero plans, if there are late tax payments, we are not currently able to recognise these separately from Accounts Payable and include them in our tax calculations as we would wish to. The result is the report will assume that tax has not been paid, and will present figures as if this were the case, making the reforecast of the tax lines on the Cash Flow and Balance Sheet incorrect.
For standalone Brixx plans (no Xero connection):
You need to enter tax liabilities to correctly calculate your Cash Flow tax forecast
We've added 3 lines to the manual Cash Flow actuals data entry form. These are Balance Sheet accounts for tax assets and liabilities. We use these values to determine how much tax should be paid in the forecast.
For all Brixx plans:
Equity set to a yearly % dividend does not take into account actual profits generated in each financial year.
These calculations do not yet take actual profits into account, only forecast values. As a result, yearly % of profit dividend calculations do not yet calculate based on actual profit values.