Payroll HTML to Excel

Payroll Register

Upload payroll HTML — auto-fills all months (Mar–Feb)

Uploading & converting…

Preview truncated — full file is used for conversion 


                        

                    


                    

                        

    

    

        

            

                
            

        


        

            

                
                    
                
            

        


        

            Preview truncated. Download to see the full file.
        

    



                    

                

                


                

    

        

            

                
                    
                
                
Column mapping

            

            

                                    Dues
                                    Deductions
                                    Calculated
                            

        

        
How HTML payroll rows map to Excel register columns

    


    

        

            

                
                    

                        Col
                        Column
                        Calculation
                        Source
                        Key
                    

                
                
                                            

                            
                                E
                            
                            Pay
                            Sum of all Duty Pay rows
                            
                                
                                    Dues tables
                                
                            
                            
                                pay
                            
                        

                                            

                            
                                F
                            
                            DA
                            Sum of all Dearness Allowance rows
                            
                                
                                    Dues tables
                                
                            
                            
                                da
                            
                        

                                            

                            
                                G
                            
                            Medical
                            Sum of all Medical Allowance rows
                            
                                
                                    Dues tables
                                
                            
                            
                                medical
                            
                        

                                            

                            
                                J
                            
                            Gross Pay
                            Sum of every Dues row (all sections)
                            
                                
                                    All rows under Dues header
                                
                            
                            
                                gross_pay
                            
                        

                                            

                            
                                K
                            
                            EPF/CPF
                            GPF + CPS
                            
                                
                                    Deductions
                                
                            
                            
                                epf_cpf
                            
                        

                                            

                            
                                L
                            
                            FBF
                            Family Benefit Fund
                            
                                
                                    Deductions
                                
                            
                            
                                fbf
                            
                        

                                            

                            
                                M
                            
                            SPF
                            Special Provident Fund 2000
                            
                                
                                    Deductions
                                
                            
                            
                                spf
                            
                        

                                            

                            
                                N
                            
                            IT
                            Income Tax + GTN Income Tax_A
                            
                                
                                    Deductions
                                
                            
                            
                                it
                            
                        

                                            

                            
                                R
                            
                            Cess
                            Income Tax Cess + GTN Income Tax Cess_A
                            
                                
                                    Deductions
                                
                            
                            
                                cess
                            
                        

                                            

                            
                                S
                            
                            Total Deduction
                            Sum of every Deductions row (all sections)
                            
                                
                                    All rows under Deductions header
                                
                            
                            
                                total_deduction
                            
                        

                                            

                            
                                T
                            
                            Net Salary
                            Gross Pay − Total Deduction
                            
                                
                                    Calculated
                                
                            
                            
                                net_salary