Add Item
Cart Summary
- Subtotal 0.00
- Total Discount 0.00
- Tax 0.00
- Grand Total 0.00
Items
| # | Product | Category | Unit Cost | Qty | Discount % | Tax % | Line Total |
|---|
Formula Used
Per-item computations:
base = unit_cost × quantity
item_discount = base × (discount_pct ÷ 100)
after_discount = base − item_discount
item_tax = after_discount × (tax_pct ÷ 100)
line_total = after_discount + item_tax
Order-level computations (applied to the sum of after_discount across items):
subtotal = Σ base
sum_after_discount = Σ after_discount
order_discount_value = sum_after_discount × (order_discount_pct ÷ 100)
taxable_after_order_discount = sum_after_discount − order_discount_value
order_tax_value = taxable_after_order_discount × (order_tax_pct ÷ 100)
grand_total = taxable_after_order_discount + order_tax_value
total_discount = (Σ item_discount) + order_discount_value
total_tax = (Σ item_tax) + order_tax_value
All amounts are rounded to two decimals for display; exports keep full precision and include headers.
Example Data Table
Click “Load Example Data” above to populate this into the calculator.
| Product | Category | Unit Cost | Qty | Discount % | Tax % |
|---|---|---|---|---|---|
| Hydrating Serum | Skincare | 22.50 | 2 | 10 | 8 |
| Volumizing Shampoo | Haircare | 9.99 | 3 | 0 | 5 |
| Matte Lipstick | Makeup | 14.20 | 1 | 5 | 12 |
| Eyeliner Pen | Makeup | 7.80 | 2 | 0 | 12 |
| Facial Brush | Tools | 11.00 | 1 | 0 | 0 |