Example: Handling Deductions
For each day of a trip, an employee has a lunch deduction. This deduction is 1,800 in Spain and 3,200 abroad. The employee receives the cleared difference.
In example 9, the following absolute amount deductions in ESP are stored in the view:
Trip provision - deduction amount/percentage: Spanish settlement
.
Domestic |
International |
|
Breakfast |
800 |
1,600 |
Lunch |
1,800 |
3,200 |
Dinner |
1,800 |
3,200 |
T R A V E L E X P E N S E S S T A T E M E N T
Name |
De Cervantes, Miguel |
|||
Personnel no. |
00065734 |
Country template |
ES |
Payroll area 1 |
Trip no. |
0000000101 |
Personnel area |
ES01 |
Cost center TRV_01 |
I T I N E R A R Y
Main destination |
Reason/Location/Country |
TTS/TTE/Activity |
04.10.1997 06:00 - |
Executive training |
Trip |
04.15.1997 22:00 |
Bingen |
All employees |
Germany |
No distinction |
|
Border crossing, trip out |
04.10.1997 12:00 |
|
Border crossing, trip home |
04.15.1997 18:00 |
|
M E A L S A N D A C C O M M O D A T I O N S
Rec |
Amount in |
|||||||
Date |
No. |
Expen. text |
VAT |
Amount |
Curr. |
Ex. rate |
ESP |
|
04.10.97 |
001 |
Breakfast |
S0 |
2,000 |
ESP |
1.00000 |
2,000 |
|
04.10.97 |
002 |
Lunch |
S0 |
4,000 |
ESP |
1.00000 |
4,000 |
|
04.10.97 |
003 |
Dinner |
S0 |
5,000 |
ESP |
1.00000 |
5,000 |
|
04.10.97 |
004 |
Hotel |
S0 |
10,000 |
ESP |
1.00000 |
10,000 |
|
04.12.97 |
005 |
Hotel paid |
S0 |
100,000 |
ESP |
X |
1.00000 |
100,000 |
04.13.97 |
006 |
Lunch |
S0 |
2,500 |
ESP |
1.00000 |
2,500 |
|
04.14.97 |
007 |
Breakfast |
S0 |
20,000 |
ESP |
1.00000 |
20,000 |
|
04.14.97 |
008 |
Lunch |
S0 |
20,000 |
ESP |
1.00000 |
20,000 |
|
04.14.97 |
009 |
Dinner |
S0 |
20,000 |
ESP |
1.00000 |
20,000 |
|
04.14.97 |
010 |
Hotel paid |
S0 |
50,000 |
ESP |
X |
1.00000 |
50,000 |
04.15.97 |
011 |
Breakfast |
S0 |
2,800 |
ESP |
1.00000 |
2,800 |
Date |
Cntry |
Tax-free |
Company |
Amount, |
Amount, |
Reimburse. |
tax-free |
taxable |
amount |
||||
04.10.97 06:00 - 04.10.97 24:00 |
||||||
Max. rate |
DE |
61,000 |
62,000 |
|||
.L... |
0 |
3,200- |
||||
Reduced |
61,000 |
55,800 |
||||
Per diem |
DE |
22,600 |
24,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
22,600 |
20,800 |
||||
All receipts |
DE |
21,000 |
21,000 |
21,000 |
0 |
21,000 |
Per diem |
DE |
1,600 |
0 |
0 |
0 |
0 |
04.11.97 00:00 - 04.11.97 24:00 |
||||||
Max. rate |
DE |
61,000 |
62,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
61,000 |
58,800 |
||||
Per diem |
DE |
22,600 |
24,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
22,600 |
20,800 |
||||
Per diem |
DE |
22,600 |
20,800 |
20,800 |
0 |
20,800 |
04.12.97 00:00 - 04.12.97 24:00 |
||||||
Max. rate |
DE |
61,000 |
62,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
61,000 |
58,800 |
||||
Per diem |
DE |
22,600 |
24,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
22,600 |
20,800 |
||||
Paid receipts |
DE |
100,000 |
100,000 |
39,000 |
||
All receipts |
DE |
100,000 |
100,000 |
0 |
0 |
0 |
04.13.97 00:00 - 04.13.97 24:00 |
||||||
Max. rate |
DE |
61,000 |
62,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
61,000 |
58,800 |
||||
Per diem |
DE |
22,600 |
24,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
22,600 |
20,800 |
||||
All receipts |
DE |
2,500 |
2,500 |
2,500 |
0 |
2,500 |
Per diem |
DE |
20,100 |
18,300 |
18,300 |
0 |
18,300 |
04.14.97 00:00 - 04.14.97 24:00 |
||||||
Max. rate |
DE |
61,000 |
62,000 |
|||
.L... |
0 |
3,200- |
||||
Reduced |
61,000 |
58,800 |
||||
Per diem |
DE |
22.600 |
24,000 |
|||
.L... |
0 |
3,200 |
||||
Reduced |
22,600 |
20,800 |
||||
Paid receipts |
DE |
50,000 |
50,000 |
|||
All receipts |
DE |
110,000 |
110,000 |
8,800 |
0 |
8,800 |
04.15.97 00:00 - 04.15.97 22:00 |
||||||
Max. rate |
ES |
3,600 |
4,400 |
|||
.L... |
0 |
1,800 |
||||
Reduced |
3,600 |
2,600 |
||||
Per diem |
ES |
3,600 |
4,400 |
|||
.L... |
0 |
1,800 |
||||
Reduced |
3,600 |
2,600 |
||||
All receipts |
ES |
2,800 |
2,800 |
2,600 |
0 |
2,600 |
Per diem |
ES |
800 |
0 |
0 |
0 |
0 |
Total amounts meals and accomm. in ESP |
74,000 |
0 |
74,000 |
T O T A L A M O U N T S
Total amount tax-free in ESP Total imputed income (taxable amount) in ESP |
74,000 39,000 |
Trip reimbursement amount in ESP| |
74,000 |
S E T T L M E N T
Trip reimbursement amount in ESP| |
74,000 |
Paid by company |
150,000 |
Total trip costs in ESP |
224,000 |