Professional Invoice Template for Google Sheets 2027 — Free

By Tuân HoangMarch 29, 20267 min read

Quick Summary

This comprehensive guide covers invoice template for google sheets. Read on for practical tips, templates, and comparisons.

Template Features

Professional invoice layout with: company logo, invoice number (auto-increment), date, customer info, itemized products/services, subtotal, VAT (10%), and grand total.

Vietnamese compliance: includes fields for tax code (MST), company seal area, and Vietnamese dong (VND) formatting.

Auto-numbering: Each new invoice gets a sequential number (INV-2027-001, INV-2027-002, etc.) based on the last used number.

How to Use

1. Fill in your company info in the Settings sheet (once). 2. For each invoice, enter customer details and line items. 3. Totals calculate automatically. 4. Print or export as PDF (File > Download > PDF).

The template supports both products and services. Quantity and unit price multiply automatically. Discounts can be applied per line or as a total discount.

Invoice Tracking

A separate Tracker sheet logs all invoices: number, date, customer, amount, status (Sent/Paid/Overdue), and payment date.

Dashboard shows: total invoiced this month, paid vs outstanding, overdue amounts, and average days to payment.

SheetStore Pro adds Apps Script automation: email invoices directly from the sheet and send payment reminders for overdue invoices.

Try SheetStore Today

SheetStore offers affordable Google Sheets-based solutions for Vietnamese businesses. Starting from just 699,000 VND with lifetime access. View Pricing

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