ORCA Financial developed by TCS Created with Caché
Home Page Solutions Services Company Partnerships Contact Us Site Map  
> Solutions > ORCA Financial Product Overview > Functionality > Reporting > Payroll Reports

Payroll Reports

Advance Payments Report
Employee Pay History
Employee Payslips
Employee Timesheet Analysis
Group Employees Schedule
Labour Productivity Analysis
Leave Accruals Report
Leave Entitlements
Payroll Adjustments Report
Payroll Codes Report
Payroll Document Report
Payroll Payments Report
Sales Performance Report
Schedules of Employees
Staff Turnover Analysis
Timesheet Document Report
Work Hours Schedule

Advance Payments Report

The Advance Payments Report option provides the capability for producing payments schedules in regard to existing payroll prepayments documents. The summary information presented includes payment document numbers, bank accounts from which payments will be made, payment dates and documentation of the payroll adjustment document numbers from which the amounts due for payment have been selected. The payee details include employee account numbers and names, payment references, bank account numbers and pay advance amounts, accompanied by the source pay adjustment document number and the narration entered thereon. The report is typically produced as a draft schedule, i.e. prior to document processing, to enable the verification of the proposed payments. View sample reports TCSDocuPrePmntPay-Draft, and TCSDocuPrePmntPay.

Employee Pay History

The Employee Pay History option provides the capability for generating selective listings of employee earnings, deductions and net pays over a nominated time period, as defined by the control account, department, employee account group, employee pay group, employee account number range, date range and format requirements specified. The history may be presented as a financial analysis, i.e. in terms of employee earnings dates, or as a payroll analysis, i.e. in terms of physical payment dates. The summary format presents employee account numbers and names, period ending dates, and for each pay type code, code descriptions and accumulated hours or quantitites and amounts. The detailed format presents the summary data, accompanied by the dates, references, narrations, hours or quantities and amounts for all the transactions from which the summary values have been accumulated. The analysis format also presents the summary values, but alternatively accumulated into gross earnings, pre-tax deduction, taxable allowance, tax payable, after tax deduction, non-taxable allowance, net pay and employer superannuation contribution categories. All report types may be sequenced in either employee name, account group, pay group or department order, with the analysis format accompanied by sub-totals for the by account group, by pay group and by department selections. View sample reports TCSEmplPayHist-Sum, TCSEmplPayHist-Det, TCSEmplPayHistAnal-Empl, and TCSEmplPayHistAnal-Dept.

Employee Payslips

The Employee Payslips option provides the capability for generating listings of payroll data applicable to the advising of employees of payroll payments made. The format presents summary data in regard to employee name, department code and description, job title, base pay rate, pay frequency, pay period date range, gross pay amount, net pay amount and payment date. That summary data is detailed in terms of the various pay code level transactions from which the gross pay, deductions and nett pay have been determined, and is presented as pay code description, pay code type, hours or quantities, rate and amount, accompanied by pay year to date values. Optionally, all or selected leave entitlements, as at the pay period end date, may also be included on the payslip. The production of payslips is preceded by the printing of a summary or control report, listing the employee and net pay details and the output type, e.g. print or email, applicable for each. View sample reports TCSPaySlipFormat, and TCSPaySlipSumm.

Employee Timesheet Analysis

The Employee Timesheet Analysis option provides for the selective reporting of timesheet entries in terms of charge-to accounts, i.e. job accounts or ledger accounts, work codes or pay codes. The report content is defined by the control account, account number range, location, department, timesheet date range and format requirements specified. The hours analysis may be presented in either summary or detailed format, may include employee account and timesheet document notes, and lists employees in either account number or employee name sequence. Where employees have been temporarily transferred between departments, such employees are identified in separate 'loan staff' sub-sections on the summary format. Optionally, the detailed format may include either timesheet line narrations, or job request texts. View sample reports TCSDocuTshEmployee-Sum, TCSDocuTshEmployee-Sum-Notes, TCSDocuTshEmployee-Sum-Loan, TCSDocuTshEmployee-Det-Narr, TCSDocuTshEmployee-Det-Job, and TCSDocuTshEmployee-Det-Notes.

Group Employees Schedule

The Group Employees Schedule option provides the capability for producing analyses of staff members on a group, or multiple company, basis. Report content is determined through the specification of company codes, control accounts, account groups and currently employed date, and the selection of summary and analysis options by business group, location, or account group, i.e. staff category, codes. The report may be presented in either summarised, i.e. statistical, or detailed, i.e. individual employee, format. View sample reports TCSEmplGroupSched-Sum, and TCSEmplGroupSched-Det.

Labour Productivity Analysis

The Labour Productivity Analysis option provides the capability for analysing labour performance, focusing on potentially recoverable hours and billed hours. View sample report TCSEmplLabProd.

Leave Accruals Report

The Leave Accruals Report option provides the capability for producing selective listings of employee leave entitlements detailing the value of the accruals as at a nominated end of month date. The report details, for each leave type, employee account numbers and names, employment commencement dates, outstanding leave hours, pay rates and extended amounts, presented in either employee name or department order, with sub-totals provided for the by department selection. Optionally, auto reversing journal documents may be generated to process the accrual amounts. View sample reports TCSEmplLeaveAcc-Empl, and TCSEmplLeaveAcc-Dept.

Leave Entitlements

