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

My client has uncleared transactions from last year, I'm not sure how to make those disappear from their bank rec screen.

I just started working with this person last Friday, I'm trying to clean things up for them which has proven to be super difficult. He has only done one bank rec. It was reconciled on 3/25/21 yet it includes transactions from late 2019, all the way through 2020, and ending around January 2021. When they reconciled everything zeroed out so I assume they did it correctly. Working on their next one, they tried to reconcile uncleared transactions starting on Feb. 2020 through 2020 to Feb 2021 and of course it didn't match and there was a huge difference since those couldn't be reconciled since they are uncleared. What do I do to fix this? I tried to create reverse journal entries which worked to clear the transactions from the bank rec screen but then that messed up the bank balance in quickbooks. Please help, they just want the charges that are uncleared to disappear. I just did his next reconciliation, and everything is still zeroing out so since were caught up and everything matches I'm not sure what to do to take care of these uncleared transactions. Thanks

4 Comments 4
Giovann_G
Moderator

My client has uncleared transactions from last year, I'm not sure how to make those disappear from their bank rec screen.

Welcome to the Community space, jaderoy.

 

I'm here to help you reconcile the account.

 

 The uncleared transactions were probably not matched correctly. If they're not reconciled, you can manually clear (C) them in the bank register.

 

Here's how:

 

1. Click Accounting on the left menu.

2. Select Chart of Accounts.

3. Locate the bank account and click View register from the Action column.

4. Identify the transaction to clear.

5. Under the reconcile status, click until C for cleared appear. You can select R if this already part of the previous reconciliation.

6. Hit Save.

 

For further guidance, you can read these articles:

 

Reply to this post if you have further questions about reconciliation. We're always here to help you. Take care and stay safe!

 

 

 

 

 

jaderoy
Level 1

My client has uncleared transactions from last year, I'm not sure how to make those disappear from their bank rec screen.

This is what I've been stuck on, I've manually cleared the transactions but they still show up. The past two reconciliations have all zeroed out according to the statement ending balance so I'm not sure why these are still here. Should I delete or void them? How would that affect things? The owner says it's okay to get rid of previous stuff but I personally don't like deleting transactions. Is it necessary in a case like this? 

MaryLandT
Moderator

My client has uncleared transactions from last year, I'm not sure how to make those disappear from their bank rec screen.

Thanks for getting back to us and for providing additional details about the uncleared transactions, jaderoy.

 

Yes, you can delete them. However, you need to make sure they aren't associated with any other transactions. 

 

Based on your screenshot, the expense falls in 2021. You need to verify the date range when reconciling your bank.

 

In addition to this, you need to compare each transaction from your bank with the ones entered into QuickBooks. If everything matches, here are the steps on how to reconcile your bank:

 

  1. In QuickBooks Online, select Settings ⚙ and then Reconcile. If you're reconciling for the very first time, select Get started to continue.
  2. From the Account ▼ drop-down, select the account you want to reconcile. Make sure it's the same one on your statement.
  3. Important: If you see a message about a previous reconciliation, select We can help you fix it. You need to fix this before you start.
  4. Review the Beginning balance. Make sure the beginning balance in QuickBooks matches the one on your statement. Here's what to do if they don't match.
  5. Enter the Ending balance and Ending date on your statement. Some banks call the ending balance a "new balance."
  6. If you see it, review the Last statement ending date. This is the end date of your last reconciliation. Your current bank statement should start the day after.
  7. When you're ready to start, select Start reconciling.

After reconciling the bank, you can run a report to review the work:

  1. Go to the Accounting menu and select Reconcile.
  2. Select History by account.
  3. Use the drop-down menus to select the account and date range.

You also have the option to print or export your reconciliation reports if you need to share them.

 

Stay in touch with me by commenting below if you have follow-up questions about this. I'll be around to help you.

scottkingenterprises
Level 1

My client has uncleared transactions from last year, I'm not sure how to make those disappear from their bank rec screen.

You're not an accountant.

 

A.) Read the entire question/answer thread.  You obviously didn't.

B.) Don't respond if you don't have the answer; which you most assuredly don't.

 

You clog up forums like this where REAL accountants and bookeepers are looking for real answers, not your rote, boilerplate data dump that you pasted from the contents glossary page.  

 

Now leave before you cause any more confusion.

Need to get in touch?

Contact us