QuickBooks Bank Reconciliation Missing Transactions

Bank reconciliation in QuickBooks helps businesses maintain accurate financial reports. The process checks transactions in the bank statement against QuickBooks records.

However, missing transactions or entries can trigger issues between these records. Such QuickBooks bank reconciliation issues impact account balances and are common among users.

This guide outlines the causes of such “missing transactions in QuickBooks issues. The following section outlines the steps to resolve missing transactions during QuickBooks reconciliation. Implementing the steps correctly ensures precise and updated financial records.

Missing Transactions During Reconciliation in QuickBooks: An Overview

QuickBooks bank reconciliation issues like missing transactions that fail to appear on the Reconcile page. These are bank or credit card transactions that result in differences between the financial statement and QuickBooks. 

QuickBooks Online checks the recorded entries with the bank or credit card statements. Unavailable or missing transactions need review prior to reconciliation. The missing transactions can be added or downloaded to ensure precise account records.

Reasons for Missing transactions in QuickBooks during reconciliation

Multiple factors can stop transactions from getting displayed on the Reconcile page. Here is the list of the reasons for QuickBooks bank reconciliation missing transactions:

• Transactions are often delayed by banks until later in the day or the following morning.
• Banks may show transactions on their website before they can be downloaded.
• Recently posted entries take time to record in QuickBooks, based on the bank.
• Downloaded transactions are often displayed on the “For Review” page. They are required to be classified or aligned before they impact the books.
• A transaction is included in the account register and reconciled. Hence, it may not be visible as an unreconciled entry.
• The current available transactions are downloaded by the connected bank account.

Fix Missing Transactions During Reconciliation in QuickBooks Online

Follow these steps to resolve the QuickBooks bank reconciliation issues and locate the missing transactions:

Review the Bank Statement

Here are the steps to check the bank statement:

1. Check the statement- Check every entry for the specific reconciliation period.
2. Analyze the transactions- Check the bank statement against QuickBooks.
3. Detect unavailable transactions- Review payments, deposits, and other entries missing from QuickBooks.
4. Register the transactions- Register the unavailable transactions once the difference is verified. 

Navigate to the “For Review” Page

QuickBooks Online can import transactions into the “For Review” page. Such entries are not added in the account register until you assign a category or match them.

1. Navigate to the “Transactions” page.
2. Choose the “Bank Transactions” option.
3. Click the “For Review” tab.
4. Locate the unavailable transaction.
5. Classify or align the transaction.
6. Go back to the Reconcile page and review the transaction once more.
7. Move to step 3 when the transaction cannot be located.

Bank Connection Status Update

Follow these steps to update the bank connection in QuickBooks Online:

1. Check the bank feed for the missing or unavailable transaction.
2. To download the latest transactions, wait for 24 hours.
3. Check the bank feed once more after 24 hours.

Review the Account Register

The transaction can be present under a different account in QuickBooks Online. Review the account register before entering a new transaction, using these steps:

1. Navigate to “All apps.”
2. Choose the “Accounting” option.
3. Choose the “Chart of Accounts” option.
4. Locate the account required to reconcile.
5. Choose the “View register” option.
6. Check transactions for the specific reconciliation tenure.
7. Perform a search based on amount or date.
8. Access the transaction you locate.
9. Review the account and transaction information.
10. Rectify the details when needed.
11. Choose the “Save” button.
12. Go back to the Reconcile page and verify that the transaction is displayed.

Add the Missing Transaction

Follow these steps to include the missing transaction and fix the QuickBooks reconciliation issue:

1. Manually add the transaction when it is missing in QuickBooks Online.
2. Add the right amount, date, and account from the bank statement.
3. Choose the transaction type- Register the expenses as expense entries and deposits as deposit entries.
4. Once the details are checked, save the transaction. Go back to the Reconciliation page and verify the transaction. 

Fix Missing Transactions During Reconciliation in QuickBooks Desktop

