Docstoc

N70_TDS_JISL_DOC

Document Sample
N70_TDS_JISL_DOC Powered By Docstoc
					TDS – JISL –POST LIVE DOCUMENTATION 1. CHECK WITHHOLDING TAX COUNTRIES:
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  Check Withholding Tax Countries

1

2. DEFINE WITHHOLDING TAX KEY Withholding tax keys identify the different withholding tax types, these are official names for company tax code.
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  Define Withholding Tax Keys

2

3. DEFINE WITHHOLDING TAX TYPE FOR INVOICE POSTING
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Calculation  Withholding Tax Type  Define Withholding Tax Type for Invoice Posting

TDS – INVOICE POSTING

3

SURCHARGE – INVOICE POSTING

4

EDUCATION CESS – INVOICE POSTING

5

HIGHER EDUCATION CESS – INVOICE POSTING

6

Withholding Tax Types for Invoice Posting WH Tax Code AA AB AC AD AE AF AG BA BB BC BD CA CB CC CD CE CF CG DA DB DC DD EA EB EC ED EE WH Tax Type AA AB AC AD AE AF AG BA BB BC BD CA CB CC CD CE CF CG DA DB DC DD EA EB EC ED EE

Name 193 Inv Interest on Securities [TDS]20% 193 Inv Interest on Securities [Sch]10% 193 Inv Interest on Securities [CESS]2% 193 Inv Interest on Securities [ECESS]1% 193 Inv Interest on Securities [TDS]10% 193 Inv Int on Sec [for TDS10%][CESS]2% 193 Inv Int on Sec [for TDS10%][ECESS]1% 194 Inv Dividend [TDS] 20% 194 Inv Dividend [CESS] 2% 194 Inv Dividend [Ecess] 1% 194 Inv Dividend [Sch] 0% 194A Inv Interest Others [TDS]20% 194A Inv Interest Others [Surcharge]10% 194A Inv Interest Others [CESS]2% 194A Inv Interest Others [Ecess]1% 194A Inv Interest Others [TDS]10% 194A Inv Int Oth[for TDS10%][CESS]2% 194A Inv Int Oth[for TDS10%][Ecess]1% 194H Inv Commission/Brokerage [TDS]10% 194H Inv Commission/Brokerage [Surcharge]10% 194H Inv Commission/Brokerage [CESS]2% 194H Inv Commission/Brokerage [Ecess]1% 194I Inv Rent [TDS]20% 194I Inv Rent [Surcharge]10% 194I Inv Rent [CESS]2% 194I Inv Rent [Ecess]1% 194I Inv Rent [TDS]15%

GL Account 16611201 16611204 16611206 16611208 16611201 16611204 16611206 16611401 16611406 16611408 16611404 16611421 16611424 16611426 16611428 16611421 16611424 16611426 16611471 16611474 16611476 16611478 16611481 16611484 16611486 16611488 16611481 7

EG EH EF EI EJ FA FB FC FD GA GB GC GD HA HB HC HD IA IB IC ID JA JB JC JD

EG EH EF EI EJ FA FB FC FD GA GB GC GD HA HB HC HD IA IB IC ID JA JB JC JD

194I Inv Rent[for TDS15%][CESS]2% 194I Inv Rent[for TDS15%][Ecess]1% 194I Inv Rent [TDS]10% 194I Inv Rent[for TDS10%] [CESS]2% 194I Inv Rent[for TDS10%] [Ecess]1% 194J Inv 194J Inv 194J Inv 194J Inv Fees [TDS]10% Fees [Surcharge]10% Fees [CESS]2% Fees [Ecess]1%

16611484 16611486 16611481 16611484 16611486 16611491 16611494 16611496 16611498 16611431 16611434 16611436 16611438 16611431 16611434 16611436 16611438 16611431 16611434 16611436 16611438 16611431 16611434 16611436 16611438

194C Contractor Invoice - [TDS]2% 194C Contractor Invoice - [Surcharge]10% 194C Contractor Invoice - [CESS]2% 194C Contractor Invoice - [ECESS]1% 194C Transporter Invoice - [TDS]2% 194C Transporter Invoice - [Surcharge]10% 194C Transporter Invoice - [CESS]2% 194C Transporter Invoice - [ECESS]1% 194C Postage Invoice - [TDS]2% 194C Postage Invoice - [Surcharge]10% 194C Postage Invoice - [CESS]2% 194C Postage Invoice - [ECESS]1% 194C Advertising Invoice - [TDS]1% 194C Advertising Invoice - [Surcharge]10% 194C Advertising Invoice - [CESS]2% 194C Advertising Invoice - [ECESS]1%

