Invoice Template Google Sheets 2027 — Free Download & Auto-Number

Invoice Template Structure

Your Google Sheets invoice should include:

• Header: Your company name, logo, address, tax code, phone
• Invoice details: Invoice number, date, due date, payment method
• Buyer info: Company name, tax code, address, contact
• Line items: Description, quantity, unit, unit price, VAT rate, total
• Totals: Subtotal, VAT amount, grand total, amount in words
• Payment info: Bank name, account number, account holder

Auto-Invoice Numbering

Auto-increment invoice number:
="INV-" & TEXT(COUNTA(InvoiceLog!A:A),"0000")
Result: INV-0042

Or date-based:
="INV-" & TEXT(TODAY(),"YYYYMM") & "-" & TEXT(DailyCount,"000")
Result: INV-202703-015

VAT Calculation

Line total: =Quantity*UnitPrice
VAT amount: =LineTotal*VATRate
Line total incl VAT: =LineTotal*(1+VATRate)

Invoice subtotal: =SUM(D10:D20)
Total VAT: =SUM(E10:E20)
Grand Total: =Subtotal+TotalVAT

PDF Export and Sending

To send invoices as PDF:

1. File > Download > PDF (.pdf) — manual method
2. Apps Script automatic: export specific sheet as PDF, attach to email, send to customer — fully automated on invoice creation

Invoice Tracking Sheet

Keep a log of all invoices: Invoice No. | Date | Customer | Amount | Due Date | Status (Draft/Sent/Paid/Overdue) | Payment Date

Use conditional formatting to highlight overdue invoices in red automatically.

Get a complete invoicing template at SheetStore.

FAQ