Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Why is a bank that we no longer use and has a zero balance showing up with a balance on my detailed summary report? I checked banking-register and it is correct. I checked banking-reconciliation and am able to reconcile without any problems. The old bank did not show up on last month’s report. Thank you in advance!
Solved! Go to Solution.
Hi @CdSecretary
The balance sheet detail report will show the opening balance, activity, and ending balance for each account for the date range shown at the top of the report.
It should show the same ending balances for each account as the standard balance sheet (summary) report.
If you are seeing different balances, make sure the ending date on the balance sheet detail report matches the balance sheet summary report, and make sure they're both running on the same basis, either Cash or Accrual. (The basis appears at the top left corner of each report.)
Also, be sure you're comparing the account balance to the same date in the account register, not the ending balance there, if there are transactions after the balance sheet reports' dates.
Glad to have you back here in the Community, @CdSecretary.
I'm here to help you identify the reason behind the old bank account balance that's showing on your report.
When pulling up reports in QuickBooks Desktop, make sure that the report period is correct. It's possible that date of the report that you've pulled up contains transactions for the old bank.
You can also open the balance of the bank to see the transaction detail of the amount. If those are unnecessary, you can delete them by clicking Ctrl+D and hit Enter.
Once verified and the problem continues, I'd recommend verifying and rebuilding your data. This can help fix data-related issues in the program like the once that you've experience.
To do that:
After that, let's verify the data:
For complete details about this process, please see this reference: Verify and Rebuild Data in QuickBooks Desktop.
I'm also adding here some links that can help you in managing and fixing reconciliation issues:
I'll be right here to assist you if you need anything else with QuickBooks. Just leave a reply below, and I'll get back to you. Take care!
Depends if the report is designed to show account balances or detailed activity.
What is a "detailed summary report"? I've never heard a of a QuickBooks report with that name or description. How do you run the report?
Excuse me, balance sheet details report.
Thank you for responding. I tried rebuilding data per your first suggestion and it didn’t work. I’ll follow through with the other suggestions that you gave me and keep you posted on the results. Thanks!
Try setting the date filter to All dates...
Hi @CdSecretary
The balance sheet detail report will show the opening balance, activity, and ending balance for each account for the date range shown at the top of the report.
It should show the same ending balances for each account as the standard balance sheet (summary) report.
If you are seeing different balances, make sure the ending date on the balance sheet detail report matches the balance sheet summary report, and make sure they're both running on the same basis, either Cash or Accrual. (The basis appears at the top left corner of each report.)
Also, be sure you're comparing the account balance to the same date in the account register, not the ending balance there, if there are transactions after the balance sheet reports' dates.
I was on the phone with QB Pro Desktop this afternoon on another subject and asked about this problem. The specialist was able to direct me on what needed to be done to zero out the account that is no longer used. Thank you for your comments responding to my problem.
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