ACCOUNTS LIST TOTALS WONT ADD UP CORRECTLY

Question

I've created a new company and am progressively setting-up accounts. As I'm doing this, I'm entering opening balances for Equity accounts. After some deliberation, I've moved account numbers around a bit to better reflect the structure I'm after.

What's resulted is that the grand total of the "Equity" amount does not add to the respective "child" accounts which roll-up to the Equity total. I now have a total Equity amount of $1,513,518.61 for which child accounts add to $68,996.13.

I have attempted to rectify this by removing the opening balances previously entered in the child accounts (now $0.00 for all). I have also moved accounts up/down in the hierarchy as suggested in the post here:

https://community.myob.com/t5/AccountRight-Sales-and-purchases/ACCOUNTS-LIST-ISSUE-TOTALS-WONT-ADD-UP-CORRECTLY/td-p/680903

I have also deleted the "child accounts", however this made the situation worse by then calculating a "historical balance" (I subsquently restored from backup to rectify the historical balance problem. The screen-shot provided is after the restore).

The balance sheet is calculating correctly.

Would you please suggest a remedy for the issue.

celia_b · Answer

Hi schryan&nbsp;
&nbsp;
Thanks for you post.&nbsp;
&nbsp;
If you were trying to remove or you have already removed accounts, I'd &nbsp;recommend speaking with your accountant. &nbsp;They will be able to provide you advice and check on it. &nbsp; since we don't have an access to your account.&nbsp;
&nbsp;
If you need further assistance, feel free to post again. We're happy to assist.&nbsp;
&nbsp;
Cheers,&nbsp;
Cel
&nbsp;
&nbsp;

gavin12345 · Answer

Hi&nbsp;schryan&nbsp;&nbsp;I hope you found reply by&nbsp;Celia_B&nbsp;useful. Sadly MYOB sacked its moderator staff and much of the support staff, in preference to outsourced support and use of AI.&nbsp;What you are seeing in your file is the result of 2 different although related issues (aka bugs).&nbsp;&nbsp;Firstly:Moving accounts up and down causes calculation errors. Developers did not code for MYOB header accounts to re calculate correctly the total for sub accounts.&nbsp;&nbsp;Secondly:When a header account is changed to a detail account, and one of the detail accounts had an opening balance set, MYOB gets confused and adds the opening balance back to the Historical Balancing account. Again, and again, and again - each time you make a change. Sometimes the fix outlined in the link below will fix this issue - sometimes it will not.https://community.myob.com/t5/AccountRight-Installing-and/Balance-sheet-out-of-balance/m-p/747370&nbsp;&nbsp;Options:Start a new file and set accounts correctly before adding amounts, orSend the file to MYOB to get fixed, oruse File Utility MYOX to fix the AccountList totals (approx $100 fee for 3rd party program)RegardsGavin&nbsp;

schryan · Answer

Hi Celia.&nbsp;Thanks for your reply.&nbsp;The issue may have been triggered by accounts that I removed. However, I removed these after I re-assigned "$0.00" to the Opening Balance field for each.&nbsp;Please note that:-1. the GL trial balance is in balance;2. the balance sheet balances;3. there is no "Historical Balancing" amount and;4. all required accounts exist.&nbsp;I'm an accountant and understand the implications of deleting an account which has any activity or an opening balance. Myob doesn't permit you to delete an account with non-zero amounts.&nbsp;This is definitely a bug in Myob's ability to relcalulate the rolled-up amount.&nbsp;I find interesting the reply in this thread posted by&nbsp;gavin12345 and supportive of what I've uncovered.&nbsp;Regards,Peter

schryan · Answer

Hi Gavin.&nbsp;Thanks for your reply and appreciate your suggestions.&nbsp;I've managed to restore an earlier version of the file and I'm in the middle of reconstructing it (had the sense to take a backup at an earlier stage). Fortunately, only 2-3 hours of re-work (not days).&nbsp;Quite frustrating and astounding that a bug like this exists.&nbsp;&nbsp;Regards,Peter&nbsp;&nbsp;&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;schryan&nbsp;&nbsp;Agreed, there are hundred of bugs reported (some since 2011) that MYOB have simply chosen to ignore. Unless a bug affects all users or leads to file corruption, they seem to leave it alone rather than fix it.&nbsp;Fortunately the Account List totals are a display issue only, it won't affect your financial statements. So don't expect a fix.&nbsp;RegardsGavin

Forum Discussion

ACCOUNTS LIST TOTALS WONT ADD UP CORRECTLY

Looking for something else?

Related content

ACCOUNTS LIST ISSUE TOTALS WONT ADD UP CORRECTLY

Chart of Account sub-totals incorrect

Balances not displaying correctly

Superannuation not calculating correctly

Account List Totals

Bill Totals differing

Is tax being taken correctly

MYOB payroll journals not posting correctly