cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
JTofu
Level 3

Inactive bank account showing on Jan balance sheet, but not on Feb balance sheet - how to get rid of it.

Here's an overview of my situation:

1. I manually imported bank checking account transactions as my client hadn't connected bank feeds yet. 

2. Afterwards, I connected the bank checking account to the bank feeds in QBO. There are now 2 checking accounts in QBO - the same checking account: one manually created, the other automatically created via the bank feed connection. 

3. I deleted the manually important bank transactions and made the manually created bank account inactive. 

4. When running a balance sheet report for January, the inactive, manually created bank account shows up with "(deleted)" next to it with a balance of $8,259.38.

5. Running a balance sheet for February does not show the deleted/inactive account.

6. The Opening Balance Equity account shows:

 

DateTypePayee AcctIncreaseDecreaseBalance
02/07 CheckChase (deleted) $8,259.38$8,259.38
01/01DepositBUS CHK$8,259.38 $16, 518.76
01/01DepositChase (deleted)$8,259.38 $8,259.38

 

Question: How do I get the deleted account from showing up in the January balance sheet? Is it because I didn't move out the opening balance to retained earnings? This is for an S-corp. Thank you.

3 Comments 3
MorganB
Content Leader

Inactive bank account showing on Jan balance sheet, but not on Feb balance sheet - how to get rid of it.

Hey there, JTofu.

 

Thanks for turning to the Community for support. I'm happy to provide some info about removing the inactive account from your balance sheet in QuickBooks Online.

 

Good news is that this can be done in just a few steps. Here's how:

 

1. Go to Reports.
2. Open the report you want to view and edit.
3. Select General options.
4. Select the Show non-zero or active dropdown, then select Non-zero.

 

The following article provides additional info about removing deleted accounts from reports in QuickBooks Online.

 

Please drop a comment below if you have any other questions. I'll be here to lend a hand.

JTofu
Level 3

Inactive bank account showing on Jan balance sheet, but not on Feb balance sheet - how to get rid of it.

Hi Morgan,

 

Thanks for your response. I tried another step that seems to have worked. Could you check if this is acceptable?

 

I saw the date for the check automatically created by QBO to zero out the manually created bank account was dated for 02/07. So I reactivated the account, changed the date of the check to 1/31, then deactivated it again. Now it doesn't show in the January reports. Is this a viable alternative?

 

Thanks.

Candice C
QuickBooks Team

Inactive bank account showing on Jan balance sheet, but not on Feb balance sheet - how to get rid of it.

Good evening, @JTofu

 

Thanks for coming back and giving us some additional details. 

 

Yes, this should be acceptable. However, please make sure with your accountant that changing the date was right for you business. 

 

Feel free to reach back out if you have any other questions. Have a great day! 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us