Undo or remove transactions from reconciliations in QuickBooks Online

      Comments Off on Undo or remove transactions from reconciliations in QuickBooks Online

Later on, you find out that something has changed or was missed and now you need to go back in and undo that reconciliation in order to make adjustments. You’ve gotten to a zero balance and you complete the task by reconciling your account. If you know which entry you need to change, you can edit the transaction by clicking the Gear icon at the top of the page and the Chart of Accounts tab under the Your Company column. 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. Many or all of the products featured here are from our partners who compensate us.

  • Once you have your statement in hand, you can begin the process of reconciliation.
  • On the far right, you will see the options mentioned above.
  • Any transactions that were marked as reconciled during a reconciliation were necessary to reconcile the books to the bank statement.
  • Be aware that you will lose any other work you have saved since that backup.

When done correctly, it also helps you prevent fraud in your business. Once done, you can start undoing the 2 months reconciliation. You can either invite an accountant to perform the process or edit the individual transactions manually. Keep in mind, even small changes can unbalance your accounts.


Accountant users can undo an entire reconciliation; so if you’re working with an accounting professional, contact them if you need to undo entire reconciliations. On the QuickBooks desktop application, you can undo an entire reconciliation in a single step. However, QuickBooks Online users have to reconcile each transaction one at a time. QuickBooks Online will automatically check transactions entered using the bank feed feature on the reconciliation screen. If your filters are set up incorrectly, you could reconcile a transaction that hasn’t cleared the bank yet, causing problems down the line.

One of the most common errors with reconciliation is when the bookkeeper incorrectly enters the opening or closing balance. Carefully review the opening balances financial statements and closing balances for errors. Don’t confuse the accountant view with accessing the company in a QBO Accountant’s account – they are not the same thing.

Reasons to undo reconciliation in QuickBooks Online

Or sometimes the beginning balance or ending balance on the account for the period you’re reviewing was entered wrong. We recommend reviewing your opening, beginning, and ending balances first to be sure you’ve ruled out any possible errors. If your firm uses QuickBooks Online Accountant, you have a special reconciliation tool. When one of your clients needs to edit or undo several transactions on a past reconciliation, it’s sometimes best to start over from scratch. You are able to undo their entire reconciliation and get a fresh start.

This allows you not to miss recording any activity that happened at the bank and highlights if you’ve recorded anything in duplicate. The practice of reconciling bank accounts helps you keep track of your cash flow so that you know the details of how money is being received and spent. You’re working on reconciling your accounts because a bank or credit card statement came in. You’ve gone through and adjusted what needed to be adjusted and it’s time to reconcile and close. QuickBooks Online is pretty reliable, but as with any software, human slip-ups can cause errors. Thankfully, there are QuickBooks apps that can help with this, but more on that later.

You’re our first priority.Every time.

Please remember, I’m always here for any other questions or concerns. Sure, but that would be quite cumbersome to do, especially if there were a number of transactions for the period. Keep in mind that discrepancies should be dealt with immediately to avoid problems later on. Reconciliation performed in every area will safeguard against incorrect reporting and make tax time easier. If you feel paperless is better, you can save a PDF of the reconciliation to a folder on the cloud. Additionally, it will be saved in your QBO account and is easily accessible.

When you come across duplicate transactions in QuickBooks Online (QBO), there are two ways to handle them. If you choose to exclude a transaction, it won’t show up again in the bank feeds. However, if you delete it, QBO will recognize it as missing and download it again. I’d recommend that you exclude duplicates to avoid any reconciliation issues. QuickBooks Online makes reconciliation very easy. Sometimes, this ease of use can cause you to make an error that results in having to undo the reconciliation.

Undo a client’s reconciliation in QuickBooks Online Accountant

Let’s look at four common reasons why you might have to undo reconciliation in QuickBooks Online. Even then, you’ll likely only reconcile non-bank accounts once a year, as in an inventory reconciliation. From time to time, it is necessary to undo reconciliation. This could be a reconciliation you’ve just completed, or it could be a reconciliation from a previously closed month. This is the first reconciliation since migrating to QB Online and my beginnig balance for my reconciliation is not correct.

Many times, QBO will choose a category automatically and you can make rules that assign similar transactions to the same category. Once all of your transactions are downloaded, you are ready to begin matching or adding. QuickBooks Online uses a series of options, including matching, adding, or transferring. Matching means there is a corresponding invoice or sales receipt that goes with the expense or deposit. Adding is used when an expense needs to be categorized.

Restore a backup for whole reconciliation

Highlight the transaction, click Edit and untick the Bank rec. When you return to the transactions page, you should see ‘N’ to indicate that the transaction is not reconciled. Secondly, if you only wish to unreconcile specific transactions you can unflag them.

If you see issues in the middle of your reconciliation, here’s what you should review. This is not applicable to undoing a reconcile. 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.

There are two ways to reconciling an account. 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 balance. Second, reconciling through the reconcile page where it creates a reconciliation history report that shows each transaction included. Even a minor error can completely unbalance your accounts, and unreconciling and re-reconciling your company files can slow down your workflow and reduce your productivity.

To ensure you’re able to use the UNDO reconciliation option in QuickBooks Online Accountant, we might need to look over the account if we’re using the Accountant version. With this, let’s consider manually removing your transactions from reconciliation to undo them. When it comes to the pop-ups about purchasing products, this is a way to introduce new features and enhancements for users like you, our valued customer.

You can follow the steps shared by my colleague LieraMarie_A above. Visit this article to learn more ways to reconcile previously deleted and re-entered checking or credit card transactions in QuickBooks. You can only unreconcile one transaction at a time. If you need to start over, I’d suggest reaching out to your accountant. They can undo the entire period at once using QuickBooks Online Accountant. I was able to unreconcile the entire month by going to the Accounting tab then to Chart of Accounts  then to Reconcile.