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

Uncleared checks and deposits

Hello, I'm new at working with QB Online and I reconciled for 2018. I show a $0 difference, but I still have uncleared deposits and checks. What do I need to do in order to check them off my list? Will these uncleared items affect my overall P&L?

Solved
Best answer January 18, 2019

Best Answers
Rose-A
Moderator

Uncleared checks and deposits

Thanks for dropping by, Cavecloth.

I can share with you some information about uncleared deposits and checks in QuickBooks Online.

 

The uncleared deposits and checks in QuickBooks Online are not yet cleared in your bank, so you can leave those transactions as is. You can filter the reconciliation page to show the cleared transactions only.

 

Transactions that are cleared and uncleared will not affect your P&L since the report is accrual/cash basis.

 

You can check these articles for more insights about reconciliation:

 

If you need help with QuickBooks in the future, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

 

Should you need anything else, don't hesitate to fill me in. Have a nice day.

View solution in original post

Malcolm Ziman
Level 10

Uncleared checks and deposits


@Rose-A wrote:

 

 

Transactions that are cleared and uncleared will not affect your P&L since the report is accrual/cash basis.

 


It should be mentioned that this would depend on how old the uncleared items.  If they are older than a week or 2 then they are probably errors.

the "accrual/cash basis" reference makes no sense 

View solution in original post

27 Comments 27
Rose-A
Moderator

Uncleared checks and deposits

Thanks for dropping by, Cavecloth.

I can share with you some information about uncleared deposits and checks in QuickBooks Online.

 

The uncleared deposits and checks in QuickBooks Online are not yet cleared in your bank, so you can leave those transactions as is. You can filter the reconciliation page to show the cleared transactions only.

 

Transactions that are cleared and uncleared will not affect your P&L since the report is accrual/cash basis.

 

You can check these articles for more insights about reconciliation:

 

If you need help with QuickBooks in the future, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

 

Should you need anything else, don't hesitate to fill me in. Have a nice day.

Malcolm Ziman
Level 10

Uncleared checks and deposits


@Rose-A wrote:

 

 

Transactions that are cleared and uncleared will not affect your P&L since the report is accrual/cash basis.

 


It should be mentioned that this would depend on how old the uncleared items.  If they are older than a week or 2 then they are probably errors.

the "accrual/cash basis" reference makes no sense 

DeadWood
Level 2

Uncleared checks and deposits

I'm also having the same problem. However the transactions are from years back. Almost as if checks were written but then never used or voided. They've been hanging out there for YEARS. I'm unable to find them or pull a report listing only these. The only time I see them is when I'm reconciling the monthly bank account. Having to scroll down 20+ lines of useless transactions to get to the current date is bothersome. Especially if there is a resolution to remove them properly.

DeadWood
Level 2

Uncleared checks and deposits

Replacing the previous bookkeeper and I'm finding all these transactions when reconciling. These are years old and there are many of them.  As if the transactions were not used or voided, just ignored. They don't surface until I'm scrolling through 20+ of them to work the current reconciliation. I've tried several different ways of reporting and they all hide. I can't fix them while in reconciliation, but I can't find them otherwise. 

MaryLandT
Moderator

Uncleared checks and deposits

Hi there, @DeadWood,

 

You can delete those unused checks so they won't appear on your reconciliation page.

 

Let's first locate those checks from your Chart of Accounts, then delete them from there. It's easier to find them by customizing transactions using the Filter icon.

 

Here's how:

  1. From the left menu, select Accounting, then Chart of Accounts.
  2. Open the account where checks are posted to.
  3. Click View register under the Action column.
  4. Click the Filter icon.
  5. Select Not Reconciled under the Reconcile Status drop-down list.
  6. Select Check under the Transaction Type drop-down list.
    filtericon.PNG
  7. Click Apply.
  8. Click the check, then select Delete.

Upon sharing this suggestion, I still recommend consulting with an accountant first before making any changes on your account. He/she might have specific instructions on how to handle these transactions.

 

