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

XLB1

User can create or design the template in XML file format using XL builder Macro.

Configuration -> Template Setting -> Module : XL Builder

XLB2

Working with XL Builder :

In this module following selections can be done depending on users requirement.

  1. User has to select period for which the XL builder file needs to be generated.
  2. 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.
  3. Freezed / UnFreezed / All Employees.
  4. Pay Mode i.e Bank, Cheque, DD and Cash.
  5. Status as per Left, current or All employee.
  6. Report as per Latest or Actual Master.
  7. Report Amount Inclusive or Exclusive Report for Arrears and Supplementary.

Note:

Configuration -> Report Setting -> Display checked on Pay Slips/Registers/Report Writer with Supplementary/Arrears -> save.

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.