8

4. DEFINE WITHHOLDING TAX TYPE FOR PAYMENT POSTING
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Calculation  Withholding Tax Type  Define Withholding Tax Type for Payment Posting

9

Withholding Tax Types for Payment Posting WH Tax Code A1 A2 A3 A4 A5 A6 A7 B1 B2 B3 B4 C1 C2 C3 C4 C5 C6 C7 D1 D2 D3 D4 E1 E2 E3 E4 E5 E7 E8 E6 E9 F9 F1 F2 F3 F4 G1 G2 G3 G4 WH Tax Type A1 A2 A3 A4 A5 A6 A7 B1 B2 B3 B4 C1 C2 C3 C4 C5 C6 C7 D1 D2 D3 D4 E1 E2 E3 E4 E5 E7 E8 E6 E9 F9 F1 F2 F3 F4 G1 G2 G3 G4

Name 193 Pay Interest on Securities [TDS]20% 193 Pay Interest on Securities [Sch]10% 193 Pay Interest on Securities [CESS]2% 193 Pay Interest on Securities [ECESS]1% 193 Pay Interest on Securities [TDS]10% 193 Pay Int on Sec [for TDS10%][CESS]2% 193 Pay Int on Sec [for TDS10%][ECESS]1% 194 Pay Dividend [TDS] 20% 194 Pay Dividend [CESS] 2% 194 Pay Dividend [Ecess] 1% 194 Pay Dividend [Sch] 0% 194A Pay Interest Others [TDS]20% 194A Pay Interest Others [Sch]10% 194A Pay Interest Others [CESS]2% 194A Pay Interest Others [Ecess]1% 194A Pay Interest Others [TDS]10% 194A Pay Int Oth[for TDS10%][CESS]2% 194A Pay Int Oth[for TDS10%][Ecess]1% 194H Pay Commission/Brokerage [TDS]10% 194H Pay Commission/Brokerage [Surcharge]10% 194H Pay Commission/Brokerage [CESS]2% 194H Pay Commission/Brokerage [Ecess]1% 194I Pay Rent [TDS]20% 194I Pay Rent [Surcharge]10% 194I Pay Rent [CESS]2% 194I Pay Rent [Ecess]1% 194I Pay Rent [TDS]15% 194I Pay Rent[for TDS15%][CESS]2% 194I Pay Rent[for TDS15%][Ecess]1% 194I Pay Rent [TDS]10% 194I Pay Rent[for TDS10%] [CESS]2% 194I Pay Rent[for TDS10%] [Ecess]1% 194J Pay 194J Pay 194J Pay 194J Pay Fees [TDS]10% Fees [Surcharge]10% Fees [CESS]2% Fees [Ecess]1%

194C Pay Contractor - [TDS]2% 194C Pay Contractor - [Surcharge]10% 194C Pay Contractor - [CESS]2% 194C Pay Contractor - [ECESS]1%

10

H1 H2 H3 H4 I1 I2 I3 I4 J1 J2 J3 J4

H1 H2 H3 H4 I1 I2 I3 I4 J1 J2 J3 J4

194C Pay Transporter - [TDS]2% 194C Pay Transporter - [Surcharge]10% 194C Pay Transporter - [CESS]2% 194C Pay Transporter - [ECESS]1% 194C Pay Postage - [TDS]2% 194C Pay Postage - [Surcharge]10% 194C Pay Postage - [CESS]2% 194C Pay Postage - [ECESS]1% 194C Pay Advertising - [TDS]1% 194C Pay Advertising - [Surcharge]10% 194C Pay Advertising - [CESS]2% 194C Pay Advertising - [ECESS]1%

11

TDS – PAYMENT POSTING

12

SURCHARGE PAYMENT POSTING

13

EDUCATION CESS – PAYMENT POSTING

14

HIGHER EDUCATION CESS – PAYMENT POSTING

15

5. CHECK RECIPIENT TYPES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  Check Recipient Types

16

6. MAINTAIN TAX DUE DATES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  India  Maintain Tax Due Dates

17

7. Defining Rounding Rule for Withholding Tax Types
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Calculation  Withholding Tax Type  Define Rounding Rule for Withholding Tax Types

18

8. DEFINE WITHHOLDING TAX CODES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Calculation  Withholding Tax Codes  Define Withholding Tax Codes

TDS

Surcharge – 10% ON TDS 20%

19

CESS---2% ON TDS 20%

ECESS-----1% ON TDS 20%

20

9. Maintaining Types of Recipient
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Withholding Tax  Basic Settings  Maintain Types of Recipient

21

10. Maintaining Surcharge Calculation Methods
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Calculation  India  Surcharges  Maintain Surcharge Calculation Methods

MAINTAIN SURCHARGE RATES (Surcharges combined with basic W.tax Codes)

22

11. Defining Separate Tax Code for Education Cess & Defining Separate Tax Code for Secondary and Higher Education Cess
Transaction code IMG menu SM30 System  Services  Table Maintenance  Extended Table Maintenance

In order to include the Higher Education cess amount to the Education Cess amount – the relevant tax codes to be updated with Higher education cess table only. We have to update the table J_1IEWTECESS using SM30 – by preparing the codes in excel sheet. – Refer the excel sheet here.

23

12. ASSIGN WITHHOLDING TAX TYPE TO COMPANY CODE
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Company Code  Assign Withholding Tax Types to Company Code

Validity Dates are from 01.04.2008 To 31.03.9999.

24

13. ACTIVATE EXTENDED WITHHOLDING TAX
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Company Code  Activate Extended withholding tax

ENTER

25

14. DEFINE BUSINESS PLACES AND SECTION CODES The Business Places and Section Codes represents TDS Offices and the use of business place and section codes is mandatory.
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  India  Define Business Places

26

15. DEFINING SECTION CODES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Basic Settings  India  Define Section Codes

27

Important Note:

Update the address details for each section code, to get the address to print on TDS Certificate. Click on address tab to enter the address on APTB. The address details are to be updated for each Business Place / Section Code.

28

16. DEFINE ACCOUNTS FOR WITHHOLDING TAX TO BE PAID OVER
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  Accounts for withholding tax Define Accounts for Withholding Tax to be paid over

System will ask for saving the rule first. Save. Then we will get the following screen

Click on posting Key—by Default the screen should come:

29

Then go back by clicking on Accounts-to map the GL accounts as follows, or refer the excel file attached above and here.

30

17. MAINTAIN NUMBER GROUPS (For internal challan numbers)
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Remittance ChallansMaintain Number Groups. System  Services  Table Maintenance  Extended Table Maintenance SM30

SAP menu Transaction code

Although we update the details in the above screen through the menu path in IMG the table J_1IEWTNUMGR_1 also needs to be checked through transaction code SM30 and if the above data is not reflected in the table we need to again update and maintain the same data in the above table.

31

18. ASSIGN NUMBER RANGES TO NUMBER GROUPS
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Remittance ChallansAssign Number Ranges to Number Groups

In this customizing activity we manually update the number groups and the internal number range. Note : These number ranges are not transferable through Transport Request-TR. We have to maintain for each client and save.

32

19. MAINTAIN NUMBER RANGES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Remittance ChallansMaintain Number Ranges

By Default the Number groups will be without text

Right Click on ―Group without Text‖ and select Maintain Text:

Popup comes to change the group text. Change the Group Text as per number groups identified based on section code and withholding tax key.

33

34

Withholding Tax / TDS Certificates for Vendors and Customers 20. ENTER GLOBAL PARAMETERS
Transaction code IMG menu OBY6 Financial Accounting (New)  Financial Accounting Global Settings (New)  Global Parameters for Company Code  Enter Global Parameters

Click on additional Details icon.

35

21. MAINTAIN NUMBER GROUPS AND SAP SCRIPT FORMS
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Withholding Tax Certificates for Vendors and CustomersMaintain Number Groups and SAP script Forms System  Services  Table Maintenance  Extended Table Maintenance SM30

SAP menu Transaction code

Also execute Transaction Code SM30 and check table J_1IEWT_CERT_N to verify if the above data gets updated and if not then update the table as per the data given above and save.

36

Important Note:
1. Changed the Script form with ZJ_1IEWT_CERT

2. Here we have changed the program of the script – to arrive the TDS Number as mentioned in Global parameters above, for the JISL company code on to the TDS Certificate. The script code has called a new program created for capturing the TDS number updated in OBY6 for company code.

37

Code Changes in Script - ZJ_1IEWT_CERT
PERFORM GET_DETAILS IN PROGRAM Z_T001Z_PAVAL USING &PAVAL& CHANGING &PAVAL& ENDPERFORM &PAVAL&(&j_1iewt_cert-j_1isectyp&)&adrc-name_text&,,,, New Report that is getting called from the Script. FORM get_details TABLES in_tab STRUCTURE itcsy out_tab STRUCTURE itcsy. DATA: l_paval LIKE t001z-paval. READ TABLE in_tab WITH KEY name = 'paval'. SELECT FROM INTO WHERE AND SINGLE paval t001z l_paval bukrs = 'JISL' party = 'J_1I01'.

in_tab-value = l_paval. out_tab-name = in_tab-name. out_tab-value = l_paval. refresh out_tab[]. append out_tab. refresh in_tab[]. append in_tab. ENDFORM.

38

22. PAN NUMBER OF THE VENDOR
SAP menu Transaction code J1ID

To get the PAN number of the Vendor on the TDS Certificate – use Tcode : J1ID to update the vendor PAN number details.

Click on change button

39

23. ASSIGN NUMBER RANGES TO NUMBER GROUPS
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Withholding Tax Certificates for Vendors and Customers  Assign Number Ranges to Number Groups

40

24. MAINTAIN NUMBER RANGES
Transaction code IMG menu SPRO Financial Accounting (New)  Financial Accounting Global Settings (New)  Withholding Tax  Extended Withholding Tax  Postings  India  Withholding Tax Certificates for Vendors and Customers  Maintain Number Ranges

41

25. Acknowledgement numbers
Transaction code IMG menu SM30 System  Services  Table Maintenance  Extended Table Maintenance

Also Update the table J_1IEWT_ACKN_N. This is required to get acknowledgement numbers [12 Digit] on the TDS Certificate along with Quarter no.

Also execute Transaction Code SM30 and check table J_1IEWT_CERT_N to verify if the above data gets updated and if not then update the table as per the data given above and save.
Note : This part of updation to be trained to the Customer – and to be done by the responsible person from Customer Core Team.

Important Note: If you are using separate tax codes for Education Cess, those tax codes should be maintained in the J_1EWTECESS table and ‗X‘ should be maintained for the company code in J_1EWT_ECFLAG table.

42

26. Maintaining Bank BSR Codes
Transaction code IMG menu FI01 / FI02 SAP Easy Access  Accounting – Financial Accounting  Banks  Master Data  Bank Master Record  Create

This is also maintained along with House Banks Master Data.

43

27. Cheque Number printing on TDS Certificate
For getting the Cheque number printed on to the TDS Certificate – SAP Note 912767 has been applied or not to be checked. There is an USER EXIT for this purpose – J_1I7_USEREXIT_CHEQUENO_CERT. The User Exit Code has been changed based on fields it is capturing the cheque number while doing Manual Cheque assignment after the TDS Payment.
FUNCTION J_1I7_USEREXIT_CHEQUENO_CERT. *"--------------------------------------------------------------------*"*"Local Interface: *" TABLES *" I_PRINTTAB OPTIONAL *"--------------------------------------------------------------------*{ INSERT JEDK901642 1 DATA : I_payr LIKE payr OCCURS 0 WITH HEADER LINE. DATA: i_J_1IEWTCHLN like J_1IEWTCHLN OCCURS 0 WITH HEADER LINE. data : BEGIN OF zprinttab OCCURS 0 . INCLUDE STRUCTURE with_item. DATA: budat LIKE bkpf-budat, bupla LIKE bseg-bupla, secco LIKE bseg-secco, j_1iextchln LIKE j_1iewtchln-j_1iextchln, j_1iextchdt LIKE j_1iewtchln-j_1iextchdt, bankl LIKE j_1iewtchln-bankl, flag TYPE c, no_print TYPE c, method type c, print_order LIKE sy-tabix, lifnr LIKE bseg-lifnr, base_mod type c, sno LIKE sy-tabix, tds_amount LIKE bseg-wrbtr, surc_amount LIKE bseg-wrbtr, ecess_amount LIKE bseg-wrbtr, cheque_no like inrdp-fromnumber, banka LIKE bnka-banka, ort01 LIKE bnka-ort01, brnch LIKE bnka-brnch, j_1itdbank like J_1ICERTIF-j_1itdbank, word LIKE spell-word, paise LIKE spell-decword, END OF zprinttab. data : BEGIN OF zprint . INCLUDE STRUCTURE with_item. DATA: budat LIKE bkpf-budat, bupla LIKE bseg-bupla, secco LIKE bseg-secco, j_1iextchln LIKE j_1iewtchln-j_1iextchln, j_1iextchdt LIKE j_1iewtchln-j_1iextchdt, bankl LIKE j_1iewtchln-bankl, flag TYPE c, 44

no_print TYPE c, method type c, print_order LIKE sy-tabix, lifnr LIKE bseg-lifnr, base_mod type c, sno LIKE sy-tabix, tds_amount LIKE bseg-wrbtr, surc_amount LIKE bseg-wrbtr, ecess_amount LIKE bseg-wrbtr, cheque_no like inrdp-fromnumber, banka LIKE bnka-banka, ort01 LIKE bnka-ort01, brnch LIKE bnka-brnch, j_1itdbank like J_1ICERTIF-j_1itdbank, word LIKE spell-word, paise LIKE spell-decword, END OF zprint. clear: I_PRINTTAB, ZPRINT, ZPRINTTAB. refresh : zprinttab. CLEAR I_payr. REFRESH I_payr. loop at i_printtab. MOVE-CORRESPONDING I_PRINTTAB TO ZPRINT. append ZPRINT to zprinttab. clear zprinttab. clear zprint. endloop. SELECT * INTO CORRESPONDING FIELDS OF table i_J_1IEWTCHLN FROM J_1IEWTCHLN FOR ALL ENTRIES IN zprinttab WHERE J_1IEXTCHLN = zprinttab-j_1iextchln AND J_1IEXTCHDT = zprinttab-j_1iextchdt. sort i_J_1IEWTCHLN by belnr. SELECT * INTO CORRESPONDING FIELDS OF TABLE I_payr FROM payr FOR ALL ENTRIES IN i_J_1IEWTCHLN WHERE VBLNR = i_J_1IEWTCHLN-BELNR AND ZALDT = i_J_1IEWTCHLN-j_1iextchdt. sort i_payr by vblnr. IF SY-SUBRC EQ 0. LOOP AT zprinttab. READ TABLE i_J_1IEWTCHLN WITH KEY J_1IEXTCHLN = zprinttab-j_1iextchln J_1IEXTCHDT = zprinttab-j_1iextchdt BINARY SEARCH. READ TABLE i_payr WITH KEY vblnr = i_J_1IEWTCHLN-belnr zaldt = i_J_1IEWTCHLN-j_1iextchdt BINARY SEARCH. IF SY-SUBRC EQ 0. zprinttab-cheque_no = I_payr-CHECT. zprinttab-brnch = Ipay-bankl. MODIFY zprinttab. ENDIF. ENDLOOP. CLEAR I_PRINTTAB. REFRESH I_PRINTTAB. 45

*

LOOP AT ZPRINTTAB. MOVE-CORRESPONDING ZPRINTTAB TO I_PRINTTAB. APPEND I_PRINTTAB. clear i_printtab. ENDLOOP. ENDIF. * *} INSERT ------------------------------------------------------------------------------------------------------------------------

46

Withholding Tax (Tax Deducted at Source) Processing - Manual
1. CHANGE CHECK WITH VENDOR MASTER RECORDS – INTENDED FOR TDS

T Code : FK02

ENTER
Check whether both Invoice and Payment Tax Codes are entered and saved, else we can enter and save.

47

2. POST VENDOR INVOICE – FROM FI SAP EasyAccountingFinancial AccountingAccounts payable  Document EntryInvoice General (F-43)



Business Place and Section Codes Mapping is must while doing the transactions. If this is not done, at the Remittance Challan, TDS Payable will not be displayed. For Example: o o While Making Advance Payment While making invoice from FI, if any.

Note: If we don’t maintain Business Place and Transaction Codes at the time of Transaction, the same will not be picked for TDS Remittance

