WELCOME TO DELHI RCC

1. WELCOME TO DELHI RCC

2. Arrear Demand

3. Why so urgently ?

4. Concerns • Demand Uploaded through ADCR Portal + IRL Demand < CAP-I report • Demand uploaded is incorrect leading to grievances • Action plan target to upload 100% demands

5. Case of Mathur • Received143(1) order – two months • Refund of Rs 220 was adjusted against demand of AY 2006-07 • Enquired CPC Call centre. Why? • To his dismay he knows about DEMAND of 30K+ was uploaded for 2 Ass. Years. • What to do?

6. Issues • Data was not verified • Data was uploaded • Unaware how to correct it • Give me an direction • So is not trained

7. LOGIN • Click on Internet Explorer on the system which is on the taxnet • Type the URL https://cpcaoportal.dept.cpc.gov.in • For security reasons ITD as well as CPC has gone for 2 factor authentication [RSA] • To login to CPC Portal • Login with RSA Token • Login with regular Userid and password used in ITD apps

8. URL for CPC Portal https://cpcaoportal.dept.cpc.gov.in not http://cpcsso.incometax.net.in

13. Issues • Unable to login • Is your userid mapped • As per the recent password change policy have you the password changed within 30 days • When the same password is working for my ITD applications why is not working for AST applications • Are you holding additional charge ?

14. Additional Charge • AO is holding Additional charge then AO can upload the arrear data with Range Head’s code • If both Range head and AO are additional charges ?

15. Where is the Utility & Info ? • Where is the utility • Where are the codes • What are the valid sections • Etc.,

17. Click here To download the arrear demand utility, CBDT instruction, user manual for Arrear demand and associated FAQs • Click here To download the manual on how Assessing Officers can identify the returns transferred from CPC to AST • Click here To download the help document on Arrear Demand Error Codes • Click here To download the presentation explaining the procedure to Upload Arrear Demand • Click here To download the clarification document • Click here To download the CPC News Letter

18. Before using the utility … • If you are using MS Office 2003 or below set the security level low. How? Tools > Macros > Security > Low • If you are using Windows XP ensure that you have installed the latest Service Pack. How will you know?

19. Upload process briefly …

20. Demands • Demands available with A Os are in 3 modes. IRL,TMS,MANUAL • IRL demands can be generated through a report under the module IRL • TMS demands are the demands raised using TMS/Local packages - available in dbf form • MANUAL demands are raised manually either available in excel or books

21. Which is correct Demand ? • Find out the demand available on record • Verify whether any further orders (154, 143(3) etc.,) are passed • Verify any payments done • Net will be the correct demand to be uploaded

22. Demo of uploading

23. Upload failed with error 13 • Date error • Possibility of spaces in the Total Income • Error in date format

24. What to do? • Old demand where PAN is unavailable • Demand where PAN is available but files are not available • Demands relating to Block Assmt

25. Caution • Upload demands raised through AST upto 31-03-2010 only • Manual and TMS demands should be uploaded always

26. File upload Successful ? • How do you know that file upload is successful • Did you observe the left hand portion of the screen

28. What did you see? • File uploaded successfully • Files not uploaded successfully • File with this name has already been uploaded • Area code does not match • Area Type code does not match • Range code does not match • AO Number does not match

29. What happens after upload • Data is received at CPC through exchange tables • Inwarded data is thoroughly validated – PAN, Section code [with master tables] • Successfully validated records are uploaded to FAS • Failed records are tagged with the error codes

31. What is the status? • File uploaded successfully. Verification (Step 1) in progress. • File uploaded successfully. Verification (Step 2) in progress. • Application Error • File Processed Successfully

32. Upload Successful. Really?

33. Technical Issues • Update document details operation failed • Run Time error occurred in Arrear Demand Approval Process  • File Adaptor Operation failed in Arrear Demand Process • Update DB operation failed in Arrear Demand Process • ArrearDemandProcess failed while posting to Oracle Apps

34. Upload 100%. Are you Sure?

35. Verification of the upload • I have uploaded the demand but CPC did not adjust • Did you verify the upload status? • How will I do it? • DOWNLOAD – OPEN – CHECK STATUS – ACT – UPLOAD • How to do?

38. What is the outcome • Click on the hyperlink • download latest arrear demand records • Data uploaded by AO will be downloaded as an xml file • Open the xml file in ADCR 1.13 utility. Not in Excel • Select Home page and click on Import xml • Observe column AV (S/P/F) • Observe column AX

39. What did you observe? •  DIN Validation failed (6) • The 4th character of PAN is invalid (For DDT, 4th character can only be “C”). •  Application error has occurred at CPC Accounting System (8) •  If the section is 220(2) in section column, the amount of interest has to be entered in demand column (9) •  Demand column and Interest column cannot be blank or zero (10) •  Demand amount cannot be blank or zero (11) •  Two or more records with the same DIN exist in a single file. Therefore, all such records with the same DIN are rejected/errored out (12)

40. This is Original record but DIN already exists in CPC Accounting System (13) • Key attributes, i.e., DIN, AY, PAN, Section Code, Schedule Type and Last Interest Calculation Date should not be changed in the reversal/revised record uploaded with Addl. CIT’s code (14) • Arrear demand is already adjusted against refund at CPC. Reversal/Revision rejected.

41. Section code is mandatory (16)

42. Order date is mandatory (17) • Demand created in AST on or after 01/04/2010 need not be uploaded through this portal. Therefore, errored out (18) • Source of Demand (IRLA/TMS/MNL) is mandatory (19) • This record already exists. Duplicate data is being passed with the same file ID. (20) • This is original record but PAN, Section code, Schedule Type, AY already exists is CPC Accounting system. It is possible that you or any other AO has already uploaded this demand(21)

43. File processing failed due to System Error in CPC Accounting System (25) • File processing failed due to error in DIN Sequence Num generation (26) • Error in Updating Application Database (27) • Demand Reversal not allowed for AO (28) • Original Demand uploading is to be done only with AO’s code (29) • PAN Invalid (30) • File Corrupted (32)

44. Correction

45. Types of corrections • Correction of demands which had errored out • Correction of demands which have been successfully upload

46. Errored out records • As per the error displayed in column AX take the corrective measure • Generate XML • Upload can be done by the Assessing officer himself • Range head also can upload this xml file

47. Successfully uploaded records (correction)

48. What to do Demand uploaded in the case of one assessee Ay – 2006-07 • Demand u/s 143(1) - 12230696 • Demand u/s 154 - 708221 What will happen?

49. How to correct? • Download the arrear data • Open the xml file in ADCR 1.13 • Reduce the demand u/s 143(1) to 0 • Upload the demand raised u/s 154 • Generate xml • Upload through Range Head

50. Successfully uploaded records (CORR) • I have uploaded a demand of 25000 u/s 143(1) but missed out the later 154 where the demand is reduced to 13500 • Can I correct the section as 154 and demand as 13500 ?