Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
fsantel
Level 1

Q: How to remove account from balance sheet report? My personal checking was added to QB. All the transactions were excluded but still showing up on balance sheet. Txs!

 
1 Comment 1
Dandie_A
QuickBooks Team

Q: How to remove account from balance sheet report? My personal checking was added to QB. All the transactions were excluded but still showing up on balance sheet. Txs!

Hello there, fsantel.

 

QuickBooks Online (QBO) is currently unable to delete accounts from your Chart of Accounts. However, I'd be glad to show you how to make them inactive, which is similar to deleting them.

 

Before you make a balance sheet account inactive, ensure that its balance is zero. If not, QBO will create an automatic adjustment entry to zero out the balance, which posts to the Opening Balance Equity account. This could result in inaccurate tax filings.

 

Here's how to make an account inactive:

 

  1. Go to Settings and choose Chart of Accounts.
  2. Find the account you want to remove.
  3. Click the Action dropdown and select Make inactive.

 

Once done, you can remove the deleted accounts from your Balance Sheet report. I'll share the steps on how you can remove the inactive accounts from your Balance Sheet and another financial report.

 

 Here's how: 

 

  1. Click Reports tab.
  2. Click and search the Balance Sheet in the Typer report name here drop-down.
  3. Click Customize beside Switch to modern view in the upper right corner of the screen.
  4. Scroll down to Rows/Columns, then set Show non-zero or Active only to Non-zero.
  5. Choose Run report.

 

image (16).png

image (20).png

image (17).png

image (18).png

image (19).png

Additionally, you can import a spreadsheet of custom or existing accounts from another company file to your QBO account. This way, you may avoid having to enter them manually.

 

For further assistance, you might want to explore QuickBooks Live Expert Assisted , an additional service designed to help keep your business well-organized.

 

Fill me in if you have additional concerns about reports in QBO. I'll be with you to answer your questions. Stay safe!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us