Skip to main content
G
garbia
June 18, 2020
Question

Delete a reconciled transaction and then recreate it and beginning balance

  • June 18, 2020
  • 2 replies
  • 0 views

Solved by performing a mini reconciliation.

 

I have deleted a cheque from july 2019 and then recreated, went back in the bank account, and ticked the transaction so it would show as clear again.

I assume it was all ok until I started March Reconciliation and noticed that the beginning balance was off and the cheque I have deleted and recreated now shows in the list of march reconciliation.

I know in Quickbooks online you can mark with R but I use QB Desktop Enterprise 2020.

Undo the reconciliations isn't' an option, I have thousands of transactions from July 2019 to Feb 2020, I know I can fix the opening balance but there should be an easy way to do this....

Any help is appreciated

 

    2 replies

    L
    LauraAB
    June 18, 2020

    Hello again garbia,

     

    Welcome back! It seems from your first sentence of this post that you may have solved the issue you were having with your transactions and reconciliations, which is awesome! I'd like to take a moment to shed some light on what you've mentioned here so you have a sense of what's happening in QuickBooks Desktop Enterprise.

     

    Recreating a transaction that was previously reconciled and then going into the account register to put the check mark is the first step in approaching these situations. This check mark in QuickBooks Desktop is effectively the same thing as putting the R beside a transaction in the account register in QuickBooks Online.

     

    That being said, completing that task doesn't always do the trick. The beauty of QuickBooks Desktop is you can undo a reconciliation back to the point where things were balanced and then move forward again, and this often solves these kinds of hiccups in your books. I can appreciate how having thousands of transactions would make this a daunting task and would take up a large chunk of your time, so I'm glad to hear that a mini-reconciliation seems to have solved this for you.

     

    Feel free to share more details about what you did for the mini-reconciliation to help others who may be in the same boat. If you are still needing a hand with the reconciliation issue, please let me know. I'm here to help. :)

      H
      High Voltage
      April 13, 2021

      I can't find the account register to mark it R manually.  Ive found the transaction but no where to mark it off.  Someone deleted 7 transactions AFTER reconciliation, so it looks like i have to put them back in and then mark as reconciled,,,but I find figure out how to mark it that way. 

      L
      LauraAB
      April 13, 2021

      Hello High Voltage,

       

      Welcome to this thread, and thanks for taking a moment to explain a bit about what's going on with your books. I can definitely see how transactions being deleted post-reconciling would negatively impact your books, and it sounds like you're on the right track to fix it by recreating the transactions and then manually reconciling them. I can help you with this.

       

      Since you mention that you're looking to manually change the transaction status to R in your account register, it sounds like you're potentially using QuickBooks Online. If that's the case, navigating to the account register is as simple as selecting the Accounting tab from the left menu and then Account history for the account in question. That'll bring you to the account register, where you'll see a column that has a checkmark as the header. Here's an example from a test account of what that looks like.

       

       

      I've circled the column in green for emphasis. When you click that column for a transaction, the status of the transaction will change. The C denotes "cleared" and the R means "reconciled." Once you see R for your transactions, you should be good.

       

      If you do happen to be using QuickBooks Desktop, the process for getting to the Chart of Accounts is a bit different and there are a few ways to get there, including using the keyboard shortcut CTRL + A. You can then double-click the account in question to bring up the register and then use the checkmark column there to change the status. However, QuickBooks Desktop also gives you the opportunity to undo the reconciliation entirely, which, depending on how many transactions you have overall, may be easier. Our article Reconcile an account in QuickBooks Desktop touches on that option if you'd like to explore that.

       

      I hope this has been helpful. If you'd like any clarification, don't hesitate to ask in a reply. I'm here to help. :)

      W
      Waypoint2
      April 26, 2022

      I know it's been awhile since your post but I have exactly the same problem but over a longer span of time and redoing all reconciliations are not an option. Please tell me how you successfully did a mini-reconciliation?

      J
      JamesM4
      April 26, 2022

      Hello Waypoint2. Thanks for chiming in on this thread. To make sure we're both on the same page, are you using QB Online, Desktop, or Self-Employed? 

      Terms & ConditionsAccessibility statement