Yes, you can delete a duplicate sales receipt sitting in undeposited funds in QuickBooks Online, even if the month it landed in has already been reconciled. Since the duplicate never made it into a bank deposit, it never picked up an R in your register, which means it was never actually part of that reconciliation.
Why the duplicate didn't affect your reconciliation
The undeposited funds account is a temporary holding spot. It collects sales receipts and invoice payments until you combine them into a bank deposit that matches what actually hits your bank statement. A transaction only gets marked R (reconciled) once it's part of a deposit you've matched against a bank statement during reconciliation.
Because your duplicate sales receipt from Square never got swept into a real bank deposit, it sat in undeposited funds on its own, unreconciled. That's exactly what an empty checkmark column tells you.
Managing your undeposited funds account
How to delete the duplicate
- Go to the Chart of accounts and open the register for your undeposited funds account.
- Find the duplicate sales receipt and confirm the checkmark column is blank, not marked R or C.
- Open the transaction and delete it.
If you ever come across a duplicate that does show an R, don't delete it yet. Removing a reconciled transaction changes the beginning balance for your next reconciliation, so you'll want to unreconcile it first, then delete it, then reconcile the account again.
Undo or remove transactions from reconciliations in QuickBooks Online
What changes after you delete it
Deleting the duplicate removes the extra amount sitting in undeposited funds, and brings your income back down to what you actually earned. If that sales receipt included inventory items, deleting it also corrects your inventory and cost of goods sold.
Double-check your reconciliations still balance
Since the duplicate was never reconciled, deleting it shouldn't throw off any of your completed bank reconciliations. But it's worth confirming: the next time you reconcile that bank or credit card account, check that your beginning balance still matches the ending balance from your last reconciliation. If it's off, QuickBooks will flag it and walk you through the Reconcile Discrepancy Report, which shows exactly what changed and when.
Resource: Fix beginning balance issues when reconciling in QuickBooks Online
Have more questions about cleaning up undeposited funds or Square imports in QuickBooks Online? Just ask below.
