Reports

Expenditures and Forecasts Reports

Overview

The Expenditures and Forecasts Report shows the actual expenditures from the beginning of the fiscal year up to the pay date preceeding the Report Date, as well as the accruals from day following the pay date to the Report Date, and the forecasts from the day following the Report Date to the end of the fiscal year.

Navigation

Payroll Management ► Report ► Expenditures and Forecasts Reports

Expenditures and Forecasts Reports Screen Fields

Fields	Description
Report Type	Allows to select report type from the drop down list
Pay Code	Allows to select pay code from the drop down list
Report Calculation Date	Current Date when generating the report
Employee	Optional parameter. The system must allow filtering on any Employee ID, Employee Last Name and Employee First Name, of the Employee Assignments
Employee Position	Optional parameter. The system must allow filtering on any Position ID, or Position Description, of the Employee Assignments
Comment	User comments
Salary Group	Optional parameter. The system must allow filtering on any Salary Group, of the Employee Assignments
Salary Classification	Optional parameter. The system must allow filtering on anySalary Classification or combination of Salary Group and Salary Classification, of the Employee Assignments

Nicaragua Reports

Associated with Catalogues

Listing of Job Description Report

Overview

This report displays employee position information. Users can generate this report as a summary or detailed. It provides different filter option to generate a specific report. The report generates a list of the employee based on the report filters supplied by users.

A screenshot of the Listing of Job Description Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Listing of Job Description Report from within the menu through this navigation path: Payroll Management ► Reports ► Nicaragua Reports ► Associated with Catalogues ► Listing of Job Description Report.

Filters

The following table lists and describes all filter fields for the Listing of Job Description Report in their default order. Note that some fields depends on the system parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Employee Position	Lookup feature allows users to select an employee position ID from the list or enter it manually as a filter.
Sort By	It provides the sorting feature for results.
Institution	Institution listed as a tree, allows users to select one or multiple institutions as a filter criterion.

Visible Fields

A sample of the report is available here.The following table lists and describes all visible fields for the Listing of Job Description Report, in their default order. Note that some fields depend on filters selection and the language of the report depends on the configuration of the system.

Field	Description
Employee Position Code	It displays the employee position code.
Institution	The institution code and description.
Administrative Unit	The administrative unit details related to the institution.
Description of Employee Position	It displays the description of the employee.

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Listing of Job Description Report feature.

Button Image	Description
	This button allows users to generate the report as PDF format.
	This button allows users to generate the report as MS Excel format.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as ODS format.
	This button allows users to generate the report as RTF format.
	This button allows users to generate the report as MS Word format.
	This ODT button allows users to generate the report in ODT format.
	The Lookup tool allows users to browse and select existing items. It is used to add the employee position filter.

Payroll

Payslip Report

Overview

This report includes all payslips that correspond to the filter selected (Pay Period, Organization, etc.)

Navigation

Payroll Management ► Reports ► Payroll ► Payslip Report

Payslip Report Screen Fields

Fields	Description
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Code	Pay Code of the cost item Per Period from employee assignment.
Pay Period	This will establish the filter net Payment(s) per Pay Period
Employee	It shows Employee pick-list in order that the user chooses the desire Employee ID, Last Name and/or First Name, or group of Employees.
Comment	A comment for the Pay slip Report.
Institution	Allows selecting the institution for Pay slip

Payroll by Financial Account Report

Overview

The Payroll by Financial Account report will allow the user to have a detail or summary of Coding Block assigned to each Cost Item/Deduction of a Net Payment number.

Navigation

Payroll Management ► Reports ► Payroll ► Payroll by Financial Account Report

Payroll by Financial Account Report Screen Fields

Fields	Description
Report Type	Users can see two types of report. Summary report and Detail report.
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Code	Pay Code of the cost item Per Period from employee assignment.
Pay Period	This will establish the filter net Payment(s) per Pay Period
Employee	It shows Employee pick-list in order that the user chooses the desire Employee ID, Last Name and/or First Name, or group of Employees.
Employee Position	It contains all employee positions in the government.
Cost Item	It shows a Cost Items pick-list in order that the user chooses the desired Cost Item ID, Cost Item Name or multiple Cost Items.
Deduction	Deduction Unique Identification Code associated to this Deduction Per Period.
Expense Voucher	Allows selecting the institution for Pay slip
Journal Voucher	Every time a transaction is create in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts.
Situation Code Level	Code Levels should select from the drop down. Situation Codes Acronyms are unique within a level, but can be repeat for different levels.
Coding Block Filter Type	Possible values are “Coding Block”, “Coding Block Expression Filter”, and “Hierarchical Coding Block Element”. If “Coding Block” is select, the system will allow the user to enter a coding block that will be use for filtering. “Coding Block Expression Filter” is selected the system will allow the user to enter a coding block expression that will be used for filtering. If “Hierarchical Coding Block Element” is select, the system will allow the user to select any CoA concept element or ranges of elements, from the segment that are included in the selected CoA Group.

Gross Salary Gap Report

Overview

The Gross Salary Gap report allows the user to view employee’s Gross Salary Gap between two selected periods. It is recommended to execute this report prior to finalizing the current period Pay Calculation, as once the pay has been finalized, the user will be unable to make any modifications if there is any error in an employee Pay Calculation.

An example report is shown below.

Navigation

Definition of Report Fields

The Gross Salary Gap Report includes the following fields:

Report Field	Description
Fiscal Year	Accounting year
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter By	Sorting criteria
Employee Code	Employee Identification number
Employee Name	Employee's name
Assignment #	Identification number of Item assignment
Cost Item	Item label
Period	Time period covered
Gap	Difference in period changes
Total	Sum of item values

Generation of the Report

The Gross Salary Gap Report allows the user to view employee’s gross salary gap between 2 selected periods.

To GENERATE a Gross Salary Gap Report, follow the steps below:

Navigation

The Gross Salary Gap Report includes the following filter criteria available for the report:

Report Type: Select Report Type Status from the drop-down menu. Options are 'Summary' or 'Detail.'

- Specify Period Compare details.

Fiscal Year: Select Fiscal Year from the drop-down menu
Pay Code: Select Pay Code from the drop-down menu
Pay Period: Select Pay Period from the drop-down menu

- Specify Period Compare details.

