These are denoted by an R (a C indicates the transaction was matched or entered via bank feeds, but it hasn’t been reconciled through the reconciliation process yet). First, manually changing the status in the bank’s register. Doing this causes the Reconcile feature not to detect the date when it was reconciled but affects the opening total budgeted cost definition balance. Second, reconciling through the reconcile page where it creates a reconciliation history report that shows each transaction included. I was able to unreconcile the entire month by going to the Accounting tab then to Chart of Accounts  then to Reconcile. Then I just used the arrow next to view report and clicked Undo.

  • This allows you not to miss recording any activity that happened at the bank and highlights if you’ve recorded anything in duplicate.
  • Carefully review the opening balances and closing balances for errors.
  • If you need to undo reconciliation for a larger amount of past transactions, it might be easier to start from scratch.
  • I’ve included some steps to unreconcile both ways below.
  • This is the most ridiculous pile of dog doo-doo I’ve ever heard.

Now, click on the Reconcile button at the top right corner of the Bank Register screen. To resolve this, make sure to choose the correct ending date in the reconciliation window. You’re always welcome to post again here and ask any other questions about managing your reconciliation.

Step 5: Review the beginning balance

By following the above-mentioned steps, it is very simple to undo the bank reconciliation process. These are the common steps which can be performed in the latest versions of QuickBooks Online. You’re working on reconciling your accounts because a bank or credit card statement came in.

Usually, reconciliation signals all the information in your books has been verified against an outside source and the books are ready to be closed for the month. In other words, reconciliation is typically final. To undo a reconciliation the user has to change the R in the status column of the transaction in the bank register to a C or leave the it blank. The above instructions allow a user to re-do a reconciliation rather than undo a reconciliation. Unless the status for each transaction is changed in the register they will not appear as available for reconciliation.

Reasons for undoing a reconciliation in QuickBooks Online

After you’ve adjusted the opening balance, you can begin reconciling the next month’s bank statement. I also wanted to include additional information about resolving issues at the end of reconciling. Check out Fix issues at the end of a reconcile in QuickBooks Online to review this information. However, that might affect the beginning balance since that amount is usually the statement ending balance from the previous reconciliation. There’s also a column in the Reconciliation screen where you can see all the payment transactions. One of the most common errors with reconciliation is when the bookkeeper incorrectly enters the opening or closing balance.

Considering that, you don’t have the Undo option under the Action column on the Reconciliation page. If you have an accountant, you may invite them to your company so they can accomplish this task on your behalf. Remember, after undoing a previously reconciled transaction, you may need to re-reconcile to keep your books accurate. Also, it’s always a good idea to consult your accountant or financial advisor before making these changes. You can go to the bank’s register to add either a journal entry, transfer, expense, refund, bill payment, receive payment, sales receipt, deposit, or a check. You can also get transactions from your bank or credit cards and manually import them into QuickBooks Online.

Related Posts on Redmond Accounting CA

Here is a list of our partners and here’s how we make money. I do appreciate you for doing the steps my colleagues provided, pirraglia. Moreover, you can open this link to know more about modifying the account’s opening balance.

Step 9: Review the reconciliation report

Once the above steps are done, now you can reverse the bank reconciliation process in QuickBooks Desktop. However, if you only need to undo reconciliation for several transactions, it’s possible to do so manually, one transaction at a time. Since you mentioned above that you’d be undoing a reconciliation for several months, you should keep in mind that you must begin with the elderly months.

The month-end closing process can seem tedious and daunting to many small business owners. Thankfully, learning how to reconcile in QuickBooks Online to close your books can help ease that burden. QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts. In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.

Let me provide the steps on how you can undo a reconciled period in QuickBooks Desktop (QBDT). You may also consider looking for an accountant to Redo the reconciliation process. I’d be glad to assist you with unreconciling previous statements so they will not throw off your records. Undoing a Reconcile is an accountant only feature, as you stated. The reason for this is so It’s not done accidentally. If a user was to accidentally undo a reconcile it could put them back for a lot of work they’ve put in.


I’ll provide details on how reconciliation works in your version of QuickBooks Online. Feel free to visit our Banking page for more insight s about managing your bank feeds transactions. Ask questions, get answers, and join our large community of QuickBooks users. Learn how to unreconcile an individual transaction from a completed reconciliation. Now, open the register for the account you are un-reconciling by hovering over Accounting on the left-side toolbar and then selecting Chart of Accounts. When the Chart of Accounts appears, click View Register.

When you need to restore your data in a hurry, automated cloud backup solutions such as Rewind act as an undo button for businesses using QuickBooks Online. @Maybelle_S  Hello,  I need to unreconcile my January 2021 bank statement. I fear will throw off every single bank reconciliation report from that point forward. I do not want to unreconcile EVERY SINGLE transaction in EVERY SINGLE month’s report. Is there no way to unreconcile the entire report with a click of a button in QB online? If you’ve identified any errors on the statement, contact your financial institution at once so they can investigate.

How to unreconcile a monthly statement that has already by reconciled?

To have a better overview of a company’s purchases, save time and minimize human errors while buying, numerous businesses choose to integrate procurement and accounting systems. During the month of June I accepted a transaction from the bank matching it incorrectly to a vendor’s check when indeed it was an ACH transaction for another company. I ran the reconciliation for June with this transaction matched incorrectly and now discovering it, I’m not sure how to proceed. Alternatively, you can invite an accountant to help you unreconcile the transactions. I’d be happy to help you unreconcile your past bank reconciliations so they don’t throw off your records, akrill.



No responses yet

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments
    Header BG
    Welcome to SecMyIT
    Open chat
    Chat on WhatsApp
    How we can help you?