Why QuickBooks Online Resets Invoice Numbers
QuickBooks Online (QBO) may reset invoice numbers due to several common causes:
1. Custom Transaction Numbers Were Turned Off
In Settings > Sales > Sales form content, there is an option called “Custom transaction numbers.” If this is turned off, QBO automatically hides manual invoice numbers and reverts to its internal sequence. When turned back on, the numbering may restart or duplicate an older sequence.
2. Data Import or Migration
If you imported invoices via Excel, CSV, or QuickBooks Desktop migration, QBO may start a new sequence from the first imported number or from “1.” Sometimes migrations reset the counter because QBO recognizes the last imported invoice as the highest number, not the real last one.
3. Multiple Users or Templates
Different users or custom invoice templates can trigger separate numbering if not consistent. Manual edits or copy/paste from older invoices may also cause numbering issues.
4. New Company or Reconnected Subscription
If you duplicated your company file or recreated your QBO account, invoice numbering will start over by default.
How to Restart Invoice Numbers Correctly
Step 1: Turn On Custom Transaction Numbers
- Go to Settings > Account and Settings.
- Select Sales > Sales form content.
- Turn on “Custom transaction numbers.”
- Click Save. You can now manually edit invoice numbers again.
Step 2: Set the Correct Next Number
- Create a new invoice.
- In the Invoice No. field, type the number you want to start from (for example, 1050).
- Save and close. QuickBooks will continue numbering sequentially from that point onward (1051, 1052, etc.).
Step 3: Double-Check for Duplicates
Run Reports > Invoice List and sort by Invoice number. Ensure there are no duplicates. If duplicates exist, manually edit the older invoice to maintain a clean sequence.
Additional Tips
- Limit who can create invoices or edit forms to prevent accidental resets.
- Use prefixes for new years or divisions, e.g., 2025-001, to avoid overlap if QBO restarts.
- Check third-party apps such as Shopify, PayPal, or Synder, as they may auto-generate invoice numbers that override QBO’s sequence.