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.

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.

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.

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. 

Your answer does make sense, however, the transaction I'm having an issue is wanting to reconcile in my client's checking account, however, it is a transaction that was actually on the client's credit card. So I deleted the transaction out of the register and then excluded it out of the bank feed in the transactions. Now it keeps telling me in the reconciliation screen of the checking account (which remember it's not even a checking account transaction, it's on the credit card) that my balance is off be that exact amount. 

What do I do here? 

Thank you for bringing this matter to our attention, cynthia. Let's work together to navigate this situation, identify the root cause of the ongoing discrepancy to ensure the checking account is accurately reconciled.

The possible reason your balance is off by the same amount as the deleted credit card transaction is likely due to an accounting discrepancies. Specifically, you may have inadvertently recorded the credit card expense in your Checking account. Thus, deleting the transactions has caused the balance to be off, which affects the previous reconciliations or created imbalances in the accounting system. 

In this case, you'll need to adjust all affected reconciliations or undo your client's reconciliations, working backwards from the most recent period to the point where the discrepancy originated or where the deleted transaction was initially reconciled. I'll guide you to the process: 

1. Sign in to QuickBooks Online Accountant.
2. Find and open your customer's QuickBooks Online company.
3. Then, go to the Transactions and hit Reconcile.
4. Choose History by account.
5. Select the account you want to reconcile and date range from the dropdowns.
6. Find the reconciliation on the list.
7. Select View report to open the Reconciliation report.
8. Review any discrepancies and changes your client wants to make.
9. When you’re ready, select the dropdown menu in the Action column, and then click Undo.
10. Hit Yes and then Undo to confirm.

Repeat the same process until you reach the certain period where the deleted transaction was initially reconciled. After that, you'll need to reconcile your client's Checking account moving forward. Start from the period of the original discrepancy and systematically work through each subsequent reconciliation period. 

Thank you for your commitment to ensuring the accuracy of your client's financial records, cynthia. Your attention to detail in identifying and resolving this issue demonstrates your dedication to providing high-quality accounting services. If you have additional questions, please don't hesitate to share them in the comment section below. Maintaining accurate financial records is a critical part of your role, and it's important to address these issues thoroughly.