Settings

In this help topic you will understand how to do various Settings related to Online Payroll application (PF, ESI, PT, Bonus, Gratuity, TDS, NPS)

Settings

In this window, you will be selecting which statutory/services features are required in your Organisation.



Settings for Salary Calculation in Online Excel Payroll


Statutory Settings

Under Statutory Settings, you can configure Statutory Rates for different period. During Covid Season, PF Rate was Changed from 12% to 10% for a few months.



Statutory Settings for Salary Calculation in Online Excel Payroll


Email Settings

You can send Communication to Employees from Payroll Application itself. You can send Payslips, Offer letters, TDS reports etc. to all your Employees. If you want to send emails from the Payroll System, you need to Configure Email Server and Email Accounts Details in Email Setting.



Email Settings for Salary Calculation in Online Excel Payroll

Payroll Settings

You can configure which statutory/services of the application are required for Payroll Processing in your Organisation



Payroll Settings for Salary Calculation in Online Excel Payroll

To enable PF:

  1. Check the checkbox and select Month and Year from which it is applicable.
  2. Import option allows you to import respective VPF details from excel at once.
  3. Auto-calculate option computes EPS automatically.

Similarly, you can configure all other statutory Components.

Month Days for Calculation

While processing salary, working days considered will differ in a few organisations. There are two options available here:

Custom days : Working days to be entered for every month.

For instance: In a month of 30 days if there are 4 Sundays, then working days will be 26. The application will calculate for 26 days.

All days : Complete month days will be considered for salary processing.



Month Days Calculation for Salary Calculation in Online Excel Payroll

Round Off

In the Monthly salary, final salary will be computed and displayed. If you want to round off the calculated value, you can configure the same.



Round off – Net salary in Online Excel Payroll

Employee Login

If individual employees need to be given access to the software, then enable this option. User can log in to the application with his credentials and access his data.



Employee login access to Online Excel Payroll software


Document Request

If this feature is enabled, the employee can log in and upload the requested documents. HR/Admin can approve/reject the documents uploaded by the employees.



Upload the required documents in Online Excel Payroll for Salary
    Calculation

Allow the employee to declare details for TDS using their login: Employees can submit their TDS declaration details. HR/Admin can approve/reject the TDS declaration details uploaded by the employees.



declare details for TDS in Online Excel Payroll
    Solutions for Salary Calculations

View Months

In the Payroll application, salary details will be processed on the months created, all created months will be displayed in the Month dropdown across the application.

There are two options here:

Display all Months: All months created will be displayed across the application.

Display Latest Months: Across the application, Last 4 months will be listed in dropdowns. Usually, you will be referring to the last few months while working on payroll application.



Display months in Online Excel Payroll Solutions for
    Salary Calculations

User Type

Firms and Companies can use this application. If you are a Company or Firm, then HR/Admin will be using this application and Set HR as your preference. Consultants who help companies manage their payroll effectively use this application. If you are a Staffing Service or a Consultant, Select the other option. Some of the features in the application, including Reports, will change depending on this option setting.



Online Excel Payroll Solutions for Salary Calculations with user
    type


Once the settings are enabled, we have to define the Statutory rates:



Define Statutory rates in Online Excel Payroll
    Solutions screen for Salary Calculations

  1. Click on the Settings menu, click on Statutory, select PF Configuration in the sub-menu.
  2. In the screen that opens, select the Month and Year.
  3. Employee and Employer contribution rates to be entered along with other details.
  4. You can click on the prefill button to auto-populate the latest rates.


Employee and Employer contribution
    rates in Salary Calculation screen

Click on Save button to save details.


ESI, NPS, Bonus & Ex-gratia configurations can follow a similar procedure.



ESI, NPS, Bonus & Ex-gratia
    configurations for Statutory Settings