XL Builder Detail
In XL builder two forms are available named as "Form X III OT Register" and "Form X VIII Rule 78". Incase user wants to add Employee details with Salary data and Attendance data in this form then user can create template as per requirement for which various Macro available in Macro list of XL Builder in Template Setting.
Report Writer -> Tools -> XL Builder

User can create or design the template in XML file format using XL builder Macro.
Configuration -> Template Setting -> Module : XL Builder

Working with XL Builder :
In this module following selections can be done depending on users requirement.
- User has to select period for which the XL builder file 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.
- Sponsor Name selection is madatory to view header data of Sponsor Master.
- Pay Mode i.e Bank, Cheque, DD and Cash.
- Status as per Left, current or All employee.
- Report as per Latest or Actual Master.
- 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.
- 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.
- Include Salary Data : If this option is selected then salary heads macro (@@a1,@@d1 etc) will display data as per salary processed amount for selected month and year.
- Include Structure Data : If this option is selected then salary heads macro (@@a1,@@d1 etc) will display data as per salary structure amount.
- Include Attendance Data : If this option is selected then attendance macro (@@dtype_1,@@PL etc) will display data as per attendance data for selected month and year.
As per selected period and options, XL builder file will be generated in excel (.xls) format by clicking on "View" button for the selected template.