Proportionate Report Description
Proportionate Report will help in Import and view data of employee, if employee work in different location or Master in particular month then salary can be distributed as per Masters employee worked in. It consists of Filters, Fields, Title and Preview options.
Before working on Proportionate Report user need to check setup done for it, as import will work as per setting done.
Configuration -> Report Settings
- Based On Days : If option opted then while importing data of particular employee it should be equal to Days Paid for that month.
- Based On Percentage : If option opted then while importing data of particular employee it should be equal to 100% for that month.

Report Writer -> Proportionate
- Filter : In this module following selections can be done depending on users requirement.
Report Type :
- Detailed
- Summary

Working with this Module :
- Import Data as per Days/Percentage by selection Master from Utility -> Import button provided on the top right corner.
- User has to select Report Type and Proportionate Based On 'Master' for which the Report needs to be generated.
- Select period for which the Report needs to be generated.
- 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.
- Freezed / UnFreezed / All Employees.
- Pay Mode i.e Bank, Cheque, DD and Cash.
- Report as per Latest or Actual Master.
- Status as per Left, current or All employee.
- Report Amount Inclusive or Exclusive Report for Arrears and Supplementary.
Note:
- Inclusive Amount with selection of Supplementary/Arrears will include the amount of Supplementary/Arrears. In net salary paid.
- Exclusive Amount will show exclusively only Supplementary/Arrears.
- Make the default setting to show the pay slip, report writer with supplementary/Arrears.
Configuration -> Report Setting -> Display checked on Pay Slips/Registers/Report Writer with Supplementary/Arrears -> save.
Utility :
In Utility user will find two option "Import" and "Delete Imported Data".

- Import : Import Data as per Days/Percentage by selecting Master from Utility -> Import button provided on the top right corner. File can be imported in .csv and .txt format with all mandatory fields.
- Delete Imported Data : Imported Data can be deleted by this utility, here master need to be selected by this all the record of that particular master will get displayed with Upload id, File name and User name who has uploaded that file.


- Template :
Template option on the top Right corner of the Report has some more settings Add, Save as, Select in which modify and delete template can be done.

Please Note that User has to first do the necessary selection for “Fields, Filter, Custom Filter and Title” then save the settings from option “Template -> Save as”. This report can be selected from “Template -> Select” option.
- Fields : Fields related to salary details (Processed Records Only) such as Earned Basic, HRA, Total Earned, PF, PT, Total Deduction, Net Paid, etc can be selected from this option through Add Fields button for Summary as well as Detailed report but for Detailed report extra field provided related to Employee Master Details such as Ticket Number, Employee Code, Employee Name, Date of Birth, Date of Joined, etc.

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

Extra Payment : If user wish to provide Extra Payment i.e. Additional Index for any head then need to select this checkbox.
Remove : User can remove any of the selected head from this option.
Calculated Fields : There are 15 Calculated Fields provided in Report Writer - Detailed. i.e. Calculated Field 1 to Calculated Field 15.

The main function of the Report is to provide details of Processed Records as per Master. User can use these fields for getting the records calculated as per his requirement. This field will allow defining necessary formula for calculation and as per the formula the result will be calculated at run time without again processing the salary.
For E.g. we require total of heads “Basic and HRA”, user has to follow below procedure.
- Select the necessary “Calculated Field” Column.
- Select the Column Total of the Selected Column if the total is required.
- Rename the Field Name for the particular column as per the requirement.
- Right Click on any cell in the particular field's row, module for defining formula will be evoked.
- User has to Select Fields Name or Actual Name whichever is remembered by user and
- Click on Add Fields.
- Select the Operators {+, -, /, *, (, or )} which needs to be used and click on Add Operator.
- Select another Fields Name or Actual Name whichever is remembered by user and click on Add Fields.
- Once the necessary formula is defined click on close.
- Custom Filter Condition : User can write the condition by which only those record will be displayed as per the filter condition.

- Join : User can select “AND” / “OR”.
- Field Name : User can select field name for which the filter condition needs to be written from the list given.
- 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.
- 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.
- Value : User can provide the Value required for the Filter condition from “Existing Values” in “Value” field.
- 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.
- 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”.
- Title :
User can define the title required in the report. Various different settings for the report can be managed from this option such as setting the Decimal Places, Number Separator, serial number, etc.

- Print Serial Number : By selecting this option user will find column as Serial Number (First Column in preview) i.e. 1,2,3,4...
- Print Decimal Places : By selecting this option user will find Decimal Places to be printed in Preview in All amount fields i.e. 54378.12
- Print Number Separator : By selecting this option user will find Decimal Places to be printed in Preview in All amount fields i.e. 1,000
- Do Not Print Selected Month - Year : By selecting this option user will not find the “For Month” in Preview provided in Filter. (By Default For Month Selected in Filter shown in Preview)
- Print Run Date : System will print Run Date on Preview i.e. Date provided in “Date” Field.
- Reset Sr. No while grouping : By selecting this option system will Reset the Sr. Number as per Group.
- Date : Run Date need to be provided, by default today’s date is shown.
- Calculate Fields Rounding : User find three option for Calculate Fields rounding i.e. Round Off, Round Up and None.
- Preview For Summary Report :
After above selection when user move to Preview tab find Preview of data as shown below.

- Preview For Detailed Report:
After above selection when user move to Preview tab find Preview of data as shown below.

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