Simplify payday and set payroll to run automatically on QuickBooks.

Green Circle Icon with Stylized White Letters
QuickBooksHelpIntuit

Find duplicate transaction numbers

by Intuit • Image Alt Text 101
Image Alt Text Updated 8/5/2026 01:53

Learn how to find duplicate transaction numbers in QuickBooks Online. This way, if you've accidentally used the same number twice, you can edit your transaction numbers.

icon of an agentIf you need help using QuickBooks, you can partner with a dedicated bookkeeping expert to feel more confident. Find out more about QuickBooks Live.

Check your expenses for duplicate transaction numbers

Here’s how to find your expense transactions with duplicate transaction numbers.

  1. Go to All apps A bunch of numbers and letters on a tile wall., then Expenses & Bills, then Expense transactions (Take me there).

  2. Select the NO. column to sort your transactions.

  3. Check for duplicates.

Run a vendor report

You can run a vendor report to have a clear view of all your expenses.

  1. Go to Reports Icon image of the Reports menu., then Standard reports (Take me there).

  2. Enter Transaction List by Vendor in the search field.

  3. From the Report period dropdown menu, select All Dates.

  4. Select Run report.

  5. Select Sort▼.

  6. From the Sort by▼ dropdown menu, select Num. Then select Ascending order or Descending order.

You’ll see a list of your bills, checks, expenses, and other expense transactions listed in numerical order.

Check your sales for duplicate transaction numbers

Here’s how to find your sales transactions with duplicate transaction numbers.

  1. Go to All apps A bunch of numbers and letters on a tile wall., then Sales & Get Paid, then Sales transactions (Take me there).

  2. Select the NO. column to sort your transactions

  3. Check for duplicates.

Run a customer report

You can run a customer report to have a clear view of all your sales transactions.

  1. Go to Reports Icon image of the Reports menu., then Standard reports (Take me there).

  2. Enter Transaction List by Customer in the search field.

  3. From the Report period dropdown menu, select All Dates.

  4. Select Sort▼.

  5. From the Sort by dropdown menu, select Num. Then select Ascending order or Descending order.

You’ll see a list of your invoices, sales receipts, and other sales transactions listed in numerical order.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

Sign In / Sign Up