Actual Margin Report

Report Overview

The Reports > Management > Actual Margin Report calculates the actual margin that is made over a specified period, for each employee.

It displays an overall summary for the entity and breaks down individual employee and job margins on separate report lines underneath.

The Actual Margin Report attributes oncosts including super, Payroll Tax and Workplace Insurance.

The report uses timesheet data that meets the following conditions:

• the timesheet is at least in a pay run in Draft status
• the timesheet is at least included in an invoice in Draft status.

By default, the report will display data for the last full calendar month as well as the current month up to today’s date.

On-screen Columns

The Report Summary in the Actual Margin Report includes the following data:

• Period
• Total Paid
• Total Charged
• Margin $
• Margin %
• Superannuation
• Payroll Tax
• Work Cover

Each report line will include the following data:

• Employee
• Job
• Total Charged
• Total Paid
• Total Oncosts
• Margin $
• Margin %

Export Options

You can export the on-screen view in .pdf or .csv format. The on-screen CSV will also include Employee ID and Job ID.

The Detailed CSV export includes the following columns:

• Employee ID
• Employee
• Job ID
• Job
• Units Worked
• Units Paid
• Units Charged
• Allowances Claimed
• Allowances Paid
• Allowances Charged
• Total Paid
• Superannuation
• Payroll Tax
• Work Cover
• Total Charge
• Margin $
• Margin %