Fix issues when you’re reconciling in QuickBooks Desktop and Online

QuickBooks reconciliation aligns with recorded bank transactions or credit card entries. This procedure helps to validate accounting integrity.

QuickBooks Desktop reconciliation issues arise when transaction records or ending balances fail to align with the financial statement. A reconciliation irregularity generally shows a difference rather than USD 0.00. These issues can impact both QuickBooks Online and QuickBooks Desktop.

This guide outlines the common reasons for issues when you’re reconciling in QuickBooks. The following section outlines the effective steps to troubleshoot such issues and restore regular business workflow.

Understanding QuickBooks Reconciliation Problems

QuickBooks reconciliation issues arise when credit card or bank records fail to align with QuickBooks records. The reconciliation procedure can detect unavailable entries, irregular amounts, and repeated entries, triggering account discrepancies.

A completed reconciliation should display a USD 0.00 difference between QuickBooks and statement balance. Any remaining discrepancy directs towards an error with the beginning balances, recorded entries, and ending balance.

What are the Reasons that Trigger QuickBooks Reconciliation Issues

QuickBooks Online and QuickBooks Desktop reconciliation issues often arise from inaccurate balances. They can also arise from modified reconciliation entries or repeated transactions.

Here is the list of the reasons for ending and beginning balance discrepancies:

Reasons for Ending Balance Inconsistencies

The following reasons can alter the ending balance while reconciling:

• An inaccurate ending balance is entered during the initial reconciliation.
• A previously reconciled entry is modified or erased.
• An entry is added twice or erased from QuickBooks.
• A transaction is recorded in QuickBooks before the bank registered it.
• An added journal entry altered the initially reconciled balance.

Reasons for Beginning Balance Inconsistencies

The following reasons can modify the beginning balances while reconciling:

• Inaccurate opening balances entered while creating the account.
• Transaction date added prior to the opening balance without changing the initial balance.
• An initially reconciled transaction is adjusted, erased, shifted, or unreconciled.
• A previously reconciled entry is reconciled once more.

What are the Prerequisites for Bank Reconciliation?

To fix bank reconciliation in QuickBooks Desktop and Online, ensure you finish the following checks:

• Take a QuickBooks company file backup.
• Validate the beginning balance of the account.
• Add uncleared entries for the reporting period.
• Get the present credit card or bank statement.
• Validate amounts, transaction dates, and account activities.

Method to Fix Issues When Reconciling in QuickBooks Desktop

QuickBooks Desktop reconciliation completion displays a USD 0.00 difference. Follow these steps to review the beginning balance, ending balance, and reconciled transactions in case a discrepancy exists:

Step 1: Review the Opening and Beginning Balances

Confirm that the QuickBooks beginning balance aligns with the credit card or bank statement. Check the initial reconciliation report. Search for changes that may impact the present reconciliation.

Step 2: Detect Altered, Erased, or Missing Entries

Review QuickBooks reports to detect transactions that were adjusted after the initial reconciliation. Each of the following reports addresses a different purpose:

1. QuickBooks Reconciliation Discrepancy Report

The following report helps to locate entries that change after the initial reconciliation:

• Choose the “Reports” option and browse to “Banking”.
• Choose the “Reconciliation Discrepancy” option and select the account.
• Choose the “OK” account and check the listed entries.
• Review the modified entries and rectify any incorrect transactions.

2. Missing Checks Report

The following report helps to locate unavailable checks that impact the reconciliation balance:

• Choose the “Reports” option and browse to “Banking”.
• Choose the “Missing Checks” option and select the account.
• Choose the “OK” button and check the report.
• Register missing entries that are displayed on the bank statement, however, unavailable in QuickBooks.
• Erase transactions from QuickBooks that are not displayed on the bank statement.

3. Transaction Detail Report

The following report helps to locate transaction changes that lead to QuickBooks reconciliation discrepancies:

• Choose the “Reports” option and browse to “Custom Reports”.
• Choose the “Transaction Detail” option.
• Assign the needed date range.
• Access the “Filters” tab and choose the reconciliation account.
• Assign the “Entered/Last Modified” date range from the initial reconciliation to the present date.
• Choose the “OK” button and check the entries.
• Review the transactions against the bank statements and rectify any incorrect entries.

Note: Conduct a quick reconciliation after adding transactions or altering reconciled entries.

Step 3: Check Reconciliation Adjustments

Check the “Reconciliation Discrepancies” account. Search for adjustments that altered the account balance using the steps shared below:

• Choose the “Lists” option and access the Chart of Accounts.
• Access the “Reconciliation Discrepancies” account.
• Assign the date range to include the impacted reconciliations.
• Check every change and rectify any incorrect transactions.

Step 4: Finish the Reconciliation

Check the reconciliation report once the inconsistencies are rectified, using the following steps:

• Choose the “Display” option to check the report.
• Choose the “Print” button to generate a copy.
• Undo the initial reconciliation in case the beginning balance is still inaccurate.
• Check previous reconciliations in case a previous transaction was erased or modified and altered later balances.

Steps to Resolve Reconciliation Discrepancies in QuickBooks Online

QuickBooks Online reconciliation irregularities need to check account balances, transaction records, and statement information. Follow these steps to locate and resolve common reconciliation problems:

Step 1: Review the Beginning Balance

Review the QuickBooks Online beginning balance. Review the balance against the previous card or bank statement. Rectify the balance in case the records fail to align.

Step 2: Confirm the Ending Balance

Review the ending balance and statement date added during reconciliation. Follow these steps to verify the ending balance:

• Choose the “Edit Info” option in the reconciliation screen.
• Check the “Ending Balance” and “Ending Date”.
• Review both the balances and check them with the bank statement.
• Rectify any issues and choose the “Save” button.

Step 3: Merge Multiple Entries

Check if the bank merged different payments into a single transaction. Ensure you access the same transaction format in QuickBooks Online.

Record separate payments in Undeposited Funds when required. Now, generate a bank deposit to merge the payments and ensure the deposits align with the bank statement.

Conclusion

Locating the primary reason can help fix the issues when you’re reconciling in QuickBooks. In this guide, complete information on how to resolve reconciliation issues in QuickBooks Desktop and Online has been shared.

Still, if the issue persists, get in touch with our qualified QuickBooks reconciliation experts.

Frequently Asked Questions