ETF II

ETF & EPF File Builder

Generate the ETF (Form II) and EPF member contribution upload files

01 Employer & period

1–2 letters (A–Z)
Up to 6 digits

02 Members

Member no.6 digits Initialse.g. A B C · max 20 Surnameletters & spaces · max 30 NICmax 12 Salary (Rs)e.g. 50000.00 ETF 3% (Rs)employer · auto EPF 20% (Rs)8% + 12% · auto New Employee?N / C

03 Output files

Members
0
Total salary
Rs 0.00
Total ETF (3%)
Rs 0.00
Total EPF (20%)
Rs 0.00
8% Rs 0.00 · 12% Rs 0.00
Status
—

ETF file ETF_YYYYMM.txt

ETF — fixed-width, space-padded 98 cols / detail · 43 / trailer 

        

      


      

        Each detail line: D + employer + member no. + initials + surname + NIC +
        period from/to + ETF contribution×100. The contribution is the employer-paid
        3% of salary, and the period from/to are both set to the contribution month.
        The final H line is the trailer (member count + grand total in cents +
        24). Fields are padded with spaces to fixed widths — no tabs.
      


      
EPF file A_NNNNNN_YYYYMM_01.txt

      

        

          
          EPF — fixed-width, space-padded
          144 cols / record
        

        

          

        

      


      

        Each EPF record (144 cols): NIC + surname + initials + member no. + total (20%) +
        employer (12%) + employee (8%) + total salary, then a tail of
        N (new) / E (existing) employee flag + company number
        (code+number) + period (YYYYMM+01).
        Amounts are right-aligned with two decimals.
      


      

        
Next step — upload & pay via your bank portal

        

          Once you have downloaded the ETF_YYYYMM.txt and
          A_NNNNNN_YYYYMM_01.txt (EPF) files, log in to your bank's online
          payment portal and submit each one through the matching file-upload facility.
        

        

          Example (Commercial Bank): Payment & Transfer
          → File Upload
          → ETF / EPF File Upload
          → follow the on-screen instructions.
        

        

          Other banks offer a similar option — look for an "ETF", "EPF" or "Bulk / File Upload"
          section under their payments menu.
        

      

    

  


  

    Runs entirely in your browser — nothing is uploaded. Save this page and open it offline anytime.

    Replaces the ETF Form II Creator and EPF return Excel macros.

    ← Four Spices · Freebies