Monthly Comparison Detail Description

With this module, user can display and Print the details of the Basic salary, Allowance, Deduction and Variable heads along with Leave details for selected period.

Payroll -> Comparison Report -> Monthly Detail

ComparisonDetail1_UAE

  1. User has to select period for which the Report needs to be generated.
  2. System will filter data as per Sponsor selected, on preview data will only be shown of employee associated with selected sponsor.
  3. System will filter data as per Batch selected, batch of selected month will only be shown which are active.
  4. Then the necessary grouping required for generating of report E.g. Grade wise, Branch wise, Department wise, Division wise, Unit wise, Category wise, Project wise or for any single employee selection can be selected. If no masters are selected it will generate report for all the employees.
  5. Show Row Total This will print the row total for all the heads which are displayed.
  6. Show Column Total This will print the column total for all the columns.
  7. Show Employee Wise Total This will print the column total for all the columns employee wise.

Note:

ComparisonDetail2

Please Note that User has to first do the necessary selection for Fields and Filter then save the settings from option “Template -> Save as”. This report can be selected from “Template -> Select” option.

Field Caption : In this field user can update the Name of the heads required in the Report for the selected head.

Remove : User can remove any of the selected head from this option.

ComparisonDetail3

  1. Join : User can select “AND” / “OR”.
  2. Field Name : User can select field name for which the filter condition needs to be written from the list given.
  3. Actual Name : If user remembers actual name instead of field name he can search the list and select Actual Name instead of Field Name for which the filter condition needs to be written. Once the Actual Name is selected the respective “Field Name” is displayed in the “Field Name” Column.
  4. Operator : The operator such as Equals, Greater than, Less than (=, > , >=, <, <=, <>) are available for selection. User can select the necessary operator required for writing the filter condition.
  5. Value : User can provide the Value required for the Filter condition from “Existing Values” in “Value” field.
  6. Add : After all the above fields are selected user has to click on “Add” button. This will display the condition selected in “Existing Filter Condition” window.
  7. Clear : if user clicks on “Clear” button this will clear all the condition displayed in “Existing Filter Condition” window.

Note:

User Can also select multiple selection for single report by using Join “AND” / “OR”.

After above selection when user move to Preview tab find Preview of data as shown below.

ComparisonDetail4

User can Copy,Print and Export data in CSV, Excel and PDF format through “Export” Button.