Skip to main content

Balance Costing and Payroll Reports

The Costing Report doesn't balance to the Payroll Report

Updated over 3 months ago

It is recommended that you regularly balance your Payroll and Costing Reports. You might balance the This Pay values as part of your payroll process, or you might balance the Year-to-Date values periodically.

To balance the reports:

  1. In the Payroll and the Costing Reports, select the following:

    • Not Paid and Terminated Employees on the Payroll Report.

    • The same Period End Dates and date ranges have been selected on both reports.

    • If balancing YTD, ensure the dates encompass all pays for the current Tax year.

    • Include Superannuation on the Costing Report.

  2. Once you have generated both reports, compare the values in Report Totals. You should balance the following components, but you can expand the list to include more or all components.

    • Net Pay

    • Total Cost

    • Total Tax

    • Super Values

If the reports do not balance, check:

  1. The parameters selected. Refer to Step 1 above for the required selection and ensure you have used the same Period End Dates and date ranges on both reports.

  2. The End of Pay process has been completed for all Period End Dates included in the Parameter selection (e.g. all periods that fall between the From and To dates used for YTD Cumulatives) by going to:

    1. Payroll, Maintenance, General, Pay Frequencies.

    2. If Processed is not ticked for a Period End Date, ensure that there are no transactions in the period by running the Payroll Report just for that Pay Frequency and the unprocessed Period End Date. If you find unprocessed transactions, these will not be included in the Costing Report as Costing Transactions are created as part of the End of Pay process.

  3. If the Reports still don't balance after confirming the parameters used on the reports and that the End of Pay has been processed for all periods, try to locate the difference. To do this, compare Pay Components, Employees and Period End Dates and raise a case online that includes:

    • Subject: Costing Report and Payroll Report do not balance.

    • Description: Supply as much detail as possible (as to what you think may be causing the balancing issue). E.g. Pay Component, Period, Employee, etc.

    • File attachments: (1) Year-to-Date Costing Report and (2) Year-to-Date Payroll Report.

Did this answer your question?