Invoice Template Spreadsheet: VAT/GST Auto Tax, Item List & Invoice Log (Excel & Google Sheets)

Make a print-ready invoice in 2 minutes — without an invoicing subscription.

HOW IT WORKS

1) Settings (once): your business details, tax preset for your country, currency, numbering (e.g. INV-0001).

2) Items & Clients: list your products/services and customers once.

3) New Statement: pick the client, pick items from the dropdown, type quantities. Price, tax and totals appear instantly.

4) Print / save as PDF: Invoice, Korean 거래명세서 or Delivery Note — each fits one A4 page (prints on US Letter too).

5) Invoice Log: paste the log row, type payments → balance, Paid / Partly paid / Unpaid / Overdue, days overdue, totals per currency.

WHAT MAKES IT DIFFERENT

• 60+ country VAT/GST presets (UK, EU, Japan, Korea, Australia, NZ, Canada, Singapore, India…) with source links and the date checked — or type your own rate (US sales tax)

• Prices exclusive OR inclusive of tax

• Tax per line, or once per rate on the invoice (Japan qualified-invoice style)

• Round, round down or round up — currency decimals automatic (KRW/JPY 0)

• Standard / Reduced / Zero-rated / Exempt items on the same invoice, with a tax summary per rate

• Line discounts, deposits/payments, previous balance, balance due

• Amount in words: English (any currency) + Korean 일금 ○○원정

• Title options: INVOICE, TAX INVOICE, TRANSACTION STATEMENT, QUOTATION, PROFORMA INVOICE, 거래명세서

• Checks: duplicate invoice number warning, missing rate, lines without a price

• 300 items, 200 clients, 20 lines per statement, 1,000 log rows

• Works in Excel 2010+ (Windows/Mac/web) and Google Sheets. No macros, no add-ons, nothing locked.

WHAT YOU GET (instant download, v1.0)

• Invoice-Statement-BLANK.xlsx

• Invoice-Statement-EXAMPLE.xlsx (fictional UK example, GBP)

• Invoice-Statement-EXAMPLE-Korea-KRW.xlsx (fictional Korean example)

• Quick Start PDF (2 pages)

TESTED

Every total was checked against an independent calculation in 214 test scenarios (12,400+ comparisons, 0 differences) and recalculated with 0 formula errors.

GOOD TO KNOW

• One tax per line (for Canada QST/PST use the combined rate as a custom rate).

• Tax presets are a convenience, not tax or legal advice — rates change; check your local rules. A Korean 거래명세서 does not replace a 세금계산서.

• Digital download — nothing is shipped. For your own business use; please don't resell or share.