--- title: "Reporting > Job List 3 - Expenditure Overview Cost Prices" canonical: "https://technology.bytangram.com/space/TGKB/1656979841/Reporting%20%3E%20Job%20List%203%20-%20Expenditure%20Overview%20Cost%20Prices" format: markdown --- You can create many reports from the **jobs** module > **jobs list** simply by changing the **jobs list view** field. **Job list #3** gives detailed information on the cost rate of time and purchases on the selected jobs. | **ON THIS PAGE YOU WILL FIND:** | | --- | | > Macro (toc) | --- ## HOW TO RUN JOB LIST 3 - Go to the **jobs** module > **jobs list** > **filter** your jobs list according to what you want to see in your report e.g. client/client group and project - Click **apply** ![image](media://0732786c-e254-4d7f-b4a8-182f38a70228) - Once the job list has been filtered change the job list to **expenditure overview cost prices (3)** ![image](media://9b9e059c-0f84-4e0c-8e50-64161c003fb7) - Your job list will reformat to **WorkBook’s expenditure overview cost prices (3)** ![image](media://63b116d3-78f4-497c-9a4e-9b720628812d) --- ## EXPLANATION OF JOB LIST 3 DETAILS There are a number of columns that can make up job list 3 - here is a break down of the column headers and their definitions. | | | | --- | --- | | **COLUMN NAME/S** | **DEFINITION** | | **Job No.** | WorkBook job number | | **Job Name** | Indicates the name of the job | | **Client** | The client the job belongs to | | **Project** | Comes from the Project field in the job properties sidebar | | **Created** | Date the job was created | | **End Date** | Indicates the job’s end date. It comes from the End Date field in the job properties sidebar | | **Project Manager** | Indicates the project manager assigned on this job. It comes from the Project Manager field in the job properties sidebar | | **Billable** | There will be a tick in the field to indicate the job is billable | | **Company** | The WorkBook company the job belongs to | | **Company Currency** | Default currency of the WorkBook company the job belongs to | | **Reference Key** | The reference key field is sometimes used as part of the implementation process when jobs are imported into WorkBook. It comes from the reference key field in the job properties side bar > job finance settings | | **Display Currency** | The displayed currency of the current user
> 📝 All the other currencies created/incurred on the job will be converted into the user’s displayed currency using the rate defined under the exchange rate tables. > 📝 > 📝 This is only for displaying purpose. WorkBook still maintain the original currency value set on the transaction. | | **PQ Hours** | Total number of hours for time-based items on approved Price Quotes | | **Hours Incurred** | Total number of hours recorded on the job to date via timesheets, displayed in real time and includes non-approved time entries. | | **Quoted Amount** | Total of approved Price Quotes on the job | | **PQ Net Revenue** | Total Net Revenue on approved Price Quotes (approved Price Quote amount minus total purchases on those approved Price Quotes). | | **Hours Cost Price, Total** | Cost price of hours recorded on the job to date via timesheets - this is based on the individuals hourly cost rate set against their employee record > rates & billable targets | | **PO Remaining Cost** | Total amount of approved Purchase Orders on the job, that have not yet been settled | | **Purchases Cost from Price Quote** | Total amount of purchases on approved Price Quotes on the job | | **Purchases Total Cost** | Any creditor invoices registered to the job + any unsettled POs | | **Sum of Purchase Orders** | Total of all approved (unsettled) purchase orders on the job | | **Purchases External Cost** | Total of all creditor invoices registered to the job, including personal expenses | | **Expenditures Total Cost** | Purchase Total Cost (cost price of any creditor invoices registered to the job + any unsettled POs) + Hours Cost Price, Total (the cost price of timesheets logged on the job to date) | | **Invoiced** | Total finalised invoices to date on the job | | **Net Revenue** | Invoiced minus Purchases Total Cost | | **Contribution Margin** | Invoiced minus Expenditures Total Cost | | **Net Profit** | Net Revenue minus Hours Cost Price, Total | | **Department/Profit Centre** | Comes from the Department/Profit Centre field in the job properties sidebar | | **Job Status** | Indicates the current status of the job | --- ## CONFIGURING JOB LIST 3 Job list 3 contains many details for your retainer reporting purposes. Use the **modify grid** functionality to configure job list 3 to suit your agency’s retainer reporting process. > ℹ️ For more information on how to use the modify grid functionality refer to the [grid view reporting](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/959021106) article. --- ## EXPORTING JOB LIST 3 You can export job list 3 to create your own reports using WorkBook’s **export grid data** functionality. > ℹ️ For more information on how to use the export grid data functionality refer to the [grid view reporting](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/959021106) article. --- Related Articles > Macro (contentbylabel)