Quickbooks Bank Reconciliation: Undo And Redo With Ease

how to undo bank reconciliation in quickbooks

QuickBooks is an accounting software that allows users to reconcile their accounts and make adjustments when necessary. The process of reversing reconciliations depends on whether you are handling a single transaction or multiple transactions. To undo a reconciliation in QuickBooks Online, you can go to the Accounting tab, select the Chart of Accounts, click on the name of the account you want to unreconcile, and then click Unreconcile All or Unreconcile Selected. If you are using QuickBooks Desktop, you can select Reconcile from the Banking menu and choose the appropriate account. If a previous reconciliation exists, QuickBooks will display an Undo Last Reconciliation button.

Characteristics Values
Process for unreconciling Much the same across QuickBooks Desktop and Online
How to undo reconciliation in QuickBooks Online Go to the "Accounting" tab > Select the account from the "Chart of Accounts" section > Click "View Register" > Change the status of relevant transactions from "Reconciled" to "Cleared" > Head to the "Reconcile" page > Input the correct ending balance > Click "Start Reconciling"
How to undo reconciliation in QuickBooks Desktop Go to the "Banking" menu > Select "Reconcile" > Choose the account > Click "Undo Last Reconciliation" > Confirm by clicking "Continue"
How to undo reconciliation using QuickBooks Online Accountant Click "Accounting" in the left menu > Go to the "Reconcile" tab > Select "History by account" > Choose the account and set a date range > Find the reconciliation on the list > Select "View report" > Review any discrepancies > Select "Undo" in the Action column > Confirm by selecting "Yes" and then "Undo"
How to undo reconciliation using a different version Manually unreconciling each transaction > Click the Gear icon > Select "Chart of Accounts" > Choose the account > Click "View Register" > Select the transactions to unreconcile > Click the "R status" until it shows blank or cleared > Click "Save" > Confirm by selecting "Yes"
How to undo reconciliation if the "Undo" button is not visible Clear the browser's cache > Use other supported browsers
How to undo reconciliation if a deposit is improperly categorised Delete the deposit from the bank register > Match it to an open Account Receivable

bankshun

Using the Undo reconciliation feature

To undo a reconciliation in QuickBooks Online, start by selecting the "Accounting" tab and then the "Chart of Accounts". Next, click on the name of the account you want to unreconcile and go to the "Reconciliation" section. Here, you can choose to “Unreconcile All” or “Unreconcile Selected”. Confirm your selection by clicking “Yes” in the pop-up window.

If you are using QuickBooks Online Accountant, you can utilise the Undo reconciliation feature to undo previous transactions without manually editing individual transactions. To do this, click on "Accounting" in the left menu and go to the "Reconcile" tab. Select "History by account", choose the account you want to reconcile, and set a date range. Find the reconciliation on the list and select "View report" to open the Reconciliation Report. Review any discrepancies and changes, then select "Undo" from the dropdown menu in the Action column. Confirm your selection by clicking "Yes" and then "Undo" again.

For QuickBooks Desktop users, the process is slightly different. Launch QuickBooks Desktop and access the "Banking" menu. From the dropdown list, select "Reconcile" and then choose the appropriate account. If a previous reconciliation exists for that account, QuickBooks will display the "Undo Last Reconciliation" button. Confirm your decision by clicking "Continue" on the screen that appears.

It is important to note that unreconciling a month may affect any reports you have already created for that period. You may need to reprint those reports to reflect the updated information. Additionally, be very careful when performing an unreconciliation as it can significantly impact your financial records. Double and triple-check everything before proceeding.

bankshun

Manually unreconciling each transaction

If you're using QuickBooks Online Accountant, you can utilise the Undo reconciliation feature to undo previous transactions without manually editing individual transactions from within the register. However, if you use a different version, you can undo a reconciled statement by manually unreconciling each transaction. Here is a step-by-step guide on how to do this:

Firstly, click the Gear icon at the top of your screen and then click on the 'Chart of Accounts' option. Find and choose the account you're working on, and click on 'View Register'. Now, select the transactions you want to unreconcile. Keep clicking the 'R' status in the checkmark column until it shows blank or 'C' (Cleared). Click on 'Save' and then choose 'Yes' to confirm.

Before completing any of the steps, it is recommended that you consult with your accountant to ensure that all of your records are in order. It is also important to note that unreconciling a month may affect any reports you've already created for that period.

bankshun

Adjusting the opening balance

Step 1: Identify the Need for Adjustment

Before making any changes, it is essential to understand the reason for adjusting the opening balance. This could be due to errors in data entry, discrepancies between bank statements and QuickBooks transactions, or the need to correct beginning balances for accurate financial reporting.

Step 2: Consult with Professionals

It is highly recommended to consult with an accountant or bookkeeper before making any adjustments. They can provide valuable expertise and ensure the accuracy of your financial records during and after the adjustment process. Their guidance can be especially important when dealing with complex financial scenarios or closed accounting periods.

Step 3: Access the Opening Balance Equity Account