QuickBooks Desktop can display less entries compared to the bank statement. Often, erased transactions, unavailable checks, or adjusted entries can trigger this difference.

Follow these steps to fix the “QuickBooks transactions not showing in bank reconciliation” issue:

Check the Beginning and Opening Balances

Here are the steps to review the opening and beginning balances in QuickBooks Desktop:

1. Check the bank statement and both balances and compare them.
2. Verify that QuickBooks Desktop aligns with the bank statement.

Locate Modified, Erased, or Missing Transactions

QuickBooks Desktop offers reports that help detect entries that impact the reconciliation. The following steps can help resolve the “QuickBooks transactions not showing in bank reconciliation” issue:

• Start a Reconciliation Discrepancy Report
  • The Reconciliation Discrepancy Report detects entries changed post-reconciliation. Here are the steps to run the discrepancy report:
    • Navigate to the “Reports” section.
    • Choose the “Banking” tab.
    • Choose the “Reconciliation Discrepancy” report.
    • Select the account.
    • Click the “OK” button.
    • Check the modified transactions.
    • Check every transaction with the bank statement.
    • Rectify incorrect transactions when required.
• Start the Missing Checks Report
  • The Missing Checks report detects checks that can impact the reconciliation. Follow these steps to run the report:
    • Navigate to the “Reports” section.
    • Choose the “Banking” option.
    • Choose the “Missing Checks” tab.
    • Select the account and click the “OK” button.
    • Check the listed checks.
    • Analyze the checks with the bank statement.
    • Review checks that differ from the statement.
• Start the Transaction Detail Report
  • The Transaction Detail report helps detect transactions modified post-reconciliation. Follow these steps to run the detail report:
    • Navigate to the “Reports” section.
    • Choose the “Custom Reports” option.
    • Choose the “Transaction Detail” tab.
    • Go to the “Display” tab.
    • Add the needed date range.
    • Click the “Filters” tab.
    • Choose the account in the “Account” field.
    • Add the ending reconciliation date in the “Entered/Last Modified” option.
    • Add today’s date in the next date section.
    • Choose the “OK” button.
    • Check the bank statement with the report.
    • Check transactions that fail to align.
    • Rectify incorrect entries when required.
• Review Reconciliation Changes
  • Reconciliation changes modify account balances without rectifying the initial transaction. 
  • Follow these steps to check the Reconciliation Discrepancies account for incorrect adjustments:
    • Navigate to the “Lists” section.
    • Choose the “QuickBooks Chart of Accounts” section.
    • Go to “Reconciliation Discrepancies”.
    • Choose the date range for the latest discrepancies.
    • Check the listed changes.
    • Analyze every adjustment with the bank statement.
    • Detect adjustments that do not align.
    • Rectify the initial transactions when needed.
• Complete Reconciling
  • Follow these steps to finish bank reconciliation in QuickBooks Desktop:
    • Check the bank statement with QuickBooks Desktop. Verify all entries, amounts, and dates.
    • Check the initial reconciliation when transactions are not available.
    • Rectify the opening balance when the initial reconciliation includes an error.
    • Talk to professionals before modifying reconciliation records.

Key Tips to Prevent Missing Transactions in QuickBooks

Follow these tips to avoid missing transactions in QuickBooks:

• Reconcile amounts every 30 days to identify missing transactions promptly.
• Check bank feeds with bank statements prior to reconciliation.
• Review the dates, accounts, and amounts before confirming matches.
• Maintain invoices and receipts for transaction validation.
• Wait for 24 hours for the latest bank transactions to get displayed.
• Get in touch with QuickBooks Online support when bank feed problems persist.

Conclusion

Unavailable transactions can impact bank reconciliation in QuickBooks. Check the bank feeds and account register frequently.

In this guide, the steps to resolve QuickBooks bank reconciliation issues due to missing transactions have been shared. The steps include solutions for both QuickBooks Online and Desktop.

Still, if there are additional queries or doubts, feel free to call our QuickBooks experts at +1800-974-3985 today.

Frequently Asked Questions