Fiscal Year: Select Fiscal Year from the drop-down menu
Pay Code: Select Pay Code from the drop-down menu
Pay Period: Select Pay Period from the drop-down menu
Employee - Employee unit (optional parameter) that can be selected using the Lookup icon , and Find icon to retrieve the Employee. If selected, the report will include the selected Employee and all Employees below the selected unit. Refer to Employee for more information.
Gap - Enter Gap

If all filter criteria are left blank, all Employees allowed by the report will be included.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Production Control Report

Overview

The Production Control Report is a report that will allow users to make comparisons for amounts paid in Earnings and Deductions between two different pay periods.

An example of the report is shown below.

Navigation

Definition of Report Fields

The Production Control Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Group By	Used to group report information by Employee, Institution, Value
Difference	Difference in Filter Criteria and Group By values
Comment	Optional description
Cost Items	Classification for Institution expenditures
Deductions	Classification for deducted values from expenditures
Period 1	First period value
Period 2	Second period value
Difference	Change in value from period one to period two
Difference (%)	Percent change in value from period one to period two
Total	Sum of values for group
Grand Total	Sum of values for entire report

Generation of the Report

The Production Control Report is a report that will allow users to make a comparison for amount paid in earnings and deductions between 2 different pay periods.

To GENERATE the Production Control Report, follow the steps below:

Navigation

The Production Control Report includes the following filter criteria available for the report:

Enter Period Compare information
Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Enter Period With information
Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Employee Position - To enter the Employee Position, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee Position list, then select the Employee Position
Cost Item - To enter the Cost Item, (optional field) click on the Lookup icon , click on Find icon to retrieve the Cost Item list, then select the Cost Item
Deduction - To enter the Deduction, (optional field) click on the Lookup icon , click on Find icon to retrieve the Deduction list, then select the Deduction
Difference - Enter Difference
Salary Group - Select Salary Group from drop-down menu.
Salary Classification - Select Salary Classification from drop-down menu.
Salary Step - Select Salary Step from drop-down menu.
SCC Level 1 - Select a Situation Code Combination (Level 1) from the drop-down menu.
SCC Level 2 - Select a Situation Code Combination (Level 2) from the drop-down menu.
Is Apply Coding Block Restriction - Check the checkbox to apply a coding block restriction on this report.
Comment - Enter additional Comments (optional)
Situation Code Combination - Check Situation Code Combination, if necessary
Salary Transition - Check Salary Transition, if necessary
Employee Position - Check Employee Position, if necessary
Employee - Check Employee, if necessary
Group By Organization Unit - Check Group By Organization Unit, if necessary
Group By Institution Type - Select Group By Institution Type from drop-down menu

If all filter criteria are left blank, all Employees, Employee Positions, Cost Items, Deductions will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Payroll Verification Report

Overview

This report should be based on Entity Employee Net Payment. From this entity there is a link to Cost Items per Period, Deductions per Period and Assignment.

An example of the report follows.

Navigation

Definition of Report Fields

The Payroll Verification Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Date	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Comment	Optional Comment
EMP #	Employee Identification Number
Name	Name of Employee
Year	Year of report
Pay Code	Pay Code assigned to Employee
Period	Payment Period
Assignment Coding Block	Coding Block Identifier
Situation	Determines type of employment
Position	Identifies employee position
Classification	Employee salary classification
Step	Employee salary step
Organization	Organization responsible for the employee
Base	Base salary
Other Earning ($)	Additional earnings
Gross	Sum of Base and Other Earning
Total Deduction ($)	Value of deduction from Gross Earning
Net Pay	Difference of Gross and Total Deduction
First Cost Item	Value of Cost Item
Second Cost Item	Value of Cost Item
Third Cost Item	Value of Cost Item
First Deduction	Value of Deduction
Second Deduction	Value of Deduction

Generation of the Report

The xls file produced will allow users to do verification for a specific payroll period. The xls file will be detailed by employee and no grouping will be allowed. Also no total will be generated. The reason is that the user will manipulate the data as he wants and produce the total for any grouping.

To GENERATE the Payroll Verification Report, follow the steps below:

Navigation

The Payroll Verification Report includes the following filter criteria available for the report:

Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Employee Position - To enter the Employee Position, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee Position list, then select the Employee Position
Net Pay - Enter Net Pay
Salary Group - Select Salary Group from drop-down menu.
Salary Classification - Select Salary Classification from drop-down menu.
Salary Step - Select Salary Step from drop-down menu.
SCC Level 1 - Select a Situation Code Combination (Level 1) from the drop-down menu.
SCC Level 2 - Select a Situation Code Combination (Level 2) from the drop-down menu.
Is Apply Coding Block Restriction - Check the checkbox to apply a coding block restriction on this report.
Sort By - Select a choice from the drop-down menu to sort the report by a specific selection. Sort the list items by the preferred ascending and descending order using the red arrow icon.

If all filter criteria are left blank, all Employees, Employee Positions, Cost Items, Deductions, Situation Code Combinations, Salary Transitions will be included in the Report, as well as the Institutions allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Payroll Exceptions Report

Overview

The Payroll Exceptions is a report that will allow users to visualize employees whose Cost Items and/or Deductions per period have been updated with a corrected amount after the initial Payroll Calculation was executed but when the pay period was not yet closed at the time the change was done.

An example report is shown below.

Navigation

Definition of Report Fields

The Payroll Exceptions for Cost Items and Deductions Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Group By	Used to group report information by Employee, Institution, Value
Comment	Optional description
Cost Item	Classification for Institution expenditures
Deductions	Classification for deducted values from expenditures
Calculated Value	Initial value
Corrected Value	Value after correction
Difference	Change in value from calculated to corrected
Total	Sum of values for group
Grand Total	Sum of values for entire report

Generation of the Report

The Payroll Exceptions for Cost Items & Deductions is a report that will allow users to visualize employees whose Cost Items and/or Deductions per period have been updated with a corrected amount after the initial Payroll Calculation was executed but when the pay period was not yet closed at the time the change was done.

To GENERATE the Payroll Exceptions for Cost Items and Deductions Report, follow the steps below:

Navigation

