This support note applies to:
- AE MAS (NZ)
- AE MAS (AU)
In an MYOB Accountants Enterprise (AE) Management Accounting System (MAS) ledger, if you experience a Trial Balance which does not balance, you need to perform the following tasks to rectify the error:
In MYOB System Release, perform the following steps: Click Next. The Select source ledgers screen appears. Select the required option in the Ledgers chosen section, then click Next. The options available are: Review the Backup location and Backup name and if correct click Next. The Completing the Ledger Backup Wizard screen appears. Click Finish. The backup process executes and creates a file in the specified location. The backup file has the name ss<unique number>.zip.
As selected includes only files for the selected ledger in the backup Related ledgers includes all ledgers with the same Client Code. All in folder includes all ledgers that exist in the folder from which the backup is initiated; an Custom defaults all ledgers in the current folder and allows you to select the individual items you wish to include. Highlight the required items to back up.
In MYOB System Release, perform the following steps:
Click Next. The Select source ledgers screen appears.
Select the required option in the Ledgers chosen section, then click Next. The options available are:
Review the Backup location and Backup name and if correct click Next. The Completing the Ledger Backup Wizard screen appears.
Click Finish. The backup process executes and creates a file in the specified location. The backup file has the name ss<unique number>.zip.
- Open the MAS ledger and from the Utilities menu, select Rebuild. The message "This process will rebuild data files & recalculate all balances, any early Exit from this routine, will require a restoration of original data" appears.
- Click Proceed. The routine runs and the MAS detail screen appears.
- Click OK. The MAS ledger appears.
- From the Utilities menu, select Revise Periods. The Revise Periods screen appears.
- Click the Year Structure button. The Current Year Structure dialogue box appears with the cursor in the Year Start Date field.
- Take note of the details in the Maximum Periods and the Current Period Number fields.
Click in the Maximum Periods field and type a different number into the Maximum Periods field and press ENTER.If you enter "1" in the Maximum Periods field, the focus moves to the Edit button. If any other figure is typed, the cursor moves to the Current Period Number field.
- Click OK. The message "Maximum periods has changed. Must regenerate all period dates. Proceed?" appears.
- Click Yes. The Revise Periods routine proceeds and the Revise Periods screen appears.
- Click Execute. The message appears, "Period details have changed. Balances to be recalculated. Proceed?"
Click Yes. The Journal Entries dialogue box appears.The questions at this point are not relevant to Australian requirements.
- Click OK. The Revise Periods routine proceeds and the MAS ledger appears.
- Return the ledger to the original period structure by repeating step 4 to through to step 9 to change the period structure of the ledger and return the Maximum Periods and Current Period noted at step 3.
First, identify the source of the out of balance amount.
If it is the value of the profit, check Profit Split accounts are correct under Setup > Client Files > Ledger Options > Profit Split.
The % for each account must total to 100.
The account code or codes must be correct for the entity type.
- Check the profit share accounts on the Trial Balance, if they are not zero use Edit Entries to edit the journal for the profit share to change the account balance to zero.
- If it is the value of a specific account code:
Review the transactions for the affected account code, and
Use Edit Entries to correct or delete any incorrect transactions.
Secondly, determine if there was a crash in the ledger while you were performing data entry, including Edit Entries.
- If there has been a crash:
- Run the List Entries report to determine the status of the entries;
- Use Edit Entries to continue entering the batch which was in progress at the time of the crash to complete the transactions.
Thirdly, identify if One Sided Journal data entry has been used:
- If One Sided Journal data entry has been used:
- Identify the reason for the use and if not valid;
- Use Edit Entries to remove the one sided transaction.
The value contained in each control account is the total of the values in all the sub accounts established for that individual control account. If a detailed trial balance balances but the summarised trial balance doesn't balance, this could indicate a discrepancy between the value contained in sub accounts and the value contained in a control account.
- Identify the control account which is incorrect;
- Refer to Updating control account balances to update the control account balances; and
- Run another rebuild.