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

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

Question to all:

Is it a better option to buy the VIP self guided course or the 2 day training for a newbie?

My husband uses quickbooks for his company and I am going to learn quickbooks to do the work.

In the 2 day online course, does quickbooks cover reconciling a bank account?

 

One issue I see now is, I ran his missing checks report and it is huge, items on there from 2016,2017,2018,2019

Your advice would be appreciated,

Thanks, Maria

RaymondJayO
Moderator

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

Welcome to the Community, @Mnews. Thank you for your interest in learning more QuickBooks Online (QBO), so you're able to manage your husband's company. We're unable to provide the better option for you. But I'd be delighted to share the benefits regarding them.

 

With the VIP self-paced course, you'll have unlimited access to our training library, email support, and weekly Q & A sessions. This way, you'll get the best QuickBooks support in the world. You can also look for the other self-paced QBO courses here

 

For the 2-day online class, yes, it'll cover the bank reconciliation. Your dedicated trainer will discuss this when you go to the "Accounting tasks & concepts you must know" topic. There are available dates for this, and you'll want to check them out through this article: Upcoming QBO Classes. See the screenshot below for your visual reference. 

 

Once you've chosen the right course for you, you can now resolve the items on the missing checks report. Just start from the oldest year (2016) until 2019. I also recommend consulting your accountant for further assistance regarding this. They can help you ensure your husband's historical books are accurate. 

 

Lastly, I recommend visiting this Community article: Reconcile Workflow. It contains in-depth details about starting, fixing any difference, and completing the reconciliation process. 

 

You can tag my name (@RaymondJayO) if you have any other concerns. I'm cheering on you and your husband's continued prosperity while using QuickBooks, @Mnews.

christianallen
Level 1

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

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!

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.

Thanks for joining us in this thread, christianallen.

 

Transactions added from the bank feeds will be listed as Cleared in both register and reconcile page. Here's a sample screenshot for reference:

 

 

To fix this, we can try to close the reconciliation page by clicking the drop-down arrow next to Save for later and selecting Close without saving. Doing this will reset all the transactions to the original state. 

 

 

Once done, enter the Ending balance and Ending date again. Then, check if you see the cleared transactions.

 

Otherwise, we can do some troubleshooting steps to rule out any browser-related issues. Open your company in an incognito or private browser. This mode will not save any browsing history.

 

Here are the keyboard shortcuts: 

  • Google Chrome: Ctrl Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Safari: Command Option P

Go back to the Reconcile page. If you see the cleared transactions, open your regular browser again and clear its cache. Please make sure to close and re-open your browser afterwards. Alternatively, try using a different supported browser.

 

Please let me know how it goes or if you have other concerns. I'll be around to help some more. Take care.

christianallen
Level 1

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

Hi renjolynC,

 

Thanks for that super helpful post complete with screenshots!  Neither idea cleared the issue.  Any other ideas?


Thanks,
Christian

MaryLurleenM
Moderator

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

I appreciate you following the steps provided, christianallen.

 

Since none of those worked, let's contact QuickBooks Online support. We will be able to check your account further and see what's causing the error. We can perform a share screen to review your account and figure a way to resolve this.

  1. On your QBO account, click on Help.
  2. Select Contact Us.
  3. Type reconcile error, then click Let's talk.
  4. Select Start messaging.

You might want to check out this article that has detailed steps on how to reconcile and how to resolve errors while reconciling: Reconcile an account in QuickBooks Online.

 

I'll be right here if you have other questions.

Anonymous
Not applicable

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

My client entered transactions directly in the check register. Consequently, the transactions coming though the bank feed are not finding a match. How can I reconcile this?

Rasa-LilaM
QuickBooks Team

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

Thanks for following up on this thread, My Priority.


There are several reasons why QuickBooks may not recognize a match. Check out the list below.

 

  • The data is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank and was recorded in a different bank account
  • The entry from the bank is a payment/ deposit of two or more open transactions in QuickBooks. 

Since the entries were entered directly into the register, let’s verify that they're not matched to another downloaded transaction or have been reconciled. I can help show the steps.

 

  1. Tap the Accounting menu on the left panel to select Chart of Accounts.
  2. Click the View Register link for the bank.
  3. From the list, look for the transactions you’re working on.
  4. In the Checkmark column, there will be two green squares (R) if they've been matched.manual R.png

If they’re already reconciled, exclude them to avoid duplication. Here’s how:

 

  1. On the left panel, choose the Banking menu to select Banking.
  2. Then, go to the For Review tab for the account you’re working on.
  3. Tick the boxes for the entries you want to remove and hit the Exclude the button.exclude qbo.pngexclude new qbo.png

However, if they’re yet not reconciled, I recommend following the suggestions in this article: Tips for Working in QuickBooks Online’s Bank Feeds.


For additional resources, the following guide covers all the details on how to classify downloaded entries and reconcile them.

 

If you have any clarifications or other questions, click the Reply button and post a comment. I’ll get back to answer them for you.

Djay0542
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 am having problems with duplicates.

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

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

jshootan
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 am unsure how to clear the unreconciled line items in my chart of accounts.  I have reconciled the banking account but i have a number of items that are just sitting in the chart of accounts that are making my total of my account look higher.  They are transactions from the undeposited funds that came in from Clover.  Can anyone help with this????

elholland
Level 1

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

