How to use the multi-rate tax invoice calculator
- Choose whether line amounts are before tax or include tax, and choose the rounding you want in the summary.
- Add your invoice lines: a description, a quantity, a unit price and the tax rate that applies to that line.
- Read the invoice total and the summary by tax rate, which groups lines with the same rate.
- Compare the three rounding methods side by side to see how many cents they differ by.
Formula
Line amount = quantity x unit price, rounded to the cent
Tax added on top = amount x rate / 100
Tax inside a price = amount x rate / (100 + rate)
Round per line: round each line's tax and add them
Round per rate: add the lines of one rate and round that tax once
Round per invoice: add the exact taxes of all lines and round once
Rates are whatever you type. The tool contains no tax rates and does not know which method your place requires.
Four lines at two rates
An invoice has four lines: $568.74 and $296.34 at a 5% rate, and $37.56 and $121.86 at a 10% rate. The total before tax is $1,024.50. The exact taxes are $28.437, $14.817, $3.756 and $12.186, which add to $59.196.
Rounded line by line they are $28.44, $14.82, $3.76 and $12.19, so the tax is $59.21. Rounded once per rate, the 5% lines ($865.08) give $43.25 and the 10% lines ($159.42) give $15.94, so the tax is $59.19. Rounded once on the invoice it is $59.20. The three methods differ by up to 2 cents on this invoice, and the total is $1,083.69 with the once-per-rate method.
When rounding gives different answers
Tax is rarely a whole number of cents, so it must be rounded somewhere. Rounding each line can shift the total either way, rounding once per rate keeps each rate's tax consistent with its taxable total, and rounding once for the invoice gives the closest result to the exact tax. Which one is used depends on your tax rules or accounting software, and the differences are usually a few cents.
The comparison table lets you see the spread for your own invoice. If the three methods agree, the choice does not matter for that invoice. If they differ, ask your tax authority or adviser which one applies to you. This tool does not tell you which is compliant.
Prices that include tax
Some places show prices with tax already included. The tax in such a price is amount x rate / (100 + rate), and the amount before tax is what is left. Choose Include tax and enter each price as printed. Mixing rates in an invoice with included tax is common for goods and services taxed differently.
For a single rate and a quick total, use the Sales Tax Calculator, and for comparing shelf prices with and without tax use the Price With Tax Comparison Calculator. To produce the invoice itself, use the Invoice Generator, and the Discount Calculator handles price cuts first.
Assumptions and limits
- Every tax rate is typed by you as an example or from your own records. No rate is built in.
- Line amounts are rounded to the cent first, then taxes are figured on those amounts.
- Discounts, shipping, withholding and special rules for exempt items are not modeled.
- The tool is not tax or accounting advice, and nothing is filed or stored.
Frequently asked questions
Which rounding method should I use?
The one your tax rules or invoicing system require. The three methods can differ by a few cents, and no single method is right everywhere, so the page shows all of them for comparison.
How is the tax found when prices include it?
The tax part of a price is amount x rate / (100 + rate). For a $110 price at 10%, the tax is $10 and the amount before tax is $100.
Can I use a rate of zero for some lines?
Yes. A line with a rate of 0 adds no tax and appears as its own row in the rate summary, which is useful for exempt or zero-rated items.
Does the tool know my local tax rates?
No. It has no rates inside it, so you type the rate for each line. That keeps the tool correct when rates change.