Customer Pay/Charge Report

Overview

The Reports > Management > Customer Pay/Charge report uses paid and charged data to report the following information:

• Amount billed per customer group by invoice, approver, or billing contact
• Hours worked for billable units
• Total Paid
• Total Billed

The report will split the above data by customer per day worked. 

Note: For a record to be included in this report, 2 conditions must be met:

• The timesheet must be in a PAID status; AND 
• The invoice must be in at least a SENT status

On-screen Columns

The on-screen report contains the following information:

• Customer Name
• Workplace Name
• Primary Approver
• Employee Name
• Total Pay
• Total Charge

The Total Pay column will include any pay runs with a status of Paid.

The Total Charge column will include invoices in a status of Sent and will exclude GST. 

Export Options

You can export the on-screen view in .pdf format, or download either a summary or detailed view of the report in .csv format.

The Summary .csv includes the following data:

• Pay Entity
• Bill Entity
• Customer ID
• Company Name
• Customer Remote ID
• Workplace Name
• Workplace Address 1
• Workplace Suburb
• Workplace Region
• Primary Approver ID
• Primary Approver
• Billing Contact
• Invoice Date
• Invoice Number
• MID
• Employee Name
• Employee Remote ID
• Employee Type
• Job Title
• Pay Item
• Allowance (Y/N)
• Work Units
• Date Worked
• Units Paid
• Pay Rate
• Units Charged
• Charge Rate
• Total Charge (Units Charged x Charge Rate)

The Detailed .csv includes additional job and recruiter columns, with the following data presented

• Pay Entity
• Bill Entity
• Customer ID
• Company Name
• Customer Remote ID
• Workplace Name
• Workplace Address 1
• Workplace Suburb
• Workplace Region
• Primary Approver ID
• Primary Approver
• Billing Contact
• Invoice Date
• Invoice Number
• MID
• Employee Name
• Employee Remote ID
• Employee Type
• Job ID
• Job Title
• Job Remote ID
• Recruiter 1 ID
• Recruiter 1 Name
• Recruiter 2 ID
• Recruiter 2 Name
• Recruiter 3 ID
• Recruiter 3 Name
• Recruiter 4 ID
• Recruiter 4 Name
• Recruiter 5 ID
• Recruiter 5 Name
• Pay Item
• Allowance (Y/N)
• Work Hours
• Date Worked
• Units Paid
• Pay Rate
• Units Charged
• Charge Rate
• Total Charge (Units Charged x Charge Rate)