cancel
Showing results for 
Search instead for 
Did you mean: 
CindyMatteson
Level 2

Subaccount

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.

Solved
Best answer January 16, 2020

Best Answers
Tori B
QuickBooks Team

Subaccount

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!

View solution in original post

RCV
QuickBooks Team
QuickBooks Team

Subaccount

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.

View solution in original post

4 Comments 4
Tori B
QuickBooks Team

Subaccount

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!

CindyMatteson
Level 2

Subaccount

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.  

RCV
QuickBooks Team
QuickBooks Team

Subaccount

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.

FWtreas
Level 2

Subaccount

@RCV This is a very useful report and one that should somehow be made more obvious. One suggestion is that if you haven't found the transaction causing the problem, set the start date of the report much earlier then work forward. That's how I found a transaction that should have been on a subaccount but was on a parent account instead.

Need to get in touch?

Contact us