The Payroll Exceptions for Cost Items and Deductions Report includes the following filter criteria available for the report:

Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Employee Position - To enter the Employee Position, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee Position list, then select the Employee Position
Cost Item - To enter the Cost Item, (optional field) click on the Lookup icon , click on Find icon to retrieve the Cost Item list, then select the Cost Item
Deduction - To enter the Deduction, (optional field) click on the Lookup icon , click on Find icon to retrieve the Deduction list, then select the Deduction
Cost Item Difference - Enter Cost Item Difference
Deduction Difference - Enter Deduction Difference
Comment - Additional remarks
SCC Level 1 - Select SCC Level 1 from drop-down menu
SCC Level 2 - Select SCC Level 2 from drop-down menu
Is Apply Coding Block Restriction - Check the checkbox to apply a coding block restriction on this report.
Select Group By Organization Unit
Group By Institution Type - Select Group By Institution Type from drop-down menu
Group By - Select Group By from drop-down menu

If all filter criteria are left blank, all Employees, Employee Positions, Cost Items, Deductions will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Payment Schedule by Pay Period Report

Overview

This report displays the schedules for all Payment Methods: Direct Deposit and Pay Agents (cash or check).

An example of the report is shown below.

Navigation

Definition of Report Fields

The Payment Schedule By Pay Period Report includes the following fields:

Report Field	Description
Page	Indicates page number
Pay Period	Payment dates
Position Category	Description of employment position
Institution	Institution responsible for pay
Employee ID	Employment Identification number
First Name	Employee first name
Last Name	Employee last name
Payment Method	Method of pay
Total Paid	Value of payment
Pay Agent	Entity responsible for payment

Generation of the Report

This report is for all payment methods DIRECT DEPOSIT and PAY AGENT (CASH or CHECK)

To GENERATE the Payment Schedule By Pay Period Report, follow the steps below:

Navigation

The Payment Schedule by Pay Period Report includes the following filter criteria available for the report:

Report Type - Select Report Type from drop-down menu
Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Pay Agent - Enter Pay Agent, if necessary
Bank - Enter Bank, if necessary
Branch - Enter Branch, if necessary
Select Group By Organization Unit
Group By Institution Type - Select Group By Institution Type from drop-down menu

If all filter criteria are left blank, all Employees will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Detailed Cost Item or Deduction Per Period Report

Overview

The Detailed Cost Item/Deduction Per Period report allows the user to view the list of employees who obtained the selected Cost Item/Deduction for the specified Pay Period

An example report is shown below.

Navigation

Definition of Report Fields

The Detailed Cost Item / Deduction Per Period Report includes the following fields:

Report Fields	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Group By	Used to group report information by Employee, Institution, Value
Deduction	Label of deduction the report is based upon
Employee Code	Employee Identification number
Employee Name	Employee's first and last name
Assignment #	Identification number for deduction assignment
Utilization Rate (%)	Percentage rate of utilization
Amount	Value of deduction
Rate	Percentage of deduction rate
Calculated Amount	Value of deduction
Corrected Amount	Value of deduction after correction
Cumulative	Total value of deductions to date
Total	Sum of deduction values

Generation of the Report

The Detailed Cost Item/Deduction Per Period report allows the user to view the list of employees who obtained the selected Cost Item/Deduction for the specified Pay Period.

To GENERATE a Detailed Cost Item/Deduction Per Period Report, follow the steps below:

Navigation

The Detailed Cost Item / Deduction Per Period Report includes the following filter criteria available for the report:

Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Employee Position - To enter the Employee Position, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee Position list, then select the Employee Position
Report Type - Select Report Type from drop-down menu
Cost Item - To enter the Cost Item, (optional field) click on the Lookup icon , click on Find icon to retrieve the Cost Item list, then select the Cost Item
Deduction - To enter the Deduction, (optional field) click on the Lookup icon , click on Find icon to retrieve the Deduction list, then select the Deduction
Situation Code Combination - To enter the Situation Code Combination, (optional field) click on the Lookup icon , click on Find icon to retrieve the Situation Code Combination list, then select the Situation Code Combination
Enter Group By information
Group By - Select Group By from drop-down menu
Select Group By Organization Unit
Group By Institution Type - Select Group By Institution Type from drop-down menu

If all filter criteria are left blank, all Employees, Employee Positions, Cost Items, Deductions, Situation Code Combinations, will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Excluded Cost Items or Deductions by Employee Report

Overview

The Excluded Cost Items/Deductions by Employee report allows the user to view active employee assignments that do not have the selected Cost Items/Deductions for the selected Pay Period.

An example report is shown below.

Navigation

Definition of Report Fields

The Excluded Cost Items / Deductions by Employee Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Cost Item	Item label
Comment	Optiolnal comments
Assignment ID	Identification number for Item assignment
Employee Name	Employee Item is assigned to

Generation of the Report

Overview

The Excluded Cost Items/Deductions by Employee report allows the user to visualize active employee assignments who do not have the selected Cost Items and /or Deductions for the selected Pay Period.

To GENERATE an Excluded Cost Items/Deductions by Employee Report, follow the steps below:

Navigation

The Excluded Cost Item / Deduction Per Employee Report includes the following filter criteria available for the report:

Fiscal Year - Select Fiscal Year from drop-down menu
Pay Code - Select Pay Code from drop-down menu
Pay Period - Select Pay Period from drop-down menu
Employee Position - To enter the Employee Position, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee Position list, then select the Employee Position
Cost Item Scale Group - To enter the Cost Item Scale Group, (optional field) click on the Lookup icon , click on Find icon to retrieve the Cost Item Scale Group list, then select the Cost Item Scale Group
Report Type - Select Report Type from drop-down menu
Excluded Cost Item - Excluded Cost Item - To enter the Excluded Cost Item, (optional field) click on the Lookup icon , click on Find icon to retrieve the Excluded Cost Item list, then select the Excluded Cost Item
Excluded Deduction - To enter the Excluded Deduction, (optional field) click on the Lookup icon , click on Find icon to retrieve the Excluded Deduction list, then select the Excluded Deduction
Comment - Add additional comments
Enter Group By information
Group By - Select Group By from drop-down menu
Select Group By Organization Unit
Group By Institution Type - Select Group By Institution Type from drop-down menu

If all filter criteria are left blank, all Employee Positions, Cost Item Scale Groups, Excluded Cost Items, Excluded Deductions will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Arrears by Employee Report

Overview

The Arrears by Employee Report allows the user to view the list of outstanding Arrears per Employee. The report should list only the outstanding arrears on which payment is required.

An example report is shown below.

Definition of Report Fields

