My Balance Sheet is out of balance / my reports are wrong

My Balance Sheet is out of balance / my reports are wrong

Issue:
My balance sheet is out of balance or my reports are not showing the correct figures.
This can also be for consolidations.

Cause:
Sometimes this can occur with the calculations have not been properly refreshed.

Solution:
1. Under Utilities, run the budget and system recalculations.


2. Make a change in a record (e.g. change Days credit from 20 days to 30 days) and then change it back.

3. In Settings > Preferences, check that the Stock On Hand Cost Per Unit Timing has been set.

4. Check that there are no duplicates in your reports. If there are duplicates, please export the forecast and send it through to support@forecast5.com with an explanation of the issue and where the duplicates can be located.

5. Check that you have not double entered Opening Balances for Separately Invoice records:


6. Check there are no negative loans. Forecast 5 does not recognise negative loans
e.g. loans with balloon payments but no loan balance or balance paid in excess of owing on the loan, etc.

7. Reset the GST/VAT rates to 0 and recalculate.

8. Check the PAYE rates are correct.

9. Change the Income Tax Provision/Corporation Tax percentage to force a recalculation.

10. Check you have entered Days Credit on any factoring records.

    • Related Articles

    • Consolidation Rules for Forecast 5

      In order to successfully create a consolidation in Forecast 5, there are some rules and tips to be followed: Rules The forecasts must all have the same start date and number of years. The forecasts must be in the same state e.g. budget, actuals or ...

    • PAYE is causing an out of balance

      Issue: My balance sheet is not balancing due to my PAYE. Cause: This can be caused when the first data month has been changed from any period except the first, to another period, after the figures have been entered and the PAYE figures get stuck. ...

    • Consolidation: Why are there two records with the same name?

      Question: Why are there two records with the same name in my consolidation? Answer: If you have two records of the same name in two different forecasts but they are different record types, they will not be able to be consolidated and Forecast 5 will ...

    • Opening Balance: Opening Balance of An Asset Does Not Show On Reports

      Issue: Entering or changing the opening balance on an asset record does not update on the reports. Solution: You must enter the opening balance through the opening balance screen:

    • Why are there two opening entries for an Accrued / Prepaid record in the opening balance sheet?

      The reason is that the accrual or provision has an opening balance, i.e. we have an opening balance of a prepaid record called Insurance of $100, and at the same time, the latest invoice may be in the opening balance sheet waiting for payment. So we ...