Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

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.
exetergirlssocce
Level 1

Uncleared deposits showing up on reports. Account reconciled. I manually downloaded the txs, then likely bank feed did too. Then I Excluded and deleted to no avail

I excluded the transactions and then deleted them.  They are still showing up on my reports as uncleared.  They are mostly .01 cent interest transactions all in a montnly row for 6 months.  TIA.
4 Comments 4
Bryan_M
QuickBooks Team

Uncleared deposits showing up on reports. Account reconciled. I manually downloaded the txs, then likely bank feed did too. Then I Excluded and deleted to no avail

Good day, @exetergirlssocce.

 

I'll share some info about why excluded and deleted transactions are still showing in reports and help you stop them from showing there.

 

The excluded transactions don't appear in any account registers or financial reports. If it's deleted, and your bank is connected to QuickBooks, the system will see the transaction as not accounted for and will download the same transaction again from the bank.

 

For more info, you can read this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Also, you mentioned that the account was reconciled before it was excluded and deleted. To ensure that all transactions with the same details are reconciled, let's review to see if there are still duplicates. Then, exclude them to stop showing in reports.

 

After that, if you confirm that the transactions are being downloaded again. I recommend contacting your bank to check for issues or system maintenance and ask for a workaround.

 

You might want to categorize your transactions automatically. Check out this article: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

Feel free to come back here if you have additional questions about managing your bank transactions in reports. I'll be willing to help. Keep safe always.

exetergirlssocce
Level 1

Uncleared deposits showing up on reports. Account reconciled. I manually downloaded the txs, then likely bank feed did too. Then I Excluded and deleted to no avail

Could I "delete" the transactions by adding a credit to the account for each of the 7 transactions, calling the addition a correction to this error (the error being that I manually added the transactions) Then when the bank downloads the transactions, start over.  These 7 transactions are literally .01 or .02 transactions for interest earned.  Thank you so much!

 

Aldren18
QuickBooks Team

Uncleared deposits showing up on reports. Account reconciled. I manually downloaded the txs, then likely bank feed did too. Then I Excluded and deleted to no avail

I'll give you some information to clarify and provide further guidance in handling uncleared deposit transactions in your reports, @exetergirlssocce

 

When you accept or exclude a downloaded transaction, QuickBooks prevents the same bank entry from appearing in the bank feed again. However, if you delete the transaction instead of excluding it, the system will detect the discrepancy and download it again from the bank.

 

If you want to offset the interest earned, you can do so by creating a Journal Entry. I recommend consulting your accountant for guidance in offsetting the earned interest through a Journal Entry to ensure accurate financial records.

 

If you don't have an accountant, you can find one through this link: Find Pro Advisor.

 

Furthermore, I have a set of articles that can help you organize your transactions and reconcile your account. By doing so, you can classify your transactions correctly and prevent discrepancies in your books. Here are the links to the articles:

 

 

Continue to keep in touch with us if you need more assistance on how to handle uncleared deposit transactions in QuickBooks Online. We're always available to help out. Take care.

Rainflurry
Level 15

Uncleared deposits showing up on reports. Account reconciled. I manually downloaded the txs, then likely bank feed did too. Then I Excluded and deleted to no avail

@exetergirlssocce 

 

If your QB bank account is overstated, create an Expense transaction for the overstated amount.  Assign your Interest Income account to the expense transaction.  The next time you reconcile, clear the outstanding deposits against this expense and you should be all set. 

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

Need to get in touch?

Contact us