The Leave Entitlements option provides the capability for generating selective listings of employee leave entitlements over a nominated time period, as defined by the department, employee account group, employee pay group, employee account number range, date range and format requirements specified. The entitlements may be presented as a summary analysis, listing the total leave earned, total leave taken and total leave outstanding for each leave type. Alternatively, a detailed analysis may be produced, typically at selected employee level, that lists all the leave transactions in date sequence. The reports may sequenced in either employee name, account group, pay group, leave type or department order, accompanied by sub-totals for the by group, by leave type and by department selections. View sample reports TCSEmplLeave-Sum, and TCSEmplLeave-Det.

Payroll Adjustments Report

The Payroll Adjustments Report option provides the capability for producing selective 'prooflists' of payroll adjustment documents, as defined by the document number range specified. The listing presents summary details in regard to document dates, adjustment types, document numbers and processing status, e.g. New or Complete, accompanied by employee account numbers and names, pay codes and descriptions, hours or quantities, amounts, and where applicable, tax codes and descriptions, and payment methods and bank account numbers. Where defined, adjustment entry narrations and notes, at both document and document line level, are also presented. View sample report TCSDocuPayAdj.

Payroll Codes Report

The Payroll Codes Report option provides the capability for generating listings of the various details associated with a nominated payroll code type defined within the system, with the option of specifying whether 'open', 'closed' or all occurrences of code 'values' are to be presented. View sample reports TCSCodePayBenefit, TCSCodePayDeduction, TCSCodePayStatReturn, TCSCodePayPeriod, TCSCodePayTable, and TCSCodeEmployeeGrp.

Payroll Document Report

The Payroll Document Report option provides the capability for producing 'prooflists' of process payroll documents, as defined by the document number, employee account number and format requirements specified. The summary format presents employee account numbers and names, and gross pay, deduction and nett pay amounts. The detailed format presents the summary information, accompanied by the individual amounts, in terms of pay codes, from which the gross pay and deduction totals for each employee have been accumulated. Optionally, and typically run for a selected employee for investigatory purposes, the detailed format may also include the transactions from which the pay code values have been determined. Additionally, all report formats incorporate, for 'regular' payment types, the listing of any employee accounts that meet the payroll document selection criteria but for whom no payroll amounts have been scheduled, or for whom recorded hours are less than their specifed standard period hours, and also may include error or warning messages in regard to missing statutory deductions, e.g. income tax, or adjusted deductions, e.g. child support deductions subject to 'protected earnings' restrictions. View sample reports TCSDocuPay-Sum, TCSDocuPay-Det, and TCSDocuPay-Det-Trns.

Payroll Payments Report

The Payroll Payments Report option provides the capability for producing payments schedules in regard to existing payroll payments documents. The summary information presented includes payment document numbers, bank accounts from which payments will be made, payment dates, and documentation of the process pay document numbers from which the amounts due for payment have been selected. The payee details include employee account numbers and names, payment references, bank account numbers and net pay amounts. The report is typically produced as a draft schedule, i.e. prior to document processing, to enable the verification of the proposed payments. View sample reports TCSDocuPmntPay-Draft, and TCSDocuPmntPay.

Sales Performance Report

The Sales Performance Report option provides the capability for analysing vehicle salesperson performance. It lists invoice, margin and commission values on sales of vehicles. New vehicles, used vehicles or both categories may be selected, and a date range is required, and information may be presented in either summary or detailed format.

Schedules of Employees

The Schedules of Employees option provides the capability for producing selective analyses of staff members. Report content is determined through the specification of employee control accounts, department codes and account groups, and the selection of summary and analysis options by business group, location, department or account group, i.e. staff category, codes. The report may be presented in either summarised, i.e. statistical, or detailed, i.e. individual employee, format. View sample reports TCSEmplSched-Sum, and TCSEmplSched-Det.

Staff Turnover Analysis

The Staff Turnover Analysis option provides the capability for analysing staff movements, i.e. commencements and terminations, over selectable time periods. Report content is determined through the specification of employee control accounts, department codes, account groups, and start and end date ranges, and may be summarised at company, location or business group level, with employee details presented in either event date sequence or event date within department sequence. Transfers of staff between departments may be optionally included in the analysis. View sample reports TCSEmplTurn, TCSEmplTurn-Locn, and TCSEmplTurn-BGrp.

Timesheet Document Report

The Timesheet Document Report option provides the capability for producing selective 'prooflists' of timesheet documents, as defined by the document number range specified. The listing presents a summary of the total pay hours and charge hours recorded on the document and its processing status, e.g. New or Complete, accompanied by employee account numbers and names, dates, pay codes and descriptions and pay hours, work codes and descriptions and charge hours, and charge-to account numbers and names. Where defined, timesheet entry narrations and notes, at both document and document line level, are also presented. A timesheet may reflect multiple employees for a single date, i.e. where entries have been recorded through the Daily Timesheets option, or multiple dates for a single employee, i.e. where recorded through 'Admin' action in the Timesheet Document option. View sample reports TCSDocuTsh-Daily, and TCSDocuTsh-Weekly.

Work Hours Schedule

The Work Hours Schedule option provides the capability for producing selective listings of employee work hour parameters, as defined by the control account, department, account group, account number and format requirements specified. The report details employee account numbers and names, pay codes and descriptions, workdays and the maximum hours payable, may be analysed by employee, account group or department, and may be presented in either employee account number or account name sequence, with work hours grouped by pay code or pay date. View sample reports TCSEmplWorkHrs-Dept, and TCSEmplWorkHrs-AGrp.