The Arrears By Employee Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	User enters organization criteria
Group By	Used to group report information by Employee, Institution, Deduction
Deduction Description	Brief description or label for deduction
Assignment #	Identification number for the assigned Arrear
Date of Transaction	Day, month, year of transaction
Pay Period	Label for pay period
Arrear Amount	Value of Arrear
Payment Amount	Value of payment

Generation of the Report

Bank Pay Agent Summary Report

Change Request Summary Report

Data Entry Report

Detailed Vendor Payment List Report

Overview

This report shows information about the employee deductions per Vendor.

The report must be filtered by Pay Period but also can be filtered by Vendor and/or Fund.

Navigation

Payroll Management ► Report ► Payroll ► Detailed Vendor Payment List Report

Detailed Vendor Payment List Report Screen Fields

Fields	Description
Fiscal Year	Allows to select the fiscal year from the drop down list
Pay Code	Allows to select the pay code from the drop down list
Pay Period	Allows to select the pay period from the drop down list
Element	Allows to select the element from the look up button. Optional Filter
Vendor	Allows to select the vendor related to the detailed vendor payment list from the look up button.Optional Filter.

Employee Deductions Per Vendor Report

Employee Loan Or Advance Report

Expenditures Report

Individual Payroll Summary Report

Monthly Payroll Summary Report

Monthly Remittance Report

Overview

This report is sent to deduction vendors along with the remittance cheque. The report is generated for each vendor for each pay period.

Navigation

Payroll Management ► Reports ► Payroll ► Monthly Remittance Report

Monthly Remittance Report Screen Fields

Fields	Description
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Code	Pay Code of the cost item Per Period from employee assignment.
Pay Period	This will establish the filter net Payment(s) per Pay Period
Status of Pay	Possible values are Pay Calculated, Pay Finalized, Pay Finalized with Paid, Pay Finalized with out Paid.
Is Employer Share Deduction	If checked, employer share deduction is available.
Group Individual Institution	If checked, group individual institution is available
Group by Institution	Allows selecting the institution type

Pay Change Report

Overview

The Pay Change Report shows the changes that took place within certain specified dates. The changes that this report should display are based on the Workflows and the Pay Change Requests.

Navigation

An example report is shown below.

Definition of Report Fields

Report Field	Description
Fiscal Year	Accounting year
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Page	Indicates page number
Filter Criteria	Sorting criteria
Group By	Used to group report information by Employee, Institution
Filter	Filtering Period
Comment	Additional comments
Workflow ID	Workflow identification number
Workflow Status	Current Status of workflow
Date	Date of workflow status change
User	User responsible for status change
Employee ID	Employee identification number
Employee Name	Name of employee
Entity	Employee Role
Attribute	Subject of Change Request
Value Before	Previous value before change request
Value After	Value after change request

Generation of Report

Overview

The Pay Change Report shows the changes that took place within certain specified dates. The changes that this report should display are based on the Workflows and the Pay Change Requests.

Navigation

The Pay Change Report includes the following filter criteria available for the report:

Employee - To enter the Employee, (optional field) click on the Lookup icon , click on Find icon to retrieve the Employee list, then select the Employee
Approved User - To enter the Approved User, (optional field) click on the Lookup icon , click on Find icon to retrieve the Approved User list, then select the Approved User
Created User - To enter the Created User, (optional field) click on the Lookup icon , click on Find icon to retrieve the Created User list, then select the Created User
From Date - Select From Date using Calculator tool
To Date - Select To Date using Calculator tool
Select Group By Institution Unit
Group By Institution Type - Select Group By Institution Type from drop-down menu

If all filter criteria are left blank, all Employees, Approved Users, Created Users will be included in the Report allowed by the report user security profile.

The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.

Payment List Report

Payroll Appropriations Analysis Report

Overview

The Payroll Appropriation Analysis is designed to generate a summarized list of Payroll expenses that are grouped by the Payroll coding block. For each distinct Payroll GL coding block, the report must also look for the Budget and Allotment roll-up Coding Block with the corresponding available amount and display those roll-up coding block in a hierarchy way. The main purpose of this report is for the payroll person to determine if there are sufficient money to pay the employees.

Navigation

Payroll Management ► Reports ► Payroll ► Payroll Appropriation Analysis Report

Payroll Appropriation Analysis Report Screen Fields

Fields	Description
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Code	Pay Code of the cost item Per Period from employee assignment.
Pay Period	This will establish the filter net Payment(s) per Pay Period

Payroll Register Report

Overview

The Payroll Register Report is a report that will allow users to see for a specific period all the amounts for the Cost Items, Deductions (Employee and/or Employer) and also the cumulative amounts up to this specific period.

Navigation

Payroll Management ► Reports ► Payroll ► Payslip Register Report

Payroll Register Report Screen Fields

Fields	Description
Report Type	Users can see two types of report. Summary report and Detail report.
Fiscal Year	This will establish the filter positions per Fiscal Year
Employee	It shows Employee pick-list in order that the user chooses the desire Employee ID, Last Name and/or First Name, or group of Employees.
Employee Position	It contains all employee positions in the government.
Cost Item	It shows a Cost Items pick-list in order that the user chooses the desired Cost Item ID, Cost Item Name or multiple Cost Items.
Deduction	Deduction Unique Identification Code associated to this Deduction Per Period.
Comment	A comment for the Payroll register Report.
Show Cumulative	If checked, cumulative is available.
Status of Pay	It display the pay status
Salary Group	One salary transition can have one salary group.
Salary Classification	It shows classification from the same selected Salary Group.
Salary Step	Show the steps number for the pay zone, group, subgroup, level selected above.
Situation Code Level	Code Levels should select from the drop down. Situation Codes Acronyms are unique within a level, but can be repeat for different levels.
Coding Block Filter Type	Possible values are “Coding Block”, “Coding Block Expression Filter”, and “Hierarchical Coding Block Element”. If “Coding Block” is select, the system will allow the user to enter a coding block that will be use for filtering. “Coding Block Expression Filter” is selected the system will allow the user to enter a coding block expression that will be used for filtering. If “Hierarchical Coding Block Element” is select, the system will allow the user to select any CoA concept element or ranges of elements, from the segment that are included in the selected CoA Group.
Pay Period	This will establish the filter net Payment(s) per Pay Period

Definition of Report Fields

The Payroll Register Report includes the following fields:

