How to Add a Prefix or Suffix to Invoice Numbers in QuickBooks Online
Customizing invoice numbers in QuickBooks Online is a practical way to improve organization, track different business units, and create a more professional billing system. By adding prefixes (like “NY-” or “2026-”) or suffixes (like “-A” or “-WEB”), you can categorize invoices by location, service type, or time period.
Although QuickBooks Online doesn’t have a single “prefix/suffix” button, it provides flexible tools that allow you to achieve this result manually or semi-automatically. This guide walks you through every step.
Understand How Invoice Numbering Works
Before making changes, it’s important to understand how invoice numbers function in QuickBooks Online.
By default:
- Invoice numbers are automatically generated
- They follow a simple sequence (e.g., 1001, 1002, 1003)
- Each new invoice increments the previous number
However, QuickBooks allows you to:
- Turn off auto-numbering
- Manually override invoice numbers
- Continue sequences using custom formats
This flexibility is what allows prefixes and suffixes.
Decide Your Prefix or Suffix Strategy
Before configuring anything, decide how you want your numbering system to look.
Common Prefix Examples
- NY-1001 (location-based)
- WEB-1001 (sales channel)
- 2026-1001 (year-based)
Common Suffix Examples
- 1001-A (division)
- 1001-REV (revised invoice)
- 1001-US (region)
Choose a format that is:
- Consistent
- Easy to read
- Scalable for future growth
Turn On Custom Transaction Numbers
To use prefixes or suffixes, you must enable manual control.
Steps:
- Click the Settings icon
- Select Account and Settings
- Go to the Sales tab
- Find Sales form content
- Enable:
- “Custom transaction numbers”
- Click Save, then Done
What This Does
This setting allows you to:
- Edit invoice numbers manually
- Override automatic numbering
- Insert prefixes/suffixes
Without this enabled, QuickBooks will lock numbering.
Create Your First Prefixed Invoice
Now you’ll create your first customized invoice.
Steps:
- Click + New
- Select Invoice
- Locate the Invoice no. field
Instead of a number like:
1001
Enter your custom format:
NY-1001
Or:
2026-1001
Then save the invoice.
Important Behavior
After you enter a custom number:
- QuickBooks will continue the pattern automatically
Example:
- First invoice: NY-1001
- Next invoice: NY-1002
QuickBooks “learns” your format.
Adding a Suffix Instead
You can also use suffixes in the same field.
Example:
1001-A
Then the next invoice becomes:
1002-A
However, note:
- QuickBooks increments the numeric portion only
- The suffix stays constant unless changed manually
Use Different Prefixes for Different Workflows
If your business needs multiple numbering systems, you can switch prefixes manually.
Example:
For online orders:
WEB-2001
For retail:
STORE-3001
To do this:
- Manually type the new prefix when creating an invoice
- QuickBooks will continue that sequence from the last number used
Reset or Change Prefix Mid-Year
If you want to change prefixes (e.g., new year):
Example:
From:
2025-1500
To:
2026-1001
Just:
- Manually enter the new format on the next invoice
QuickBooks will adopt the new sequence.
Use Custom Fields (Optional Enhancement)
If you want more structure, combine prefixes with custom fields.
Steps:
- Go to Settings
- Select Custom fields
- Create a field like:
- “Region”
- “Department”
This doesn’t change the invoice number directly but helps:
- Filter invoices
- Keep reporting consistent
Automate with Recurring Invoices
If you send repeat invoices, use recurring templates.
Steps:
- Create an invoice with your prefix
- Click Make recurring
- Set schedule
Limitation:
Recurring invoices do not dynamically change prefixes, so you must:
- Set the format carefully in advance
Avoid Duplicate Invoice Numbers
QuickBooks may warn you if a duplicate number is used.
To avoid this:
- Always continue sequences properly
- Use unique prefixes for different categories
Example:
- NY-1001 and CA-1001 are allowed because they differ
Best Practices for Prefix/Suffix Systems
Keep it Simple
Avoid overly complex formats like:
2026-NY-WEB-INV-0001-A
Instead:
NY-1001
Be Consistent
Once you choose a format, stick with it.
Changing formats too often can:
- Confuse customers
- Complicate reporting
Document Your System
Write down your format rules:
- What each prefix means
- When to change sequences
Reporting with Custom Invoice Numbers
You can search and filter invoices using prefixes.
Example:
Search:
NY-
This pulls all New York invoices.
This is useful for:
- Regional reporting
- Department tracking
Multi-User Considerations
If multiple people create invoices:
- Train staff on numbering rules
- Assign specific prefixes to teams
Example:
- Sales team → S-1001
- Service team → SV-1001
This avoids conflicts and duplicates.
Troubleshooting Common Issues
Issue: Prefix not continuing
Fix:
- Re-enter full format manually
- Ensure no gaps in numbering
Issue: Invoice number resets unexpectedly
Cause:
- Another user created a different format
Fix:
- Reapply your preferred prefix manually
Issue: Duplicate warning
Fix:
- Adjust number slightly (e.g., NY-1002 → NY-1002A)
Issue: Recurring invoices ignore format
Fix:
- Edit the recurring template manually
Advanced Tip: Year-Based Auto Organization
A powerful method is using year prefixes:
2026-1001
2026-1002
Benefits:
- Easy yearly separation
- Clean reporting
- No need to reset manually
At the start of a new year:
- Enter 2027-1001
- QuickBooks continues from there
Example Systems
Simple Business
1001-A
Multi-location Business
NY-1001
CA-1001
E-commerce + Retail
WEB-1001
STORE-1001
Year-based
2026-1001
Adding prefixes or suffixes in QuickBooks Online is straightforward once you understand how numbering works.
Key Steps:
- Enable custom transaction numbers
- Enter a custom invoice format manually
- Let QuickBooks continue the sequence
- Maintain consistency across your system
QuickBooks doesn’t automate prefixes directly, but it adapts to whatever format you start. That means the first correctly formatted invoice defines your entire numbering system.