An invoice template for Google Sheets, and the faster way

The template

The CSV has one header row (Description, Quantity, Unit price, Amount), three example lines, and Subtotal, Tax rate, Tax and Total rows. The Amount, Subtotal, Tax and Total cells are formulas, so they recalculate when you change a quantity or a price. Import it into Google Sheets with File → Import, or open it directly in Excel. Add your name, address and the client’s above the table, put the invoice number and dates beside them, and export as PDF.

• Keep one tab per invoice and never edit a tab you have already sent.
• Type dates as real dates, not text, so they sort and so a due date can be calculated.
• Keep the tax rate in its own cell and reference it; a hard-coded tax amount is the first thing to go wrong.

What breaks, in the order it breaks

Numbers. You duplicate the tab and forget to change the number, and a client’s finance team bounces the invoice because INV-0012 already exists in their system. Or you skip one, and an auditor asks where INV-0019 went.

Dates. The issue date is whatever was in the copied cell. A due date that says “Net 30” in a text cell does not tell anyone which day that is.

Who paid. The sheet knows what you sent; it does not know what arrived. So you keep a second sheet, or a column, and update it when you remember, which is after you have already chased a client who paid a week ago.

The PDF. Print margins move, a long description wraps onto a second page, and the export is a picture of a grid rather than a document with your name on it.

The faster way

Invoira’s generator is the spreadsheet loop with the loose parts fixed, and it needs no signup. You type the invoice once in a form; the preview shows the real document while you type; the PDF is built from the same data, with selectable text, and downloads instantly. Tax and discounts are calculated with decimal-safe arithmetic in your currency’s rounding rules. The draft is saved in your browser.

With a free account, the parts a sheet cannot do arrive: numbers are handed out in sequence only when you issue, so you cannot reuse or skip one; a due date is calculated from your default terms; every invoice gets a share link the client can open on a phone; and you record payments against each invoice, so “who still owes me” is a dashboard, not a second tab. “Bill again” duplicates last month’s invoice with fresh dates, which is the one thing the sheet did well.

If you stay on the sheet

That is a fine choice for a handful of invoices a year. Freeze the header row, protect the formula cells, keep a numbers log on a separate tab, and export with “Fit to width” so the PDF never splits. When you find yourself doing this monthly for the same three clients, the generator will take less time than the export did.

A worked example

Questions

Related

• Free invoice generatorA free invoice generator that does not ask you to sign up
• Freelance invoice templateA freelance invoice template that clients pay without questions
• GST invoice formatGST invoice format: what goes on it, and how to make one
• Open the generatorStart typing your invoice. No account, free PDF.
• Invoira homeHow it works, the three templates and pricing.