Invoice Template for Freelancers: What Each Field Is For

Most invoice templates for freelancers show you where the fields go and stop there. This guide goes one level down: six fields, what each one does for you, three mistakes that slow payment, and four opinions on filling them in. If you want the fill-in version instead, the free printable invoice template is a one-pager you can print today.

How to use this page: read the field table once, then open whichever template or spreadsheet you bill from and check your own invoices against it. Field names vary between tools; the jobs below do not. Pair it with the free invoice tracker so sent invoices get logged, and with payment terms explained when you pick the due date.

The six fields and what each does

Field	What it does
Invoice number	A unique ID for this bill. It is how both of you refer to the same invoice in email, and how a payment gets matched to the work when money arrives. Sequential numbering (INV-001, INV-002) keeps your own records sortable.
Dates	The issue date starts every due-date calculation, and the due date tells the client when payment is expected without them having to ask. An invoice with one date is a receipt; an invoice with both is a schedule.
Services	One line per piece of work. The client uses these lines to approve the bill internally, so a line they can recognize gets approved faster than a line they have to decode.
Rates	Quantity or hours times rate per line, shown per row. Itemized rates let a client check the math themselves, which is what turns "please pay this" into "this checks out."
Total due	The single number the client pays. Subtotal and tax sit above it so the total is auditable, but the total is the only figure that needs an action attached to it.
Payment terms	How and when you get paid: the due date rule (net 15, net 30, due on receipt) and where to send the money. This field is the difference between an invoice and a statement of work delivered.

From the Invoice Generator Spreadsheet README, on how a solo worker uses these fields: "Fill one invoice, get a clean total due, log it, and see what is still owed at a glance. This is the simple version of invoicing - one sheet per invoice, not a whole accounting system."

Same README, on where the invoice number comes from: a formula "counts logged invoices and suggests the next number", so INV-004 follows INV-003 without hand-editing.

Three mistakes that slow payment

Missing due date. An invoice without one gets scheduled whenever the client's bookkeeping cycle gets to it. "Due in 30 days" and "due when noticed" read the same to a busy accounts payable inbox, and only one of them is your fault.
Vague service lines. "Design work - September" makes the client ask what design work, and every question adds a round trip before approval. Name the deliverable per line: "Landing page redesign - 12 hours" answers it before it's asked.
No invoice number. Without one, the client's payment reference is "that invoice from Mike", and matching your payment to your records turns into guesswork. Numbering also feeds the paid-vs-outstanding log: every invoice you can count is an invoice you can chase.

Four opinions on filling it in

Invoice on the day work ships, not month-end. (opinion) A same-day invoice lands while the delivery is still fresh in the client's head; a bundled month-end invoice competes with a stack of others and starts its due-date clock on the worst possible day.
Put the total due in the email subject line. (opinion) "Invoice INV-014: due Oct 15" gets found in a search for the amount. "Invoice attached" gets found by nobody.
Keep your rate lines even when the client trusts you. (opinion) Itemized lines do their real work six months later, during a tax filing or a dispute over what a project covered. Memory fades; line items do not.
Set the payment terms before the work starts, then repeat them on the invoice. (opinion) The invoice is the worst place to introduce terms for the first time. The five common terms all work; the surprise is what kills collection.

A template is the floor, not the ceiling

Every field above exists in whatever tool you bill from, and the generic rules travel. Where a spreadsheet beats a paper template is the counting: a generator can compute subtotal, tax, and total per invoice and keep a running log of paid versus outstanding, which is the part most freelancers do in their head until an invoice goes missing.

The Invoice Generator Spreadsheet (Excel + Google Sheets) ships "up to 12 line items" per invoice with the sheet computing "subtotal, tax and total due", a client list feeding the Bill To dropdown, and "a 20-row log tracks paid vs outstanding per invoice." License: "Personal and commercial use allowed - invoice your own clients, use it with your business, as many copies as you like."

Honesty note: the workbook was machine-verified (formulas parse, sample totals re-computed by hand) but has not been opened by hand in Excel or Google Sheets; if your app complains, the pack's instructions file covers the common cases. And to be plain about scope: this page is record keeping, not accounting, tax, or legal advice.

Get the Invoice Generator Spreadsheet - Excel + Google Sheets →

one-time · .xlsx for Excel & Google Sheets · instant download · personal & commercial use · full catalog

Related on this site: the free printable invoice template (one page, fill by hand), the free invoice tracker spreadsheet (log what's paid vs outstanding), and free freelance quote template for the stage before invoicing.