Duplicate sales transactions reduces net total sales

Forum|Forum|4 months ago
March 3, 2026
1 reply
8 views

I'm looking at my 2025 Sales Transactions report, and there are a few items that show up twice. I realize the ones that show up twice are ones where I created an invoice through QB and emailed it to the clients for payment (ACH payments). My banks are connected to see transactions go in and out.

So now, I have those items show up twice in the sales transaction report. But for some reason, one of each is having it's value be deducted from the total of the sales transactions. My P&L report appears to be right, but the sales transaction view does not show the correct total of sales.

What's going on?
How do I figure out which is the duplicate, and how do I fix them - just delete or?

QuickBooks Online

TrixieD

QuickBooks Team

Hello there, Chris. When you send an invoice, and the client pays via ACH, QuickBooks automatically creates a payment. Since your bank is connected, duplicates can happen if the payment is being added instead of matched.

The Profit and Loss (P&L) report remains intact because those entries are not posted as income. However, it will affect your sales transaction report.

To figure out the duplicates, you don’t have to delete them. You can undo those entries in your Bank page.

Navigate to the Banking tab.
Go to the Posted section and locate the transaction.
Click Undo in the Action column to move it back to the Pending tab.

Once done, you can match the payment and reconcile your accounts to ensure that your QuickBooks balance accurately matches your books.

Notify here if you need more help. We’re here to help.

Sign up

Login with SSO

Let's get you signed in

Login with SSO