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 


                        

                    


                    

                        

    

    


                    

                

                


                

    

        

            

                
                    
                
                
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