Skip to main content
E
exetergirlssocce
April 28, 2024
Question

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

  • April 28, 2024
  • 1 reply
  • 0 views
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.

1 reply

Bryan_M
Bryan_M
April 28, 2024

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.

E
exetergirlssocceAuthor
May 11, 2024

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!

 

A
Aldren18
May 11, 2024

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.

Terms & ConditionsAccessibility statement