Question

How do I correct uncleared transactions in the reconciliation report. Many of these transactions have cleared yet must have had double entries.

Forum|Forum|7 years ago
February 5, 2019
5 replies
18 views

No text available

QuickBooks Online

Level 2

While duplicate transactions do occur, it is also possible that transactions were not "matched" properly within the bank feed before adding them to the account register. If there is no green square under the "C" (Cleared) reference in your check register the transaction has not been "matched" within the bank feed to a manually entered transaction. You can "undo" the "Add" of transactions that were not properly matched and find the match and Add them back.

M

minie123

I like your solution of this problem but, what if reconciliation is done already, still can go to Undo from REVIEWED and change it and ADD them back?

Thanks

M

minie123

Thanks for providing the detailed information, minie123.

You'll need to delete the Cleared (C) transfer transaction if it is a duplicate of the Reconciled (R) one.

Click Accounting on the left menu and select the Chart of Accounts tab.
Look for the bank account and click View register.
Select the Cleared (C) transfer transaction.
Click Delete and choose Yes to confirm the action.

I'd also recommend seeking professional advice from your accountant about this. They'll be able to provide an option that suits your company setup.

You can always get back to us if you have follow-up questions.

Thank you. I am definitely going to see an professional accountant.

But for this situation, If I delete R transaction or C transaction which are duplicate, it is going to change beginning balance, correct?

So, is better to keep it till get help.

Thank you for your time.

C

cfwnole

I'm bad & wasn't reconciling each month; therefore I have transactions

from March let's say, not cleared until April.

As me accountant will be swamped, how do I fix this, especially since I know it's cleared? Then I can finally get on with it? TY!!

Lily_Kristine

Moderator

Welcome back to the Community, @cfwnole.

I'd like to share some insights about clearing the transactions from the previous month.

If these transactions weren't reconciled yet, you can go to your bank register and manually clear the transactions from there. Otherwise, you may need to undo it before you proceed with this month's reconciliation.

Here's how to manually clear bank transactions in QuickBooks:

Go to the Gear icon, then choose Chart of Accounts.
Locate the account of the transaction.
Select View Register from the Action column.
Identify the transaction to clear.
Under the reconcile status column, select C for Cleared. You can also manually reconcile by selecting R or you can leave it as blank if they aren't cleared or reconciled.
Select Save.

For other reconciliation resources you can check, please click this guide: Learn the reconcile workflow in QuickBooks.

Should you have any additional questions or concerns, the Community will have you covered. Thanks for reaching out, best wishes.

C

christianallen

Hi IntuitLily,

This was super helpful, however I am still stuck. When I reconcile, I have a long list of transactions that are listed as uncleared, however we do not manually add any transactions in QB, everything comes in via bank feeds. Additionally, I followed your instructions and went to the relevant account's register and found a couple of transactions that are listed as "uncleared" on the Reconciliation Report and they are listed as "cleared" in the account register. Any thoughts?

Thanks!

P

PerfCarBuilder

I have a question.....I have debits out there from 2019 sitting in my bank reconciliation. I just need to get rid of them. Is making a journal entry the only way as I don't want to mess up my books from last year. Thanks for any help!!

MaryLandT

Level 10

Thanks for joining this thread, PerfCarBuilder,

You'll want to delete uncleared transactions from your bank if those are duplicates. It will help clear those transactions on your bank reconciliation page.

Let me show you how:

Click Accounting from the left navigation bar, then Chart of Accounts.
Look for the bank account, then click View register.
Locate the transaction, then open it.
Click Delete and choose Yes to confirm the action.

You can also create a journal entry to clear them. However, I highly suggest consulting your accountant for advice about this process. He/she will can provide an option that suits your company setup.

Feel free to leave a comment below if you have follow-up questions. I'm always glad to help.

P

PerfCarBuilder

Last year is closed. I can not get into last year and delete things without changing my year end Cost of Goods Sold (which is what these were mostly categorized as) numbers. Those debits and credits were considered at year end 2019.

D

Djay0542

I am having problems with duplicates.

reconciliation should show one check entry for each check. Severera are showing the original entry twice?

A

AileneA

Moderator

Hello, Djay0542.

Let's isolate this case by perform basic browser troubleshooting by clearing the cache to fix the issue.

There are times that the browser is full of frequently accessed page resources, causing some unusual responses. We can start by accessing your account in a private browser. This mode doesn't save your searches, visited pages, log-in details, and cookies.

You can use the shortcut keys that I've listed below.

Ctrl + Shift + P (Firefox)
Command + Shift + N (Safari)
Ctrl+ Shift + N (Google Chrome

If it works, then you can go back to your original browser and clear the cache. Alternatively, you can use other compatible browsers. It could be that the one you're currently working on has a temporary issue with QuickBooks.

Here's a step-by-step guide in reconciling your account in QuickBooks Online: Reconcile an account in QuickBooks Online.

Also, learn what to do if your account in QuickBooks Online doesn't match your bank statement at the end of reconciliation: Fix issues when you're reconciling accounts in QuickBooks Online.

Feel free to ask questions if you need clarification. I'll be happy to assist you further. have a great day and stay safe!

S

Sllopez

jumping in on this conversation, but with a twist. My client just migrated from desktop to online yesterday. She just hired me to clean-up. We have uncleared transactions (29K) dating back to 2015! Yet, she says they have no bills outstanding, no old invoices outstanding & she is all reconciled. There are just all these unreconciled transactions (she assumes are all mis-entered duplicates from manual entries). Can I just get rid of them? There's no way I can try to figure out undoing & recreating? PLEASE HELP!!

DivinaMercy_N

Moderator

Hello there, @Sllopez. I got here steps to ensure you'll fix the uncleared transactions in the reconciliation report after the migration.

When migrating the data from QuickBooks Desktop (QBDT) to QuickBooks Online (IQBO), certain features, information, and transactions don't migrate and may create changes in your books. To know more, check this article: Learn how features and data move from QuickBooks Desktop to QuickBooks Online.

In your QBO account, you can clear the transactions manually in the bank registers. Before doing this, I highly recommend consulting your accounting professional to further review and guide you with the best possible method in clearing these items. This will help us ensure your books are accurate since these are old entries from previous years.

You can also run reports to view your previous reconciliation in QBO. This will show you the beginning and ending balances of the account as well as those cleared and uncleared transactions.

If you have other concerns about managing your account, please don't hesitate to leave a reply below. Have a great week ahead, and stay safe.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded