Skip to main content
B
buckinghamjoiner
January 17, 2023
Question

How do you remove wrong transactions that have not been reconciled from the chart of accounts?

  • January 17, 2023
  • 1 reply
  • 0 views
these transactions are purchases made with paypal that were paid from my personal account. due to a bad rule they were auto added to the business bank account in quickbooks. I have reconciled my bank account but now need to void or delete all the se transactions from the chart of accounts. obviously none have been reconciled.

1 reply

G
GeorgiaC
January 17, 2023

Hi buckinghamjoiner, if the transactions were added in via a connected bank feed, you can remove these easily by navigating to banking > categorised > tick the checkbox to the left of the transaction(s) > undo. This will move the transactions back to the for review tab, where they will no longer be posting in QuickBooks, and you can batch-tick from here to exclude and remove. If the transactions were created manually, you would need to delete these individually from within the Chart of Account by clicking the drop-down beside the transaction > delete. 🙂

B
buckinghamjoinerAuthor
January 17, 2023

Thank you. when I was doing the bank reconciliation I left these incorrect transactions unticked and when all the correct transactions had been reconciled and the difference was zero I clicked finish and went to the next month. The unticked items still appear in the reconciliation list. All these transactions are similar to the 2 in the screen shot. The auto added item will undo. If try to undo the item below I get a message saying it has been reconciled and to undo it might unbalance my reconcilition?

R
RCV
January 17, 2023

Thanks for coming back and providing us a screenshot to better isolate the issue in reconciling your bank account, buckinghamjoiner.

 

We can manually unreconciled the transaction to remove them from the Reconciliation page in the Chart of Accounts. Even small changes can unbalance your accounts. We can only unreconciled one transaction at a time to minimise the impact. When you know what you need to change, here's how to edit and unreconciled the transaction:

 

  1. Go to Bookkeeping.
  2. Select Chart of accounts.
  3. Find the account holding the transaction and click Account history.
  4. Choose the transaction you want to unreconciled to expand the view.
  5. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  6. Tap the checkbox. This changes the letter in the box. Keep selecting it until the box is blank. This removes the transaction from the reconciliation.
  7. Press Save.
  8. Close the account history.

 

Just follow the same steps to unreconciled multiple transactions. For future reference, check out this article for more details: Undo or remove transactions from reconciliations in QuickBooks Online. On the other hand, when excluding a transaction, it will not appear in any account registers or financial reports. Depending on the type of transaction, this may make it easier or harder for you to reconcile an account. To know a couple of situations to consider, go to Step 1: Review the account section in this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

I'm adding a link that covers everything you need to know about the reconciliation process: Learn the reconciliation workflow in QuickBooks.

 

There you go. Your records should now be in tip-top shape. Keep me posted if you have any clarifications or questions. Please know I’m here to answer them for you.

Terms & ConditionsAccessibility statement