Skip to main content
February 18, 2023
Question

An error QB made in duplicating an expense

  • February 18, 2023
  • 1 reply
  • 0 views

QB duplicated an expense on two dates in 2022.  Unfortunately it was for a Contractor and now the 1099 is incorrect.  I sent in the required form to the irs but now, even though I have voided the extra charges, it keeps showing up in the Contractor total in my p&l.  How can i eliminate these extras to they do not show up in the total?  I am losing my mind trying to figure it out!

Thanks

1 reply

February 18, 2023

I'm here to show you how to delete duplicate transactions in QuickBooks Online, @Sunsh1ne.

 

Let's start by verifying the duplicate expense by producing a report for those categories. This is to prevent you from erasing the actual transaction. I'll show you how to:

 

  1. Select the Gear icon and choose Chart of Accounts.
  2. From there, look for the categories where the duplicate expense is assigned. Click the Run report link.
  3. Check the duplicate expense.
  4. Once ready, follow the outlined steps below to delete the transaction.

 

If this entry was made manually, all you need to do is open the transaction, choose Details, and then click the Delete button. For a visual reference, refer to this screenshot:

 

Otherwise, if this transaction was retrieved from your bank feeds, you only need to uncategorize and exclude it. You can now delete it after it has been excluded.

 

Here's how:

  1. Navigate to the Banking menu (if you're in the Accountant view) and select Banking.
  2. From there, select the bank account where the expense is belong.
  3. Then, go to the Categorized tab.
  4. Look for the duplicate expense and click Undo.
  5. Next, go to the For review tab and check the box for the duplicate expense.
  6. Choose Exclude
  7. Then, go to the Excluded tab, check the box of the expense again and select Delete.

 

Please read this article for more details on handling expense transactions in QBO: Enter and manage expenses in QuickBooks Online.

 

To view all of the actions you took in your QBO account, you can run the Audit log report. Also, this is useful if you need to recreate some erased entries.

 

Let me know if you have additional questions about deleting duplicate transactions. I'm always here to help. Have a great day.