Free calculator
Wholesale order invoice calculator
To total a wholesale invoice, price each line at the quantity tier it reaches, take off any line discount and round the line to the cent, add up the lines, then subtract the order discount and add shipping and tax. This calculator does that for up to 300 lines with tiers you define, and shows the deposit and balance due when you enter a deposit.
The items, prices, tiers and discounts in the calculator are an example. There is no default tax rate, so tax is added only at a rate you enter. The result is an estimate for preparing an invoice, not a quote, and nothing on this page sends an invoice or takes a payment.
Currency and price tiers
The items, prices, tiers and discounts filled in are an example. Replace them with your own order, or start an empty one.
Sets the rounding, for example to the cent for USD or to whole yen for JPY. No conversion is applied.
Order lines
Each line is priced at its tier, less any line discount, and rounded to the currency's smallest unit. Tiers are optional; add them for lines with quantity price breaks.
Before any tier.
Optional. Leave empty for none.
Tick it when your tax rules exempt this item. The calculator does not decide that.
A tier starting at 100 applies from the 100th unit. Each tier is a percent off; tiers can be entered in any order.
Line total: $1,111.50 (tier from 50, 5% off $9.75)
Before any tier.
Optional. Leave empty for none.
Tick it when your tax rules exempt this item. The calculator does not decide that.
No tiers: every unit is charged the base price.
Line total: $459.72 (base price)
Before any tier.
Optional. Leave empty for none.
Tick it when your tax rules exempt this item. The calculator does not decide that.
No tiers: every unit is charged the base price.
Line total: $384.30 (base price)
4 of 300 lines.
Order discount, shipping, tax and deposit
Taken off the goods subtotal before tax. Shipping is not discounted.
Leave empty for none.
Empty by default: enter the sales tax or VAT rate that applies to this sale, if any. There are no built-in rates.
Share of the total asked for up front. Leave empty for none.
Whether freight is taxed depends on your tax rules. Leave it unticked if it is not.
Order totals
Order total $3,415.37 for 4 lines: $3,371.52 of goods less a $101.15 order discount, plus $145.00 shipping. No tax rate is entered, so no tax is added. A 30% deposit is $1,024.61, leaving a balance of $2,390.76.
- Subtotal4 lines, after line discounts
- $3,371.52
- Order discount3% of the subtotal, spread over the lines in proportion to their totals
- −$101.15
- Shipping or freightNot taxed
- $145.00
- Taxable baseLines after the order discount. Tax-exempt lines ($372.77) are left out.
- $2,897.60
- TaxNo tax rate entered, so no tax is added
- $0.00
- Total
- $3,415.37
- Deposit30% of the total
- $1,024.61
- Balance due
- $2,390.76
| Line | Quantity | Tier applied | Unit price | Line discount | Line total | Order discount share | Net |
|---|---|---|---|---|---|---|---|
| 1. MUG-350 Ceramic mug, 350 ml | 240 each | Tier from 100 | $5.90 | None | $1,416.00 | −$42.48 | $1,373.52 |
| 2. PLT-270 Stoneware dinner plate | 120 each | Tier from 50, 5% off $9.75 | $9.2625 | None | $1,111.50 | −$33.35 | $1,078.15 |
| 3. NAP-45 Linen napkins | 35 packs of 6 | Base price | $14.20 | −$37.287.5% of $497.00 | $459.72 | −$13.79 | $445.93 |
| 4. COF-1K Ground coffee, 1 kgTax-exempt | 18 bags | Base price | $21.35 | None | $384.30 | −$11.53 | $372.77 |
| Subtotal | −$37.28 | $3,371.52 | −$101.15 | $3,270.37 |
How these figures were rounded
- Each line's gross amount and line discount are rounded to $0.01, and the line total is the rounded gross less the rounded discount. Unrounded, the 4 lines would come to $3,371.525; the rounded line totals add up to $3,371.52, $0.005 less.
- The 3% order discount is $101.1456 before rounding and $101.15 after. It is spread over the lines in proportion to their totals. Rounded down to $0.01, the shares leave $0.02 over, which goes $0.01 at a time to the lines that lost the largest fraction (line 2 and line 4), so the shares add up to the discount exactly.
- The 30% deposit is $1,024.611 before rounding and $1,024.61 after. The balance is the total less the rounded deposit, so the two add up to the total.
Line 1 (MUG-350 Ceramic mug, 350 ml): 250 at the next tier would cost $1,350.00, less than the $1,416.00 that 240 cost now (both before any line discount).
The CSV has one row per line, then one row each for the subtotal, order discount, shipping, taxable base, tax and total (and the deposit and balance when you enter a deposit), with plain amounts in USD.
How the wholesale order total is calculated
The calculator prices each line, adds the lines up, and then works through the order figures in a fixed order. For a line with quantity q:
- Unit price: the base unit price, or the price of the tier the quantity reaches. A tier set as a percent off charges base price × (1 − percent ÷ 100), rounded to six decimal places.
- Gross: G = q × unit price, or the sum of each band's quantity times its price with incremental tiers, rounded to the currency's smallest unit.
- Line discount: d = G × line discount ÷ 100, rounded, which gives the line total L = G − d.
- Subtotal: S is the sum of the line totals.
- Order discount: D = S × discount ÷ 100, rounded, or the fixed amount you enter. It cannot be more than S, and it applies to the goods only, not to shipping.
- Taxable base: B is the total of the lines not marked tax-exempt, each less its share of D, plus shipping when you mark shipping as taxable.
- Tax: T = B × your rate ÷ 100, rounded. With no rate entered, T is zero.
- Total: S − D + shipping + T.
- Deposit: total × deposit ÷ 100, rounded, and the balance due is the total less the deposit.
Because the order discount comes off before tax, it lowers the tax as well as the goods total. Shipping is added after the discount, so a percentage order discount never reduces the freight charge. A line discount and an order discount can both apply; the line discount is taken first.
All-units price breaks and incremental quantity tiers
A tier has a starting quantity and either its own unit price or a percent off the line's base price. The example's first line, MUG-350 Ceramic mug, 350 ml, has a base price of 6.50, a tier from 100 at 5.90 and a tier from 250 at 5.40. You choose for the whole order how tiers apply.
“All units at the tier reached” is the usual wholesale price break. Once a line reaches a tier's starting quantity, every unit on it is charged the tier price. 240 mugs reach the tier from 100 but not the one from 250, so all of them cost 5.90: 240 × 5.90 = 1,416.00.
“Incremental, each band at its own price” works like tax brackets. Units before a tier's starting quantity keep the earlier price, and only the units from that quantity on are charged the tier price. The same 240 mugs come to 99 × 6.50 + 141 × 5.90 = 1,475.40.
In both modes a tier that starts at 100 applies from the 100th unit. The table shows the mug line just below, at and just above each tier.
| Quantity | All units: price charged | All units: line total | Incremental: bands | Incremental: line total |
|---|---|---|---|---|
| 99 | 6.50 (base price) | 643.50 | 99 × 6.50 | 643.50 |
| 100 | 5.90 (tier from 100) | 590.00 | 99 × 6.50 + 1 × 5.90 | 649.40 |
| 101 | 5.90 (tier from 100) | 595.90 | 99 × 6.50 + 2 × 5.90 | 655.30 |
| 249 | 5.90 (tier from 100) | 1,469.10 | 99 × 6.50 + 150 × 5.90 | 1,528.50 |
| 250 | 5.40 (tier from 250) | 1,350.00 | 99 × 6.50 + 150 × 5.90 + 1 × 5.40 | 1,533.90 |
With all units priced at the tier reached, a line just below a break can cost more than one just above it: 249 mugs at 5.90 cost 1,469.10, while 250 at 5.40 cost 1,350.00. The calculator points this out when ordering up to the next tier would cost less. Incremental pricing has no such jump, because each extra unit adds its own band's price to the line.
Quantities can have up to six decimal places, for goods sold by weight or length, but tier starting quantities are whole numbers. Incremental bands count whole units, so with a tier from 100 the first 99 units stay at the earlier price. If the mug tiers were set on goods sold by the kilogram, 99.5 kg would put 0.5 kg in the band from 100 under incremental pricing (99 × 6.50 + 0.5 × 5.90 = 646.45), while all-units pricing would charge all 99.5 kg at the base price (646.75), because the quantity has not reached 100.
How the invoice figures are rounded
Arithmetic is exact until a figure would be printed. Each figure that appears on an invoice (a line's gross amount, its discount, the order discount, the tax and the deposit) is rounded once to the currency's smallest unit, half away from zero: 0.01 for USD or EUR, 1 for JPY, 0.001 for KWD. The subtotal is the sum of the rounded line totals, so the lines on the invoice add up to the subtotal shown, and the subtotal, discount, shipping and tax add up to the total. Amounts you enter for shipping or a fixed discount must already be in whole units of that size.
The order discount is shared out over the lines in proportion to their totals, so each line has a net amount and the taxable base matches the discount exactly. Every share is first rounded down; the units left over go one at a time to the lines that lost the largest fraction, and a tie goes to the line higher in the list. Tax is then worked out once on the taxable base rather than line by line. Other invoicing software may take an order discount off after tax or work out tax line by line, so check its tax and total if you copy the order into it. The section on putting the order on a Hanko invoice, further down, covers Hanko's invoice editor.
Unit prices keep up to six decimal places. With incremental tiers, a line's unit price is the average across its bands, shown rounded to six places and labelled as an average; the line total comes from the bands, not from the rounded average. Under the results, the calculator lists each rounding step with the amount before rounding.
Worked example: a four-line tableware and coffee order totalling USD 3,415.37
The calculator opens with this example, and the items, SKUs, prices and tiers are made up. The order is in USD with all units priced at the tier reached, a 3% order discount, USD 145.00 of freight that is not taxed, no tax rate, and a 30% deposit.
- MUG-350 Ceramic mug, 350 ml: 240 each. The quantity reaches the tier from 100, so 240 × 5.90 = 1,416.00.
- PLT-270 Stoneware dinner plate: 120 each, base price 9.75, with tiers of 5% off from 50 and 12% off from 200. The quantity reaches the 5% tier: 9.75 × (1 − 5 ÷ 100) = 9.2625, and 120 × 9.2625 = 1,111.50.
- NAP-45 Linen napkins: 35 packs of 6 at 14.20 = 497.00. The 7.5% line discount is 37.275, rounded to 37.28, which leaves a line total of 459.72.
- COF-1K Ground coffee, 1 kg: 18 bags at 21.35 = 384.30, marked tax-exempt in the example.
The subtotal is 1,416.00 + 1,111.50 + 459.72 + 384.30 = 3,371.52. Without rounding the napkin discount, the lines would come to 3,371.525.
The order discount is 3,371.52 × 3 ÷ 100 = 101.1456, rounded to 101.15. Spread over the lines and rounded down, the shares leave 0.02 over, which goes to line 2 and line 4:
| Line | Line total (USD) | Share of the discount | Net (USD) | Tax |
|---|---|---|---|---|
| 1. MUG-350 Ceramic mug, 350 ml | 1,416.00 | 42.48 | 1,373.52 | Taxable |
| 2. PLT-270 Stoneware dinner plate | 1,111.50 | 33.35 | 1,078.15 | Taxable |
| 3. NAP-45 Linen napkins | 459.72 | 13.79 | 445.93 | Taxable |
| 4. COF-1K Ground coffee, 1 kg | 384.30 | 11.53 | 372.77 | Marked tax-exempt |
| Total | 3,371.52 | 101.15 | 3,270.37 |
Shipping of 145.00 is added after the discount. With no tax rate entered the tax is 0.00, and the taxable base of 2,897.60 (lines 1 to 3 after their discount shares) is shown for reference. The total is 3,371.52 − 101.15 + 145.00 = USD 3,415.37. The 30% deposit is 1,024.611, rounded to 1,024.61, which leaves a balance due of 2,390.76.
The calculator also flags line 1, because 250 mugs at the next tier would cost 1,350.00, less than the 1,416.00 for 240. With incremental tiers instead, line 1 comes to 99 × 6.50 + 141 × 5.90 = 1,475.40 and line 2 to 49 × 9.75 + 71 × 9.2625 = 1,135.3875, rounded to 1,135.39, which makes the order total USD 3,496.17.
Suppose you then enter a tax rate of 10%, a number picked only to show the arithmetic and not the rate for any place or product. The tax is 2,897.60 × 10 ÷ 100 = 289.76, the coffee line adds nothing to it, and the total becomes 3,705.13, with a deposit of 1,111.54 and a balance of 2,593.59. Ticking “Charge tax on shipping” as well raises the taxable base to 3,042.60 and the tax to 304.26.
Choices to make before you invoice a wholesale order
- Which tier mode your price list uses. A price list can be written either way, and a table of quantity ranges does not say on its own whether the tier price applies to every unit or only to the units in that range. If the price list or agreement does not say, ask before you invoice.
- Tier prices or percentages off. Set a line's tiers as unit prices when the price list gives prices, and as percentages when it gives discounts off a list price.
- Line discount or order discount. A line discount fits a negotiated price on one item; an order discount, such as a volume discount on the whole order, comes off the subtotal after the line discounts.
- The tax rate, which lines are tax-exempt, and whether shipping is taxed. These depend on where you and the buyer are, what the goods are, and sometimes on whether the buyer is reselling them. The calculator applies only the rate you type and the boxes you tick. For cross-border orders, import duties and taxes collected at the border are separate and are not calculated here.
- The deposit and when the balance is due. The payment due date calculator works out the due date for terms such as Net 30 or end of month.
- How incremental lines appear on the invoice. An average unit price may not multiply back to the line total exactly, so you can list each band as its own invoice line, with its quantity and price, to keep every line exact.
Assumptions and limitations
- The result is an estimate built from the prices you enter. It is not a quote, a price list or a tax calculation, and it does not check that a buyer is entitled to a tier or discount.
- There are no built-in tax rates or rules. One rate applies to the whole order, and lines are left out of the taxable base only when you mark them tax-exempt. Duties, customs charges and landed costs are not included.
- The order discount applies to the goods subtotal, before tax, and never to shipping. There is one order discount per order.
- Up to 300 lines and 10 tiers per line. Quantities run from 0 to 1,000,000,000 with up to 6 decimal places, unit prices take up to 6 decimal places, percentages up to 4, and a tier starts at a whole number of units from 2.
- The currency sets the rounding and nothing else. There is no conversion, and listing a currency here does not mean Hanko invoices or accepts payment in it.
- Nothing you type leaves your browser or is saved; reloading the page brings back the example. If analytics are on, the page records that the calculator was used, copied, printed or downloaded, with the currency code. Items and amounts are never sent, and the CSV is built on your device.
Putting the order on a Hanko invoice
The button below opens Hanko's International Client Invoice template in the invoice editor after you sign up or sign in. The lines and totals from this page are not carried over: the link only names the template, and the app does not read amounts from a link. An invoice's line items, discount, currency, client and dates can be changed only while it is a draft. Once it is finalized those fields are locked, and only its notes can still be edited.
In Hanko's invoice editor each line has a quantity, a unit price, its own tax rate and a discount entered as an amount, and the invoice can also have one invoice discount, entered as an amount. Each line's tax is worked out on that line after its own discount. The invoice discount is subtracted from the total after tax, so it does not lower the tax. Line amounts and taxes are added up before they are rounded to two decimal places, and there is no separate shipping field. This calculator takes the order discount off before tax instead. If you type the order discount into the editor's invoice discount, its tax and total will not match this page whenever a tax rate applies.
To get the same tax and total, enter the lines from this page in place of any example lines the template opens with. In each line's discount, enter its line discount and its order discount share added together, as an amount; both are in the results table and in the CSV. Leave the invoice discount empty, enter your tax rate on each taxable line and 0 on the lines marked tax-exempt here, and add shipping as a line of its own, with your tax rate only if you charge tax on shipping. The editor's subtotal then has the discounts taken off and includes shipping, so compare its tax and total with the figures here before you send the invoice. Where a quantity times its unit price leaves a fraction of a cent, the editor keeps the fraction until it adds the lines up, while this calculator rounds each line, so the totals can differ by a cent or two.
For a one-off invoice without an account, the invoice generator builds an invoice you can print or save as a PDF. The international client invoice template page covers the currency, bank charge and tax details a buyer in another country needs to see.
Related tools, templates and guides
Tools
- Invoice generatorBuild an invoice with line items, tax and discount assumptions and a due date, then print it or save it as a PDF.
- Payment due date calculatorWork out an invoice due date from its issue date and payment terms, counting calendar or business days.
- Retainer billing plannerLay out a monthly retainer's billing dates, included capacity, overage charges and rollover rule as invoice line items.
Guides
- Invoicing software built for client workBill line items, taxes and discounts on a hosted pay page your client can pay from directly, without a separate payment link.
- InvoicingGuides to issuing an invoice that a client can pay in USDC, USDT, DAI or EURC, or through the bank options you have set up, and to recording what was paid.
Turn the order into a Hanko invoice
Sign up or sign in and Hanko opens the International Client Invoice template in its invoice editor (a new account sets up its workspace first). The lines and totals from this page are not carried over, so you enter them in the editor yourself, with the discounts entered as described above so that its tax and total match these.