Forum Discussion

GA39's avatar
GA39
Trusted User
2 years ago
Solved

P&L Header Account Subtotals in wrong position

MYOB's subtotal grouping function is not working properly.

Some of them display correctly. Some are not.

How do we fix this?

 

wrong subtotal location.png

  • Hi GA39 

     

    I would still recommend reviewing your accountslist as it does seem to be set up incorrectly. 

     

    If moving the accounts has not worked, can you please try to move the accounts in the way explained below as it is meant to refresh the Accounts List correctly. However, please ensure you've a backup of the file before attempting this: 

     

    1. In the Accounts List window, click to highlight a detail account below the Header account with the incorrect balance. (we can only move one at a time)
    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 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 to option 2.

    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.


5 Replies

Replies have been turned off for this discussion
  • Yanike_S's avatar
    Yanike_S
    MYOB Moderator

    Hi GA39 

     

    Accounts lists are built on the account numbers provided and the level of the accounts.  So if you are finding an account in the incorrect location I would first review the account number(s) used for that account(s). So we can investigate further can you provide a screenshot of the Accounts Lists>>Expense window.

    • GA39's avatar
      GA39
      Trusted User

      Please see below screenshot.

       

      exp.png

      • Yanike_S's avatar
        Yanike_S
        MYOB Moderator

        Hi GA39 

         

        Thanks for the screenshot. I can't see the entire screen, but it seems that your 6-1020 Electricity account is on the same level as the other accounts (1-1030 etc). I would recommend using the up/down button to make sure the accounts are on a different level so the subtotal will be added under the correct accountheader. Read more about this here: Customise your accounts list.