Excel template

Quote & Invoice Generator

Type an item code and quantity; description, unit price, amount, tax and totals fill in. Quote and invoice each print on one page.

Get it on Gumroad · USD 7

Opens the Gumroad product page. The price shown there is the one that applies.

Need more than one template? This one is also in the Excel Templates Bundle (all 4) on Gumroad: $19 instead of $30 bought separately.

See how it works

Animated demo in 3 steps: 1. Type an item code: description and price fill in. 2. Enter the quantity: amount, tax and total calculate. 3. Add more lines: subtotal, tax and total update. Fictional sample data.
3 steps, loops. Real sheet, recalculated in LibreOffice. Sample data is fictional.

What the sheets look like

Line amounts and tax calculated, Quote sheet (screenshot, fictional sample data)
Line amounts and tax calculated (Quote sheet). Sample data is fictional.
Quote number, dates and client, Quote sheet (screenshot, fictional sample data)
Quote number, dates and client (Quote sheet). Sample data is fictional.
Invoice from the same item list, Invoice sheet (screenshot, fictional sample data)
Invoice from the same item list (Invoice sheet). Sample data is fictional.
Item list: pick by code, Items sheet (screenshot, fictional sample data)
Item list: pick by code (Items sheet). Sample data is fictional.

What it does

What it does not do

How to use

  1. On Settings, enter your business details, tax rate, tax name and currency code.
  2. On Items, list your products or services with a code, unit price and Taxable Yes/No.
  3. Optional: list your clients on Clients.
  4. On Quote or Invoice, enter the number, dates and client, then only the item code and quantity per line.
  5. Print (one page), then record the document on Ledger.

Sheets in the file

Compatibility

Free guide and tool

FAQ

Can I use VAT, GST or sales tax?

You set one tax rate and the tax name shown on documents. Items can be marked taxable or not. One rate per file.

Is it a compliant e-invoice?

No. It calculates and prints; it does not submit e-invoices or check local invoice rules.

Does it print on US Letter?

It is set to A4 by default. Change the paper size in Page Setup and it still fits one page.

Quote & Invoice Generator

Excel file (.xlsx), no macros. USD 7 on Gumroad.

Get it on Gumroad · USD 7

Digital download. If the file doesn't work for you, email within 30 days for a full refund.

Good to know