Balance Sheet is Out of Balance

In MYOB Advanced you can often resolve a Balance Sheet out of balance by running the Recalculate Account History process, otherwise review the design report

Purpose


To assist you in identifying and rectifying the cause of a Balance Sheet report being out of balance (OOB).

Disclaimer: This information about how to use MYOB Advanced is of a generic nature and is based on information supplied by MYOB. Not to be relied on for legal, accounting or employment advice. Data in screenshots is fictional and any resemblance to real personal information is coincidental. BusinessHub makes no warranties in relation to and is not responsible for information contained in third party websites.

Identify and Rectify Balance Sheet OOB


A Balance Sheet can be OOB for a number of reasons.  Following is a list of things to check to identify the cause of the issue and how to rectify the issue.

  1. Does the OOB amount equal the value of an account code/s on the Trial Balance?
    If so, is that account code, one that allows transactions or is it an automatic/calculation account such as Retained Profit or YTD Net Income?
    1. If it is a calculation account - run Recalculate Account History on the Actual ledger.  For more details refer to General Ledger Balances Incorrect.
    2. If it is a normal account, is this a new account? Does it have an Account Class or if it does have an Account Class, is the Account Class correct?
      1. If the missing account doesn't have an Account Class or the Account Class is incorrect, add/edit the Account Class on the Chart of Accounts.  For more details refer to Financial Reports Missing Rows.
      2. If the missing account does have the correct Account Class, is that Account Class referred to in the Balance Sheet row set? For more details regarding referencing Account Classes in a Row Set refer to Financial Reports Missing Rows.

Ensuring all the accounts have an account class and all the account classes are referenced correctly in the Row Set will resolve most issues.  

Note: Not all Row Sets are designed to use Account Classes, for example those used in Detailed reports.  If your report uses individual accounts, you need to ensure the relevant Row Set includes a reference to all the active accounts.

Related Articles


Questions?


If you have more questions, please contact BusinessHub's support desk on 1300 733 071 or raise a Support Case.