Report Field	Description
Fiscal Year	Fiscal Year of report data
Report Generation Date	Date of report generation automatically generated by the system
Report Generation Time	Time of report generation automatically generated by the system
User	User who generates the report
Filter	Filtering Criteria
Group By	Organizational structure of the report
Group By Description	This is the Description of the first Group By item if the report is grouped by any item
Cost Item	Abbreviation for Cost Item
Description	Brief Description of Cost Item
Amount	Value of Cost Item
Cumulative	Sum of Cost Item per period
Deduction	Abbreviation of Deduction
Description	Description of Deduction
Employee	Value of Deduction per Employee
Employer	Value of Deduction per Employer
Cumulative	Sum of Deductions per period
Total	Sum of report values

Generation of the Report

Pre Finalize Exception Report

Year End Procedure

Generate Tax Forms

Overview

This entity allows users to generate annual tax forms. In this report screens users able to generate 6 different types of forms which are:

T4
T4 Summary
T4A
T4A Summary
NR4
NR4 ORS

A screenshot of the Generate Tax Forms feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Generate Tax Forms from within the menu through this navigation path: Payroll Management ►Reports ►Payroll ►Year End Procedure ►Generate Tax Forms

Filters

The following table lists and describes all filter for the Generate Tax Forms, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Fiter names are subject to change through language label configuration.

Field	Description
Calendar Year	Shows the last calender year. This is a autopopulated filter criterion.
Tax Form Type	Allows users to selet tax form type. Available options are: T4 T4 Summary T4A T4A Summary NR 4 NR 4 ORS
Pay Code	Users can select pay code to filter tax forms.
Employee	Users can select pay code to filter tax forms.

T4

Overview

The purpose of this report is for employers to produce T4 slips (resident or non-resident) if they paid employees employment income, commissions, taxable allowances and benefits, fishing income, or any other remuneration.

Visible Fields

A sample of the T4 Report output is available here.The following table lists and describes all visible fields for the T4 Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Employer's name	Shows the employer's name and address.
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Employer's account number	Empty space to be filled by users.
Province of employment	Shows province of employment of the employee.
Social insurance number	Shows social insurance number of the employee.
is Exempt CPP	If the tax is exempt from CPP then the check box is true.
is Exempt EI	If the tax is exempt from EI then the check box is true.
is Exempt PPIP	If the tax is exempt from PPIP then the check box is true.
Employment Code	Shows employment code of the employee.
Employee's name and address	Shows the employee's name and address.
Employment income	Shows employment income of the employee.
Income tax deducted	Shows the amount of income tax deducted from the employee.
Employee's CPP contributions	Shows CPP contributions of the employee.
Employee's QPP contributions	Shows QPT contributions of the employee.
Employee's EI premiums	Shows EI premiums paid by the employee.
RPP contributions	Shows RPP contributions paid by the employee.
Pension adjustment	Shows the amount od pension adjustment made by the employee.
Employee's PPIP premiums	Shows PPIP premiums of the employee.
Union dues	Shows the amount of union dues.
Charitable donations	Shows the amount od charitable donations made by the employee.
RPP or DPSP registration number	RPP or DPSP registration number of the employee.
Other information	Custom box for to add any other information of the employee.

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the T4.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

T4 Summary

Overview

T4 Summary report is a summary report of T4 report.

Visible Fields

A sample of the T4 Summary Report output is available here.The following table lists and describes all visible fields for the T4 Summary Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Employer's name	Shows the employer's name and address.
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Employer's account number	Empty space to be filled by users.
Total number of T4 slips filed	Shows total number of T4 produced for the employee.
Employment income	Shows employment income of the employee.
Income tax deducted	Shows the amount of income tax deducted from the employee.
Employee's CPP contributions	Shows CPP contributions of the employee.
Employer's CPP contributions	Shows amount of CPP contribution made by employer.
Employee's EI premiums	Shows amount of EI premiums paid by the employee.
Employer's EI premiums	Shows amount of EI premiums paid by the employer.
Total deductions reported	Shows total deduction deducted from the employee salary.
Pension adjustment	Shows the amount od pension adjustment made by the employee.
Registered pension plan (RPP) contributions	Shows amount of contribution made by employee to the registerd pension plan.
Certification	Field for certify that the information given on this T4 information return and on related slips is correct and complete.

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the T4 Summary.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

T4 A

Overview

T4A slip applicable for a payer, such as an employer, a trustee, an estate executor (or liquidator), an administrator, or a corporate director, and the employer's pay any of the following types of income:

Pension or superannuation.
Lump-sum payments.
Self-employed commissions.
Annuities.
Patronage allocations.
Registered education savings plan (RESP) accumulated income payments.
RESP educational assistance payments.
Fees or other amounts for services or
Other income such as research grants, payments from a registered disability savings plan (RDSP); wage-loss replacement plan payments if you were not required to withhold Canada pension plan (CPP) contributions and employment insurance (EI) premiums, death benefits, or certain benefits paid to partnerships or shareholders.

Visible Fields

A sample of the T4A slip Report output is available here.The following table lists and describes all visible fields for the T4A slip Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Payer's name	Shows the employer's name and address.
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Payer's account number	Empty space to be filled by users.
Social insurance number	Shows social insurance number of the employee.
Recipient's account number	Shows bank account number of the employee.
Recipient's name and address	Shows name and address of the employee.
Pension or superannuation	Shows amount of pension or superannuation paid to the employee.
Income tax deducted	Shows amount of income tax deducted from the employee.
Lump-sum payments	Shows lump-sum amount payable to the employee.
Self-employed commissions	Shows any self-employed commissions earned by employee.
Annuities Rentes	Shows any annuties made to the employee for rent.
Other information	Custom box for to add any other information of the employee.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

T4 A Summary

Overview

T4A summary report is a summary report of T4A Slip report.

Visible Fields

