Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
C
CindyMatteson
January 14, 2020
Solved

Subaccount

  • January 14, 2020
  • 1 reply
  • 0 views

I am the 4th manager of our QuickBooks, we have 3 sub-accounts below our main operating account. As long as I have been here, the sub-account balance total is always higher than the main operating account balance (Main Ops account balance is $31,589.55 with Sub-Account balances totaling $33,677.45. I cannot figure out a way to find this error and move it to the correct sub-account. However, I cannot figure out a way to locate the entry or entries that is causing this balance discrepancy. Thank you in advance.

Best answer by Tori B

Hey there, @CindyMatteson.

 

Thanks for reaching out to Community. I'm happy to assist you with account balances. 

 

To see the most accurate information on the accounts, I recommend running a quick report on the main account. In doing so, it will provide your transaction history on that account and also include the sub-accounts. By running the report and reviewing the balances, you can see the type of transactions included, and the dates posted. 

 

To run a quick report:

 

  1. Open your Chart of Accounts.
  2. Locate the main account, then right-click it. 
  3. Choose Quick Report: (Name of account)

Once the report is open, you have the option to customize it. Customizing the report will allow you to include more details that are necessary to help you get the most information. For more help on customizing the report, you can check out: Customize reports in QuickBooks Desktop.

 

If you have further questions or concerns, feel free to reach back out. Take care!

1 reply

Tori B
Tori BQuickBooks TeamAnswer
QuickBooks Team
January 14, 2020

Hey there, @CindyMatteson.

 

Thanks for reaching out to Community. I'm happy to assist you with account balances. 

 

To see the most accurate information on the accounts, I recommend running a quick report on the main account. In doing so, it will provide your transaction history on that account and also include the sub-accounts. By running the report and reviewing the balances, you can see the type of transactions included, and the dates posted. 

 

To run a quick report:

 

  1. Open your Chart of Accounts.
  2. Locate the main account, then right-click it. 
  3. Choose Quick Report: (Name of account)

Once the report is open, you have the option to customize it. Customizing the report will allow you to include more details that are necessary to help you get the most information. For more help on customizing the report, you can check out: Customize reports in QuickBooks Desktop.

 

If you have further questions or concerns, feel free to reach back out. Take care!

    C
    CindyMattesonAuthor
    January 16, 2020

    Thank you.  I had previously created this report and could not find the error so thought maybe I was doing something wrong.  Still didn't find it, but I haven't given up yet.  I think I'll let our Accountant find it.  

    R
    RCVQuickBooks Team
    QuickBooks Team
    January 16, 2020

    Thanks for coming back, CindyMatteson.

     

    Aside from running a Quick report, you may want to try running a Transaction Detail by Account report to review the accounts. Then, customize it to the parent and sub-accounts to give you more details of per account transactions.

     

    Here's how:

     

    1. Click Reports on the top menu.
    2. Choose Accountant & Taxes.
    3. Hit Transaction Detail by Account.
    4. Tick the Customize Report.
    5. Select Filters.
    6. Under Filter, choose Account.
    7. Hit the Account drop-down and select Multiple accounts. From there, place a checkmark for the parent account and its sub-accounts.
    8. Hit OK and OK.

    Then, enter the report date period in the Dates field to trace the discrepancy in the report.

     

    I've got an article here about customizing company and financial reports: Customize company and financial reports.

     

    Keep us posted if you need a hand with preparing your year-end report or any QuickBooks related, I'm determined to ensure your success. Have a great day ahead.

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement