---
title: "Reporting > Job List 17 - Expenditure Overview Cost & Sale"
canonical: "https://technology.bytangram.com/space/TGKB/1656946881/Reporting+%3E+Job+List+17+-+Expenditure+Overview+Cost+%26+Sale"
format: markdown
---
You can create many reports from the **jobs** module > **jobs list** simply by changing the **jobs list view** field. **Job list #17** gives a detailed overview on the cost and sale rates of time and purchases and invoice data on the selected jobs.

| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |

---

## HOW TO RUN JOB LIST 17

- 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://96931208-3147-4bae-adda-179a7c900ae5)


- Once the job list has been filtered change the job list to **expenditure overview cost & sale (17)**

![image](media://184493b2-d7da-461d-a771-cb3c9deb5cfc)


- Your job list will reformat to **WorkBook’s expenditure overview cost & sale (17)**

![image](media://cc78114d-4ce3-4b8e-b7a3-4f585f2e4b03)


---

## EXPLANATION OF JOB LIST 17 DETAILS

There are a number of columns that can make up job list 17 - 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 |
| **Company** | 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 |
| **End Date** | Indicates the job’s end date. It comes from the End Date field in the job properties sidebar |
| **Responsible** | 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 |
| **Display Currency** | The displayed currency of the current user<br>> 📝 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. |
| **Quoted Hours** | Total number of hours on time based items on approved Price Quotes on the job or all Price quotes on a job, depending on the setup of system variable #1051 |
| **Quoted Hours (sales price)** | Total value of approved Price Quotes on the job or all Price Quotes on a job, depending on the setup of system variable #1051 |
| **Quoted Purchases (sales price)** | Value of total purchases on approved Price Quotes |
| **Quoted Total** | Quoted Hours (sales price) + Quoted Purchases (sales price) + any margin/extra added to the price quote |
| **Hours Used** | Hours logged via timesheets to date |
| **Cost Total Hours (cost price)** | 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 |
| **Purchases (cost price)** | The cost to the <u>agency</u> of the total creditor invoices registered to the job + any unsettled POs |
| **Expenditures Total (cost price)** | Costs Total Hours (cost price) + Purchases (cost price) |
| **Costs Total Hours (sales price)** | Sales price of hours recorded on the job to date via timesheets, the rate is taken from the employee’s activity or the task activity on the price list assigned to the job, depending on the setup of system variable #802 |
| **Purchases (sales price)** | The cost to the <u>client</u> of total creditor invoices registered to the job + any unsettled POs |
| **Costs Total (sales price)** | Costs Total Hours (sales price) + Purchases (sales price) |
| **Invoice Amount (non-purchase related)** | Total invoice amount of non-purchase items |
| **Invoice Amount (purchase related)** | Total invoice amount of purchase items |
| **Invoice Amount** | Invoice Amount (non-purchase related) +  Invoice Amount (purchase related) + any margin/extra added to the invoice |
| **Unbilled (non-purchase related)** | Invoice Amount (non purchase related) minus Cost Total Hours (sales price) |
| **Unbilled (purchases)** | Invoice Amount (purchase related) minus Purchases (sales price) |
| **Unbilled Total** | Unbilled (non purchase related) + Unbilled (purchase related) |
| **Department/Profit Centre** | Comes from the Department/Profit Centre field in the job properties sidebar |
| **Job Status** | Indicates the current status of the job |
| **Adjustments** | Cumulative sum of all WIP adjustment values on the job |

---

## CONFIGURING JOB LIST 17

Job list 17 contains many details for your retainer reporting purposes. Use the **modify grid** functionality to configure job list 17 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](#) article.


---

## EXPORTING JOB LIST 17

You can export job list 17 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](#) article.


---

Related Articles

> Macro (contentbylabel)