In QuickBooks Online (QBO), the Opening Balance Equity account is used to create initial balances or balance adjustments. To access this feature, log in to your QuickBooks account and navigate to the appropriate section, such as the "Accounting" or "Chart of Accounts" menu, depending on the version of QuickBooks you are using.

Step 4: Make the Necessary Adjustments

To adjust the opening balance, follow these sub-steps:

  • Select "+ New" and then choose "Journal Entry."
  • Enter a date before the oldest transaction in the account. This will be your opening balance date.
  • On the first line, select the account for which you want to enter the opening balance.
  • Add a descriptive note in the "Description" field to explain the purpose of the journal entry.
  • On the second line, select "Opening Balance Equity" from the "Account" dropdown.
  • Refer to your bank statements and enter the accurate opening balance.
  • Based on the type of account selected in the first line, enter the corresponding debits and credits.

Step 5: Review and Confirm

Once you have made the necessary adjustments, carefully review the changes to ensure accuracy. Verify that the new opening balance matches your real-life bank account balance. This step is crucial, as an incorrect beginning balance can impact your financial reports, tax calculations, and overall account management.

By following these steps, you can confidently adjust the opening balance in QuickBooks, maintaining the integrity of your financial records and ensuring a smooth reconciliation process. Remember to keep detailed records of any adjustments made and always seek professional advice when in doubt.

bankshun

Changing the ending balance

  • Review Your Beginning Balance: Before making any changes to the ending balance, it's crucial to ensure that your beginning balance is accurate. This will help you identify any discrepancies and make the necessary adjustments.
  • Navigate to the "Reconciliation Window": In QuickBooks, access the "Reconciliation Window" to verify and adjust the ending balance. This window allows you to review and make changes to your financial records.
  • Consolidate Transactions: If your bank has treated multiple transactions as a single record, you'll need to consolidate them in QuickBooks. This ensures that your records match the bank's records.
  • Mark Matching Transactions: Go through your bank statement and identify any transactions that match the entries in QuickBooks. Mark these transactions accordingly to indicate that they have been reconciled.
  • Enter Missing Transactions: Compare your bank statement with the transactions in QuickBooks. If there are any transactions missing in QuickBooks, be sure to enter them accurately.
  • Remove Unmatched Transactions: Conversely, if there are transactions in QuickBooks that do not appear on your bank statement, remove them. This ensures that your records are accurate and up-to-date.
  • Address Discrepancies: If you encounter transactions that are slightly off or don't quite match, take the time to investigate and address these discrepancies. This may involve contacting your financial institution to clarify any mistakes on their end.
  • Check for Accuracy: Before finalizing any changes, double-check all the transactions and amounts. Ensure that your ending balance in QuickBooks matches your bank statement to avoid further discrepancies.
  • Finalize the Ending Balance: Once you've made all the necessary adjustments and confirmed the accuracy of your records, you can finalize the ending balance. Save the changes and proceed with the reconciliation process.

Remember, changing the ending balance can have implications for your financial records, so always proceed with caution and consider seeking professional advice if you're unsure.

bankshun

Using the QuickBooks reconciliation report

The QuickBooks reconciliation report is a useful tool to help you keep your financial records accurate and up to date. It allows you to see exactly where things may have gone wrong, helping you to pinpoint which transactions need to be fixed.

To access the reconciliation report, go to the "Accounting" menu, then the "Chart of Accounts", and select the bank account in question. You can then review the report and make any necessary changes.

If you are using QuickBooks Online Accountant, you can undo previous reconciliations without manually editing individual transactions. To do this, click on "Accounting" in the left menu, then go to the "Reconcile" tab. Select "History by account", choose the account and set a date range. Find the reconciliation on the list, select "View report", and then review any discrepancies. When you are ready, select "Undo" in the Action column and confirm this action.

If you are using a different version of QuickBooks, you will need to manually unreconcile each transaction. To do this, click on the "Gear" icon, select "Chart of Accounts", and choose the account you are working on. Click on "View Register", select the transactions you want to unreconcile, and keep clicking on the "R" status until it shows as blank or "C" for "Cleared". Click "Save" and confirm.

It is important to consult with your accountant before completing these steps to ensure that your records are in order.

PPD in Banking: What Does It Mean?

You may want to see also

Frequently asked questions

To undo a bank reconciliation in QuickBooks Online, go to the "Accounting" tab, select the "Chart of Accounts", click on the name of the account you want to undo, and then click "Unreconcile All" or "Unreconcile Selected".

Launch QuickBooks Desktop, access the "Banking" menu, select "Reconcile" from the drop-down list, choose the account, and click "Undo Last Reconciliation".

Click on "Accounting" in the left menu, go to the "Reconcile" tab, select "History by account", choose the account and date range, find the reconciliation on the list, review any discrepancies, and then select "Undo" from the dropdown in the Action column.

Clear your browser's cache, use a different device, or try a supported browser.

Go to the "Bank Register", filter by reconciled transactions, select multiple entries, and change their reconciliation status.

Written by
Reviewed by
Share this post
Print
Did this article help you?

Leave a comment