A negative balance where none should exist is one of the clearest signals that something is wrong in the books. Duplicates quietly inflate income or expenses until a reconciliation fails. Both are fixable once you know what to look for. This article focuses on diagnosing and correcting them. For a wider cleanup process, see our QuickBooks Online cleanup checklist. Menu names vary by version.
Why duplicates happen
- A transaction was entered manually and then also pulled in through the bank feed.
- A bank feed connection was reset and re-imported past transactions.
- An invoice or bill was entered twice by different users.
- A payment was recorded as both a deposit and a customer payment.
- A CSV or spreadsheet import was uploaded more than once.
- A transfer was recorded in both accounts as separate income and expense.
How to find duplicates
- 1Sort the transaction list by amount and date, and look for matching pairs in the same account.
- 2Compare the register to the bank statement line by line for the suspected period.
- 3Run a reconciliation. Differences equal to one transaction's amount point to a duplicate.
- 4Check the audit log for repeated entries by the same user or import.
- 5Look at unusually high income or expense categories that exceed what you expect.
How to remove them safely
- Confirm the second entry really is a duplicate and not two legitimate transactions.
- Delete or void the duplicate, preferably the one not matched to the bank feed, and add a note.
- If the period was already reconciled, un-reconcile or follow your accountant's guidance, since deleting a reconciled item will break the reconciliation.
- If the period is closed or filed, ask your accountant before changing it. A correction may require an amended return.
- Re-run the reconciliation afterwards.
Negative bank or cash balance
A book balance below zero in a bank account usually means a deposit is missing, an expense was recorded twice, or an opening balance was wrong. Check recent deposits against the statement and look for payments recorded from the wrong account. Do not fix it by recording a plug deposit.
Negative inventory
Negative quantity on hand typically means sales were recorded before the related purchase, a purchase was never entered, or a quantity was entered incorrectly. Enter the missing receipts with correct dates, then reconcile quantity to a physical count. Inventory affects cost of goods sold and therefore taxable profit. See cash vs accrual accounting.
Negative accounts payable or receivable
- Negative payable: a bill payment that exceeds the bill, a duplicate payment, or a vendor credit that was never applied.
- Negative receivable: a customer overpayment or an unapplied credit memo.
- Resolve by applying credits to open items, or by recording a refund or a vendor/customer credit properly.
Negative sales tax payable or equity
- A negative sales tax balance can mean you remitted more than you collected, or recorded a payment twice. Match it to filings. See sales tax filing services.
- Negative owner equity may be legitimate if draws exceed contributions and profit, but confirm that draws are not misclassified expenses.
- Check that Opening Balance Equity is zero.
Prevent them
- 1Choose one source for each transaction: either the bank feed or manual entry, not both.
- 2Record transfers as transfers.
- 3Reconcile monthly and review the audit log.
- 4Limit who can import or edit transactions.
- 5Review bank rules so they do not create duplicates.
If you are tangled in errors, see bank reconciliation problems and bookkeeping cleanup services. Our bookkeeping service includes error tracing and correction. To discuss your bookkeeping cleanup, tell us which account shows the negative balance and for which period.
