cancel
Showing results for 
Search instead for 
Did you mean: 
Steve11979
Level 2

How do I resolve a duplicate expense that's been reconciled?

I ran a payroll for an employee that created the normal payroll expense. A co-worker paid that expense by creating a check in QB, which in turn created another expense for the same pay period in QB. I tried to zero out the duplicate expense, but it took my Checking account out of being reconciled. How can I eliminate the duplicate expense without affecting the Checking account reconciliation?

Solved
Best answer January 19, 2021

Best Answers
DivinaMercy_N
Moderator

How do I resolve a duplicate expense that's been reconciled?

The Community has got your back, @Steve11979.

 

I can share options so you can fix your reconciled transactions. First, you can manually reconcile the payroll that equals the amount of the deleted expense. To do so, follow these easy steps:

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Look for the account that affects the transaction.
  3. Click View register and find the transaction you need to reconcile.
  4. Under the Reconcile column, click the blank field to mark the transaction "R" (reconciled).
  5. Hit Save and tap Yes

 

Another option is to consult your accountant and request to undo the reconciliation. They use a specific tool to batch undo the transactions on your account. If you don't have one, you can use the Find a Pro-Advisor tool to look for an accountant near your area. 

 

For your reference, please visit our Reconciliation hub


When the reconciliation is done, you can pull up a reconciliation report to have a summary of your beginning and ending balances and lists of cleared and uncleared transactions in QBO. 

 

Don't hesitate to post here again if you have further questions about this. I'm always around to help you have a good one. 

View solution in original post

4 Comments 4
Ryan_M
Moderator

How do I resolve a duplicate expense that's been reconciled?

Hi @Steve11979,

 

I'll share insight on your situation about a duplicate expense transaction in QuickBooks Online (QBO).

 

I suggest you undo the steps you took earlier to zero out the duplicate expense. After that, you can directly delete the duplicate transaction to fix your situation. 

 

Here's how:

 

  1. Go to the Expenses tab.
  2. Search for the expense transaction.
  3. Click the drop-down menu beside the View/Edit link under the Action column.
  4. Select Delete.

 

You can then follow the steps in this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online. It's a detailed guide on how you can fix the online bank accounts you've reconciled before. 

 

Let me know if you have other questions about reconciliation in QBO. I'll be sure to take care of them. 

Steve11979
Level 2

How do I resolve a duplicate expense that's been reconciled?

I deleted the transaction and it caused the account to not be reconciled. I followed the instructions you provided. Attached is what shows in the discrepancy report. Not sure how to resolve this. Recreating the Expense will duplicate payroll. 

 

Thanks,

Steve

DivinaMercy_N
Moderator

How do I resolve a duplicate expense that's been reconciled?

The Community has got your back, @Steve11979.

 

I can share options so you can fix your reconciled transactions. First, you can manually reconcile the payroll that equals the amount of the deleted expense. To do so, follow these easy steps:

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Look for the account that affects the transaction.
  3. Click View register and find the transaction you need to reconcile.
  4. Under the Reconcile column, click the blank field to mark the transaction "R" (reconciled).
  5. Hit Save and tap Yes

 

Another option is to consult your accountant and request to undo the reconciliation. They use a specific tool to batch undo the transactions on your account. If you don't have one, you can use the Find a Pro-Advisor tool to look for an accountant near your area. 

 

For your reference, please visit our Reconciliation hub


When the reconciliation is done, you can pull up a reconciliation report to have a summary of your beginning and ending balances and lists of cleared and uncleared transactions in QBO. 

 

Don't hesitate to post here again if you have further questions about this. I'm always around to help you have a good one. 

Steve11979
Level 2

How do I resolve a duplicate expense that's been reconciled?

Thank you! That was it. I made the mistake of not manually reconciling the payroll.

Need to get in touch?

Contact us