How to Undo Reconciliation in QuickBooks online?

Step-by-Step Guide to Undo or Unreconcile Transactions in QuickBooks Online

Once you’ve identified the transaction you need to adjust, follow these steps to unreconcile it:

1. Review the account, check the opening, starting or beginning, and ending balance, and ensure that account is reconciled. 
2. Click on Settings > Chart of Accounts.
3. Locate the account that contains the reconciled transaction. Then click on View Register.
4. Scroll through the register to find the specific transaction. If it’s reconciled, an “R” will appear in the checkmark (✔) column.
5. Select the transaction to open it. In the checkmark (✔) column, click on the box containing the “R” until the box becomes blank. This action removes the transaction from the reconciliation.
6. After deselecting the “R,” select Save to update the transaction.
7. Once the transaction is unreconciled, close the account register.

Step-by-Step Guide to Undo or Unreconcile Transactions in QuickBooks Desktop (Pro or Premier)

Here’s how you can undo reconciliation in QuickBooks Desktop Pro and QuickBooks Desktop Premier:

1. Launch QuickBooks Desktop 2024, and navigate to the Banking menu at the top of the screen.
2. From the Banking menu, choose Reconcile from the drop-down list.
3. Select the account you want to reconcile, and enter the correct date range. Be sure to choose the balance before you begin the undo process.
4. Once you’ve selected the account and date, click on the Undo Last Reconciliation button.
5. A confirmation screen will appear. To proceed with the reversal, click Continue.

Note: Before undoing any reconciliation, it’s advisable to review and note any discrepancies. This will help you avoid making the same mistakes again when reconciling in the future.

See More: Ensure accurate financial reporting with our QuickBooks reconciliation report – simplify your accounting today!

How to fix Reconciliation Issues in QuickBooks Online?

These steps mentioned below will help resolve the issues if you’re facing difficulties with reconciliation in QuickBooks Online:

1. Check the Opening and Beginning Balances

Before proceeding, double-check the opening and beginning balances. Accuracy is key to ensuring the rest of the reconciliation process goes smoothly.

2. Check the Ending Balance

Make sure the entered ending balance matches the one on your bank statement. You can edit the ending balance in the Reconciliation Window if needed.

3. Combine Multiple Transactions

Sometimes, banks combine multiple transactions into one entry. You will need to consolidate these transactions in QuickBooks to avoid discrepancies if this happens.

4. Separate the Correct Transactions

Ensure that all transactions appearing in both QuickBooks and your bank statement are marked as reconciled. Mark it as reconciled in QuickBooks if a transaction matches both records.

5. Add Missing Transactions details

You can add them manually by entering the transaction details from your bank statement if you notice that some transactions are missing from QuickBooks.

6. Delete Unmatched Transactions

Look for transactions in QuickBooks that are not listed on your bank statement. Delete them to maintain accuracy if they are indeed errors.

7. Talk to Accountant for any Slightly Off Transactions

Minor discrepancies, such as small differences in amounts, may require professional attention. Consult with your accountant for guidance in resolving these minor errors.

8. Check for Bank Errors

Sometimes, errors may arise from the bank or financial institution. Verify that your bank statement is accurate and investigate any inconsistencies.

9. Complete the Reconciliation

Once all QuickBooks discrepancies are resolved, your accounts should balance correctly. Proceed with completing the reconciliation process in QuickBooks Online.

How to Fix Reconciliation Issues in QuickBooks Desktop?

QuickBooks Desktop features 2024 also offers tools and reports to help you resolve reconciliation issues. Follow these steps to correct discrepancies:

Step 1: Check the Opening and Beginning Balances

Check that the opening and beginning balances are correct. Proceed with troubleshooting other potential errors if these balances are accurate

Step 2: Change, Deleted, or Added Transactions

QuickBooks provides reports that can help you identify if transactions were changed, deleted, or added:

Reconciliation Discrepancy Report:

This report identifies transactions that have changed since the last reconciliation. 

• You can run it by clicking on Reports > Banking > Reconciliation Discrepancy.
• Select the desired account and click on the OK button.
• Consult with the person who has made the change. You can edit the transaction based on their reasoning.

Missing Checks Report:

 Use this report to find any checks that may be missing from the bank statement.

• Go to Reports > Banking > Missing Checks.
• Select the desired account and click on the OK button.
• Check the report and also verify whether there are any transactions

See More: QuickBooks cancel bank reconciliation

Transaction Detail Report:

This report provides a detailed list of all transactions, which can help you spot any discrepancies.      

• Access it from Reports > Custom Reports > Transaction Details > Display.
• Select the Date From and Date To fields.
• After this, click on the Filters Tab. 
• Select the desired account from the Account field.
• Click OK.

Note:

1. Date From can be chosen from the earliest date from your QuickBooks Account. You can also avoid filling out the Date From field. 
2. In the Date To field, you have to enter the last date of reconciliation. 

Step 3: Resolve Discrepancies

After running these reports, review them carefully. Here’s how you can resolve the discrepancies.

• Click on Lists menu >Chart of Accounts > Reconciliation Discrepancies account. 
• Now, you will be able to make changes in the Dates field.

Discuss them with the individual who made the changes and edit transactions as necessary if discrepancies exist.

Frequently Asked Questions