Skip to main content
Kathy GreenBudBooks
Oct 6, 2020 1:45 PM UTC
Solved

Correcting for bank reconciliation

A transaction was deleted after it was reconciled. It SHOULD be deleted but now I can't reconcile without clearing it somehow. How do I do this?

Kathy GreenBudBooksAnswer
Oct 8, 2020 12:46 PM UTC

Hi Kathy GreenBudBooks. 

 

Thanks for dropping by the QuickBooks Community. If the steps provided by my colleagues haven't help. I would definitely recommend reaching out to support, they will be able to dive into your personal account with you in a 1-on-1 setting to diagnose what's going on.

 

To reach them, you can follow these steps:

  1. Sign in to your QuickBooks Online company.
  2. Go to Help (?).
  3. Select Contact Us.
  4. Enter your concern, then select Let's talk.
  5. Choose a way to connect with us:
    • Start a chat with a support expert.
    • Get a callback from the next available expert.

If there's anything else I can help with, feel free to post here anytime. Thank you and have a nice afternoon. 


I was able to speak with a QBO agent.  After 1.5 hrs, the problem wasn't fixed but she was able to guide me thru an acceptable work-around by adding a new Balance Equity entry for the next month to be reconciled.   

View in thread

16 replies

AlcaeusF
AlcaeusF
Oct 6, 2020 3:17 PM UTC

Hi there, @Kathy GreenBudBooks.

 

Thanks for dropping by here in the Community. I can help you correct the bank reconciliation in QuickBooks.

 

Once you delete a reconciled transaction, it will affect the specific period and the opening balance. If your accountant have access to your company file, I recommend you request to undo the reconciliation.

 

The ability to perform the process is only available in QuickBooks Online Accountant (QBOA) version.

 

Here's how:

 

  1. Go to the Accounting menu.
  2. Select the Reconcile tab.
  3. Select History by account.
    This is an image of the main reconcile an account screen, highlighting the link to History by account
  4. Select the account you want to reconcile and date range from the drop-down menus.
  5. Find the reconciliation on the list.
  6. If you haven’t already, select View report to open the Reconciliation Report. Review any discrepancies and changes your client wants to make.
    This is an image of your history by account screen 
  7. When you’re ready, select the arrow in the Action column, and then select Undo.
  8. Select Yes and then Undo to confirm.

If you don't have an accountant, you may need to unreconcile transactions individually. Please follow these steps:

 

  1. Go to the Accounting menu. Then select Chart of Accounts.
  2. Find the account and select View register. 
  3. Select the transaction you want to unreconcile.
  4. Review the check column. If the transaction is reconciled, you’ll see an “R.” User-added image
  5. Select the box and keep clicking it until the box is blank. This removes the transaction from the reconciliation.
    Reconcile
  6. Select Save. Then close your register.

Additionally, I recommend visiting the following article to resolve problems with reconciling accounts: Fix issues when you're reconciling accounts in QuickBooks Online.

 

Please let me know if you need anything else. The Community and I will be here to help you.

Kathy GreenBudBooksAuthor
Oct 6, 2020 9:34 PM UTC

Hello and thank you for your response.  Unfortunately, I'm still stuck. 

 

When I tried following the steps you outlined for QBOA, after going from History by Account and then to View Report, I can't find the Action column and am unable to complete steps 7 and 8 below.

 

When I try doing it manually, the transactions (which show on the History by Account/View Report) do NOT show in the registry because they've been deleted. 

 

These transactions were intentionally deleted after reconciling and should stay deleted.  Where do I go from here.  There are several of these in each of the 2 bank accounts.

CharleneMaeF
Oct 6, 2020 11:02 PM UTC

Allow me to share additional info about reconciliation,  Kathy GreenBudBooks.

 

When reconciling, even small changes can unbalance your accounts. To correct your reconciliation, we'll have unreconcile the transactions and start over from the beginning. I recommend reaching out to your accountant to undo the entire reconciliation. Doing so can help QuickBooks detect that the deleted transaction is already excluded in the data.

 

You can use the reconciliation report to serve as a guide to see all the transactions that need to be unreconciled.

 

Here's how to run the report:

  1. Go to the Reports menu.
  2. Type Reconciliation Report in the search bar, then click to open.
  3. Select the Account for the reconciliation report you want to view.
  4. From the Report period drop-down arrow, choose the reconcile period.
  5. Click the View Report option.

 

If you'd like to unreconcile the transactions manually, you may follow the steps shared by my colleague.

 

Once done unreconciling, let's reconcile the transactions again. Here's how:

  1. Go to the Gear icon and then select Reconcile. 
  2. On the Account drop-down menu, select the bank account you want to reconcile.
  3. Check the Last statement ending date. Make sure your bank statement starts the day after your last reconciliation.
  4. Review the Beginning balance. Ensure the beginning balance in QuickBooks matches the one on your bank statement. Here’s what to do if they don't match.
  5. Enter the Ending balance and Ending date written on your bank statement. 
  6. When you're ready to start, select Start reconciling.

 

For more details about the process, you can check out our reconcile guide.

 

Additionally, I've included our Year-end guide and checklist. This helps you complete the important task to maintain accurate data of your books.

 

You can count on us if you have other questions in reconciling your accounts in QuickBooks. We'd be glad to assist you.

Rustler
Rustler
Oct 7, 2020 12:55 PM UTC

@Kathy GreenBudBooks 

 

If the check was reconciled, then it is a valid transaction and should not be deleted, it did clear the bank.

Please explain the issue

 

Kathy GreenBudBooksAuthor
Oct 7, 2020 1:58 PM UTC

Hi Rustler,

The business owner reconciled the transactions for each bank account, but didn't realize that 1 bank account was a sub-account at her bank.  Transactions were entered twice in QBO when both the parent and sub-account were linked to QBO.  Both sets of transactions were reconciled in QBO based on the separate QBO accounts for the parent and the sub-account.  I went in and deleted everything from the sub-account and then made the sub-account inactive.  But, to reconcile the parent account in QBO, the Reconciliation Discrepancy Report gives me a list of 5 transactions that were deleted after reconciling that I now need to handle.  When I click on "View" from the Reconciliation Discrepancy Report for the individual transactions, I get a blank screen.  The previous answers in this post didn't help me get rid of these.  

 

ShiellaGraceA
Oct 7, 2020 4:22 PM UTC

Thanks for getting back to us, @Kathy GreenBudBooks.

 

I have some information to share about the reconciliation discrepancy report. This report will display cleared transactions that were changed or deleted since you last reconciled. Clicking on "View" will route you to the audit history page that contains details of the changes. Here's how it looks like.

 

 

In your case, you can leave the transactions in the report or ask your accountant to undo and reconcile that period again.. Just make sure your opening balance matches with your bank statement. Here's a link that'll guide you through the process: Learn the reconcile workflow in QuickBooks.

 

If you need help with fixing issues when reconciling, click this link. It has step-by-step instructions to help you finish your reconciliation.

 

Let me know if you if you still have questions or concerns. I'll be here for you. Take care and stay safe.

Terms & ConditionsAccessibility statement