Tax details (File path) upload (worksheet / template)

[Former Member]

Hi,

Please help me out on this, I need to upload tax details (file path) in form16 of one TDS amount and this value will show in summary in TDS & page no.3 (chalan details). I have prepared a worksheet to upload the same , but it is not working,

Any help in this reqard would be highly appreciated.

emp.num Comp.Code payroll peri tax surchage cess total che.num bank num challan date vocer number TDS date

[Former Member]

Any suggestion for the above would be highly helpful

[Former Member]

Hi,

For correct file format check the SAP Note 1468518. However, i am also puttinng the format of tab delimited .txt file with example -

Field                                   Field type   Length   dummy value
|Employee Number                 |TEXT    |      8|    400010001|
|Company code                      |TEXT    |      4|               IN01|
|Payroll period                         |TEXT    |      6|         012009|
|Income tax                             |TEXT    |    15|            20000|
|Surcharge                              |TEXT    |     15|            2000|
|Education cess                      |TEXT    |    15|               200|
|Total tax                                 |TEXT    |     15|          22200|
|Cheque/DD Number               |TEXT    |    14|           12345|
|Bank branch code                 |TEXT    |      7|       1234567|
|Challan date                           |TEXT    |    10|   28.04.2009|
|Challan number                      |TEXT    |      9|           12345|
|Pay Date                                |TEXT    |    10|    21.04.2009|
|Begin Date of payroll period  |TEXT    |     10|   01.04.2009|
|End Dateof payroll period      |TEXT    |     10|   30.04.2009|

- Praveen

Edited by: praveen.hcm on May 12, 2011 11:41 AM

[Former Member]

HI,

Thanx a ton for your reply. But just to update you, SAP have revised the template to upload tax details. The concerned note is 1573538.

Field Description |Type |Length |Example |

-

---

Employee Number	TEXT	8	400010001
Company code	TEXT	4	IN01
FOR period	TEXT	6	200901
FOR period start date	TEXT	8	20090401
FOR period end date	TEXT	8	20090430
Income tax	TEXT	15	20000
Surcharge	TEXT	15	2000
Education cess	TEXT	15	200
Total tax	TEXT	15	22200
Cheque/DD Number	TEXT	14	12345
Bank branch code	TEXT	7	1234567
Challan date	TEXT	10	20090428
Challan number	TEXT	9	12345
Pay Date	TEXT	10	20090421
Pay Type	TEXT	1	A
Pay ID	TEXT	1
Begin Date of payroll period	TEXT	10	20090401
End Date of payroll period	TEXT	10	20090430

-

---

[Former Member]

Oh great. So is it working for you?

[Former Member]

Yeah, I have tested too.

Cheers!