A sample of the T4A Summary Report output is available here.The following table lists and describes all visible fields for the T4A Summary Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Payer's name	Shows the employer's name and address.
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Name and address of employer or payer	Shows name and address of employer or payer.
Payer's account number	Shows bank account number of the paye.
Total number of T4A slips filed	Shows the total number of employee T4A's produced.
Pension or superannuation	Shows amount of pension or superannuation given to the employees.
Lump-sum payments	Shows lump-sum payments made to the employees.
Self-employed commissions	Shows amount of self-employed commissions given to the employees.
Annuities – Rentes	Shows amount of annuities for rentes given to the employees.
Other income	Shows amount of other income received by the employees.
Patronage allocations	Shows amount of patronage allocations given to the employees.
RPP contributions (past service)	Shows amount of RPP contributions for past service given to the employees.
Pension adjustment	Shows amount of pension adjustment made to the employees.
RESP accumulated income payments	Shows amount of RESP accumulated income payments made to the employees.
RESP educational assistance payments	Shows amount of RESP educational assistance payments made to the employees.
Fees for services	Shows amount of fees paid the employees for the service.
Other information	Any other information related to T4A slip
Income tax deducted	Shows amount of income tax deducted from the employees pay.
Remittances	Any remittances deducted from employee salary.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

NR4

Overview

The NR4 are printed when payments are done to non-residents for income such as interest, dividends, rents, royalties, pensions, and acting services in a film or video production.

Visible Fields

A sample of the NR4 Report output is available here.The following table lists and describes all visible fields for the NR4 Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Recipient code	Recipient code, always shows number 1.
Country code for tax purposes	Shows country code of the employee.
Payer or agent identification number	Shows identification number of the payer or agent.
Foreign or Canadian tax identification number	Shows foreign or domestic tax identification number of the employee.
Income code	Shows income code of the employee earnings.
Currency code	Shows code of currency used to pay the employee.
Gross income	Shows gross income earned by the employee.
Non-resident tax withheld	Non-resident tax withheld limit of the employee.
Exemption code	Shows tax exemption code.
Non-resident recipient's name and address	Shows non-resident recipient's name and address.
Name and address of payer or agent	Shows name and address of payer or agent.
Country code	Shows country code of the employee.

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the NR4.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

NR4 ORS

Overview

NR4 Old Age Security information slip is needed when employee fill out the form Old Age Security Return of Income.

Visible Fields

A sample of the NR4 ORS Report output is available here.The following table lists and describes all visible fields for the NR4 ORS Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Year	Shows the calendar year that was selected by the user when starting the processing of this year end tax form.
Recipient code	Recipint code, always shows number 1.
Country code for tax purposes	Shows country code of the employee.
Old age security number	Shows old age security code number.
Foreign or Canadian tax identification number	Shows tax identification number of the employee.
Non-resident account number	Shows bank account number of the non-resident employee.
Income code	Shows income code of the employee earnings.
Currency code	Shows code of currency used to pay the employee.
Gross income	Shows gross income earned by the employee.
Non-resident tax withheld	Non-resident tax withheld limit of the employee.
Exemption code	Shows tax exemption code.
Recovery tax code	Shows deduction recovery tax code.
Recovery tax withheld	Recovery tax withheld limit of the employee.
Non-resident recipient's name and address	Shows non-resident recipient's name and address.
Name and address of payer or agent	Shows name and address of payer or agent.

Button Image	Description
	When exporting this report, click the icon to export in PDF format.
	Click to remove the record. A window is displayed confirming the item is deleted.

SLK Reports

Certificate Of Income Tax Deductions

Overview

The purpose of this report is to:

Issued with a certificate of tax deduction (T10);
T10 report is a certificate of tax deduction that every employer must issue for own employees on an annual basis.

A screenshot of the Certificate Of Income Tax Deductions feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Certificate Of Income Tax Deductions from within the menu through this navigation path: Payroll Management ► Reports ► SLK Reports ► Certificate Of Income Tax Deductions

Filters

The following table lists and describes all filter for the Certificate Of Income Tax Deductions, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Fiter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Allows users to select the fiscal year to use. This is a mandatory filter criterion.
Institution	Users can select an institution code to filter employee's tax deduction.
Employee	Users can select an employee code to filter employee's tax deduction.

Visible Fields

A sample of the Certificate Of Income Tax Deductions output is available here.The following table lists and describes all visible fields for the Certificate Of Income Tax Deductions, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Printed Date	Date of when the report is printed.
Printed Time	Report generation time.
Employee ID	Employee code of the employee.
Full Name of Employee	Full name of the employee as per employee record.
NIC Number	Employee NIC number.
Period of service for which remuneration was paid	Shows from date as employee hire date and to date as retirement date.
Total gross remuneration as per Pay Sheet	Amount of gross remuneration of the employee calculated in the reporting period.
Total amount remitted to the Department of Inland Revenue	Total amount of tax remitted to department of inland revenue.
Taxable Cash Benefit	Amount of taxable cost items of the employee calculated in the reporting period.
Tax Exempt Cash and Non Cash Benefits	Shows tax exempt portion of the cash and non cash benefits.
Total amount of tax deducted	Shows total amount of tax deducted for the reporting period.
Total amount remitted to the Department of Inland Revenue	Total amount remitted to the department of inland revenue during the deduction period.
Name of the Employer	Name of the institution where the employee belongs to.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Word.
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as ODT.
	This button allows users to generate the report as ODS.

Coin Analysis Report

Overview

The purpose of the this report is:

To make sure that correct quantity of cash denominations are available to disburse salaries to the employees;
The Report is issued per Pay period;

Navigation

Payroll Management ► Reports ► SLK Reports ► Coin Analysis Report

Coin Analysis Report Screen Fields

Fields	Description
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Period	This will establish the filter net Payment(s) per Pay Period
Institution	This will establish the filter net Payment(s) per Institution
Employee	This will establish the filter net Payment(s) per Employee

Pay Sheet Report

Overview

The purpose of the this report is to display Salaries, Allowances, Deductions, of each paid employee.

The Report is issued each Pay period

Navigation

Payroll Management ► Reports ► SLK Reports ► Pay Sheet Report

Pay Sheet Report Screen Fields

Fields	Description
Fiscal Year	This will establish the filter positions per Fiscal Year
Pay Period	This will establish the filter net Payment(s) per Pay Period
Institution	This will establish the filter net Payment(s) per Institution
Employee	This will establish the filter net Payment(s) per Employee

T9_01 Schedule Report

Overview

The purpose of this report is to

Issue report 01/Schedule -01 (T9);
Every Employer is required to deduct income tax from the gross remuneration for every pay period of each employee liable to income tax at the time such remuneration is paid.
T9 report is an annual declaration of PAYE deducted and has to be delivered on an annual basis to to DPRA

