Discounts and VAT are calculated as follows in the MICROS Retail OSCAR POS program.
Example: Update program Item:
Note:
If an item is to receive a discount, switch "Price change permitted"
should be set in program Item -> Sales.
|
Item 1: |
VAT 20% |
Department 1 |
Sales price 10.00 |
Discount perm. |
|
Item 2: |
VAT 20% |
Department 2 |
Sales price 10.00 |
Discount perm. |
|
Item 3: |
VAT 10% |
Department 3 |
Sales price 10.00 |
No discount perm. |
|
Item 4: |
VAT 10% |
Department 4 |
Sales price 10.00 |
Discount perm. |
Example: Update program Price change:
Note:
The following values and buttons must be set in program Application -> Parameter -> Markup/markdown -> Price change type (category Discount).
|
Discount1: |
10% |
with "Net costing" |
and "Reassignment" |
|
Discount2: |
10% |
with "Net costing" |
and "Reassignment" |
|
Discount3: |
10% |
with "Net costing" |
and "Reassignment" |
|
Discount4: |
10 Euro |
w.o. "Reassignment" |
with VAT 10% |
|
Sale: |
Amount |
Discount1 |
2 |
3 |
4 |
VAT 20% |
10% |
|
Item 1 = |
10.00 |
- |
X |
X |
- |
X |
- |
|
2 x Item 2 = |
20.00 |
X |
X |
X |
- |
X |
- |
|
Discount 1 10 % = |
-2.00 |
|
|
|
|
|
|
|
Item 3 = |
10.00 |
- |
- |
- |
- |
|
X |
|
Item 4 = |
10.00 |
- |
X |
X |
- |
- |
X |
|
Total = |
48.00 |
|
|
|
|
|
|
|
Discount 2 10 % = |
3.80 |
|
|
|
|
|
|
|
Total = |
44.20 |
|
|
|
|
|
|
|
Discount 3 10 % = |
3.42 |
|
|
|
|
|
|
|
Total = |
40.78 |
|
|
|
|
|
|
|
Discount 4 10.00 |
-10.00 |
|
|
|
|
X |
|
|
VAT 20 % = 12.68 |
2.11 |
|
|
|
|
|
|
|
VAT 10 % = 18.10 |
1.65 |
|
|
|
|
|
|
Using the example for Item sales the following discount calculation ensues. The final amount is rounded to 2 decimal places.
|
Discount1 |
Position discount |
10% of 20.00 |
= 2.00 |
|
Discount2: |
Total discount |
10% of (10 + 20 - 2 + 10) |
= 3.80 |
|
Discount3: |
Total discount |
10% of (10 + 20 - 2 + 10 - 3.80) |
= 3.42 |
|
Discount4: |
Total discount |
10.00 Euro |
= 10.00 |
Using the Item sale example, the following VAT calculation ensues. The final amount is rounded to 2 decimal places. All discounts are assigned to the positions:
Discount1: (10 %): = 2.00 assigned to Item 2 (20.00)
|
Item 2 |
(20.00 - 2.00) |
= 18.00 |
Discount2: (10%) = 3.80 assigned to Item1, Item2, Item4 (10 + 18 + 10)
A percentage value from 3.80 * 100 / 38.00 = 10.00000000% is calculated.
It is assigned to the items and is rounded to 2 decimal places.
|
Item 1 |
10.00 - ((percent value * 10.00) / 100) |
= 9.00 |
|
Item 2 |
18.00 - ((percent value * 18.00) / 100) |
= 16.20 |
|
Item 4 |
10.00 - ((percent value * 10.00) / 100) |
= 9.00 |
The total of the assigned discounts is ascertained = 38.00 - 34.20 = 3.80
If the discount has not yet been assigned, the remainder is assigned to the highest value item.
Discount3: 3.42 assigned to Item1, Item2, Item4 (9 + 16.20 + 9)
The percentage value is calculated from 3.42 * 100 / 34.20 = 10.00000000%
It is assigned to the items and is rounded to 2 decimal places
|
Item 1 |
9.00 - ((percent value * 9.00) / 100) |
= 8.10 |
|
Item 2 |
16.20 - ((percent value * 16.20) / 100) |
= 14.58 |
|
Item 4 |
9.00 - ((percent value * 9.00) / 100) |
= 8.10 |
The total of the assigned discounts is calculated = 34.20 - 30.78 = 3.42
If the discount has not yet been completely assigned, the remainder will be assigned to the highest value item.
Discount4: will not be re-assigned
The re-assignment to the items is now:
|
Item 1 = |
8.10 |
Discount = 1.90 |
|
Item 2 = |
14.58 |
Discount = 5.42 |
|
Item 3 = |
10.00 |
Discount = 0.00 |
|
Item 4 = |
8.10 |
Discount = 1.90 |
Item1 and Item 2 with the total of 22.68 should be charged with 20% VAT. As discount 4 includes VAT 20%, the turnover for the calculation should be reduced by 10.00.
The VAT is assigned to the items for the turnover reports. As discount 4 should not be reassigned, the calculated VAT should also not be reassigned.
The basis for the turnover of Item 1 and Item 2 is VAT 20%.
A VAT of 20% is calculated on 22.68 = 3.78 (rounded).
An amount of 3.78 is assigned for the VAT 20%.
A value of 1.65 is calculated for VAT 10%.
The VAT on the individual items is rounded to 2 decimal places.
VAT 20%: 3.78 assigned to Item 1, Item 2 (8.10 + 14.58 = 22.68)
The percent value is calculated from 3.78 * 100 / 22.68 = 16.66666670
It is assigned to the items and rounded to 2 decimal places
|
Item 1 |
8.10 - ((percent value * 8.10) / 100) |
= 6.75 net |
|
Item 2 |
4.58 - ((percent value * 14.58) / 100) |
= 12.15 net |
The total of the assigned VAT is calculated = 22.68 - 18.90 = 3.78
If the discount has not been fully assigned, the remainder will be assigned to the highest-value item.
VAT 10%: 1.65 assigned to Item 3, Item 4 (10.00 + 8.10 = 18.10)
The percent value is calculated from 1.65 * 100 / 18.10 = 9.11602210
It is assigned to the items and rounded to 2 decimal places
|
Item 3 |
10.00 - ((percent value * 10.00) / 100) |
= 9.09 net |
|
Item 4 |
8.10 - ((percent value * 8.10) / 100) |
= 7.36 net |
The total of the assigned discounts is calculated = 18.10 - 16.45 = 1.65
If the discount has not been fully assigned, the remainder will be assigned to the highest-value item.