Free tool

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.

Updated 2026-11-02. Not tax advice: you choose the tax rate; this page only does the arithmetic. Runs in your browser: what you type is not sent anywhere or saved, and is gone when you close the page.

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

ItemQtyPriceAmount

Invoice total

0.00

Subtotal0.00
Discount0.00
After discount0.00
Tax0.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

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%.

  1. Lines: 255.00 + 120.00 + 92.50, so the subtotal is 467.50.
  2. Discount: 467.50 x 10% = 46.75. After discount: 420.75.
  3. Tax: 420.75 x 8.25% = 34.711875, rounded to 34.71.
  4. 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

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 7

Opens 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 editions

About this tool