At the time of invoice, we have to remove the Payment TDS Codes and keep only invoice TDS Codes.

48

Document Simulation

Document 1900000040 was posted in company code JISL

49

3. TDS Remittance Challan Procedure
1. Access the activity choosing one of the following navigation options: SAP menu Accounting Financial AccountingAccounts PayableWithholding TaxIndiaExtended Withholding taxInformation systemJ1INMIS – Withholding Tax J1INMIS

Transaction code

With this one Screen we can complete upto the Consolidated Report.

Execute

Click on Challan update

50

Here we have to give the payment bank account through which we are paying the TDS amount – as 24100191 as above. Execute

Change the document type to SK, give the value date, and text, click on process open items.

51

Click on Green tick / continue

52

The amount in the first line item to changed to 226 as above, click on back arrow

Double click on line item and change the amount to 226

DocumentSimulate and post

53

Remittance Challan Created.

You will get Clearing document number, challan number etc details as above.

54

4. Create and New Session To issue manual cheque for this Payment and assig the Cheque Number to the TDS Payment Document as created above. Note: This is important to get the Cheque number printed on to the TDS Certificate automatically. T Code: FCH5

Give the relevent Cheque number for the Bank through which the TDS Payment has been made as above.

Check JISL AXI02 AXI02 100153 created manually

From this transaction the TDS Certificate Program picks the Cheque number field in the above screen.

55

T Code: FCHU To assign the Cheque number to the payment document.

Give the target field in which the cheque number to be displayed and F8 Execute

Now for the above TDS Payment Document the Cheque number assigned. Document Display – FB03 for the Bank Line Item

56

5. TDS Remittance – Bank Challan Updation Go back to the main window from the Step No.4 above session of withholding tax information system  Select Bank challan status now and execute-F8

Select the Internal challan number as above relevant for this vendor and click on Bank challan update.

57

Give the bank challan number received from the bank, - manual number and Bank key of the payment bank used for the above payment.

Execute

58

6. Vendor TDS Certificate Print
Use
You need to issue the TDS certificates to the vendor for each type of services separately i.e. TDS section code wise. TDS certificate has to be generated as per the format of Form 16A. The TDS certificate contains various details, company address and TAN number, vendor‘s PAN number, vendor address, tax details, external challan remittance, external challan date, etc., some among them.

Procedure
1. Access the activity choosing one of the following navigation options: SAP menu Accounting Financial AccountingAccounts PayableWithholding TaxIndiaExtended Withholding taxCertificates J1INCERT - Print J1INCERT

Transaction code

Alternatively – We can print the Certificate from the above session itself – Select Certificate Status – and Execute

59

Click on Certificate Printing Button Give the Details as required to print the certificate

Execute

60

Give the output device and select only [ New Spool Request] click on print ]

Go to system  Own Spool Request and print the certificate.

61

62

63

7. TDS Quarterly E-Returns
Use As per the legal requirement quarterly e-TDS returns are to be submitted in the prescribed e-TDS file format. This e-file needs to be mailed or submitted to Income Tax Authorities quarterly. Prerequisites TDS is deducted, TDS challan is deposited and entries are posted appropriately in SAP.

Procedure
1. Access the activity choosing one of the following navigation options: SAP menu Accounting Financial AccountingAccounts PayableWithholding TaxIndiaExtended Withholding taxReporting J1INQEFILE - Quarterly TDS Returns J1INQEFILE

Transaction code

2. On the Quarterly E-returns (India) screen, make the following entries: Field name Company Code Deductor Status Deductor State Co Tax Deduction Account Number Period Fiscal period Description Company Code Deductor status Deductor state code Tax Deduction Account Number Quarter Fiscal period User action and values JISL O 13 NSKJ0066D Comment Enter the company code key If you are not central government organization For example only For example only

Q2 e.g.> 01.04.2007 to 30.06.2007 194C

Q1, Q2, Q3, Q4 For example period only

Section Code

Section Code

For example only

3. On the Quarterly E-returns (India) screen, on the Address Details tab, make the following entries: Field name Name of the Deductor Description Name of the Deductor User action and values Jain Irrigation Systems Ltd., Comment For example only

Deductor Division/Branc h Flat / Door / Block No.

Deductor Division/Branch Flat / Door / Block No. For example only

64

