How to drill down Job Cost & Billing Detail

Access a customizable view of job transaction details

Steps:

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

For information on the Job Cost & Billing Summary page, see:

Job Cost & Billing Summary Overview

Job Cost & Billing Detail Columns

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

Column Name	Detail /Transaction Page
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