Summary Variable Detail

This option allows the user to define formula for getting values from the respective heads for previous selected period within last one year tenure. This automates the process of transfer of value for selected period for the respective heads.

There are 60 summary Variables in total, listing from s1 to s60

For E.g. Special Incentive is calculated every month on provisional basis, this is to be paid to the employee in the month of October every year.

sumvar1

Working with this Module :

  1. Go to Payroll -> Component Setup -> Summary Variables, this will open the summary variable settings window.
  2. User find Create and Delete button, click on Create button.
  3. Now user have to select Grade for which Summary Variable need to be define.
  4. Respective Field provided for defining summary variable, this consist of following:

Case 1) If Amount for respective heads as per the formula needs to be transferred every month from last month to current month.

sumvar2

Procedure:

1. Select Column in “Code” option. (i.e. s1, s2, etc)

2. Input the require formula in “Formula” option. (e.g. new_basic * 20/100)

3. Select option “Previous Month Flag”

4. Call this summary variable in formula of any head in Salary Head.

Case 2) If Amount for respective heads as per the formula needs to be transferred from a selected period in selected payable month.

sumvar3

Procedure:

1. Select Column in “Head” option. (i.e. s1, s2, etc)

2. Input the require formula in “Formula” option. (e.g. new_basic * 20/100)

3. Select the month in which the amount needs to be transferred in column “Payable In”

4. Select the respective months in columns “Calculate for Current Year” and “Calculate for Past Year” from where the value needs to transfer in current month. (See the screen shot above)

5. Call this summary variable in formula of any head in Salary Head.

Case 3) If Amount for respective heads as per the formula needs to be transferred every month in current month on the basis of Group Selected (Master).

sumvar4

Procedure:

1. Select Column in “Code” option. (i.e. s1, s2, etc)

2. Input the require formula in “Formula” option. (e.g. new_basic * 20/100)

3. Select option “Execute for current month”, Group Based on become enable.

4. Select the particular Group Based on which will help user to calculate value on the basis of Selected Group.

5. Call this summary variable in formula of any head in Salary Head.

Utilities :

1. Copy Summary Variable : When Column Structure of one grade is almost similar to another grade user can copy the existing structure to the new grade with the "Copy Summary Variable" option. When user want to copy salary head from one grade to another completely.

User can also delete already existing data with “Delete existing Records” option.

sumvar5

2. Export : If user wants to create Summary Variable for new company or want to create same Summary Variable for one grade as per the existing company then user can use option Export Summary Variable. To upload the text file of Summary Variable from one company to another, again in new company select file to Import & click on Import Summary Variable.

sumvar6

3. Import : If user want to Import the Summary Variable previously exported or exported from another company than can do this by Import Utility. User can also delete already existing data with “Delete existing Records” option.

sumvar7

4. Variable : These are the Standard Variables that can be used in Summary Variable settings for writing any formula.

sumvar8

It can be view from icon provided while adding formula.

sumvar9