How to Calculate Invoice Total With Tax and Discount

To calculate an invoice total with tax and discount, add up the line items for the subtotal, subtract the discount to get the discounted subtotal, then multiply the discounted subtotal by the tax rate and add that tax, because tax is normally charged on the price after discount, not before. Build the invoice and check the total with our free invoice generator, and read on for the worked example and the discount-timing trap.

Try it now: Invoice Generator →

The Invoice Total Formula

The invoice total formula has four steps in a fixed order: subtotal, minus discount, plus tax, equals total. First, add every line item, each being quantity times unit price, to get the subtotal. Second, compute the discount, which is either a percentage of the subtotal or a fixed amount, and subtract it to get the discounted subtotal. Third, multiply the discounted subtotal by the tax rate to get the tax amount. Fourth, add the tax to the discounted subtotal for the total due. The order matters because tax is calculated on the discounted price in most jurisdictions: a 1,000 dollar subtotal with a 10 percent discount and an 8 percent tax rate gives a 900 dollar discounted subtotal, 72 dollars of tax, and a 972 dollar total, while taxing before the discount would give 80 dollars of tax and a 980 dollar total, an 8 dollar overcharge. Write the four lines on the invoice itself, subtotal, discount, tax, total, so the client can verify each step, and keep the tax rate visible next to the tax line, because a hidden rate is the most common source of invoice disputes. Our free invoice generator applies this order automatically and prints all four lines.

Try it now: Invoice Generator →

Worked Example: 1,000 Dollars, 10 Percent Off, 8 Percent Tax

Take a freelance invoice with three line items: design work at 500 dollars, revisions at 300 dollars, and stock images at 200 dollars, giving a subtotal of 1,000 dollars. The client holds a 10 percent loyalty discount, which is 100 dollars, so the discounted subtotal is 900 dollars. The local sales tax rate is 8 percent, so the tax is 900 times 0.08, which is 72 dollars. The total due is 900 plus 72, which is 972 dollars. Check the arithmetic backward: 972 minus 72 is 900, plus the 100 discount is 1,000, which matches the subtotal, so the invoice reconciles. If the discount were a fixed 150 dollars instead of a percentage, the discounted subtotal would be 850 dollars, the tax would be 68 dollars, and the total would be 918 dollars, which shows why the discount type must be stated on the invoice: the same headline discount gives different totals as a percentage versus a fixed amount. For a discount quoted as a percentage off, our percentage-off guide runs the same math for retail prices.

Discount Before Tax or After Tax: The Trap

The single most expensive invoice mistake is applying the discount after tax, and it usually happens silently in spreadsheet templates. The standard rule, followed by most US states and by common business practice, is that a discount reduces the taxable price, so tax is charged on the discounted subtotal, as the formula above does. The exception is a manufacturer rebate or a coupon reimbursed by a third party, where the seller still receives the full price and tax may apply to the pre-discount amount, but that case belongs to retail tax law, not to ordinary service invoices. The practical protection is to state the order on the invoice: write Discount applied before tax beneath the discount line, so a client or an accountant reading it later knows the method. If a client contract specifies tax on the pre-discount price, follow the contract and label it, because a contract term overrides the default, but expect the total to be higher and say so when quoting. When in doubt, ask your tax advisor, since the wrong order on a year of invoices creates a tax liability that dwarfs any single invoice. Our invoice due date guide covers the next step after the total is agreed.

Multiple Line Items, Partial Discounts, and Rounding

Real invoices rarely discount everything equally, and the method for partial discounts is to apply the discount only to the eligible lines. If only the design line carries the 10 percent discount, compute the discount on 500 dollars, which is 50 dollars, subtract it from the 1,000 dollar subtotal to get 950 dollars, then apply 8 percent tax to get 76 dollars and a total of 1,026 dollars. Do not apply the percentage to the whole subtotal and then adjust, because that route invites rounding drift. Rounding itself needs a rule: round each line item to cents first, then round the discount, then the tax, and finally the total, because rounding only at the end can leave the printed lines summing to a cent more or less than the printed total. A one-cent mismatch looks like an error to every client, even when the math is defensible, so make the lines add up exactly as printed. For invoices with dozens of lines, a spreadsheet or our free invoice generator beats hand arithmetic, since a single mistyped quantity propagates through all four steps. Our late fee guide explains what happens when that correct total goes unpaid.

How to Calculate an Invoice Total in Excel

In Excel, lay the invoice out so each step has its own cell, because a single mega-formula hides errors. Put quantities in column A and unit prices in column B, with line totals in column C as =A2*B2 filled down, and the subtotal as =SUM(C2:C10). Put the discount rate in a labeled cell, say E2, and the discount amount as =subtotal*E2, or a fixed discount as a plain number, then the discounted subtotal as =subtotal-discount. Put the tax rate in another labeled cell and the tax as =discounted_subtotal*tax_rate, with the total as =discounted_subtotal+tax. Labeling the rate cells matters: a future editor who sees 0.08 in a formula cannot tell whether it is a tax rate, a discount, or a fee, while a labeled cell named TaxRate is self-documenting. Test the sheet with the worked example above, 1,000, 10 percent, 8 percent, and confirm it returns 972, before using it on a real invoice. If you bill hourly, convert tracked minutes first with our free minutes to hours converter, since billing 90 minutes as 1.9 hours instead of 1.5 overcharges the client.

Common Invoice Total Mistakes

Six mistakes recur across freelance and small-business invoices. First, taxing the pre-discount subtotal, covered above, which overcharges every discounted invoice. Second, applying the discount twice, once as a reduced unit price and again as a discount line, which undercharges and is hard to spot because the total looks plausible. Third, forgetting that shipping or expenses may be taxable in some jurisdictions and exempt in others, so check whether delivery charges join the taxable subtotal. Fourth, mixing tax rates across line items, such as goods at one rate and services at another, without separating them into taxed and untaxed groups. Fifth, rounding the tax rate itself, such as using 8 percent for an 8.25 percent jurisdiction, which under-collects tax on every invoice. Sixth, omitting the total due when a deposit was paid, since the invoice total and the balance due are different numbers and the client needs both. A final review pass that recomputes the four lines from the raw quantities catches all six, and a second pair of eyes catches the ones a tired author misses. For proposal text that must stay concise, our free word counter keeps descriptions inside their limits while the numbers stay exact.