Payroll as easy as excel for PF, ESI, PT, TDS

OfficeAnywhere logo

Excel Payroll

Payroll as easy as excel for PF, ESI, PT, TDS

Continue to do Payroll Calculation in Excel and Generate all Statutory Reports, and Electronic Returns like PF, ESI, NPS, PT and TDS from Online application.

A single solution for online return filing of PF and ESI as per the schema given by the department. Excel Payroll will also generate Payslips and deduct PT, and TDS. It will generate all the reports related to payroll.

Calculating Salary in Excel is always easy. However, you cannot generate PF Statements and ESI Statements that have to be submitted to the government portal in Excel, txt file Easily. Calculation of TDS becomes complex in Excel as it depends on many factors and not only on salary.

We have designed a Simple to Excel-based Payroll Software, which will import payroll from Excel and will generate all statutory reports in Prescribed format.

Online Payroll Application

How Excel Payroll Software Works?

Import all Employees data from excel to Employee Master Define all the applicable Salary Heads both on Income Side and Deduction Side. You need not define components like PF, ESI, PT, NPS & TDS.

Depending on the date of joining and the date of leaving, Payroll software allows you to download Excel Template for a particular month.

Either calculate salary in this template or copy and paste computed wage in this template and upload in Office Anywhere.

Excel Payroll will do all statutory calculations like PF, ESI, PT, NPS, TDS and generate all the electronic returns and the reports. You may email payslip to all the employees in simple steps.



Features


Provident Fund

• UAN number can be generated with the text file which can be uploaded to govt portal.
• PF returns reports can be generated.
• Easy access to EPFO portal via office anywhere.
• Additional reports such as, FORM 5 & FORM 10 are also available.
• Changes will be updated as per the Govt. mentioned rules.

ESI

• ESI returns reports can be generated.
• Auto calculation based on the Wage limit.
• Easy access to ESI portal via office anywhere.
• Changes will be updated as per the Govt. mentioned rules.

PT

• Calculations as per the State of the Company.
• Report FORM 5A can be generated.
• Changes will be updated as per the Govt. mentioned rules.

NPS

• Report NPS can be generated.
• Changes will be updated as per the Govt. mentioned rules.


TDS

• TDS components can be mapped with the Salary components.
• TDS declaration can be requested by Employee which then can be approved by Admin/HR.
• TDS Lock / Unlock for the declaration is available.
• TDS Lock / Unlock for the regime is available.
• TDS will be calculated with Salary details, Chapter VI-A deductions.
• TDS can be calculated on Old and New regime.
• Reports such as, FORM 16, STI, Income Tax report, Payslip with Income Tax.

Email Pay Slip to all Employees

• Payslips can be sent to employees from Office anywhere easily by only configuring Server and Email configuration.
• Emails can be sent in bulk to employees.
• Customized email templates can be prepared, payslips will be attached in the email in the PDF format.

Generate Reports

• Salary Sheet
• Wage Register
• Form T
• Form 22
• Form F
• Form H
• Bank statement
• Inc. report
• Form Q
• Bonus Form C
• Annual census & Separation tracker.

Online Applications for Business Automation, Office Anywhere