The Costing Report displays payroll values grouped by cost account and can include employee details. The Costing Report is printed after the End of Pay process. It can, however, be printed at other times to produce Month to Date or Year to Date values.
During payroll processing, the Costing Report is reconciled with the Payroll Report for the period being processed. During periodic processing, the Costing Report and Payroll report are used to reconcile year to date values.
When an employee’s cost account is changed, their year to date costing does not automatically move to the new cost account. The costs remain where they were incurred. If necessary, you can move values using the Costing Adjustment transaction.
To access the Costing Report from the system tree, select Payroll, Reports, End of Pay, Costing Report.
When generating the report to reconcile current period values, ensure that the current Period End Date is selected in the Filters section of the report. There is no need to specify Month to Date or Year to Date Cumulatives, as you are generating the report for the current period only.
When generating the report to reconcile year to date values, ensure that either the Print Month to Date Cumulatives or Print Year to Date Cumulatives checkboxes are ticked, and the corresponding From and To Dates are entered. To include all year to date values, the From date should be the first pay period end date for the financial year. The To date should be the most recent pay period end date.
Include Previous Tax Years - Tick the Include Previous Tax Years checkbox to include data from previous tax years in the report.
You can filter the report to display one or a range of Cost Accounts. You can also use wildcards to select Cost Accounts. For more information on using Wildcards, refer to the article:
Totals Options
The Show This Pay Totals checkbox must be ticked to include the values for the Period End Date selected in Filters.
Show Group Totals - Provides the ability to subtotal costing information. The groups are defined by your costing structure. The costing structure can be viewed in Payroll, Maintenance, General, General Parameters.
For example, a costing structure may be divided into two levels:
Level 1 State
Level 2 Department
You may create totals for either of these by selecting the relevant level from the Group Totals dropdown.
Display Options
Include Gender Count - If ticked, Include Gender Count, displays the total for each gender on the report. Gender count totals are only available for the latest pay period.
Include Zero Accounts - Tick the Include Zero Accounts checkbox to include all accounts in the range, even if no amount has been allocated to the account. It is not recommended that this option remain selected as a default for the Costing Report, as it may produce a large report.
Group By
New Page Per Payroll Company - tick if each Payroll Company's information is required to be printed on a new page.