A screenshot of the T9_01 Schedule Report feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access T9_01 Schedule Report from within the menu through this navigation path: Payroll Management ► Reports ► SLK Reports ► T9_01 Schedule Report

Filters

The following table lists and describes all filter for the T9_01 Schedule Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Fiter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Allows users to select the fiscal year to use. This is a mandatory filter criterion.
Institution	Users can select an institution code to filter employee assignments.
Employee	Users can select an employee code to filter employee assignments.
Employee Position (sorting criterion)	The employee position can be used as a sorting criterion.
Instituion (sorting criterion)	The institution code can be used as a sorting criterion.

Visible Fields

A sample of the T9_01 Schedule Report output is available here.The following table lists and describes all visible fields for the T9_01 Schedule Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Printed Date	Date of when the report is printed.
Printed Time	Report generation time.
Name of the Employer	Name of the institution to which the employee belongs.
PAYE Registration No.	Empty space, manually filled after generating the report.
Empl. Code	Employee ID.
Name of Employee	Employee name.
NIC or Passport Number	NIC or passport number of the employee.
Employment During Assessment Period	It is fix caption in the form.
From	Date of Hire of the employee or April 1^st of the year of reporting.
To	Date of retirement or March 31st of the year of reporting.
Cash Payments	Amount the employee got paid in the reporting period.
Non-Cash	Amount of the non-cash cost items calculated in the reporting period for an employee.
Total	Total amounts of payments made to the employee.
Total Tax Exempt Income	Total tax exempt income limit of the assessee.
PAYE Deducted	Total amount of paye deducted within the reporting period.
Tax Identification Number	Tax identification number of the employee.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format of excel).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

TL Reports

Employee Assignment List Report

Overview

This report shows a list of all employee assignments in the application and can be viewed as a detailed report.

A screenshot of the Employee Assignment List Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Employee Assignment List Report

Filters

The following table lists and describes all filter for the Employee Assignment List Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Description
Start Date	Employee assignment start date filter.
Employee	Filter criterion for employee name.
Employee Position	Filtering on employee position ID or employee position name.
Work Location	It allows users to filter by the employee's work location
Situation Code Combination	Situation codes combination for the employee.
Salary Group	It allows users to select salary group from the drop down list.
Salary Classification	Employee salaray classification.
Salary Step	It allows users to select salary step from the drop down list.
Group By District	It allows users to group the report by dictrict.
Group Individual Institutions	It allows users to group the report by individual institutions.
Group By Institution Type	It allows users to select institution type from the drop down list.

Visible Fields

A sample of the Employee Assignment List Report output is available here.The following table lists and describes all visible fields for the Employee Assignment List Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Work Location	Information about work location of the employee.
District	Information about district, where the employee works.
Employee ID	Id of the employee.
Employee Name	Name of the employee.
Date of Birth	Date of birth of the employee.
Employee Position	Position of employee.
Situation Code Combination	Situation code combination information of the employee.
Hire Date	Hire date of the employee.
Base Salary	Monthly salary amount of the employee.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as HTML.
	This button allows users to generate the report as MS Word.

Employee List Report

Overview

The Employee List Report is designed to generate a list of employees with the ability to request data in various combinations for statistical purposes.

A screenshot of the Employee List Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Employee List Report

Filters

The following table lists and describes all filter for the Employee List Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Description
Employee	Lookup filter criterion for the employee id.
Group Individual Institutions	It allows users to group the report by individual institutions.
Group By Institution Type	It allows users to group the report by institution type.

Visible Fields

A sample of the Employee List Report By District output is available here.The following table lists and describes all visible fields for the Employee List Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Employee Applicationid	Application id of the employee.
Employee Name	Name of the employee.
District	Disctric information for the employee.
Location	Information about work location of the employee.
Division	Information about the division related to the work location.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as HTML.
	This button allows users to generate the report as MS Word.

Employee With Leave Report

Overview

This report displays the leave taken by the employee for a specific period (the number of days and the amount while on leave). It provides different filter option to generate a very specific report.

A screenshot of the Employee With Leave Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Employee With Leave Report from within the menu through this navigation path: Payroll Management ► Reports ► TL Reports ► Employee With Leave Report.

Filters

The following table lists and describes all filter fields for the Employee With Leave Report in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Fiscal Year	Lists the fiscal year and allows users to select as a filter. The current fiscal year is set as default value.
Pay Code	Lists pay codes.
Pay Period	Lists the pay period.
Comment	Allows users to add a custom comment to the generated report.
Group Individual Institutions	By default, it is marked as checked. Users can uncheck it to select the value of group by institution type as a filter.
Group By Institution Type	It lists the institutions and allows to select as a filter. If group by institution is checked, then this field becomes inactive.
Institution	It allows users to select one or multiple institutions.

Visible Fields

A sample of the report is available here.The following table lists and describes all visible fields for the Employee With Leave Report, in their default order. Note that some fields depend on filters selection and the language of the report depends on the configuration of the system.

Field	Description
General Organization Name	Name of the country on the top of the report.
Report Title	The title of the report appears on the report.
Report Date	It indicates the date of the report generation.
Report Time	It indicates the time of the report generation.
User	Identifier of the user who generates the report.
Environment	The environment name.
Period	The pay period.
Work Location	The work location of the employee.
Employee ID	The employee unique identity number.
Employee First Name	The employee first name.
Employee Last Name	The employee last name.
Status	The employement status. The possible values are: P-PERMANENT T-TEMPORARY A-A MEMBER OF GOVERNMENT F-FDTL N-PNTL NP-NATIONAL PARLIAMENT PA-POLITICAL APPOINTMENTS S-STUDYING ABROAD
Payment Type	The Payment types. The possible values are: Cash Cheque Direct Deposit
Leave Days	The number of days.
Leave Amount	The calculated leave amount.
Base Salary	Total base salary amount.
Subsidy	The subsidy amount.
Overtime	The total overtime.
Gross Pay	The calculated gross pay amount.
Deductions	The deduction amount.
Net Pay	The total net payment amount.

Buttons

Button Image	Description
	This button allows users to generate the report in the pdf format.
	This button allows users to generate the report in the Excel format.
	This button allows users to generate the report in the Excel format.
	This button allows users to generate the report in ODS format.
	This button allows users to generate the report in RTF format.
	This button allows the users to generate the report in MS Word format.
	This button allows users to generate the report in ODT format.
	This button allows users to generate the report as HTML.

Payment By District Graph Report

Overview

