Invoice Total Calculator
Enter each item's quantity and unit price, an optional discount and the tax rate you charge. You get each line amount, the subtotal, the discount, the tax and the invoice total, rounded to the cent.
Items
Leave the tax rate blank or 0 if you do not charge tax. This page does not know or suggest any tax rate.
Lines
| Item | Qty | Price | Amount |
|---|
Invoice total
0.00
| Subtotal | 0.00 |
| Discount | 0.00 |
| After discount | 0.00 |
| Tax | 0.00 |
Need this as a quote or invoice you can print? See our Excel template (USD 7) or open it on Gumroad (USD 7).
What is an invoice total?
An invoice lists what you sold or did, how many and at what price. The total the client pays is built up in a few steps: each line is quantity times unit price, the lines add up to a subtotal, a discount (if any) comes off, and sales tax, VAT or GST (if you charge it) is added on what is left. Small rounding choices change the last cent, so this page shows exactly where it rounds.
How the calculator works
It uses exactly these rules:
Line amount = Qty x Unit price, rounded to the cent
Subtotal = sum of line amounts
Discount = Subtotal x Discount % / 100, rounded to the cent
(or the amount you type)
After discount = Subtotal - Discount
Tax = After discount x Tax rate % / 100, rounded to the cent
Total = After discount + Tax
- Rounding is to the nearest cent, and a half cent rounds up: 2.5 x 3.33 = 8.325 becomes 8.33. Only line amounts, the discount and the tax are rounded; sums are exact.
- Tax is worked out once, on the discounted subtotal. Some invoices round the tax on each line instead; that can differ by a cent or so.
- Quantities and prices can have decimals (hours, kilograms). Blank counts as 0. Negative numbers and text are marked in red and the line is left out.
- The discount % and tax rate must be from 0 to 100. A discount amount cannot be more than the subtotal. If either is not valid, no total is shown.
- Amounts are plain numbers, so any currency works. Use one currency for every line.
Worked example
Three lines: design, 3 hours at 85.00; hosting, 1 at 120.00; printing, 250 at 0.37. A 10% discount and a tax rate of 8.25%.
- Lines: 255.00 + 120.00 + 92.50, so the subtotal is 467.50.
- Discount: 467.50 x 10% = 46.75. After discount: 420.75.
- Tax: 420.75 x 8.25% = 34.711875, rounded to 34.71.
- Total: 420.75 + 34.71 = 455.46.
Common questions
How do I add interest to an overdue invoice?
This calculator has no interest feature. Work out the interest yourself, using the rate and rules in your contract or local law, then add it as one more item with quantity 1 and that amount as the price. The total updates at once. Keep in mind that the discount and the tax rate apply to every item, including this one, so check that is right for a late charge where you are.
Can I add a flat late fee to the invoice total?
Yes, as an item: quantity 1 and the fee as the unit price. It is added to the subtotal like any other line, so a discount % comes off it and the tax rate is applied to it. There is no way to leave one line out of the tax.
What it does not do
- It does not know tax rates or decide what is taxable. Your tax authority or an accountant can tell you which rate applies.
- It does not make an invoice document, number it, or check that an invoice meets your country's rules (some require specific content or electronic invoicing).
- It handles one tax rate and no shipping or extra fee lines (add them as items if they are taxed the same way).
- It does not remember your numbers. Nothing is stored.
Print quotes and invoices from Excel
The Quote & Invoice Generator is a paid Excel template from us: type an item code and quantity; description, unit price, amount, tax and totals fill in, and the quote and invoice each print on one page. Any tax rate (or 0%), round half up or round down, item and client lists, and a ledger. Unlike this calculator, the template has no separate discount line and works out tax per line. It is not an e-invoicing or tax-compliance system. No macros.
Quote & Invoice Generator on Gumroad · USD 7Opens the Gumroad product page. The price shown there is the one that applies.
Screenshots and details of the Quote & Invoice Generator template
How to make an invoice in Excel (free step-by-step guide)
How to make a quote in Excel (free step-by-step guide)
All English templates, including free lite editionsAbout this tool
- Made with AI (Claude). The calculation is checked by automated tests, including the worked example above.
- Simple arithmetic. Not tax advice, and not financial or legal advice.
- This page collects no personal data. No ads, no cookies and no browser storage; your inputs never leave your browser. Cloudflare Web Analytics (cookieless) counts page loads. The server only counts daily page views and buy-button clicks per page and referring site (no IP address, no user agent).