Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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!
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:
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.
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:
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!
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.
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:
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.
@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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here