Inkvoice a Femuo press

Inkvoice desk guide

CSV Invoice Numbering Best Practices (Spreadsheet → Unique Invoice PDFs)

Invoice numbers belong in the spreadsheet first. The PDF is what the client receives. This walk-through keeps those numbers unique, exportable, and mapped onto invoice PDFs without a full accounting suite.

Invoice PDFs and numbering schemes are business documents you prepare. This guide is not tax filing advice, not accounting advice, and not legal advice. Requirements vary by country — confirm with a qualified professional when needed.

Why invoice numbers belong in the spreadsheet first

The sheet is your system of record. Status, voids, and who has been sent which file live there. The PDF is a snapshot of one row — or of several rows that share a number. If the number only exists inside a downloaded file, the next export will invent a collision.

Unique invoice_no values prevent double-billing confusion and messy follow-ups. Inkvoice maps that column straight onto the paper. Rows that share a number become one multi-line invoice. That is useful only when the shared number is intentional.

Open the Inkvoice studio when the sheet is ready. Preview is free. $10 once unlocks unmarked PDFs, a logo, and a ZIP of up to 100 invoices. No account. Files stay on this computer. Buy once. Keep the file.

Pick one numbering scheme and stick to it

Pick a pattern you can sort, search, and explain in one sentence. Then stop inventing variants.

Scheme Example Fits
Year + sequence INV-2026-001 Most freelancers and small desks. Sortable. Easy to reset each January if that is your rule.
Date + daily sequence 20260917-01 High daily volume. Keep the day in ISO order so files sort in a folder.
Prefix + never-reset counter INV-1842 Long-running books where you never want two “001”s across years.

Avoid per-client counters unless you have a written process. ACME-014 on one tab and ACME-014 on another tab will collide the moment you export both. Client codes can live in a po or notes column instead.

Padding zeros (001 not 1) keeps lexical sort aligned with numeric order. Do not mix INV-2026-9 and INV-2026-10 if you rely on filename order.

Enforce uniqueness in Sheets or Excel

Add a helper column that counts how many times each invoice_no appears. In Google Sheets: =COUNTIF(A:A, A2) next to the number. Filter that helper to anything greater than 1. Fix those rows before export.

Data validation can block blanks in invoice_no once you decide every sendable row needs one. Blank numbers force the studio fallback, which is fine for a single preview and dangerous in a hundred-row ZIP.

Columns that support clean numbering

Seller name, tax ID, bank or PayPal, and terms live on the business side of the studio — not in the spreadsheet. The sheet owns the client-facing sequence.

Column Required Role in numbering
client Yes Bill-to name. Blank rows fail the file.
invoice_no No Keep unique after you send. Repeated values group line items.
description, qty, unit_price No One line item per row. Store amounts as numbers.
date, due_date, tax_rate No Issue date, due date, tax percent. Do not hide the number inside the date cell.

Operational columns that may not print: status (draft / sent / paid / void) and a void reason. Keep amounts numeric; compute totals with formulas so a renumber of drafts does not break math.

Example CSV

invoice_no,client,description,qty,unit_price,date,due_date,status
INV-2026-018,Bright Harbor Co.,September retainer,1,1200.00,2026-09-10,2026-09-24,draft
INV-2026-019,Oak and Pine Studio,Landing page revision,1,850.00,2026-09-12,2026-09-26,draft
INV-2026-019,Oak and Pine Studio,Stock photos,4,25.00,2026-09-12,2026-09-26,draft

INV-2026-019 appears twice on purpose. That is one invoice with two lines — not a duplicate error. A helper count of 2 is correct here. A helper count of 2 on two different clients is not.

From numbered rows to invoice PDFs

  1. Filter to draft, a date range, or one client. Do not export the entire history every time.
  2. Download UTF-8 CSV of only those rows. File → Download in Sheets; CSV UTF-8 in Excel.
  3. Map invoice_no and money fields in the studio. Preview one full invoice, including a long client name.
  4. Generate PDFs on your device. Save them next to that period’s sheet.
  5. Mark those rows sent in the sheet after you email the files — not only in your inbox.

Sheet design, multi-line grouping, and the end-to-end export are covered in Create Invoices from a Spreadsheet (CSV/Excel → PDF). This page is the numbering discipline that sits underneath that flow.

What not to do after sending

  1. Do not edit the PDF number without updating the sheet. Usually you should issue a new number instead.
  2. Do not regenerate an entire history folder and overwrite old filenames.
  3. Do not reuse a sent number for a “replacement” invoice. Issue the next sequence and reference the old one in notes if you must.
  4. Do not treat a numbered PDF as a filed tax return. It is an invoice, not a filing.

Taxes, e-invoicing, and honest limits

Some regions require specific invoice identifiers, tax IDs, or e-invoicing formats. A lightweight PDF generator does not replace those mandates, full bookkeeping, or legal contract terms. If you charge tax, the rate on the sheet must match what your advisor expects. This guide is not tax filing advice and not legal advice.

Inkvoice prints a layout you can send to a client. Numbering is one piece of that layout. Escalate VAT, GST, and clearance-network rules to a qualified professional.

When this workflow fits

Good fit if you already invoice from a list, want unique numbers without a finance platform, and prefer owning the file. Consider fuller accounting software if you need sequential numbers issued by a shared server every minute of the day.

Full spreadsheet invoice workflow: Spreadsheet layout and multi-line invoices. Catalog: femuo.com.

Buy once. Keep the file. Put the number in the sheet. Then print the PDF.

Inkvoice helps you generate invoice PDFs from spreadsheet data. It is not tax filing software and does not provide legal or accounting advice.

Make an invoice