| Item | Category | Unit Price | Qty | Unit | Disc. Type | Disc. Value | Tax % | Base | Item Discount | Tax | Line Total | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Subtotal (pre‑tax) | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||
Example Data
Use the button above to load these rows into the calculator instantly.
| Item | Category | Unit Price | Qty | Unit | Disc. Type | Disc. Value | Tax % |
|---|---|---|---|---|---|---|---|
| Bananas | Fresh Produce | 0.60 | 6 | piece | none | 0 | 0 |
| Whole Milk 1L | Dairy | 1.25 | 2 | liter | percent | 5 | 5 |
| Chicken Breast | Meat & Seafood | 5.40 | 1.2 | kg | fixed | 0.40 | 5 |
| Bread Loaf | Bakery | 2.10 | 1 | pack | none | 0 | 8 |
| Olive Oil | Pantry | 7.50 | 1 | liter | percent | 10 | 8 |
| Detergent | Household | 9.90 | 1 | pack | none | 0 | 12 |
Formulas Used
- Base = Unit Price × Quantity
- Item Discount =
if type =
%, Base × (Discount% ÷ 100); if type = Fixed, = Discount Value; else = 0 - Net Before Tax = Base − Item Discount
- Item Tax = Net Before Tax × (Tax% ÷ 100)
- Line Total = Net Before Tax + Item Tax
- Subtotal (pre‑tax) = Σ(Net Before Tax)
- Total Tax = Σ(Item Tax)
- Cart Coupon: applied to pre‑tax subtotal only (does not reduce tax)
- Fees = Delivery/Service Fee
- Grand Total = (Subtotal − Coupon) + Total Tax + Fees
- Rounded Total = Grand Total rounded to selected increment
Note: Jurisdictions differ on how coupons affect tax. This tool applies cart coupons to pre‑tax subtotal without altering tax. Adjust item discounts if you must model coupon‑before‑tax effects.
How to Use This Calculator
- Pick a currency and rounding option.
- Click Add Item and fill in details. Category pre‑fills tax.
- Choose discount type:
% offorFixed, then set value. - Repeat for all items. Quantities support decimals (e.g., 1.25 kg).
- Optional: set a cart coupon and any delivery/service fee.
- Totals update automatically. See the itemized breakdown at the bottom.
- Export your results as CSV or PDF using the buttons.