Show TOC

 Example: Mixed Settlement with Clearing of Differences

The switch in view V_T702N_A (Settlement control in the expert view : Spanish settlement) in the V line is set in position 1 to ‘1’ and in position 16 to ‘1’ and thus allows mixed settlement with clearing of differences to be performed.

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.

0000000053

Personnel area

ES01

Cost center TRV_01

I T I N E R A R Y

Main destination

Reason/Location/Country

TTS/TTE/Activity

02.10.1997 06:00 -

Executive training

Trip

02.15.1997 22:00

Bruchsal

All employees

 

Germany

No distinction

Border crossing, trip out

02.10.1997 12:00

Border crossing, trip home

02.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

02.10.97

001

Breakfast

S0

2,000

ESP

 

1.00000

2,000

02.10.97

002

Lunch

S0

4,000

ESP

 

1.00000

4,000

02.10.97

003

Dinner

S0

5,000

ESP

 

1.00000

5,000

02.10.97

004

Hotel

S0

10,000

ESP

 

1.00000

10,000

02.12.97

005

Hotel paid

S0

100,000

ESP

X

1.00000

100,000

02.13.97

006

Lunch

S0

2,500

ESP

 

1.00000

2,500

02.14.97

007

Breakfast

S0

20,000

ESP

 

1.00000

20,000

02.14.97

008

Lunch

S0

20,000

ESP

 

1.00000

20,000

02.14.97

009

Dinner

S0

20,000

ESP

 

1.00000

20,000

02.14.97

010

Hotel paid

S0

50,000

ESP

X

1.00000

50,000

02.15.97

011

Breakfast

S0

2,800

ESP

 

1,00000

2,800

Date

Cntry

Tax-free

Company

Amount,

Amount,

Reimburse.

tax-free

taxable

amount

02.10.97 06:00 - 02.10.97 24:00

Max. rate

DE

61,000

62,000

     

Per diem

DE

22,600

24,000

All receipts

DE

21,000

21,000

21,000

0

21,000

Per diem

DE

1,600

3,000

1,600

1,400

3,000

02.11.97 00:00 - 02.11.97 24:00

Max. rate

DE

61,000

62,000

     

Per diem

DE

22,600

24,000

Per diem

DE

22,600

24,000

22,600

1,400

24,000

02.12.97 00:00 - 02.12.97 24:00

Max. rate

DE

61,000

62,000

     

Paid receipts

DE

100,000

100,000

 

39,000

 

All receipts

DE

100,000

100,000

0

0

0

02.13.97 00:00 - 02.13.97 24:00

Max. rate

DE

61,000

62,000

     

Per diem

DE

22,600

24,000

All receipts

DE

2,500

2,500

2,500

0

2,500

Per diem

DE

20,100

21,500

20,100

1,400

21,500

02.14.97 00:00 - 02.14.97 24:00

Max. rate

DE

61,000

62,000

     

Per diem

DE

22,600

24,000

     

Paid receipts

DE

50,000

50,000

     

All receipts

DE

110,000

110,000

11,000

1,000

12,000

02.15.97 00:00 - 02.15.97 22:00

Max. rate

ES

3,600

4,400

     

Per diem

ES

3,600

4,400

All receipts

ES

2,800

2,800

2,800

0

2,800

Per diem

ES

800

1,600

800

800

1,600

Total amounts meals and accomm. in ESP

82,400

6,000

88,400

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

82,400

39,000

Total amount taxable/Additional amount in ESP

6,000

Trip reimbursement amount in ESP

88,400

S E T T L E M E N T

Trip reimbursement amount in ESP

88,400

Paid by company

150,000

Total trip costs in ESP

238,400

First, the individual meals receipts are printed with amounts. Then the receipt totals per day are shown with the respective tax-free maximum rates for receipts and tax-free per diem amounts. Furthermore, there is a line for each day with the per diem reimbursed on this day or the cleared difference.

On 2/10/97, a tax-free per diem of 22,600 (for Germany, several days, statutory) and a company-internal per diem of 24,200 (for Germany, more than one day, enterprise-specific) apply. Also, the amount up to which receipts are reimbursed tax-free is displayed, as soon as they exceed the tax-free per diem, 61,000. Next to that, the amount 62,000, up to which the company reimburses receipts is shown. Anything above that is capped. If the receipt total amounts to 21,000, as in this case, this amount is reimbursed tax-free, since it is less than the limit of 22,600. Also, the employee is paid 3,000 since his receipts only amount to 21,000 Pts although he would receive 24,000 Pts from the enterprise without receipts. Of these 3,000, 1,600 is tax-free and 1,400 is taxable.

On 2/11/97, a tax-free per diem of 22,600 (for Germany, more than one day, statutory) and a company-internal per diem of 24,000 (for Germany, more than one day, enterprise-specific) apply. Also, the amount up to which receipts are reimbursed tax-free is displayed, as soon as they exceed the tax-free per diem, 61,000. Next to that, the amount 62,000, up to which the company reimburses receipts, is shown. As in per diem settlement, the 22,600 is reimbursed tax-free, and the 1,400 is reimbursed as an additional amount, totaling a reimbursement of 24,000.

On 2/12/97, the employee had a hotel receipt paid by company amounting to 100,000. Both the tax-free and the enterprise-specific maximum amounts are reduced by 100,000. Consequently, the employee receives 0 reimbursed. The 39,000 imputed income is also indicated (see example for receipt accounting).

For 2/13/97, the employee only submitted a small receipt amount: 2,500. He therefore remains below the limit for tax-free per diems 22,600. He receives 2,500 + 20,100 tax-free, and 1,400 as an additional amount.

On 2/12/97, the employee had a hotel paid by company amounting to 50,000. Both the tax-free and the enterprise-specific maximum amounts are reduced by 50.000. Consequently, the employee receives 12,000 reimbursed. If the enterprise-specific maximum amount were not 62,000, as in this case, but, for example, 200,000, the employee would be reimbursed the remaining taxable 60,000.

On 2/15/97, the last day of the trip, the tax-free per diem 3,600 (Spain, last day, statutory) and the enterprise-internal per diem 4,400 (Spain, last day, enterprise-specific) apply. Furthermore, the amount up to which receipts are reimbursed tax-free is displayed, as soon as they exceed the tax-free per diem, 3,600. Next to that, the amount 4,400 up to which the company reimburses receipts is shown. Thus, the receipt total of 2,800 and the cleared difference of 1,600 (800 tax-free and 800 taxable) are reimbursed.