[go: up one dir, main page]

0% found this document useful (0 votes)
15 views2 pages

File Structure

The document outlines the requirements for employers to upload Monthly Wage Details in a specific txt format, with a maximum file size of 2 MB or zipped if larger. It details the necessary fields, their formats, and validation rules for wage contributions, including specific calculations for pension contributions based on wage months. Additionally, it provides guidelines for rounding numeric values entered by users.

Uploaded by

Epfo RO Shillong
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views2 pages

File Structure

The document outlines the requirements for employers to upload Monthly Wage Details in a specific txt format, with a maximum file size of 2 MB or zipped if larger. It details the necessary fields, their formats, and validation rules for wage contributions, including specific calculations for pension contributions based on wage months. Additionally, it provides guidelines for rounding numeric values entered by users.

Uploaded by

Epfo RO Shillong
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

HIGHER WAGES HELP FILE STRUCTURE

Validations for the document to be uploaded by employer for adding Monthly Wage Details:

1. The Higher Wages file should be in txt format only.


2. File size should not be greater than 2 MB. If the file size is greater than 2 MB, a single text file in ZIP format will be
accepted.
3. Monthly Wage Details should be added only against months that fall under the period of service details declared by
themember while opting for pension on higher wages i.e. Wage month should be between the Date of Joining EPS-
95 and the Date of Exit EPS-95 or upto the previous wage month, which are declared by the member.
4. Each line in the text file contains details of single months only.
5. The separator between fields should be #~# (Hash Tilda Hash).
6. In case a member has active service, Wage details will be available till the previous month.
7. Column Number 4 should be 8.33% of the column 3 “Wages on which PF contribution was paid”.
8. Column Number 5 should be 1.16% of the difference of EPF wages and 15000, for the wage months on or after Sept
2014 and if PF contribution paid (column 3) is below 15000 then the value should be 0 or will be ignored even if
provided.
9. For the wage months prior to Sept 2014, column 5 “Pension Contribution from employee @ 1.16% due on such wages
with effect from 01/09/2014” should be 0. Any entry given in this field will be ignored if wage month is prior to Sept
2014.

Sr. No. Field Name Field Width Mandatory Remarks

1. Member ID Character (22) Yes  22-character long valid Member ID

 Valid month in mm/yyyy format


 A wage month must fall between
DOJ EPS and DOE EPS, including
Wage Month (all the months from
2. Character (7) Yes DOJ EPS and DOE EPS. If DOE EPS is
date of joining to date of leaving)
not available, it must be just
previous month than the current
month.
 The field shall accept only whole
Wages on which PF contribution
3. Number(8) Yes numbers having maximum length
was paid
of 8 digits.
Pension Contribution from  The field shall accept only whole
4. employer @ 8.33% due on such Number(8) Yes numbers having maximum length
Wages as in column 3 of 8 digits.
 For wages months prior to
Pension Contribution from 01/09/2014, the value should be 0
employee @ 1.16% due on such or will be ignored even if provided.
5. Number(8) Yes
wages with effect from  For PF contribution paid (column 3)
01.09.2014 below 15000, the value should be 0
or will be ignored even if provided.
 The field shall accept only whole
Pension Contribution Paid by the
6. Number(8) Yes numbers having maximum length
employer earlier
of 8 digits.
 The field shall accept only whole
Pension Contribution to be paid
7. Number(8) Yes numbers having maximum length
along with interest
of 8 digits.
 Rate of interest in XX.YY format
Yearly PF Interest rate for PF- (fractional part is optional). It is
8. Number(2,2) No
exempt establishments mandatory for exempted
establishments

Note : For all numeric values entered by the user that have a non-zero fractional component, the user should round
off the values. For entries with a fractional value less than 0.50, the value should be rounded down. For
fractional values greater than or equal to 0.50, it should be rounded up to the next whole number. The
following are some examples of how to do this:
1) 5667.49 will be 5667
2) 5667.50 will be 5668
3) 5667.51 will be 5668

You might also like