Good day, @matt244. I'm here to provide some insights why QuickBooks Online (QBO) prompts you that you've already used an invoice number when creating invoices.
By default, you would only receive this prompt when two or more invoices have the same invoice number. This prompt only occurs once, and you can proceed sequentially entering invoice numbers for new invoices. It would help us if you could provide a screenshot or more details of the issue you've encountered.
For now, I recommend searching for the invoice transaction using the invoice number at issue to check if an invoice transaction exists. If you've found transactions with the same invoice numbers, you may perform the necessary actions of editing or deleting them. Also, I suggest temporarily turning off Custom transaction numbers in your sales settings and running a sample invoice to help us further isolate the problem. If you encounter the same, I suggest performing browser troubleshooting steps.
This article on matching bank deposits in QuickBooks by combining multiple transactions into a single record might come in handy for you in the future. I'm adding this as a reference: Record and make bank deposits in QuickBooks Online.
You're always welcome in the QuickBooks Community should you have further updates on the issue of invoice numbers. Take care.
I am having the same problem. In my case, I tried to copy a new invoice over from Harvest, which failed. So I created the invoice manually in QBO. Now QBO says the next invoice number (which would have been copied from Harvest) is already taken. However, when I look at the list of invoices in QBO, no such invoice exists. So where is it? There are now a couple of hidden invoices in QBO?
Thank you for bringing this issue to our attention. I understand the frustration of encountering discrepancies with invoice numbers. I'm here to assist you with the discrepancies invoice numbers@jason192 .
Have you already tried the troubleshooting steps recommended by my colleague? This issue may be related to your web browser. It is recommended to clear your browser's cache and cookies or try accessing QuickBooks Online from a different browser or device.
By default, QuickBooks Online generates invoice sequence numbers starting from 1001. Additionally, QuickBooks Online automatically detects if there is already an existing invoice with the same number. I suggest checking the audit log in QuickBooks Online to see if the invoice was created but is not visible in the list of invoices. The audit log provides valuable insights into changes or actions that have occurred within your QuickBooks Online account.
Here's how:
Go to the Gear icon.
Choose Audit Log.
From the Filter drop-down, choose the appropriate User, Date, and Events filter.
It turns out the problem was that my bookkeeper had created "credit memos," and the numbers assigned to those credit memos were also treated as *invoice numbers* within QBO. However, searching for those numbers, including using various versions of advanced search, would not show them. They didn't show up under invoices or transactions. I had to know that I needed to look for a credit memo, before performing a search uncovered them.
So this was a confusing waste of a couple hours of my time, since QBO decided a credit memo and an invoice are the same but credit memos are somewhat hidden.
How do I find the duplicate invoice number? I can't find a report to let me do this to change one and my HELP doesn't work in my Quickbooks which they haven't bothered to help me with.
I'm here to help you locate duplicate invoice numbers to prevent discrepancies and errors in financial records, @Elissiah.
To locate the invoice that contains duplicate transaction numbers:
Hover to Sales, then select All sales.
Select the NO. column to sort your transactions
Check for duplicates.
You can run a customer report to view all your sales transactions clearly.
Go to Reports, then enter Transaction List by Customer in the search field.
From the Report period dropdown menu, select All Dates.
Select Sort dropdown.
From the Sort by dropdown menu, choose Num. Then select Ascending order or Descendingorder.
You'll see a list of your invoices, sales receipts, and other sales transactions listed in numerical order.
Moreover, you can set up automated reminders for your customers when your invoices are due. This feature can help you get paid faster and reduce the number of overdue payments.
Just tap the reply button and enter your response whenever you need further information regarding your duplicate invoice numbers. I'm always here to help you.
I am trying to convert a Sales Order to an Invoice; I go to my Sales Orders, choose my Customer/Job and click Covert to Invoice and get "This invoice number was already used. Try a different one to continue." I have checked our invoices, I don't have any repeated Invoice numbers. When you "Convert to Invoice" you don't get to choose any Invoice number, QBO converts it for you. This is a problem. I've read through the forum and tried troubleshooting outside of QB, to no avail. I really wish the QBO team worked with the Desktop team. QBO does not function nearly as intuitively as Desktop (Enterprise). I've worked in Quickbooks for the better part of 20 years. This is not good.
I completely understand how challenging it can be to see that error, @cr8vrlj, especially when you know you haven't used that number on a visible invoice. I've gathered some information about Sales Order conversions and numbering that should help us fix the problem and get you back to invoicing smoothly.
QuickBooks Online (QBO) aims to protect your financial data by ensuring every transaction has a unique ID. When you convert an estimate to an invoice, the system immediately reserves the next available number in the sequence for an accurate audit trail. Sometimes, due to a momentary data interruption. The system successfully reserved the next number in the sequence for the conversion, but the invoice wasn't fully saved within QBO, prompting you to use the next or a different invoice number.
We can rectify this by using the Custom transaction numbers feature. It will help us temporarily skip that reserved number and direct the system to the next clean starting point.
Here's how:
Go to the Gear icon and select Account and settings.
Navigate to Sales, then the Sales form content section.
Turn Custom transaction numbers on.
Click Save, then tap Done.
Next, create a new invoice and manually enter a number that is safely past the last number you see (Example: if the last one was 1012, we'll enter 1022). It will tell QuickBooks that the new sequence starts after this number. Once done, save the temporary invoice and try converting your Sales Order again.
Once everything is working correctly, you can safely remove the temporary invoice by deleting or voiding it. After that, return to the Account and Settings menu and turn off the Custom transaction numbers feature to restore the default numbering system.
Let me know by leaving a comment below if you encounter any difficulties while following these steps or if the problem persists. We're here to support you and ensure your QuickBooks experience is as smooth as possible.
I appreciate your time, and feedback. I will try this on my end. Prior to hearing back, I was able to create a separate Invoice for the Sales Order but because the Invoice was not converted through the Sales Order, it shows as "Not Invoiced" and other than noting it in the Sales Order memo, I don't see where this can be changed.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.