Troubleshooting: Fixing Duplicate Transaction Numbers

Learn why duplicate transaction number errors occur in QuickBooks Online (QBO), how to correct the numbering sequence, and what to consider before changing existing transaction numbers.

If you're reading this page, you most likely had custom transaction numbers turned on at some point and may now be coming to the conclusion that they're not worth it. If you're on the fence, please read our CEO's treatise on why custom transaction numbers should never be used in QuickBooks: 📄 Custom Transaction Numbers in QuickBooks

Why Duplicate Transaction Number Errors Occur

When Novi encounters an error related to a document or transaction number, it typically means the number Novi is trying to use for an invoice or sales receipt already exists in QuickBooks Online.

QuickBooks does not allow Novi to create a transaction using a document number that is already in use, so the transaction cannot be completed.

This can happen when:

• An invoice or sales receipt number was manually changed in QuickBooks

• A transaction was created using a number outside the normal sequence

• Custom Transaction Numbers are or were previously enabled in QuickBooks

For example, Novi may attempt to create a new transaction using the next number it expects to be available, but that number may have already been used by another invoice or sales receipt in QuickBooks.

Before Changing Existing Transaction Numbers

If duplicate transaction numbers already exist in QuickBooks, first consider whether the historical transactions actually need to be changed.

Use the search feature in QuickBooks to determine the scope of the issue. Are there only a few duplicates, or are there hundreds or thousands?

Also consider whether the affected invoices have already been sent to customers or members. In some cases, leaving historical transactions as they are and starting with a new numbering sequence may be the better option.

Option 1: Start Fresh with a New Transaction Number

If the goal is simply to correct the numbering sequence going forward, start with a new transaction number that has not previously been used.

For example, if the current sequence is around 1456 but there are conflicting numbers, you might choose to start a new sequence at 2000.

In QuickBooks Online:

1. Turn on Custom Transaction Numbers in your QuickBooks settings.

2. Create a temporary invoice.

3. Enter the new starting transaction number you want to use. Make sure the number has not already been used.

4. Save the invoice.

5. Turn off Custom Transaction Numbers.

6. Create another new invoice.

7. Confirm that QuickBooks assigns the next number in the new sequence.

8. Delete or void the temporary invoice if it is no longer needed.

QuickBooks should now continue using the corrected numbering sequence for subsequent transactions.

Option 2: Change Existing Transaction Numbers

If you've determined that existing duplicate transaction numbers need to be corrected, you can update them directly in QuickBooks.

1. Turn on Custom Transaction Numbers in your QuickBooks settings.

2. Open the invoice that needs a new transaction number.

3. Update the transaction number to a unique number.

4. Save the invoice.

5. Repeat for any additional transactions that need to be corrected.

Once you're finished, consider turning Custom Transaction Numbers back off so QuickBooks can automatically maintain the numbering sequence going forward.

Preventing Future Duplicate Transaction Numbers

To reduce the chance of this happening again:

• Avoid manually changing invoice or sales receipt numbers unless necessary.

• Avoid using numbers outside the normal transaction sequence.

• Keep Custom Transaction Numbers turned off unless your organization has a specific need for them.

• If you need to reset the sequence, use a temporary invoice to establish a new starting number and confirm the sequence before continuing.

For more information about this QuickBooks setting, see: 📄 Custom Transaction Numbers in QuickBooks