I've also added this article to learn more about bank reconciliation: How to Reconcile an Account in QuickBooks Online.

 

Upon sharing this suggestion, I still recommend consulting with an accountant first before making any changes on your account. He/she might have specific instructions on how to handle these transactions.

 

Drop me a line if you have follow-up questions about the solution above and I'll get back to you.

JP2016
Level 1

Uncleared checks and deposits

Hi Deadwood,

 

I am experiencing this same issue. Uncleared checks/payments from months ago that are not duplicate transactions. I am unsure how to resolve and every time I call QB's support they can not figure it out either. Have you found a solution? Thanks.

David-212915
QuickBooks Team

Uncleared checks and deposits

It's nice to have you in the thread, @JP2016

 

Since you've confirmed that the transactions aren't duplicates and haven't cleared, they will appear on the screen until they are marked as reconciled. However, I'd recommend double-checking these transactions to ensure that they haven't cleared your financial institution. While a vendor may not immediately cash a check, one would expect it to be cashed within the stated time frame.

 

I'm including an article on customizing a report to see uncleared checks to make this process easier: Run a report of uncleared checks.

 

Please feel free to let me know what you find by commenting below. Have a great day.

 

ajlitt
Level 1

Uncleared checks and deposits

Having a related issue.  We moved from QB Desktop to Online and ran our first reconciliation report just for the month of January 2020 since QB was up to date through 12/31/2019.  However, the reconciliation included the entire history of transactions sitting in the QB import.  We correctly reconciled January to a $0 amount.  But the reconciliation report now shows all of the transactions from before Jan 1, 2020 as uncleared.  This is causing the register balance as of 1/31/2020 to be off from the amount it should be.  It should be lower by the amount of uncleared checks and deposits from January ONLY, not all the ones from prior periods.  Is there a way to fix this?  

GraceC
QuickBooks Team

Uncleared checks and deposits

Hello there, @ajlitt.

 

Let me provide some information about uncleared transactions in QuickBooks Online.

 

When you say you're having trouble reconciling, are you referring to your opening balance? If so, once you've unreconciled transactions from previous periods that have appeared on your bank statement but your opening balance matches, possible is, there are transactions that have already been accounted for (duplicated and marked with an R).

 

To resolve this, you'll need to identify the transactions by following the steps in this article: Troubleshoot reconciles when the opening balance is correct

 

If you're referring to something else, any details you can provide is extremely helpful for us to narrow things down. 

 

For additional reference, you can check this article: How to fix differences between QuickBooks balance and bank balance.

 

Drop your comment below if you have any have any other questions and concerns. Have a good day!

ajlitt
Level 1

Uncleared checks and deposits

Thank you for getting back to me :).

 

The problem is that the now finished reconciliation report shows uncleared deposits and uncleared payments for our entire history (back to 2005).  We were only trying to reconcile January 2020 since our books were up to date in QB Desktop through 12/31/2019.  When we synced the bank statements, we only pulled transactions as early as 1/1/2020.   I don't know why all of the QB transactions prior to 1/1/2020 were included in the reconciliation report.   Now the line item at the top of the Reconciliation Report, "Uncleared transactions as of 1/31/2020) is off by a material amount.  I need to know how to change this number to reflect reality, as the register balance on the Report is now overstated.  I hope I've explained the issue better.  Thanks again! 

Charies_M
Moderator

Uncleared checks and deposits

Thanks for clarifying this with us, ajlitt.

 

Once you connect your bank to QuickBooks Online (QBO), it automatically pull up 90 days of transactions. Thus, transactions prior to January 2020 will be included. This is the reason why it's showing an incorrect balance amount on your Reconciliation Report.

 

In this case, it's best to get in touch with your accountant as they have the special tools to help you clear those transactions and assist you with the whole reconciliation process.

 

Drop a comment below if you need more help or other questions. It's always my pleasure to assist. Have a great day ahead.

Lindsey B
Level 1

Uncleared checks and deposits

