Payroll Distribution Report

This report summarizes the actual reported crew hours for each unique combination of authority, move type group, commodity, and local service.  Then the report lists the allocations needed to provided crew payroll amount to each item.

 

Parameters

 

Parameter

Description

Branch ID

Enter *(all) to include all branches, or select branches from the drop-down list.

Sort By

Select which sort method to employee from the following list:

Authority,

Move Type Group,

Commodity,

Local Service Description

 

Payroll Period From

Enter the payroll period date to begin selecting records on.

Payroll Period To

Enter the payroll period date to end selecting records on.

Total Crew Clocked Hours

Enter the maximum value of clocked hours to select records on.

Total Crew Payroll

Enter the maximum payroll value to select records on.

 

Report Details

 

Report Grouping

 

The report groups by Branch.

 

Header Information

 

The following information displays in the report header:

    Total Crew Clocked Hours (from the input parameter of the same name)

    Total Reported Hours

    Discrepancy (difference between total crew clocked hours and total reported hours)

    Total Crew Payroll (from the input parameter of the same name)

    Total Allocation (should match total crew payroll amount)

    Total Percentage allocated (should always be 100%)

 

Detail Information

 

The report lists the following detailed items:

    Authority

    Move Type Group

    Commodity

    Local Service Description

    Actual Hours

    Percentage of Total Hours

    Allocation Amount

    General Ledger Account (a blank space is provided to write in the account number)

 

Report Totals

 

The report provides the following total counts:

    Grand Report Total for Actual Hours

    Grand Report Total for Percentage of Total Hours

    Grand Report Total for Allocation Amount