VThe Vera Standard

How to make an invoice in Google Sheets

Who it is for: freelancers, consultants and other one-person service businesses that bill clients by invoice and want the invoices and who has paid in one place.

It is not the right fit if you need:

  • payroll for staff;
  • stock or inventory tracking;
  • online card payments or automatic reminders sent from the sheet;
  • someone to tell you what to charge or what tax to add.

This is a records method. It lays out and adds up your invoices; it is not tax or legal advice. Check what your invoices need to show where you work.

What you will build

Three tabs in one Google Sheet:

  1. Invoices: one row per invoice, with its total, due date, amount paid, balance and status.
  2. Lines: one row per line of work on an invoice.
  3. Invoice: a printable page. Pick an invoice number and the page fills in.

Step 1: The Lines tab

Rename the first tab Lines and type these headings in row 1:

A Invoice no. · B Description · C Quantity · D Rate · E Amount

In E2: =IF(OR(C2="",D2=""),"",ROUND(C2*D2,2)) and copy it down.

Each line starts with the invoice number it belongs to, for example INV-0001. An invoice with three lines has three rows.

Step 2: The Invoices tab

Add a tab named Invoices with these headings in row 1:

A Invoice no. · B Client · C Issue date · D Terms (days) · E Total · F Due date · G Paid · H Balance · I Status · J Days overdue

You type B, C, D and G. The rest are formulas in row 2, copied down:

Then a filter (Data > Create a filter) on column I shows only "Overdue" or only "Sent" when you need it.

Step 3: The printable Invoice tab

Add a tab named Invoice and lay it out like a page:

Format the dates and money cells, set column widths, and hide the gridlines (View > Show > Gridlines).

Step 4: Print it or save it as a PDF

Pick the invoice number in B1, then File > Download > PDF, or File > Print. In the print settings choose Current sheet, Fit to width, and untick "Show gridlines". The download is a PDF you can attach to an email.

Step 5: Record payments

When a payment arrives, type the amount in Paid (column G) on the Invoices tab. The balance and status update by themselves: Part paid, then Paid.

An example (made-up client and figures)

Invoice no.ClientIssue dateTermsTotalDue datePaidBalanceStatus (on 14 Nov 2026)
INV-0001Sample Bakery Co12 Oct 202614$1,950.0026 Oct 2026$1,950.00$0.00Paid
INV-0002Sample Dental Group26 Oct 202630$1,680.0025 Nov 2026$500.00$1,180.00Part paid
INV-0003Sample Cycle Works20 Oct 202614$820.003 Nov 2026$0.00$820.00Overdue (11 days)

INV-0001's lines: brand discovery workshop 1 × $450, logo design 1 × $900, brand guide 1 × $600 = $1,950.

Keep it in one workbook

The Solo Business Records Workbook has these three tabs already built, with clients, projects, income, expenses, mileage, a monthly summary and a year pack, and a dashboard that shows unpaid and overdue invoices. It works in Google Sheets and Excel. You type your own figures; there is no bank login.

See the Solo Business Records Workbook

Next: track invoices and expenses together, with monthly profit and a year pack for your accountant.