I am having an issue where we have some outstanding items from 2014 that do match online banking but were never reconciled.  They continue to show as outstanding each month and I would like to clear them up.  I did not prepare the reconciliations until 2018, and it appears that one big reconciliation was done from 2012-2015.  Is there a way to fix this?  They show as a C in the register, but if I attempt to change to an R it messes up my beginning balance for the next months reconciliation..

IntuitLily
Moderator

Uncleared checks and deposits

Thank you for providing the details of your outstanding transactions, @Lindsey B.

 

You can create a journal to write off the amount of your outstanding transactions in QuickBooks. However, you'll need to consult your accountant first before trying out this option to ensure if this is the best practice for your business.

 

Here's how you can write off the amount for Accounts Receivable:

 

  1. Create a journal entry.
  2. Change the date and fill in the entry number if necessary.
  3. For customers with an over-payment, select the  Account field and choose Accounts Receivable from the drop-down list.
  4. Enter the amount under the Debit column, tab to the Name column and select a Customer Name from the drop-down list.
  5. In the next line, select the offset account and enter the amount under the Credit column. The offset account is usually an Expense account.
  6. For customers with an underpayment, select the Account field and choose Accounts Receivable.
  7. Enter the amount under the Credit column, tab to the Name column and select a Customer Name from the drop-down list.
  8. In the next line, select the offset account and enter the amount under the Debit column.
  9. Once done, select Save & Close.

Once done, apply the JE to the existing credit/debit by following the steps below:

 

  1. Go to the Plus icon and select Receive payment.
  2. Enter the name of the customer in the Customer field.
  3. Select the JE created in the Outstanding Transactions.
  4. Under the Credits section, select the available credit and select Save and close.

 

For Accounts Payable, here's how:

 

  1. Create another JE.
  2. For vendor with over-payment, select the Account field and choose Accounts Payable from the drop-down list.
  3. Enter the amount under the Credit column, tab to the Name column and select the vendor name from the drop-down list.
  4. In the next line, select the offset account and enter the amount under the Debit column.
  5. For vendor with underpayment, select the Account field and choose Accounts Payable from the drop-down list.
  6. Enter the amount under the Debit column, tab to the Name column and select the vendor name from the drop-down list.
  7. In the next line, select the offset account and enter the amount under the Credit column.
  8. Select Save & Close.

Then, apply the journal entry to the existing debit/credit.

 

  1. Go to the Plus icon and select Pay Bills.
  2. Select the bill and choose Make payment.
  3. This will automatically apply to the outstanding bill and JE created.
  4. Click Save and close.

 

I'm always here if you need further help with this process. Take care and have a nice day!

trcddc1990
Level 1

Uncleared checks and deposits

How can we remove customer payments and deposits that show in our uncleared payments and deposits report?  When we reconcile the bank statements we are seeing lots of items that have not cleared the bank. Upon investigation we have found a mixture of duplicates and erroneous payments and deposits that we put into quickbooks but there was never a customer job nor real customer, how can we get rid of these and off the books.

AileneA
QuickBooks Team

Uncleared checks and deposits

Thank you for reaching out to the Community. I'm here to help you sort this out, @trcddc1990.. 

   

In QuickBooks Online, the transactions are downloaded automatically from your bank. We can exclude and delete the duplicate transactions to correct it.  

 

 

I'll guide you on how to Exclude the Transactions:  

 

  1. From Banking, select the specific bank, and then under For Review tab. 
  2. Tick the transactions you want to exclude, then under Batch actions then drop-down arrow and then Exclude selected. 
  3. Select the Excluded tab and checkbox the transactions you want to delete.
  4. From Batch actions drop-down and select Delete.  
  5. A message will pop up asking Are you sure? These transactions will not be recoverable, and then Select Yes.  

   

 

 

 

 

 

 

 

 

 

 

Once transactions excluded, these items are no longer reported as part of your business finances and will not appear in any associated account registers or reports.  

 

 

I've got a great article for you that provides additional details on excluding transactions. You can view it by clicking this link: How to exclude expenses from downloaded bank transactions.  

 

 

