Quotation Number Format: How to Number Quotes
Choose a quotation number format that stays tidy: prefix, year and sequence patterns, revision suffixes, linking quotes to invoices, and Excel formulas.
QT-2026-0001. That is the quotation number format most small businesses settle on after trying a few alternatives: a short prefix, the year, and a four-digit sequence. It tells the customer the document is a quote, keeps numbers unique across years, and sorts correctly in any folder or spreadsheet. This guide covers the common patterns, how to handle revisions, how to link a quote number to the invoice that follows, and how to generate numbers automatically.
Why quotation numbers matter
A quote number is the reference the customer will quote back to you when they accept, ask a question or raise a purchase order. Without one, "the quote from last Tuesday" can mean three different documents. A consistent format also lets you:
- Find any quote in seconds in your email or files.
- Track how many quotes you send and how many convert to orders.
- Show which version of a revised quote is current.
- Link the quote to the resulting sales order and invoice for a clean audit trail.
Unlike invoices, quotations generally do not have to follow a legally required sequence. Official invoice guidance, such as the UK government's list of what an invoice must include, asks for a unique identification number on invoices; quotes sit outside those rules. That gives you flexibility, but it is still worth being consistent.
Common quotation number formats
| Format | Example | Best for | Watch out for |
|---|---|---|---|
| Prefix + sequence | Q-0147 | Very small businesses | No year, so it never resets and grows long |
| Prefix + year + sequence | QT-2026-0147 | Most businesses | Choose padding (0001) large enough for a year's volume |
| Prefix + year/month + sequence | QT-2611-012 | High volume, monthly reporting | Sequence resets monthly, so always include YYMM |
| Prefix + client code + sequence | QT-HBF-2026-004 | A few large repeat clients | Keep a master log to avoid duplicates across clients |
| Prefix + branch/salesperson + sequence | QT-LDS-2026-0031 | Multiple locations or sales reps | Each branch needs its own counter |
| Prefix + project code | QT-PRJ221-01 | Project businesses quoting several phases | Harder to count total quotes per year |
Choosing a prefix
Use a prefix that cannot be confused with an invoice: QT, QUO, Q or EST (if you call them estimates). Keep it to two or three letters. If you also issue proforma invoices, give them their own prefix, such as PF; our comparison of a proforma invoice vs quotation explains when each is used.
Padding the sequence
Zero-padding (0001 rather than 1) keeps documents in order when sorted alphabetically. Without it, QT-2026-10 sorts before QT-2026-2. If you send fewer than 1,000 quotes a year, three digits are enough; four digits give room to grow.
How to number revised quotations
Quotes change: a customer removes an item, asks for a cheaper material, or the validity period lapses and prices need updating. Do not issue a fresh number for each change. Keep the base number and add a revision suffix:
- QT-2026-0089 (original, issued 3 November)
- QT-2026-0089-R1 (removed item 4, issued 6 November)
- QT-2026-0089-R2 (updated prices after expiry, issued 10 December)
Add a line to the revised document: "This quotation replaces QT-2026-0089-R1 dated 6 November 2026." That one sentence stops a customer accepting an outdated price. When a quote expires, our guide to the quotation validity period covers whether to extend it or revise it.
Linking quotation numbers to orders and invoices
A tidy paper trail runs quote → order → invoice, with each document referring back to the one before:
| Document | Number | Reference shown |
|---|---|---|
| Quotation | QT-2026-0089-R1 | – |
| Customer purchase order | PO-55120 (customer's number) | Ref. QT-2026-0089-R1 |
| Sales order / order confirmation | SO-2026-0061 | Ref. QT-2026-0089-R1, PO-55120 |
| Invoice | INV-2026-0215 | Ref. SO-2026-0061, PO-55120 |
Keep quotes and invoices in separate number series. Many quotes are never accepted, and if invoice numbers were derived from quote numbers, your invoice sequence would have gaps that tax auditors and accountants ask about. Our guide to building an invoice numbering system explains why an unbroken invoice sequence matters. If you issue order confirmations, see the sales order template for the middle step.
On the invoice itself, put the quote or PO number in a labelled reference field, not buried in the notes. The difference between your own reference and the customer's is covered in invoice reference numbers.
Generating quotation numbers automatically
In Excel or Google Sheets
Keep a quote log with one row per quote. If column A holds the running sequence (1, 2, 3...), this formula builds the number:
="QT-"&TEXT(TODAY(),"yyyy")&"-"&TEXT(A2,"0000")
That returns QT-2026-0001 for row 2. Replace TODAY() with the quote date cell (for example B2) so numbers do not change when you open the file next year. For a revision, add &"-R"&C2 where column C holds the revision number.
A simple quote log
| Quote no. | Date | Client | Value | Valid until | Status | Invoice no. |
|---|---|---|---|---|---|---|
| QT-2026-0087 | 28 Oct 2026 | Harbour Foods Ltd | £4,250.00 | 27 Nov 2026 | Accepted | INV-2026-0209 |
| QT-2026-0088 | 30 Oct 2026 | Greenway Dental | £1,180.00 | 29 Nov 2026 | Open | – |
| QT-2026-0089-R1 | 6 Nov 2026 | Marsh & Co | £2,960.00 | 6 Dec 2026 | Revised | – |
| QT-2026-0090 | 9 Nov 2026 | Oakfield School | £7,400.00 | 8 Feb 2027 | Declined | – |
With this log, your conversion rate is simple arithmetic: if 18 of 45 quotes this quarter were accepted, that is 18 ÷ 45 = 40%. The client names above are illustrative.
If you just need a batch of consistent numbers, our number generator tool creates sequences with any prefix and padding, and works for quotes as well as invoices.
Setting up your quote numbering in five steps
- Pick a prefix that differs from your invoice prefix, such as QT if your invoices use INV.
- Decide whether to include the year (recommended) and whether to reset the sequence each January.
- Choose the padding based on volume: three digits for under 1,000 quotes a year, four for more.
- Define the revision rule: base number plus -R1, -R2 for changes after the quote is sent.
- Start a log (spreadsheet or software) and record every number as soon as it is issued, including quotes that are later declined.
Write the rule down in one sentence, for example "QT-YYYY-NNNN, reset each January, revisions as -R1", and share it with anyone who sends quotes. Most numbering problems start when two people in the same business use different patterns.
Changing an existing numbering system
If your current quotes are numbered 1, 2, 3 or have no numbers at all, you do not need to renumber old documents. Start the new format from a clean date, such as 1 January, and note the change in your log: "From QT-2027-0001, previous quotes numbered 1–412." Old quotes keep their original references, which matters because customers may still quote them back to you. If you move to quoting software, check whether it lets you set the starting number so the sequence continues from your spreadsheet without overlapping.
What to show next to the quote number
The quotation number works best when it sits with the other identifying details at the top right of the document:
- Quotation number (and revision)
- Quotation date
- Valid until date
- Customer reference or enquiry number, if they gave one
- Your contact name for questions
Should quote numbers be hard to guess?
Some businesses worry that a quote numbered QT-2026-0012 tells customers how few quotes they send. If that bothers you, start the sequence at a higher number (QT-2026-1001) or use a month-based format. What you should not do is skip numbers randomly, because a log with unexplained gaps is harder to audit and makes missing quotes impossible to spot. A higher starting number gives the same impression without losing the sequence.
Quotation number format examples by business type
- Freelancer: Q-26-014 (short; low volume).
- Trades business: EST-2026-0231, since customers expect "estimate".
- Wholesaler with two warehouses: QT-MCR-2026-0412 and QT-BHM-2026-0198.
- Agency with retainer clients: QT-NLS-2026-007 (client code NLS) plus a global log.
- Exporter: QT-EX-2026-0056, keeping export quotes separate for currency and Incoterms tracking.
Mistakes to avoid
- Same prefix for quotes and invoices, so accounts teams pay a quote by mistake.
- New numbers for every revision, leaving the customer with three "final" quotes.
- Dates only, no sequence (QT-20261112). Two quotes on the same day collide.
- Reusing a number after a quote is declined. Mark it declined and move on.
- Formats that change every year, which breaks searching and reporting.
For the rest of the document, our quotation format guide shows where the number, date and validity go. When the customer accepts, create the invoice in our free invoice generator and add the quote number as the reference. No sign-up is required, and the invoice downloads as a PDF.
Frequently asked questions
What is a good quotation number format?
A good format combines a short prefix, the year and a zero-padded sequence number, such as QT-2026-0001. The prefix tells everyone it is a quote rather than an invoice, the year resets the count each January without creating duplicates, and the padding keeps numbers sorting correctly in folders and spreadsheets. Add a revision suffix such as R1 when you change an issued quote.
Do quotations need to be numbered sequentially?
Usually not by law. Sequential numbering rules in VAT and GST systems normally apply to invoices, not quotes. Sequential quote numbers are still worth using because they make it easy to find a quote, track how many you send, measure your conversion rate and spot a missing document. Keep quotes in a separate series from invoices so the invoice sequence stays unbroken.
Should a quote number and invoice number be the same?
No. Use separate number series so that each invoice number is unique and sequential within your invoice records. Instead, reference the quote on the invoice, for example: Invoice INV-2026-0215, ref. Quotation QT-2026-0089. Some businesses reuse the numeric part (QT-0089 becomes INV-0089), but that breaks the invoice sequence when some quotes are never accepted.
How do I number a revised quotation?
Keep the original number and add a revision suffix, such as QT-2026-0089-R1 for the first revision and R2 for the second. This shows the customer and your team that the documents are versions of the same offer, and it makes clear which is current. State on the revised quote that it replaces the earlier version, so the customer does not accept an outdated price.
Can I include the client name in a quote number?
You can add a short client code, such as QT-ACME-2026-003, which helps when you send many quotes to a few large clients. Avoid full names, which make numbers long and change if the client rebrands. A client code works best when you also keep a global sequence, so you can still count total quotes sent in a year.
Invoice Creator Editorial Team
Guides on invoicing, cash flow and small-business finance from Invoice Creator, operated by Next Software Development Company. Content is reviewed for accuracy against the fields our own invoice generator produces.
Try the invoice generator