Chart of Accounts

Question

HiI am trying to update some of our account names/numbers in the COA and I've somehow made one of my header accounts now be at the same level as the detail accounts that linked into it, this has now meant the expenses in that group of accounts is now double counted in the total expenses.How can I fix this?&nbsp;Thanks

komal_s · Answer

Hi&nbsp;CML8&nbsp;
Please take a backup of your file and refer to this help article for details on how to group the accounts back correctly again.&nbsp;

cml8 · Answer

We are updating our chart of accounts and some account numbers have changed, I have made a new header account to have several detail accounts feed up into. The original header account for this group has somehow become a detail account and now has a financial history associated with it so can't be reverted to a header again, and now is being counted in our overall expenses header account - thus double counting the expenses that made up this total originally.

I need to do a journal to take this balance out of expenses, but I don't know where to put the other side of the journal, MYOB help desk said to do a journal to Unspent Expenses (?) but I'm not sure how to do this.

Can anyone help?

Thanks

cml8 · Answer

This isn't the answer I need to fix my problem unfortunately.I may need a support person to fix this

komal_s · Answer

Hi&nbsp;CML8&nbsp;
MYOB support would not be able to fix those accounts for you , we can only provide steps to fix the problem and assist if you're getting stuck. The detailed steps are given below to move the accounts, if it does not work for you, confirm where exactly you're getting stuck so we can advise accordingly&nbsp;(please only try these steps after you have the backup of your file as it is going to change the hiearachy) :&nbsp;
&nbsp;
Method 11. In the Accounts List window, click to highlight a detail account below the Header account with the incorrect positioning.2. Click the Up button to change the hierarchy of the detail account. This will move the detail account to not be under the Header account.Example below shows after pressing the Up button, the detail account 6-2101 is now on the same level as the header account 6-2100.Note: This Example show the header account is still incorrect. It should have no balance with no detail accounts to&nbsp;total.3. Now we have moved the the detail account this is no longer being totaled in the header account.4. Check the Header account balance,5. Move the detail account back down under the Header account, check the header account balance, this should now be correct. if not move onto&nbsp;refreshing&nbsp;the&nbsp;header&nbsp;account&nbsp;balance&nbsp;by&nbsp;refreshing the levels again.&nbsp;Example below shows the detail account 6-2101 has been moved under the header account 6-2100, and is showing the incorrect header balance still.

Method 2.&nbsp;To&nbsp;refresh&nbsp;the&nbsp;header&nbsp;account&nbsp;balance&nbsp;by&nbsp;refreshing&nbsp;the&nbsp;header&nbsp;account&nbsp;itself
&nbsp;

Make a backup of your file.&nbsp;
Click the arrow next to the header account.
Change&nbsp;the&nbsp;Header&nbsp;account&nbsp;to&nbsp;a&nbsp;Detail&nbsp;account
Under&nbsp;the&nbsp;Details&nbsp;tab&nbsp;change&nbsp;the&nbsp;Tax&nbsp;Code&nbsp;to&nbsp;N-T
Click&nbsp;OK
Click the arrow next to the header account
Change&nbsp;the&nbsp;Detail&nbsp;Account&nbsp;to&nbsp;a&nbsp;Header&nbsp;account
Select&nbsp;the first account&nbsp;that&nbsp;should&nbsp;be&nbsp;under&nbsp;the&nbsp;header&nbsp;account&nbsp;and&nbsp;click&nbsp;Down
Using&nbsp;the&nbsp;Down&nbsp;button&nbsp;move&nbsp;all&nbsp;other&nbsp;accounts&nbsp;that&nbsp;should&nbsp;be&nbsp;under&nbsp;the&nbsp;header&nbsp;account

&nbsp;
It is also recommended to restore a backup of your file to check if the accounts are organized as they should be. If either of these steps does not resolve the issue, let us know.&nbsp;

cml8 · Answer

Hi&nbsp;No this has not answered my query/fixed my problem, could you please arrange a time to call me so we can walk through how to fix this?admin@communicatemedia.co.nz&nbsp;Thanks&nbsp;

Forum Discussion

Chart of Accounts

6 Replies

Related content

Chart of Accounts

Chart of accounts

Revising Chart of Accounts

Chart of Accounts

Chart of Account sub-totals incorrect

Chart of Accounts - Assets

Chart of Account Levels

Chart of Accounts Levels