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:
- Invoices: one row per invoice, with its total, due date, amount paid, balance and status.
- Lines: one row per line of work on an invoice.
- 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:
- A2, invoice number:
=IF(B2="","","INV-"&TEXT(ROW()-1,"0000"))(row 2 gives INV-0001, row 3 gives INV-0002, and so on; never sort this tab, or the numbers move) - E2, total from the lines:
=IF(A2="","",SUMIF(Lines!A:A,A2,Lines!E:E)) - F2, due date:
=IF(OR(C2="",D2=""),"",C2+D2)(format as a date) - H2, balance:
=IF(A2="","",E2-N(G2)) - I2, status:
=IF(A2="","",IF(H2<=0,"Paid",IF(TODAY()>F2,"Overdue",IF(N(G2)>0,"Part paid","Sent")))) - J2, days overdue:
=IF(I2="Overdue",TODAY()-F2,"")
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:
- B1: the invoice number to show. Make it a dropdown: Data > Data validation > Add rule > Dropdown (from a range), range
Invoices!A2:A. - B3 to B5: your business name, email and city, typed once.
- Bill to, B7:
=IFERROR(INDEX(Invoices!B:B,MATCH(B1,Invoices!A:A,0)),"") - Issue date, E3:
=IFERROR(INDEX(Invoices!C:C,MATCH(B1,Invoices!A:A,0)),"") - Due date, E4:
=IFERROR(INDEX(Invoices!F:F,MATCH(B1,Invoices!A:A,0)),"") - Line headings in row 10: Description, Quantity, Rate, Amount.
- The lines, A11:
=IFERROR(FILTER(Lines!B2:E,Lines!A2:A=B1),"")(this fills as many rows as the invoice has lines; leave room below it) - Total, D25:
=SUMIF(Lines!A:A,B1,Lines!E:E) - Amount due, D26:
=IFERROR(INDEX(Invoices!H:H,MATCH(B1,Invoices!A:A,0)),"")
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. | Client | Issue date | Terms | Total | Due date | Paid | Balance | Status (on 14 Nov 2026) |
|---|---|---|---|---|---|---|---|---|
| INV-0001 | Sample Bakery Co | 12 Oct 2026 | 14 | $1,950.00 | 26 Oct 2026 | $1,950.00 | $0.00 | Paid |
| INV-0002 | Sample Dental Group | 26 Oct 2026 | 30 | $1,680.00 | 25 Nov 2026 | $500.00 | $1,180.00 | Part paid |
| INV-0003 | Sample Cycle Works | 20 Oct 2026 | 14 | $820.00 | 3 Nov 2026 | $0.00 | $820.00 | Overdue (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.