Skip to main content
J
jaderoy
April 14, 2021
Question

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

  • April 14, 2021
  • 1 reply
  • 0 views

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

1 reply

G
Giovann_G
April 14, 2021

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!

 

 

 

 

 

J
jaderoyAuthor
April 16, 2021

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
MaryLandT
April 16, 2021

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.

Terms & ConditionsAccessibility statement