Hi,

Referred the excel file.

In Lenvica HRMS, it's possible to calculate salary in the same manner.

I'll explain how to calculate basic pay using this method.

1. Create one salary head Gross Salary.
2. Make the Type of salary head as Non Payslip
3. Create a Salary Group
4. Add the salary head Gross Salary to this group.
5. Then add salary head 'Basic Pay'.
6. According to the excel format Basic Pay is 30% of Gross Salary
7. Define the formula for Basic Pay as (Gross Salary * 30/100).
  (Note: In Formula Editor Select the salary head "Non Payslip" from the drop down, then you can see the gross salary listed there)
8. Now Define the salary card for each employee.
9. In "Salary Card" select the salary group which you just created.(You can assign all employees in same salary group.)
11. Now edit the value of gross salary in salary card.
12. Process the salary.
13. The rest is calculated automatically.

Hope this solution is useful. For any more queries on the same please do let me know.

Regards,
Rincy