cancel
Showing results for 
Search instead for 
Did you mean: 
tim14
Level 1

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

 
45 Comments 45
Regina_Lend_A_Hand_Accounting
Level 9

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

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.

minie123
Level 2

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

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

Catherine_B
QuickBooks Team

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

Hi minie123, 

 

If these transactions are relevant yet uncleared, you'll have to wait until it will get cleared from the bank. You'll include this transaction on when it was cleared from the bank. On the other hand, if it is a duplicate or unnecessary, you can delete it the bank's register. 

 

You can read through this article for more details in troubleshooting reconciliations: 

Reach out to me if you have other questions. 

minie123
Level 2

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

Hello, 

Thanks for your help.

but my problem is still the same.

I had 2 transfers from checking account to credit card account, they were not matched, it was  I did UNDO  Add and Match them from credit card account. After that Credit Card account was nice and clear from Uncleared transfers but Checking Account had problems with beginning balance so I had to ''recreate deleted transfers'' , check them to reconcile status and got the same uncleared transfers back into Account register ( double-once as R and once as Blank).

What should I do?

 

minie123
Level 2

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

HMMM.... after I did all- Undo Add transfer from credit card banking, Match transfer instead ADD, I got new problem in checking account with beginning balance. So I had to '' recreate deleted transfer '' and manually change the Status to Reconcile. that got me to the problem where I have one transfer two times in register- one as C and one as R. 

Any solutions for this problem? 

 

Thank you

JamesDuanT
Moderator

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

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.

  1. Click Accounting on the left menu and select the Chart of Accounts tab.
  2. Look for the bank account and click View register.
  3. Select the Cleared (C) transfer transaction.
  4. 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.

minie123
Level 2

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

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.

AlexV
QuickBooks Team

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

Glad to hear from you again, minie123.

 

To answer your question, only if you delete the R transaction will change the beginning balance.I recommend deleting the C transaction only to avoid changes on your beginning balance.

 

We're always here if you have any questions about QuickBooks.

Regina_Lend_A_Hand_Accounting
Level 9

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

You can, but you will have to re-reconcile the period in which the transaction was undone.

Regina_Lend_A_Hand_Accounting
Level 9

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

Follow the order of operations. Undo the transactions in question. Transfer from the originating account to the receiving account, then match. Never Add a Transfer, transfers are always done via "Record Transfer" from originating side and then "Match" the transferred amount on the receiving side. Once you have fixed these transactions in the order of operation, re-reconcile each account to the month-end date of each impacted period, starting with the oldest month, this fixes your beginning balances. It is also not a good idea to manually re-create transactions that originally came through the bank feeds, nor is it advisable to delete transactions within the registers. You really need an Accountant to help you, as I suspect you have too many transactions in your account registers now and you have gotten yourself into a pickle with the transfers and adds.

minie123
Level 2

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

Exactly! I am totally last now...Today I am going to talk with an accountant, Thank you for your time.

kerriann
Level 1

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

YOU ARE NOT ALONE!!! I have uncleared stuff from 2016-17-18 sitting there that Im afraid to touch. I have no clue how to clean my books or my house apparently as Im sitting here pulling my hair out wondering wtf am I even trying to run a business. I may add I have been at this for 20 odd years and I m tired and when it comes to accountants and their lingo does not compute neither do their fees. Thank you as I now know I am not alone. 

Kerri 

info4ruth1
Level 2

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

I am in the same boat! 

RenjolynC
QuickBooks Team

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

Hello info4ruth1,

 

If you have duplicate transactions on the reconciliation page, you'll want to undo them if they're added from the Banking.

 

Here's how:

 

  1. Go to Banking > Reviewed tab.
  2. Find the transaction that shows duplicate in your reconciliation.
  3. Select the Undo link under the Action column.

Once done, you will see the transactions in the For Review section.

 

You can also follow the steps provided by my colleagues Catherine_B and JamesDuanT.

 

Please let us know how it goes. We're always available to help you some more. Thanks.

Regina_Lend_A_Hand_Accounting
Level 9

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

The duplicate transactions in the bank feed are typically a result on not "matching" transactions properly. An Accountant such as myself can easily help you fix this historical problem. My approach involves auditing the duplicate transactions, pushing back into the bank feed the transaction that should have been originally "matched" as opposed to directly "added". Sometimes the duplicates are the result of "adding" deposits directly within the bank feed as opposed to correctly "creating" deposits to "match" bank feed deposits as they come into the bank feed each day. These are common errors that I correct for clients daily.

caarin
Level 1

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

My duplicate transactions are a result of Bank Of America's Clearing account which is causing an issue in allocation.  I stopped using BOA 's clearing account in 2020 and pay all transactions directly from checking to credit card bank account.  Now my 2020 bank transactions are recorded and allocated properly however my 2019 P&L and BS have discrepancies as a result. I purchased QB online in January 2020 so my 2019 bank transactions from credit card were passed through the BOA clearing account which I paid by lump sum transactions from checking

 

katherinejoyceO
QuickBooks Team

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

Welcome to this conversation, @caarin. I can see that you've been allocating the transactions from BOA as lump-sum. 

 

To make sure that it will be reflected correctly on your financial reports (Profit and Loss and the Balance Shit), you'll need to allocate each of your 2019 transactions instead to match them with your checking account. 

 

If the credit card and the bank account you use to pay the credit card expense are connected in QuickBooks, you can record the payment by transferring the record. Here's how:

 

  1. In the Banking tab, select the account you need to transfer the payment from.
  2. Click the transaction, then choose the Record transfer radio button.
  3. In the Transfer account drop-down list, select the account you want to send the transaction to. Then, choose Record transfer.

 

Once done, match it with the new account. Here's how: 

  1. Click the Recognized tab, then locate the transaction.
  2. Under the Action column, click Match.

 

If you've manually recorded these transactions, follow the steps to record credit card payments

 

For future reference, read through this help article to help you customize company and financial reports.

 

Let me know if you have additional questions. We're always here to guide you. Stay safe. 

 

 

cfwnole
Level 1

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

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!!

IntuitLily
Moderator

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

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:

 

  1. Go to the Gear icon, then choose Chart of Accounts.
  2. Locate the account of the transaction.
  3. Select View Register from the Action column.
  4. Identify the transaction to clear.
  5. 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.
  6. 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.

PerfCarBuilder
Level 1

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

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
Moderator

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

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:

  1. Click Accounting from the left navigation bar, then Chart of Accounts.
  2. Look for the bank account, then click View register.
  3. Locate the transaction, then open it.
  4. 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.

PerfCarBuilder
Level 1

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

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.

Maybelle_S
QuickBooks Team

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

Hello there, @PerfCarBuilder.

 

Making changes to your closed book will mess up your reports. You can create a journal entry to reverse the transaction so it will remove for this year's reconciliation.

 

Also, I'd recommend reaching out to your accountant to help you further with this.

 

Check out this article for future reference: Year-end guide and checklist.

 

Please update me if you need further assistance with QuickBooks. I'm here to help.

Regina_Lend_A_Hand_Accounting
Level 9

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

Agreed. You should have an Accountant help you correct the prior year transactional accounting. It is not as simple as creating a journal entry to remove the un-reconciled transactions.

Need to get in touch?

Contact us