Dear Frinds
SORRY FRIENDS I FORGOTTEN FEW STEPS IN LOST POST
How to generate new ecr 2
First open new excel sheet in first row for header 1 UAN NO 2 NAME 3 GROSS SAL 4 EPF SAL 5EPS SAL 6 EDLI SAL (SAME SAL EPF ) 7 EE CON 12%OR 10% 8 ER CON 8.33% 9 DIFF EE CON & ER CON 10 NCP DAY 11 ADVANCES /REFUND FILL IT IN EXCEL SHEET AND SAVE AS csv FILE AND OPEN IT IN NOTEPAD AND SAVE THE FILE AS txt NOW REPLACE , TO #~# NOW txt ECR FILE READY LIKE THIS
100132409491#~#DEEPAK M KMALLESAPPA#~#2400#~#2000#~#2000#~#2000#~#240#~#16 7#~#73#~#11#~#0
100236604905#~#MUDAKAPPA B NARGUND#~#1550#~#1300#~#1300#~#1300#~#156#~#108#~# 48#~#18#~#0
100226790766#~#MEHABOLI M MMOULASAB#~#1950#~#1500#~#1500#~#1500#~#180#~#125# ~#55#~#16#~#0
HEADER LINE SHOULD BE DELETED IN NOTE PAD NOW THIS ECR FILE IS READY TO UPLOAD IN ECR UPLOAD PORTAL
https://unifiedportal-emp.epfindia.gov.in
FIND ATTACHED CSV FILE FOR YOUR REFERENCE
Regards