Grove HR's new Payroll feature will improve your way of calculating and exporting employee payroll. Now you are able to export the Gross salary data and have it calculated to Net salary.

In this article, you'll understand:

How does it work?

Payroll's Custom Export feature allows authorized users to have a Gross to Net salary report on hand just by using a salary calculation sheet (which contains all the formulas for calculating salary from Gross to Net).

Grove HR - Gross to Net

How to upload a salary calculation sheet

When everything looks good in Payroll review and you're happy with the Employee Payroll, it's time to export. Now, you can either choose to download a CSV file and calculate Gross to Net salary or have it calculated for you by using the option Export customized excel.

  1. In Payroll > Employee Payroll, click on Export and select Export customized excel

  2. Click Upload, select a salary calculation sheet (with formulas for calculating Gross to Net salary)

  3. Select a calculation sheet and click Next

📌 Note: You can download our sample Template to understand how the Salary calculation sheet should look like in order to work well

Map out the fields

This stage can get tricky so we recommend paying close attention to each field:

  1. Select the Starting (1) and Ending row (2)

  2. Select a Uniquely Identify Field (UIF) (3), this could be Email, Employee ID, or phone number. For the sake of accuracy, we advise using Email as the Uniquely Identify Field

  3. Match the UIF with Template Column

  4. Select the Populated fields by matching the Grove fields on the left to the Template Column (4) on the right

  5. Click Preview to move to the next stage

Example:

  • In the template, the records start from row 2 (the 1st employee) and end at row 24 (the 23rd employee) so the Starting row is 2 and Ending row is 24.

  • The UIF is Email and corresponds to column E

  • The Populated fields (Total compensation, salary, Actual, etc) all match the column F (Total Comp), G (Base Salary), H (Gross Salary)

Template

Mapping

Preview and Export file

  1. After the mapping process is done, you'll see 3 sections:

  • New record: records have been mapped successfully. Revise records to make sure Identity Values are matched in corresponding to Employee Name

  • Duplicate record: Identity Value is duplicated. Double-check the UIF (Email, Employee ID, etc) in Grove system and your template before starting again

  • Unmapped record: Identity Value cannot be found in the system. Double-check the UIF (Email, Employee ID, etc) in Grove system and your template before starting again

2. After reviewing, click Export to download your customize file

3. Now, you just need to pay your employees according to the calculated Net salary (double-check the file if needed)

Important note:

  • The uploaded templates will be available for next use

  • When closing the Export popup at stage 3 (Preview & Export), it will remain unchanged. You can continue when opening it again

  • Clicking on Cancel at stage 3 will dismiss all results

  • If several people have access to the Payroll module, they cannot view other people's sessions

Did this answer your question?