Name of the Building / Office Road / Street / Lane Area / Locality / Post Off. Town / City / District Post code State E-mail ID STD code Phone Number Add. Changed from last return

Name of the Building / Office Road / Street / Lane Area / Locality / Post Off. Town / City / District Post code State E-mail ID STD code Phone Number Flag to indicate if address is changed from last return Jalgaon 560025 13

For example only

For example only

For example only For example only For example only For example only For example only For example only

65

4. On the Quarterly E-returns (India) screen, on the Responsible person’s Address tab, make the following entries: Field name Name of the Responsible Designation Description Name of the Responsible Designation User action and values Mr. Accounts Manager Dy. General Manager – Accounts 7/4 Comment For example only

For example only

Flat / Door / Block No. Name of the Building / Office Road / Street / Lane Area / Locality / Post Off. Town / City / District Post code State E-mail ID STD code Phone Number Remark Add. Changed from last return 

Flat / Door / Block No. Name of the Building / Office Road / Street / Lane Area / Locality / Post Off. Town / City / District Post code State E-mail ID STD code Phone Number Remark Flag to indicate if address is changed from last return

For example only For example only

For example only

For example only For example only For example only For example only For example only For example only

66

On the Quarterly E-returns (India) screen, on the Output processing options tab, make the following entries: Field name Output e-File generation Layout Description Select to see an output display Select to generate e-file Layout name User action and values X X Comment For example only For example only Leave blank

e-File; Download specifications Application Server Appln Server File; parameter Presentation Server Text File Name Excel File Name Select to download the file on the application server Name of the file for downloading into on the application server Select to download the file on the presentation workstation Name of the text file for downloading on to the presentation workstation Name of the MS-Excel file for downloading on to the presentation workstation X For example only

Q2FILE

D:\Desktop\T ds_Efile.xlsx

For example only

67

5. Choose Execute (F8).

Depending on the options selected, you have displayed and/or generated the e-file for quarterly e-TDS returns.

To Generate E File into Excel – List  Export

Give the File name to the Location and Click on Generate

68

28. Lower Deduction of TDS When Vendors who got Exemption Certificate
In order to configure the lower Deductions for a particular Vendor, based on the Exemption Certification submitted by the Vendor, we need to configure the vendor master Record accordingly. For Example : A particular vendor submitted TDS Exemption certificate to JISL, to charge the Basic TDS at the rate of 0.50% only, with effect from 24.06.2008. That means from 2% basic rate of TDS 1.5% is exempted. That comes to 75% of the basic rate. Ensure that the exemption is for both invoice and payment TDS Codes. Go the Vendor Master Record – FK02 and enter the exemption percentage 75% as explained above and save the record.

Necessary Testing has been done for the system will take care of exemption from and to dates. After the end date, system will calculate full % of TDS.

69

TDS Code Changes to the Mater Records Whenver any changes made to the Vendor Master Records in respect of TDS Codes the following Program has to be updated and then only TDS Transactions to be done. Program : RFWT0010 TCode: SA38

EXECUTE

70

For example for the Vendor 2000006 the Payment Posting TDS Codes have been changed in the master record before running this programme. G1,G2, G3, G4 – CHANGED TO – H1, H2, H3, H4

71

System will prompt as below, with TDS Information changed.

########

72

TDS – Withholding Tax – Dos and Don’ts – JISL SAP  Select the TDS Codes to be based on your Vendor Classification, if not included in the master record.  Assign the TDS Codes in the Vendor Master Record. o Both for Invoices and Payments  Business Place and Section Codes Mapping is must while doing the transactions. If this is not done, at the Remittance Challan, TDS Payable will not be displayed. For Example: o While Making Advance Payment o While making invoice from FI, if any.




While making the transaction system will prompt with TDS Codes for that particular vendor. You have to remove the tax codes not relevant for the transaction at the time of transaction entry. Explained in Training.
To issue manual cheque for this Payment and assig the Cheque Number to the TDS Payment Document as created above. Note: This is important to get the Cheque number printed on to the TDS Certificate automatically.



o Program name RFWT0010 – has to be updated when ever there is a vendor / customer master changes done by the Core Team. After running this program only they have to do the tds transaction.
####

73


				
DOCUMENT INFO
Categories:
Tags:
Stats:
views:1826
posted:5/6/2009
language:English
pages:73
Description: TDS CONFIG ECC 6.0