Money & shopping

Invoice line-item calculator

Total quantities and unit prices with a supplied discount, delivery and tax.

Invoice line-item calculator
Esc to restore

Your inputs

Use the example headings. UTF-8 CSV and TSV files stay on this device; maximum 25 MB.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Line amount = quantity × unit price. Applies one order-level percentage discount, adds delivery, then applies your supplied tax rate to that total. Uses full precision until display. One currency and tax treatment throughout; this is not a legally compliant invoice generator.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

CSV: Item,Quantity,Unit price
Item,Quantity,Unit price
Design work,5,40
Hosting,1,12
Order discount (%)
10
Delivery / other taxable charge
0
Tax rate on discounted subtotal plus delivery (%)
20

Example result

Example result
ItemQuantityUnit priceLine amount
Design work540200
Hosting11212

Subtotal 212.00; discount 21.20; delivery 0.00; tax 38.16.