Free tool
Invoice generator
Lay out line items (quantity × unit price), an optional whole-invoice discount (percent or fixed), and one tax rate on the amount after discount. Copy TSV straight into Google Sheets or Excel, copy a Markdown table for docs, or print / save as PDF from your browser. Not legal invoicing software, not jurisdiction-specific VAT / sales-tax rules—see the disclaimer and FAQ.
When to use this tool
A fast sandbox before you paste rows into a model or send anything to a client.
- Check subtotal → discount → tax → total with the same rounding story you plan to use in Sheets or Excel.
- Copy TSV into a workbook tab when you want editable line items instead of a locked PDF.
- Pair with the margin and PayPal fee tools when you are stacking COGS, marketplace fees, and processor lines in one P&L view.
Each line is quantity × unit price, rounded to two decimals. Subtotal is the sum of those line totals. Discount reduces the subtotal (percent of subtotal or a fixed cap). Tax applies once to subtotal − discount. Total = that taxable base plus tax—also rounded to cents.
Line extensions and subtotal
Line total = round₂(qty × unit price). Subtotal = sum of line totals. Blank or invalid lines are skipped until both quantity and unit price parse.
Discount (optional)
Percent mode uses subtotal × (discount% ÷ 100). Fixed mode caps the discount at the subtotal so the taxable base never goes negative on-page.
Single tax band
Tax = round₂((subtotal − discount) × (tax rate ÷ 100)). Total = (subtotal − discount) + tax. We do not allocate tax per line, model inclusive unit prices, or apply withholding in v1.
What we do not model
Legal invoice numbering, mandatory fields by country, Peppol / e-invoice schemas, FX on mixed-currency lines, deposits, retainers, credit notes, shipping as its own tax class, and processor fees—use accounting software and your tax advisor when compliance matters.
For margin on a unit line, open the margin and markup calculator; for % + fixed on money you receive, see the PayPal fee calculator; for generic percent-of math, use the percentage calculator.
Google Sheets & Excel
After you paste TSV, keep qty, unit, and extension as separate columns so SUM and SUMPRODUCT stay auditable.
=B2*C2B2 = quantity, C2 = unit price; copy the column pattern for every line, then SUM the extension column for a subtotal row.
=(Subtotal-Discount)*RateStore Rate as a decimal (0.20 for 20%) or use a %-formatted cell consistently. This matches (subtotal − discount) × tax rate on this page.
Frequently asked questions
What does this invoice generator do?
It helps you type parties, optional dates, line items, an optional discount, and one tax rate, then shows subtotal, discount, tax, and total with copy helpers for TSV and Markdown. It runs in your browser—we do not store your data server-side.
Is this a legally valid invoice?
No. It is a planning layout with arithmetic only. Courts, tax authorities, and buyers expect invoices that follow jurisdiction-specific rules—use qualified advisors and a proper billing system for anything official.
Which tax rules does the calculator follow?
One user-entered percent on (subtotal − discount) after per-line rounding. It does not know your VAT registration, exempt lines, reverse charge, US sales tax nexus, or India GST slabs—treat the tax line as a spreadsheet-style illustration.
How do I move this into Google Sheets or Excel?
Use Copy TSV, paste into cell A1, then Data → Split text to columns if your app does not auto-split tabs. Keep qty, unit, and extension as separate columns so SUM and SUMPRODUCT match the methodology cards.
How is this different from asking ChatGPT to write an invoice?
The math here is deterministic from the numbers you type—no hallucinated rates or missing line items. You still need professional review for legal and tax wording.
Why might my total differ by a cent from accounting software?
Apps may round per line, per tax, or globally in a different order, or keep more precision internally. We document round₂ per line then subtotal → discount → tax—if you need an exact match, mirror the same order in your sheet.
Can I combine this with payment processor fees?
Yes as a modeling stack: finish invoice totals here, then use the PayPal fee or eBay fee tools on the gross you expect to collect—still illustration, not a processor quote.
Is this tax or legal advice?
No. It is a free educational tool—not a substitute for qualified professionals when compliance or money is on the line.