Solved

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

Forum|Forum|5 years ago
January 19, 2021
1 reply
0 views

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?

QuickBooks Online

Best answer by DivinaMercy_N

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:

Go to the Gear icon and select Chart of Accounts.
Look for the account that affects the transaction.
Click View register and find the transaction you need to reconcile.
Under the Reconcile column, click the blank field to mark the transaction "R" (reconciled).
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.

R

Ryan_M

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:

Go to the Expenses tab.
Search for the expense transaction.
Click the drop-down menu beside the View/Edit link under the Action column.
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.

S

Steve11979Author

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_NAnswer