How would you correct the transactions that are "added" as opposed to matched within quickbooks?

QueenC
Moderator

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

You've come to the right place, @elholland.

 

In QuickBooks Online (QBO), transactions may tend not to find a  match due to the following reasons:

 

  • The payees, amounts, and dates don't match
  • The transaction is older than 6 months
  • The bank account on the payment is not the same as the bank where the match is located
  • The payment has been reconciled
  • The transaction is already matched to something else
  • There's a multicurrency issue with the exchange rates, or the transaction doesn't pass through the home currency at some point.

 

To be able to find a match to the transaction, please follow these steps.

 

  1. Go to the Banking page, and select Transactions.
  2. Select the tile for the account you want to review.
  3. Select the For review tab to start your review.
  4. Find the added transaction with the Match option. Note the Date, Descripton, Payee, and amount spent or received.
  5. Review the Matching records found since this is the possible matching transaction you already entered in QuickBooks.
  6. Select the link next to each match to get more details.
  7. Make sure this is the correct match. In particular, review the Deposit to, Payment method, and Bank account fields on forms for the existing transactions in QuickBooks.
  8. If this is the correct match, close the open transaction and select Match.

 

Also, you can consider creating a bank rule to speed up the review process since it automatically categorizes transactions from your bank.

 

Additionally, here's an article that'll help you in case you need to change or move transactions to a different account: Unmatch downloaded bank transactions or move them to another account.

 

Should you have any additional queries with regard to bank transactions in QuickBooks Online, please feel free to tag my name in the comment section. I'm always available to assist you further. Have a great day!

tnich1960
Level 1

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

If you delete an unnecessary or duplicated entry from bank register and it was not cleared during reconciling will it affect the beginning or ending balance of the next month?

Kevin_C
QuickBooks Team

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

Thanks for chiming in on this thread, tnich1960. I'd like to provide details about deleting a transaction during reconciling your accounts in QuickBooks Online (QBO).

 

If you're currently reconciling your bank account and the duplicated transaction is already in the previous or current month, then it will not affect the ending balance of the current month and the beginning balance of the following month.

 

However, it will affect the ending balance of the month and the beginning balance of the following month if the transaction's date of the duplicated entry is within the next month.

 

Furthermore, check out this article to learn more about how you can effectively manage your income, expenses, and any possible errors accordingly: Learn the reconcile workflow in QuickBooks.

 

Keep me posted if you still have questions or concerns with managing your bank transactions QBO. I'll be here to lend a helping hand. Have a great day ahead!

Sllopez
Level 2

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

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

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

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.

Bkimnot
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 read through these comments and I'm having the same problem. I reconciled the account with zero difference and there's an ending balance that matches the bank account. When I go to reconcile the next month, the ending balance of the previous month which should be the new beginning balance is changed. I've tried everything even going back to the first month when I opened the account and it always gets stuck in the same month, April 2023. I've talked to the help desk multiple times and was supposed to meet with one of their bookkeepers this morning, but no one has called.  Has anyone had this problem of shifting ending and beginning balances?

ArielI
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 @Bkimnot

 

There may be someone who gets the same experience as what you have.

 

I can share some insights to correct shifting ending and beginning balance. There might have been changes added to your bank register recently. To rectify this, you'll want to check your bank statement and the transactions you've entered recently. See this article for the complete guide: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Meanwhile, I suggest contacting our QuickBooks Live Bookkeepers through your account since one of our bookkeepers wasn't able to contact you. Here are the steps:

 

  1. While reconciling an account, select Edit info from the Reconciliation window.
  2. Examine the Ending balance and date.
  3. Review your bank statements. Make changes as necessary.
  4. When finished, click Save.

 

For more of the other fixes issues and detailed information, refer to this article: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If the error still persists, you can chat with a product expert through QuickBooks Live Bookkeeping:

 

  1. Sign in to QuickBooks.
  2. Click Live Bookkeeping.
  3. In Live Bookkeeping, select Send a message.
  4. Connect with a QuickBooks expert for questions or bookkeeper assistance. Speak to a QuickBooks expert or reach your bookkeeper.

 

I've provided this resource to assist you with the things required to accomplish them: QuickBooks Online year-end guide and checklist.

 

For future help, you can open this link: QuickBooks Online year-end guide and checklist.

 

If you need any further assistance, please feel free to leave a comment, and we will get back to you as soon as possible. Take care!

SLC10
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 don't have the accounting option in the menu on the left.

 

My question other than that is - if a transaction is cleared, do I need to change the C to an R.  

 

Dazed and Confused!!!

MAnneJ
QuickBooks Team

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

I can guide you through viewing your account register and managing your reconciliation in QuickBooks Online (QBO), @SLC10

 

Due to product updates and enhancements, viewing your account register can be possible directly through your Chart of Accounts.

 

Here's how: 

 

  1. Click the Gear icon.
  2. Select Chart of accounts under Your Company.

Please check the screenshot attached below for your visual reference. 



maj.png

If you see the "C" (cleared) status, there's no need to switch it to "R" (reconciled) unless you're adding the item to the reconciliation. 

 

Also, you'll want to check this article for your reference if you encounter any discrepancy at the end of reconciliation: Enter an adjusting entry for reconciliation in QBO.

 

Please reply to this thread for further reconciliation and any QBO-related queries. I'll be here, 24/7.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us