Skip to main content
August 20, 2019
Solved

Transactions not in banking or in history but show in expenses. Why aren't they showing in the reconciliation?

  • August 20, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by JamesDuanT

It's great that you're trying to reconcile your account, hequrjag.

 

There are two possible reasons why there are missing transactions in the Reconcile page. It could be:

  • the transactions are associated to a different account
  • the filters are set differently

We can review first the filters in the Reconcile page.

  1. In the Reconcile page, lick the Filter option (funnel icon).
  2. Set the filters correctly (Cleared status, Transaction type, Payee, and Date).
  3. Click Apply.

If the same thing happens, I'd recommend reviewing the expense transaction.

  1. Open the expense transaction.
  2. Make sure the affected bank account is correct. This should be the same account you're reconciling.
  3. Click Save and close.
  4. Select Yes to confirm the action.

Then, you can continue reconciling the account.

 

Get back to me if you need more help in doing this.

1 reply

August 20, 2019

It's great that you're trying to reconcile your account, hequrjag.

 

There are two possible reasons why there are missing transactions in the Reconcile page. It could be:

  • the transactions are associated to a different account
  • the filters are set differently

We can review first the filters in the Reconcile page.

  1. In the Reconcile page, lick the Filter option (funnel icon).
  2. Set the filters correctly (Cleared status, Transaction type, Payee, and Date).
  3. Click Apply.

If the same thing happens, I'd recommend reviewing the expense transaction.

  1. Open the expense transaction.
  2. Make sure the affected bank account is correct. This should be the same account you're reconciling.
  3. Click Save and close.
  4. Select Yes to confirm the action.

Then, you can continue reconciling the account.

 

Get back to me if you need more help in doing this.

August 16, 2021

Many Thanks. I did all of the above and 2  Things:

1. The Account still shows a much higher beginning balance when I reconcile this. I suspect it is because I'm using an opening balance of $5435 (which was the opening balance on Jan-1) but QB pulled in the transactions from previous years.

2. Tha transactions are not showing in the Reconcile Page  - but shows in the balance sheet when I click on the account.

August 16, 2021

Hi TK223,

 

Welcome to the Community!

 

If this is not your first time reconciling the bank account and a change has been made to a reconciled period, you'll have to undo the previous reconciliation or manually reconcile those transaction that changed. Any changes made to a reconciled transaction will affect your beginning balance to be off for your current reconciliation.

 

Furthermore, a transaction does not show in the bank reconciliation if it has been reconciled or it could be deleted or was not added or downloaded in QuickBooks Online.

 

You can run a reconciliation report to view past reconciliations. Here's how:

  1. Click on the Accounting tab, and then click on Reconcile.
  2. Click on History by account.
  3. Click on the drop down menu and choose the account and date range.

 

To learn more about bank reconciliation in QuickBooks Online, please check this link:

 

Fix issues for accounts you've reconciled in the past in QuickBooks Online

 

Comment below if you have questions. I'll be sure to get to you right away.