That's it. This should help you point in the right direction. Let me know if you have further questions. I'll be here to answer them. Have a great day!

  

cathymarietta99
Level 2

Uncleared checks and deposits

I have this same issue.  the deposits are showing up on the reconciled statement but they're still here!!!

cathymarietta99
Level 2

Uncleared checks and deposits

How is this happening...the issue is 2 accounts receivable payments that are showing up unreconciled!!

FritzF
Moderator

Uncleared checks and deposits

Thanks for joining this conversation, @cathymarietta99.

 

If the two accounts receivables are still uncleared, so you can leave those transactions as is as mentioned by my colleague above. However, if they're already cleared or reconciled by still showing, I highly suggest contacting our Support team. They have tools that can pull up your account in a secure environment and investigate this further. They can also perform some troubleshooting steps to fix this for you.

 

Here's how to reach them:

 

  1. In QuickBooks Online (QBO), click the Help (question mark) icon at the top right.
  2. Select Contact Us at the bottom to connect with our live support.

 

Just in case, I'll add these articles for future reference:

 

 

Please let me know how it goes or if you have any other issues or concerns. I want to make sure everything is taken care of for you. I'm always here to help. Have a great day!

easybookkeeping123
Level 2

Uncleared checks and deposits

Hi, 

 

I am having the same issue. However, while the deposit made show cleared, the received payments are showing not cleared. The date for deposit and received payment are the same. I see on the bank statement that this deposit has been cleared as well. This is causing my bank actual balance vs. QBO bank balance to be incorrect.

 

For example: 

On 3/27/2020 - a deposit made in the amount of $3800.00 This deposit consists of various invoices (see below)

inv#1 - recev'd payment $2400.00

inv#2 - recev'd payment $800

inv#3 - recev'd payment $350

inv#4 - recev'd payment $250

 

What do I have to do to clear the received payments? 

Thank you

 

JenoP
Moderator

Uncleared checks and deposits

Thanks for joining us here, easybookkeeping123.

 

You can manually clear these transactions in your bank register. Here's how: 

 

  1. Open the bank register and look for these transactions.
  2. Select a payment and click on it.
  3. Go to the Reconcile and Banking Status column, then click the space or box underneath it until the C status appears. 
  4. Click Save

Let me also share these articles to share more details:

 

The Community is always here if you need anything else. 

orthosolutionsok
Level 2

Uncleared checks and deposits

I have uncleared check and payments and uncleared deposits that are more than a year old. Those are obviously errors, but... How do fix them?

LieraMarie_A
QuickBooks Team

Uncleared checks and deposits

I'm glad to see you here in the Community, @orthosolutionsok.

 

You'll need to mark these transactions as "C" to clear them again in your bank register. You can follow the steps provided by my colleague, @JenoP, to fix the uncleared in register.

 

Before doing the steps, 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.

 

I've added an article for more information about reconciling an account for months or year-old transactions: Reconcile.

 

Let me know in the comment section if you need further assistance. Have a good one.

norm22
Level 1

Uncleared checks and deposits

I also see numerous items that are uncleared transactions after successfully reconciling the bank account. I have looked at some of the suggestions to clear these, but here is my question. Is there a way to do this on a backup copy of the books, in case my changes don't work as I had planned? Thanks

JenoP
Moderator

Uncleared checks and deposits

Thanks for joining us here, norm22.

 

We're unable to create a local backup copy of your data in QuickBooks Online. This means that there's no option to clear or changed a transaction's reconciliation status in a backup copy of your books.

 

You'll want to reach out to your accountant before making any changes to make sure that your bank account is reconciled properly. 

 

You can also reach out to our chat or phone support while clearing the transactions so they can guide you through. Here's how:

 

  1. Go to the Help menu and click Contact us.
  2. If you can't see the Contact us button, type in something in the search bar.
  3. Click Start messaging or Get a callback.

Let me know if you need anything else. 

Need to get in touch?

Contact us