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
                            

        

        
Format.xlsx mapping — base and arrear columns stay separate on one row

    


    

        

            

                
                    

                        Col
                        Column
                        Calculation
                        Source
                        Key
                    

                
                
                                            

                            
                                E
                            
                            Basic Pay
                            Duty Pay (Regular / Supplementary)
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                basic_pay
                            
                        

                                            

                            
                                F
                            
                            Basic Pay Arrear
                            Duty Pay Arrear
                            
                                
                                    Salary Arrears Dues
                                
                            
                            
                                basic_pay_arrear
                            
                        

                                            

                            
                                G
                            
                            DA
                            Dearness Allowance
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                da
                            
                        

                                            

                            
                                H
                            
                            DA Arrear
                            Dearness Allowance Arrear
                            
                                
                                    Salary Arrears Dues
                                
                            
                            
                                da_arrear
                            
                        

                                            

                            
                                I
                            
                            HRA
                            House Rent Allowance
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                hra
                            
                        

                                            

                            
                                J
                            
                            HRA Arrear
                            House Rent Allowance Arrear
                            
                                
                                    Salary Arrears Dues
                                
                            
                            
                                hra_arrear
                            
                        

                                            

                            
                                K
                            
                            MA
                            Medical Allowance
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                ma
                            
                        

                                            

                            
                                L
                            
                            MA Arrear
                            Medical Allowance Arrear
                            
                                
                                    Salary Arrears Dues
                                
                            
                            
                                ma_arrear
                            
                        

                                            

                            
                                M
                            
                            PP
                            Not in HTML → 0
                            
                                
                                    Default
                                
                            
                            
                                pp
                            
                        

                                            

                            
                                N
                            
                            Other Allw 1
                            Bonus
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                bonus
                            
                        

                                            

                            
                                O
                            
                            Other Allw 1.1
                            Transit Pay
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                transit_pay
                            
                        

                                            

                            
                                P
                            
                            Other Allw 1.2
                            Special Allowance + Special Allowance Arrear
                            
                                
                                    All salary sections
                                
                            
                            
                                special_allowance
                            
                        

                                            

                            
                                Q
                            
                            Other Allw 1.3
                            City Compensatory Allowance
                            
                                
                                    Regular Salary Dues
                                
                            
                            
                                city_compensatory
                            
                        

                                            

                            
                                R
                            
                            Gross Pay
                            SUM(E:Q)
                            
                                
                                    Formula
                                
                            
                            
                                gross_pay
                            
                        

                                            

                            
                                S
                            
                            EPF/CPS
                            GPF + CPS + CPS Arrear
                            
                                
                                    Deductions
                                
                            
                            
                                epf_cpf
                            
                        

                                            

                            
                                T
                            
                            FBF
                            Family Benefit Fund
                            
                                
                                    Deductions
                                
                            
                            
                                fbf
                            
                        

                                            

                            
                                U
                            
                            SPF
                            Special Provident Fund 2000
                            
                                
                                    Deductions
                                
                            
                            
                                spf
                            
                        

                                            

                            
                                V
                            
                            Advances
                            PF Advance Recovery
                            
                                
                                    Deductions
                                
                            
                            
                                advances
                            
                        

                                            

                            
                                W
                            
                            IT
                            Income Tax
                            
                                
                                    Deductions
                                
                            
                            
                                it
                            
                        

                                            

                            
                                X
                            
                            Surcharge
                            Income Tax Cess
                            
                                
                                    Deductions
                                
                            
                            
                                surcharge
                            
                        

                                            

                            
                                Y
                            
                            Total Deduction
                            S:T + NHIS + Health Insurance + Prof Tax
                            
                                
                                    Calculated
                                
                            
                            
                                total_deduction