Standard Report - Client Billing

Report Description

This report shows a detailed summary of client billing information.

Parameters

Parameter Name	Options	Explanation
Date Type	Accounting Period Date, Invoice Date, Week Worked Date	Invoice’s Accounting Period Date, Invoice Date, Week Worked Date
Roll up to Root Customer	True, False	Based on this parameter, result will either be displayed per individual customer department or rolled into Root Customer.
Start Date
End Date
Customer Name		Filters results by Customer Name.
Branch	All available branches
Show Summary	True, False	When set to False, displays the report in the detailed format
Job Title		Filters results by Job Title.
Transaction Type		List outs all the Transaction Types
Group by	None, Branch

Report Fields

Field Name	Explanation
Branch	Invoice’s Branch
Customer #	Customer Number of Invoice
Customer Name / Department	Customer Name and Department Name of Invoice
When Parameter Show Summary is set to True
Bill Hours	Total hours billed per customer
Total Bill	Total amount billed per customer
No. of Invoices	Total number of invoices per customer
No. of Employees	Total number of employees per customer
When Parameter Show Summary is set to False
Invoice #	Invoice Number per Customer
Invoice Date	Invoice Date of Invoice
Employee Name	Employee Name from Transaction
Job Position	Job Position of Employee
Supervisor Name	Supervisor Name of order
Week Worked	Week Worked of Transaction
Assignment Length	The number of days between first assignment start date and last assignment end date (if last assignment end date is NULL then Assignment Length is given as - The number of days between first assignment start date and End Date parameter)
Type	Transaction Type like Reg, OT, DT
Pay Rate	Total Pay Rate
Pay Hours	Total Pay Hours
Mark Up	Bill Rate divided by Pay Rate
Bill Rate	Total Bill Rate
Bill Hours	Total Bill Hours
Total Bill	Total amount billed