cancel
Showing results for 
Search instead for 
Did you mean: 
virginiaparrabrown
Level 2

Bank Reconcilation

why is a clear transaction not matching with my reconciliation in QuickBooks online?

Solved
Best answer August 10, 2021

Best Answers
AlexV
QuickBooks Team

Bank Reconcilation

Hello virginiaparrabrown!

 

Allow me to assist you with your bank reconciliation.

 

The first thing we need to make sure of is that you have your bank statement handy when reconciling. It is our basis so that your books will be in balance.

 

The transactions showing on the reconciliation page depend on the period you're reconciling. If the cleared transaction is not on the bank statement, then it should not be included.

 

If what you meant by not matching is that you can't find the transaction when reconciling although it's in the right period, you'll want to make sure it's recorded. If you did not link your bank account, you can manually record it by clicking the + New button and select the type of transaction.

 

Please check this article: Reconcile an account in QuickBooks Online. This will show you the complete steps on how to balance your books as well as the fixes if you encountered errors.

 

Additionally, you'll want to keep a copy of your reconciliation report. You can use it in case you need to review it in the future. Follow the steps in this link: How do I view, print, or export a reconciliation report?

 

Leave a comment below if you have other concerns. I'll be here!

View solution in original post

7 Comments 7
AlexV
QuickBooks Team

Bank Reconcilation

Hello virginiaparrabrown!

 

Allow me to assist you with your bank reconciliation.

 

The first thing we need to make sure of is that you have your bank statement handy when reconciling. It is our basis so that your books will be in balance.

 

The transactions showing on the reconciliation page depend on the period you're reconciling. If the cleared transaction is not on the bank statement, then it should not be included.

 

If what you meant by not matching is that you can't find the transaction when reconciling although it's in the right period, you'll want to make sure it's recorded. If you did not link your bank account, you can manually record it by clicking the + New button and select the type of transaction.

 

Please check this article: Reconcile an account in QuickBooks Online. This will show you the complete steps on how to balance your books as well as the fixes if you encountered errors.

 

Additionally, you'll want to keep a copy of your reconciliation report. You can use it in case you need to review it in the future. Follow the steps in this link: How do I view, print, or export a reconciliation report?

 

Leave a comment below if you have other concerns. I'll be here!

View solution in original post

virginiaparrabrown
Level 2

Bank Reconcilation

Hello Alex, 

Thanks for replying back to me. I did check the bank statements. As well, I was able to clear on the bank register.  I did glanced over last month and also next month(in the bank statements & Quickbooks register) and I’m not able to see it. This particular transaction is only in the month I am reconciling( which is in the bank statements & Quickbooks register).

 

The strange thing is if I check it then it creates a difference and I can no longer finishing reconciling and closing the books. I have to uncheck it, in order for me finishing reconciling.

 

What can I do? Or what do you suggest I should do? In order to have this transaction in this report.

Thanks.

virginiaparrabrown
Level 2

Bank Reconcilation

Hello Alex,
Thanks for replying back to me. I did check the bank statements. As well, I was able to clear it on the bank register.  I did glanced over last month and also next month(in the bank statements & Quickbooks register) and I’m not able to see it. This particular transaction is only in the month I am reconciling( which is in the bank statements & Quickbooks register).

 

The strange thing is if I check it then it creates a difference and I can no finish the reconciliation. I have to uncheck it in order to close the books. 

what should I do? Or recommend? In order to have this transaction included in this report.

Thanks.

Ryan_M
QuickBooks Team

Bank Reconcilation

Thank you for the prompt reply, @virginiaparrabrown. I'll help you out with your reconciliation in QuickBooks Online (QBO).

 

I suggest checking the ending balance you set on the current period of the reconciliation. Here's how:

 

  1. Go to the Gear icon, then select Reconcile.
  2. Choose the correct bank account under the Account drop-down menu.
  3. Press Resume reconciling.
  4. Hit the Edit info button.
  5. Ensure the Ending balance and Ending date are both accurate.
  6. Click Save.

 

Refer to this article for additional steps you can take to resolve this reconciliation: Fix issues for accounts you've reconciled in the past in QuickBooks Online

 

I also suggest you check out this article: Learn the reconcile workflow in QuickBooks. It's an in-depth guide for reconciliation, along with links to related articles for this process.

 

Drop a comment below if you have other questions about reconciliation in QBO. I'll be sure to get back to you. Enjoy the rest of the day!

virginiaparrabrown
Level 2

Bank Reconcilation

Thanks, 

 

I was able to see that my chart of accounts were not categorized correctly. My other mistakes was the transactions were not debiting and crediting correctly, since some were missing(some only have debits and others didn’t have credits). After I fix those mistakes I was able to finish reconciling report correctly. 

(Thanks for your help, I greatly appreciate it)

Hope Causey
Level 1

Bank Reconcilation

I completed my bank rec and now I can not get it back;

TirzahC
Level 6

Bank Reconcilation

Hello there, Hope Causey.

 

I'm here to share insights about the bank reconciliation in QuickBooks Online (QBO).

 

in QuickBooks, we're not able to undo a bank reconciliation at once. Thus, your first option is to invite your accountant to your company and let them undo the reconciliation at once. Let me show you how:

  1. Click the Gear icon ⚙️ at the upper-right corner, and then select Manage Users.
  2. Go to the Accounting firms tab, and then enter the accountant's email.
  3. Tap the Invite button.
  4. Enter the needed info, and then hit Save when you're ready.

Once they accept the invitation, you can share this article in undoing a reconciliation (QuickBooks Online Accountant): Undo a Reconciliation.

 

If you wish to undo the reconciliation manually, you can do so by following these steps.

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Find the account you want to undo then select the View register link,
  4. Select the transaction you want to unreconciled to expand the view.
  5. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  6. Select the checkbox until the box is blank. This removes the transaction from the reconciliation.
  7. Click Save and close the account register.

You can use this article for reference: How to Unreconcile a Transaction or Undo a Reconciliation.

 

For a complete guide in reconciling transactions, see these helpful resources:

Feel free to get in touch with me here for any additional questions about reconciliation. I'll be around to help you out.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up