United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Liz_N
Level 1
posted
‎August 20, 2019 08:36 PM
last updated ‎August 20, 2019 4:23 AM

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

 
Solved
Reply
Best answer August 20, 2019
Solved

Best Answers
JamesDuanT
Moderator
Moderator
‎August 20, 2019 10:13 PM

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

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.

View solution in original post

Reply
5 Comments 5
JamesDuanT
Moderator
Moderator
‎August 20, 2019 10:13 PM

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

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.

Reply
TK223
Level 1
‎August 16, 2021 02:51 PM

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

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.

Reply
IntuitSheila
Level 8
‎August 16, 2021 04:00 PM

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

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.

Reply
TK223
Level 1
‎August 19, 2021 11:04 AM

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

 

Hello - I'm reconciling a new account and i set the opening balance on the amount on Dec 31, 2018 to match the bank statements but looks like QB pulled all historical transacation. How do I force QQ to only reconcile the account from Jan 2019 and to use the Dec 31, 2018 value as "opening balance". See attached.

 

 

 

Reply
IntuitSheila
Level 8
‎August 19, 2021 11:56 AM

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

Hello TK223,

 

Since the opening balance date is set in2018, all transactions not reconciled within that period will show on the reconciliation page. You'll have to edit the date range on your reconciliation page to show transactions from Jan 2019.

 

Here's how to edit the filters in the Reconciliation page:

  1. In the Reconciliation page, click on the Filter option (funnel icon above Date column).
  2. Select the filters like Transaction type, status.
  3. Under Date select a From and To based on the transaction you wanted to show on the reconciliation.
  4. Click Apply.

Then, you can continue reconciling the account. You can check this article for a more detailed information on how to Reconcile an account in QuickBooks Online.

 

If you still need help reconciling your account, we'd recommend contacting our Customer Care Team to help you. 

 

 

Reply