Formula: How to set up a formula for Baitulmal deduction?

Created by rotcana Choong, Modified on Sun, 7 Jun at 7:41 AM by rotcana Choong

Print

This setup is used to calculate Baitulmal deduction based on employee basic salary range, where different fixed deduction amounts are applied according to predefined salary brackets.


Steps to Set up Baitulmal Deduction Formula:

  1. Go to Tools > Payroll Items.

  2. Go to Deduction and click + Add New.


  1. Enter the Code and Description.


  1. Enter the formula as below.

  • IF(Basic Rate >= 300 AND Basic Rate < 1000) 1 ELSE IF (Basic Rate >= 1000 AND Basic Rate < 2000) 2 ELSE IF (Basic Rate >= 2000) 4 ELSE 0