Can you provide info on Checks cleared bank and listed in quickbooks but are showing differences when trying to reconcile July and checks cleared bank in prior months?

Hello there, finance128.

Thanks for reaching out to the Community about your concern. I’m here to help you find the cleared checks and resolve the differences in your reconciliation.

QuickBooks Online is a diary of your business that keeps track of what’s happening to your actual transactions. Let's open the Check Detail Report and tailor it to show all cleared checks.

1. Go to Reports on the left panel to enter the Check Detail Report in the search field.
2. Tap the Report period drop-down to set the correct date range.
3. Hit the Customize button to open the Customize report window.
4. Click the Filter option to mark the box for Cleared.
5. In the Account drop-down, select the bank you’re working on from the list.
6. Hit Run report to view the changes.
7. Navigate to the CLR column to see the cleared transactions.
   

Next, compare the information from your bank statement to the ones listed in the report. Allow me to share the following factors that causing both balances to be off:

• Outstanding transactions.
• New transactions for a connected account.
• Duplicate transactions.
• Edited or deleted transactions.
• Card (liability) account.

Resolving the differences depends on what’s causing the discrepancy. Let's can start by reviewing the opening balance and compare the amount to your real-life account. Sometimes the opening balance doesn't include transactions that were still pending when you made the account.

1. Tap the Accounting menu on the left panel to choose Chart of Accounts.
2. On the Bank and Credit Cards page, search for the account you’re working on.
3. Click View register under the Actions column.
4. Next, look for the opening balance and note of the date and balance.
   
5. If it's incorrect, click on the opening balance to expand the line.
   
6. Navigate to the Deposit column to change the amount to the correct one.
7. Hit the Save button to keep the changes and click Yes to confirm the action.

To continue resolving the issue, follow the instructions in the Fix beginning balance issues during your first reconciliation in QuickBooks Online guide, and perform Step 3.

For additional resources, let me also share the Fix issues when you're reconciling accounts in QuickBooks Online article. It provides complete steps to help you finish the reconciliation process.

If you need assistance while reconciling the account, post a comment below. I’ll be right here to help and make sure this is taken care of for you. Have a good one.