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

By Tuân HoangMarch 29, 20268 min read

Vietnamese Invoice Requirements

In Vietnam, official VAT invoices (hoa don GTGT) require: seller name/tax code, buyer name/tax code, item description, quantity, unit price, VAT rate (0%/5%/10%), and sequential invoice 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

Is a Google Sheets invoice valid as an official Vietnamese VAT invoice?

No — official Vietnamese VAT invoices (hoa don GTGT) must be issued through certified e-invoice systems (VNPT, Viettel, etc.) registered with the Tax Authority. Google Sheets invoices can be used for internal management or for foreign clients, but not as official Vietnamese tax invoices.

Bài viết này cũng có bản tiếng Việt

Try SheetStore for Google Sheets

Management software built on Google Sheets — from $29 one-time

View Pricing