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

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

 
Solved
Best answer September 15, 2023

Best Answers
QueenC
Moderator

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

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:

 

  1. Go to the Reports menu. 
  2. Scroll down to the Company & Financial section then select Balance Sheet Standard.
  3. Click on Customize Report


     
  4. Go to the Filters section then click on the All accounts dropdown button. 
  5. Click Multiple accounts then select the accounts you only want to show on the report.


     
  6. When done, select OK.


     
  7.  Hit OK once again to close the customization page.

 

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.

View solution in original post

BigRedConsulting
Community Champion

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

@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.

View solution in original post

5 Comments 5
QueenC
Moderator

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

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:

 

  1. Go to the Reports menu. 
  2. Scroll down to the Company & Financial section then select Balance Sheet Standard.
  3. Click on Customize Report


     
  4. Go to the Filters section then click on the All accounts dropdown button. 
  5. Click Multiple accounts then select the accounts you only want to show on the report.


     
  6. When done, select OK.


     
  7.  Hit OK once again to close the customization page.

 

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
Level 2

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

That does it, thanks!

Mich_S
QuickBooks Team

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

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!

 

BigRedConsulting
Community Champion

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

@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.

OnTrack Team
Level 4

I'm using Quickbooks Premier Plus Edition 2023. When I run my balance sheet I see bank account balances that are no longer current or being used. How can I remove these?

@BigRedConsulting,

 

Re: It's rather unwise advise

 

Shouldn't we 'Report Inappropriate Content' on replies like these?

(If it only helped...)

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us