---
title: "Reporting > Job List 18 - Project Retainer"
canonical: "https://technology.bytangram.com/space/TGKB/1656946689/Reporting%20%3E%20Job%20List%2018%20-%20Project%20Retainer"
format: markdown
---
You can create many reports from the **jobs** module > **jobs list** simply by changing the **jobs list view** field. **Job list #18** is WorkBook’s built in retainer report, for those using the WorkBook retainer module.
| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |
---
## HOW TO RUN JOB LIST 18
- 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**
- Once the job list has been filtered change the job list to **project retainer (18)**
- Your job list will reformat to **WorkBook’s project retainer report (18)**
---
## EXPLANATION OF JOB LIST 18 DETAILS
There are a number of columns that can make up job list 18 - here is a break down of the column headers and their definitions.
| | |
| --- | --- |
| **COLUMN NAME/S** | **DEFINITION** |
| **Retainer Type** | The icon indicates if the job is the master billing job or a delivery job |
| **Job Name, Project & Client** | Indicate the name of the job, the project and client the job belongs too |
| **Project Manager** | The project manager assigned to the job |
| **Company** | The WorkBook company the job belongs to |
| **Profit Centre** | The profit centre or department the job belongs to |
| **Start Date & End Date** | The job start and end dates |
| **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.
> 📝
> 📝 Refer to this article to learn more about currency rate table [https://tangram.atlassian.net/wiki/spaces/TGKB/pages/1602224129](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/1602224129)
 |
| **Master PQ original amount** | The agreed $$$ between the agency and the client, that has been captured on the master job - approved price quote/s
> 📝 Every time a price quote is added to the master job the value will increase |
| **Master PQ original hours** | The agreed number of hours between the agency and the client, that have been captured on the master job - approved price quote/s
> 📝 Every time a price quote is added to the master job the hours will increase |
| **Master PQ remaining amount** | The remaining $$$ amount on the approved price quote/s of the master job:
> ℹ️ Total original $$$ less delivery job $$$ |
| **Master PQ remaining hours** | The hours remaining on the approved price quote/s of the master job:
> ℹ️ Total original hours less total delivery job/s hours |
| **Delivery PQ original amount** | Total amount of $$$ on the approved price quote/s of the delivery jobs, covered by the retainer project |
| **Delivery PQ original hours** | Total amount of hours on the approved price quote/s of the delivery jobs, covered by the retainer project |
| **Delivery PQ hours amount** | Total value (sales price) of hours on the approved price quote/s of the delivery job |
| **Delivery hours remaining** | Hours on approved price quote/s less timesheet hours on the delivery job |
| **Delivery PQ final hours** | Total number of hours on the delivery PQ once the job is closed and adjustments made
> 📝 If project setting settlement method is “invoice amount is equal to approved price quote” then this column will be the same as Delivery PQ original hours |
| **Master PQ hours amount** | Total value of approved price quotes on the master job less total value of approved price quoted on delivery jobs |
| **Delivery PQ hours amount** | Total value of approved price quoted on delivery jobs |
| **Delivery PQ original amount (scoped)** | Total amount of activities (in scope) on delivery job price quotes, where the price quotes are in Status 50 |
| **Delivery PQ original hours (scoped)** | Total hours + contingency (in scope) on delivery job price quotes, where the price quotes are in status 50 |
| **Delivery hours remaining (scoped)** | Total hours of master price quotes (in status 50) less hours logged on delivery jobs |
| **Delivery PQ final hours (scoped)** | Total of estimated hours (in scope) on delivery job price quotes, where the price quotes are in status 40 or 50 |
| **Delivery PQ cost (scoped)** | Total cost amount of activities (in scope) on delivery job price quotes, where the price quotes are in status 10, 20, 40 or 50 |
| **Delivery PQ hours amount (scoped)** | Total hours + contingency (in scope) on delivery job price quotes multiplied by the hourly rates |
| **Used hours** | Total number of hours logged via timesheets on delivery jobs covered by the retainer project |
| **Used hours previous month** | Number of hours logged via timesheets (in the previous month) on delivery jobs covered by the retainer project |
| **Used hours current month** | Number of hours logged via timesheets (in the current month) on delivery jobs covered by the retainer project |
| **Actual hours sale** | Value of time logged on delivery jobs covered by the retainer project, based on the rate card applied |
| **Master PQ hours amount** | Total value of approved price quotes on the master job less total value of approved price quoted on delivery jobs |
| **Delivery PQ hours amount** | Total value of approved price quoted on delivery jobs - |
| **Master PQ internal cost** | Master PQ remaining hours x cost rate of activities on master price quotes |
| **Delivery PQ cost** | Cost rate of activities x number of hours on delivery price quotes
> 📝 If your project settings are set to actuals then, at job closure, this amount will change to the total amount of hours used on the job, rather than total amount of hours on the price quote |
| **Master PQ hours amount** | Total value of approved price quotes on the master job less total value of approved price quoted on delivery jobs |
| **Delivery PQ hours amount** | Total value of approved price quoted on delivery jobs |
| **Booked Hours** | Total number of hours booked on schedules/timelines on delivery jobs covered by the retainer project |
| **Remaining Booked Hours** | Total number of hours left of scheduled time, after time entries have been submitted on delivery jobs covered by the retainer project |
| **Overrun** | Number of hours exceeding booked (scheduled) hours based on time entries on delivery jobs covered by the retainer project |
| **Hours not booked** | The hours timesheeted to activities on the delivery jobs that have not been included in the delivery job schedules/timelines |
| **Planned Cost** | Cost rate of the resources assigned to tasks on the schedule/timeline |
| **Planned Sale** | Charge out rate of the resources assigned to tasks on the schedule/timeline |
| **Invoice Internal** | Invoice amount attributed to delivery job/s
> 📝 When a price quote is “approved externally” on a delivery job, an invoice is created attributing the value of the price quote as income to the job |
| **Invoice external** | Total invoiced to client (to date) |
| **Invoice Remaining** | Remaining amount to be invoiced to client |
---
## CONFIGURING JOB LIST 18
Job list 18 contains many details for your retainer reporting purposes. Use the **modify grid** functionality to configure job list 18 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 18
You can export job list 18 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)