How to Remove Duplicate Expense Entries from a Closed QuickBooks Year

Duplicate expense entries happen when the same cost is recorded twice in QuickBooks. This can overstate expenses on the profit and loss statement and leave uncleared payments on the balance sheet. We suggest correcting the mistake with a few careful steps.

Understanding duplicate expense entries

A duplicate entry occurs when the same transaction is entered more than once in QuickBooks. We often see this happen when a check payment is recorded and then an expense bill is created for the same amount. The software treats each entry as a separate transaction, which doubles the impact on reports.

Impact of duplicate entries on your reports

When an expense is duplicated, the profit and loss statement shows higher expenses than actually incurred. This overstatement reduces net income on the report. On the balance sheet, the duplicate creates an uncleared payment that appears as money leaving the bank. If the year is closed, the uncleared payment stays on the sheet until you adjust it.

Steps to clear duplicate payments from a closed year

Follow these steps to remove the duplicate amount from a closed year.

1. Locate the duplicate expense transaction or the uncleared payment in the register.
2. Note the amount and the accounts involved (usually the expense account and the bank account).
3. Create a new journal entry dated the last day of the closed year.
4. Debit the expense account and credit the bank account for the noted amount.
5. Save the journal entry and run a trial balance to verify the correction.
6. Check the profit and loss and balance sheet to confirm the duplicate is removed.

Preventing future duplicate entries

To stop duplicate entries, establish a clear workflow for recording expenses. Enter each transaction only once, either as a check, a bill, or an expense, but not more than one of these. Use the bank feed or reconciliation process to match payments to existing entries before adding new ones. Regularly review reports for unusual spikes in expenses that may signal a duplicate.