9.7.8 Payrun Detail Report (09143m)

Not a required process.

This report is by normal pay sequence, showing each pay sequence and all employees receiving a payment by the sequence, with group A and G items with accounting interface. They are sorted by project allocation and labour order number.

"A" allowances will only include a 7-day summary unless ALL days option is selected, in which case additional lines are added.

Insert the code separators. Then in sequential order, deal with allowances "B" - over.

Where a number of consecutive allowance codes have the same accounting interface order, then list all items that relate to the one accounting interface order, then show JNL.

If there is a change in the accounting interface order, then do the JNL. (so, there could be more than one journal to the same labour order)

Journal detail:

Payrun Executive Report

Project Number
Description
Allocation
Alloc Desc (if room)
Labour Order
Hours Qty
Invoice
Chargeout

At the start there is a single payrun employee summary:

Employer
RPC
Name
Worked Hrs
Total Hrs
Gross Pay
Total Pay
Pay Cost Rate
Pay Total Rate
YTD Pay Cost Rate
YTD Total Cost Rate

A list of all payrun items listed in sequence order

Sequence No - Sequence Description
RPC
Adjustment
Quantity
Rate
Cost
Invoice

When complete, this report will list all allowances and values for either a range of employees or a particular employee. It is recommended that this report be run on an individual employee basis, particularly for PAYG Summary purposes, as the totals on the report will then only apply to that particular employee. A report for all employees would be used, for example, when you require a total amount paid in respect of a particular sequence, eg: the value of a site sequence paid, the total value of fares paid, etc.

The Payrun Detail Report combines the existing Pay Allowance Report and Pay Journal Report.

All "A" pay allowance codes are grouped and displayed in project sequence while the pay processing transactions are displayed in pay sequence order. This is a common report with [9.13.2] where a number of options are allowed to dissect the data. Whereas, when the report is new, it is a total details report and therefore the dissected options are not active.

We also include the inter-company loan balancing.

To reduce transactions, each pay allowance has a flag to indicate if each individual needs to be journalised, ie: Direct Deposit or grouped as a single value.

Payrun all or singular
Payroll all or singular
Reporting on Company all or singular
Date Start Finish
List Only Pay Allowance A Y/N ???sequence
List Only GL process Transaction Y/N  
List Only Pay Journals Y/N  
List Only Pay Allowances Y/N  
List Only Pay Allowances Y/N ???sequence
List Only Checkout Values Y/N  
Exclude Recharge Orders Y/N  
Include Day Values for GPA Y/N  
Include Pay Ratew Y/N  

Input Fields are

  1. Payroll Company
  2. Payrun number