How to drill down Job Cost & Billing Detail

Step by Step Guide:

1. Navigate to JOBS > Job Summaries > Job Cost & Billing Summary.

2. Select a Job No. hyperlink to bring up the transaction details for that job.

Job Cost & Billing Detail Columns

3. All detail-level views require the Transaction Type, but can be customizable to include any of the columns listed below.

• Transaction Type - Line-item Transaction Type, e.g. Estimate, PO, Client Invoice, Supplier Invoice Time sheet etc.
• Transaction Number - Line-item Transaction No., e.g. Estimate #, PO, Client Invoice, Supplier Invoice Time sheet etc.
• Task Type - The code and name of the task type the transaction is assigned to
• Charge Type - The type of charge of the line-item transaction, ‘T’ for Time, ‘I’ for Internal Charges, ‘S’
• Employee/Supplier/Internal Charge Type - The name and code of the employee or supplier or internal charge type the line-item transaction relates to
• Description - The text description assigned to the line-item transaction
• Notes - The text notes assigned to of the line-item transaction
• View - Click the icon to see the image of the transaction such as an expense receipt or supplier invoice or client invoice
• Units - The number of units for the transaction – e.g. for timesheet entries this is the number of hours
• Rate - The rate per unit for the transaction – e.g. for timesheet entries this is the hourly billable rate

Estimated Amounts

• Estimated Time - Estimate line-item amount for Time (‘T’) charge type lines
• Estimated Internal Charges - Estimate line-item amount for Internal (‘I’) charge type lines
• Estimated Supplier Costs - Estimate line-item amount for External/Supplier (‘S’) charge type lines
• Estimated Mark Up - Estimate line-item amount (if any) for Mark Up chargeable to the client
• Estimated Service Fee - Estimate line-item amount (if any) of Service Fee chargeable to the client
• Estimate Total - Estimate line-item total amount (excluding VAT/GST taxes) PO Amounts
• PO Supplier Costs - Line-item amount of Purchase Orders – net cost
• PO Mark Up - Job Total amount of Mark Ups chargeable to the client (if any) on Purchase Order transaction
• PO Service Fee - Line-Item amount of Service Fees chargeable to the client (if any) on Purchase Order transaction
• PO Total - Job Total amount of Purchase Order transaction (excluding VAT/GST taxes)
• Un Matched PO - Line-item amount of Purchase Orders – net cost less the amount of Supplier Invoices already matched against Purchase Order transaction

Billable Amounts

• Billable Time - Line-item Billable amount for Timesheet transaction
• Billable Internal Charges - Line-item Billable amount for Timesheet Entry
• Billable Supplier Costs - Line-item amount for External/Supplier invoices/payments
• Billable Mark Up - Line-item amount (if any) for Mark Up chargeable to the client
• Billable Service Fee - Line-item amount (if any) for Service chargeable to the client
• Billable Total - Billable line-item total amount (excluding VAT/GST taxes)

Billed Time

• Billed Time - Line-item amount of Timesheet amount billed to the client
• Billed Internal Charges - Line-item amount of Internal Charge billed to the client
• Billed Supplier Costs - Line-item amount for External/Supplier invoice/payment amounts billed to the client
• Billed Mark Up - Line-item amount (if any) for Mark Up billed to the client
• Billed Service Fee - Line-item amount (if any) for Service Fee billed to the client
• Billed Total - Line-item total amount billed to the client (excluding VAT/GST taxes)

Unbilled Amounts

• Unbilled Time - Line-item amount of Timesheet amount not yet billed to the client
• Unbilled Internal Charges - Line-item amount of Internal Charge not yet billed to the client
• Unbilled Supplier Costs - Line-item amount for External/Supplier invoice/payment amounts not yet billed to the client
• Unbilled Mark Up - Line-item amount (if any) for Mark Up not yet billed to the client
• Unbilled Service Fee - Line-item amount (if any) for Service Fee not yet billed to the client
• Unbilled Total - Line-item total amount not yet billed to the client (excluding VAT/GST taxes)

Balance Amounts

• Balance Time - Line-item amount of billable Timesheet amount less billed time
• Balance Internal Charges - Line-item amount of Internal Charge billable to the client less amount billed to the client
• Balance Supplier Costs - Line Item amount of External/Supplier invoices/payment amounts billable to the client less External/Supplier invoices/payment amounts billed to the client
• Balance Mark Up - Line-item amount (if any) for Mark Ups billable to the client less Mark Ups billed to the client
• Balance Service Fee - Line-item amount (if any) of Service Fee billable to the client less Service Fee billed to the client
• Balance Total - Line-item amount billable to the client less amount billed to the client (excluding VAT/GST taxes)

WIP Amounts

• WIP Balance - Line-item WIP/Advance Billing Balance
• Balance Taken Up - Line item amount of WIP Take-Ups