Chart of Accounts

SOLVED

Is it not possible to get a sub-group total in the middle of operating expenses accounts.  For example, I would like to get a sub-total for the four vehicle expense accounts in our chart of accounts - 5915, 5916, 5917, 5918, yet my attempt sub-totals everything above.  I don't want a sub-total before this group.

Finding help files less than helpful................

Parents
  • 0

    The 5915, 5916, 5917, 5918 would be TYPE SubGroup Account so the letter A will show on Chart of Account and the sub total would be an account nbr of 5919 or later  and TYPE Subroup Total so the letter S will show on Chart of Account.

  • 0 in reply to Smith and Co

    That does not work - as it subtotals everything preceding.   In QB this is done very simply ... I want a small subgroup that just includes all of our various vehicle expenses.  I will also want to do the same for other subgroups inside expenses at some point.

  • 0 in reply to AllanSharpe
    verified answer

    On the Chart of Account is the column called 'Type', anything that is an 'S' will subtotal all the 'A's just prior to the 'S'. It will only stop going further up when there is another break such as a G or another S (or an H or T). If you are using T then it will include all the Gs As and Ss and will only stop when it meets up with an H.

  • 0 in reply to AllanSharpe
    verified answer

    Hi Allansharpe,

    If will not subtotal everything preceding if you look at the following 2 screenshots.

    The first screen shot has 2 sets of subgroup accounts (A) with their corresponding subtotals (S). The second subtotal does not include the subgroup accounts balance from the first set.

      

    The second screen shot has a set of subgroup accounts (A) with their subtotal (S) after a group account (G).  As you can see, the subtotal does not include the balance from the group account.

    Hope this helps.

Reply
  • 0 in reply to AllanSharpe
    verified answer

    Hi Allansharpe,

    If will not subtotal everything preceding if you look at the following 2 screenshots.

    The first screen shot has 2 sets of subgroup accounts (A) with their corresponding subtotals (S). The second subtotal does not include the subgroup accounts balance from the first set.

      

    The second screen shot has a set of subgroup accounts (A) with their subtotal (S) after a group account (G).  As you can see, the subtotal does not include the balance from the group account.

    Hope this helps.

Children