Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
Chris_is_BNANL
Level 1

Duplicate sales transactions reduces net total sales

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? 

1 Comment 1
TrixieD
QuickBooks Team

Duplicate sales transactions reduces net total sales

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.

 

  1. Navigate to the Banking tab.
  2. Go to the Posted section and locate the transaction.
  3. 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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us