It is a graphical report related to payment methods. The report displays information on number of employees paid by cash and direct deposit for each district, the percentage of employees paid by cash and direct deposit by district and the overall percentage paid by cash and direct deposit.

A screenshot of the Payment By District Graph Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Payment By District Graph Report

Filters

The following table lists and describes all filter for the Payment By District Graph Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Pay Code	Pay code description filter criterion.
Pay Period	Drop down filter criterion (allows to select payperiod).
Comments	Any comments to add in the output report.

Visible Fields

A sample of the Payment By District Graph Report output is available here.The following table lists and describes all visible fields for the Payment By District Graph Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Sort By	The criteria describing how the report has been sorted based on the user’s preferences.
Period	Pay period for the Payment By District Graph Report.
District	Information about distric for that payment made.
Employee Count Direct Deposit District	Information about count of direct deposits for the district to the employee.
Employee Count Cash District	Information about count cash deposit for the district to the employee.
Percentage Direct Deposit District	Calculated field shows the percentage of direct deposit district made to the employee.
Percentage Cash District	Calculated field shows the percentage of cash district made to the employee.
Percentage Overall Direct Deposit	Calculated field shows the percentage of overall direct deposit made to the employee.
Percentage overall Cash	Calculated field shows the percentage of overall direct cash made to the employee.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Payroll Information Report

Overview

This report includes the payroll information related to Basic Salary, Overtime and other Cost Items Per Period, and the total deductions, per Employee and per Ministry.

Navigation

Payroll Management ► Report ► TL Reports ► Payroll Information Report

Payroll Information Report Screen Fields

Fields	Description
Fiscal Year	Current Fiscal Year
Pay Code	Pay Code Id
Pay Period	Pay Period Number
Payment Type	Payment Type: Cash, Cheque or Direct Deposit.
Comment	Optional parameter
Group By Institution Type	Depends. The user will be able to select a value from the drop-down list only if attribute Group By Individual Organization Unit? is false.

Quarterly Salary Report By District

Overview

This report is a customized report for Timor Leste. It displays for each quarter and each month the count of employee and the total amount of gross salary per district or per institution and district.

A screenshot of the Quarterly Salary Report By District feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Quarterly Salary Report By District

Filters

The following table lists and describes all filter for the Quarterly Salary Report By District, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Quarter	Dropdown filter criterion for quarter.
Type Of Report	Drop down filter criterion for report type. Available options are: By District By Ministry and District
Comment	Any comment to add in the output report.

Visible Fields

A sample of the Quarterly Salary Report By District output is available here. The following table lists and describes all visible fields for the Quarterly Salary Report By District, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Sort By	The criteria describing how the report has been sort by based on the user’s preferences.
Quarter	Shows quarter selected for this report.
District	Information about district for that salary made.
Period	Information about period for that salary made.
Total Employees	Information about payment made to number of employee.
US Dollars	Information about salary made in US dollars.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Salaries By Staffing Profile Report

Overview

It includes the payroll information related to basic salary, overtime, other cost items per period, the total deductions and gross and net salary, for a specific pay period.

A screenshot of the Salaries By Staffing Profile Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Salaries By Staffing Profile Report

Filters

The following table lists and describes all filter for the Salaries By Staffing Profile Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Report Type	Dropdown filter criterion for report type. Available options are: Summary Detail Detail by District
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Pay Code	Pay code description filter criterion.
Pay Period	Drop down filter criterion (allows to select payperiod).
Payment Type	Dropdown filter criterion for payment type. Available options are: Cash Cheque Direct Deposits
Comment	Allows users to add a custom comment to the generated report.
Group Individual Institutions	Allow users to group the report by individual institutions.
Group By Institution Type	Allow users to select institution type from the drop down list.

Visible Fields

A sample of the Staffing Profile Report output is available here. The following table lists and describes all visible fields for the Salaries By Staffing Profile Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Period	Period for this report.
Employees Count	This is the total number of employees with the specific grouping.
Basic Salary	Amount of basic salary made to the employees.
Subsidy	Amount of subsidy made to the employees.
Overtime	Amount of overtime made to the employees.
Gross Pay	This is a calculated Value, presents the total gross pay made to the employees.
Deductions	Amount of deduction deducted from gross salary.
Net Pay	This is a calculated value, presents gross pay less deductions.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Staff Movement Detail Report

Overview

It includes information about staff movement by Ministry and/or Division for each month between two pay periods, such as how many employees were hired during the month for permanent, temporary and totals for all salary scale groups, how many ended and the total number of employees at the beginning of the month.

A screenshot of the Staff Movement Detail Report feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Staff Movement Detail Report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Staff Movement Detail Report

Filters

The following table lists and describes all filters for the Staff Movement Detail Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Descriptions
Fiscal Year	Users select a fiscal year to filter report. The default value for this filter is the current fiscal year.
Pay Code	Users can select a pay code as filter criterion.
Pay Period From	Users define a range of the pay periods to be taken into account, this is the lower limit of the range.
Pay Period To	Users define a range of the pay periods to be taken into account, this is the upper limit of the range.
Group By Institution Type	Allows to select an institution type from the drop-down list to group the results.

Visible Fields

A sample of the Staff Movement Detail Report output is available here.The following table lists and describes all visible fields for the Staff Movement Detail Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Report Date	Indicates date of report generation. This value is automatically generated by system.
Report Time	Indicates time of report generation. This value is automatically generated by system.
User	User who generated the report.
Period	The period selected for this report.
Permanent - Start	Number of the permanent employees that started working during this period.
Permanent - Hired	Number of permanent employees hired during this period.
Permanent - Ended	Number of permanent employees whose assignment ended during this period.
Permanent - Total	Total number of permanent employees moved during this period.
Temporary - Start	Number of the temporary employees that started working during this period.
Temporary - Hired	Number of temporary employees hired during this period.
Temporary - Ended	Number of temporary employees whose assignment ended during this period.
Temporary - Total	Total number of temporary employees moved during this period.
All Employees - Start	Number of the permanent and temporary employees that started working during this period.
All Employees - Hired	Number of permanent and temporary employees hired during this period.
All Employees - Ended	Number of permanent and temporary employees whose assignment ended during this period.
All Employees - Total	Total number of permanent and temporary employees moved during this period.

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Staff Movement Detail Report.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format of excel).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.
	This button allows users to generate the report as HTML.