Freelance invoice in Excel: what to include

A clean Excel invoice is enough for most US freelancers who want one-time files instead of monthly billing software. The sheet should print or save as PDF in one page, with clear totals and payment terms.

Core fields every invoice needs

Your name or business name, address, and contact
Client name and billing address
Invoice number and invoice date
Line items: description, quantity or hours, rate, line total
Subtotal, tax (if any), and amount due
Payment terms and how to pay (ACH, card link, check)

Optional but useful: project or PO reference, due date, and a short thank-you line. Keep branding light so the numbers stay readable.

Why pair the invoice with an expense log

Sending invoices is only half of sole-proprietor bookkeeping. Receipts and mileage often live in a second (or third) file. Putting a Schedule C–style expense log and a mileage log in the same workbook means one download, one place to look at month-end, and fewer copy-paste errors.

Yellow input, gray formulas

Templates that mark editable cells in yellow and calculated cells in gray reduce accidental overwrites. Avoid macros if you email the file or open it on locked-down machines.

Yellow = your numbers. Gray = formulas.

Free tools to start

Need only trip tracking for the 2026 mid-year IRS rate split? Use the free mileage log. Need a lightweight receipt sheet? Use the free simple expense log. Both upsell cleanly into the full kit when you are ready to bill from the same file.

Free mileage log Free expense log