Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
Hello there, @a1pilot. I'd be glad to assist you in running the Balance Sheet report in QuickBooks Desktop and getting rid of the bank account balances that are no longer used.
The good thing about QuickBooks Desktop is it allows us to customize any report that we generate, keeping it focused on the desired information. We can customize the data being shown, add or delete columns, add or remove information on the header/footer, and even personalize the font style of the report.
With regard to running the Balance Sheet report, yes we can definitely filter it, not to show the bank account balances that are no longer used.
I'd be glad to include the process with some screenshots for you:
Additionally, should you want to save the same settings of your customized report for future use so you don't have to repeat the process again, feel free to check out this article I have for you: Create, access and modify memorized reports in QuickBooks Desktop.
If you have any further questions or need additional assistance in running reports and customizing them, please don't hesitate to reach out to our Community team. We're here to help you every step of the way. We value your business and look forward to providing you with a seamless experience as you continue to use our service. Have a great day.
@a1pilot RE: When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?
It's rather unwise advise to filter the Balance Sheet report and remove an account because then the report won't, um, balance. Which is the point of the Balance Sheet report.
If you have bank accounts on your chart of accounts that you no longer use/that don't exist anymore, and so that don't really have a balance, then your books aren't complete (or they'd match the 0.00 balance from the bank).
Apart from reconciling the accounts and fixing the details until they reach a 0.00 balance, you could make an entry in the bank register as of the last date you used the account to adjust the balance to 0.00, probably using an Equity account as the offsetting account.
Once you do that, then on the date after the final entry the account will disappear from the balance sheet.
Hello there, @a1pilot. I'd be glad to assist you in running the Balance Sheet report in QuickBooks Desktop and getting rid of the bank account balances that are no longer used.
The good thing about QuickBooks Desktop is it allows us to customize any report that we generate, keeping it focused on the desired information. We can customize the data being shown, add or delete columns, add or remove information on the header/footer, and even personalize the font style of the report.
With regard to running the Balance Sheet report, yes we can definitely filter it, not to show the bank account balances that are no longer used.
I'd be glad to include the process with some screenshots for you:
Additionally, should you want to save the same settings of your customized report for future use so you don't have to repeat the process again, feel free to check out this article I have for you: Create, access and modify memorized reports in QuickBooks Desktop.
If you have any further questions or need additional assistance in running reports and customizing them, please don't hesitate to reach out to our Community team. We're here to help you every step of the way. We value your business and look forward to providing you with a seamless experience as you continue to use our service. Have a great day.
That does it, thanks!
That's great to hear, @a1pilot. You're most welcome!
I'm glad my colleague's suggestion was successful in accurately presenting the information on your balance sheet.
You can always get back to us in case you have clarifications or need extra help managing QuickBooks. Have a great rest of the week and take care!
@a1pilot RE: When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?
It's rather unwise advise to filter the Balance Sheet report and remove an account because then the report won't, um, balance. Which is the point of the Balance Sheet report.
If you have bank accounts on your chart of accounts that you no longer use/that don't exist anymore, and so that don't really have a balance, then your books aren't complete (or they'd match the 0.00 balance from the bank).
Apart from reconciling the accounts and fixing the details until they reach a 0.00 balance, you could make an entry in the bank register as of the last date you used the account to adjust the balance to 0.00, probably using an Equity account as the offsetting account.
Once you do that, then on the date after the final entry the account will disappear from the balance sheet.
Re: It's rather unwise advise
Shouldn't we 'Report Inappropriate Content' on replies like these?
(If it only helped...)
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