Calculate from settings

Description:

When using an extra charge instead of a discount, the grand total of the order and the tax total may be different from what you expect. You can affect these these values by using the standard settings for tax and cost calculations.

Tax settings description Tax settings

Tax Calculation Method Based On:

• Unit Price — the tax is calculated per every product unit and is summed up afterwards.
• Row Total — the tax is calculated per every order line and is summed up afterwards.
• Total — the tax is added to the grand total

Apply Customer Tax:

• Before Discount — the tax is added to the grand total before adding the extra charge or discount.
• After Discount — the tax is added to the grand total after adding the extra charge or discount.

Apply Discount On Price:

• Excluding Tax — used to calculate the discount before applying the tax.
• Including Tax — used to calculate the discount after applying the tax.

Next, we will give an example, on how these settings affect the grand total, how it is calculated, and how every setting works.

General parameters from which the result is generated

UNIT PRICE INCL. TAX —  185.00

Mark-up based on the price rules for the cart —  100.00

Tax — 21%

A list of prices based on the tax settings

Number
Selected settings
Tax
S.E.T.
S.I.T.
G.T.E.
G.T.I.

1
32.11
152.89
185.00
252.89
285.00

2
32.11
152.89
185.00
252.89
285.00

3
49.46
152.89
185.00
235,54
285.00

4
49.46
152.89
185.00
235,54
285.00

5
32.11
152.89
185.00
252.89
285.00

6
32.11
152.89
185.00
252.89
285.00

7
49.46
152.89
185.00
252.89
302.35

8
49.46
152.89
185.00
252.89
302.35

9
32.11
152.89
185.00
252.89
285.00

10
32.11
152.89
185.00
252.89
285.00

11
49.46
152.89
185.00
235,54
285.00

12
49.46
152.89
185.00
235,54
285.00

Settings

Unit Price
Before Discount
Excluding Tax

Tax
32.11

To calculate the tax you'll need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

The SUBTOTAL EXCL. TAX equals to the UNIT PRICE minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

The SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

The GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Unit Price
Before Discount
Excluding Tax

Tax
32.11

To calculate the tax, you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Unit Price
After Discount
Excluding Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
235.54

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 100.00 - (100 - 100 / 1.21)=152.89 + 100.00 - 17.35=235.54

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 49.46 + 100 - 17.35=285.00

Settings

Unit Price
After Discount
Including Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
235.54

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 100.00 - (100 - 100 / 1.21)=152.89 + 100.00 - 17.35=235.54

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 49.46 + 100 - 17.35=285.00

Settings

Row Total
Before Discount
Excluding Tax

Tax
32.11

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Row Total
Before Discount
Excluding Tax

Tax
32.11

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Row Total
After Discount
Excluding Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
235,54

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 100.00 - (100 - 100 / 1.21)=152.89 + 100.00 - 17.35=235,54

GRAND TOTAL INCL. TAX
302.35

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 49.46 + 100 - 17.35=302.35

Settings

Row Total
After Discount
Including Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
302.35

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 49.46 + 100=302.35

Settings

Total
Before Discount
Excluding Tax

Tax
32.11

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Total
Before Discount
Excluding Tax

Tax
32.11

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - (185.00 / 21%)=185 - (185 / 1.21)=32.11

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
252.89

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP.

For example: 152.89 + 100.00=252.89

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP.

For example: 152.89 + 32.11 + 100=285.00

Settings

Total
After Discount
Excluding Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
235.54

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 100.00 - (100 - 100 / 1.21)=152.89 + 100.00 - 17.35=235.54

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 49.46 + 100 - 17.35=285.00

Settings

Total
After Discount
Including Tax

Tax
49.46

To calculate the TAX TOTAL you will need to divide the UNIT PRICE INCL. TAX by TAX.

For example: 185 - ((185.00 + 100) / 21%)=185 - (285 / 1.21)=49.46

SUBTOTAL EXCL. TAX
152.89

SUBTOTAL EXCL. TAX equals to the UNIT PRICE INCL. TAX minus TAX.

For example: 185 - 32.11=152.89

SUBTOTAL INCL. TAX
185.00

SUBTOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX.

GRAND TOTAL EXCL. TAX
235.54

GRAND TOTAL EXCL. TAX equals to the UNIT PRICE EXCL. TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 100.00 - (100 - 100 / 1.21)=152.89 + 100.00 - 17.35=235.54

GRAND TOTAL INCL. TAX
285.00

GRAND TOTAL INCL. TAX equals to the UNIT PRICE INCL. TAX plus TAX plus MARK-UP minus MARK-UP TAX.

For example: 152.89 + 49.46 + 100 - 17.35=285.00

Last modify date: Friday, October 14, 2016