Job Listing Report Fields
Job Listing Report Fields
The Job Listing Report can be customised for your organisation to include the columns and sort options most useful for your workflow.
Step 1: Access Report Layout
- Select Job Listing from the drop-down list.
- Right-click on the report layout headings and select Set Columns.
Step 2: Select Columns
Columns can be chosen from the lists on the left-hand side of the screen. Column headings can also be edited.
The data fields are grouped as follows:
| Field Group |
Description |
| Contact |
Information about the client contact on the job from the Address Book |
| Invoices |
Details of invoices on the job, including test invoices |
| Keywords |
Keywords used on the job |
| Payments and Receipts |
Costs entered without an invoice |
| Quotes and Estimates |
Info about quotes and calculated values |
| Tasks |
Planned tasks on the job |
Field Group Details
- Client contact information from the Address Book.
In-House Costs
| Field Name |
Description |
| IH Cost |
Timesheet hours × cost rate; includes employee cost, kind cost, or in-house items × cost rate |
| IH Items |
Quantity of items on a job |
| IH Value |
Timesheet hours × charge rate; in-house items × charge rate; can include special rates |
| Field Name |
Description |
| (Sub)Kind or Item |
Kind or item name |
| Account Executive Name |
Name of account executive |
| Arena |
Additional client classification |
| Category |
Job category |
| Client Code |
Client code |
| Closed |
Historical field marking jobs as closed |
| Created On |
Date and time job was created |
| Date Made Dead |
Date job was marked dead |
| Deadline |
Job deadline date |
| Div Code |
Division code |
| Is External |
“No” = in-house cost; “Yes” = external cost |
| Is Overhead Job |
Indicates overhead job |
| Job No |
Job number |
| Job Title |
Job title |
| Kind or Node |
Kind or node name |
| Last Modified On |
Last modification date |
| Latest WIP Note |
Most recent WIP note from communication |
| Master Job No |
Master job number |
| Month Made Dead |
Month job was made dead |
| Opened |
Date job was made live |
| Period |
Period code |
| Phase Code |
Phase code |
| Product Description |
Description of product |
| Status |
Job status (e.g., Live, Complete) |
Keywords
- Keywords applied to the job for filtering and reporting purposes.
Misc Financial
| Field Name |
Description |
| % Profit |
(Billings − Actual Costs) ÷ Billings × 100 |
| Available Ext Value |
Estimated external value − actual external value |
| Available Int Value |
Estimated internal value − actual internal value |
| Billed This Month (ex GST) |
Total billed this month |
| Ext Cost |
Total supplier invoices |
| Future Forecast |
Value in forecast tab for future months |
| Invoiced − Quoted |
Total invoiced amount − quoted amount |
| Profit |
Actual billings − costs |
| QE External Value |
External value from estimate |
| QE In-House Value |
Value of in-house hours on estimate |
| Total Value |
Total of in-house and external value on job |
Payments and Receipts
| Field Name |
Description |
| Bank Cost |
Costs from direct payments (no supplier invoice) |
| Bank Value |
Bank cost + markup |
Purchase Orders
| Field Name |
Description |
| Outstanding PO Cost |
Outstanding amount on purchase order |
| PO Cost |
Total purchase order cost |
| PO Nos |
Purchase order numbers |
| PO PAYG |
PAYG on talent purchase order |
| PO Tax |
GST on purchase order |
Quotes and Estimates
| Field Name |
Description |
| Budget − Actual Cost |
Quoted amount − actual costs |
| QE Amount − QE Cost |
Quote amount − quote cost |
| QE Hours |
Hours specified on quote |
| QE Nos |
Quote number |
| QE Service Fee |
Service fee charged on quote |
| Quoted − Actual Hours |
Quoted hours − actual hours |
| Quoted − Value |
Quoted amount − value of hours and costs |
Supplier Invoices
| Field Name |
Description |
| Sinv Cost |
Supplier invoice cost |
| Sinv Nos |
Supplier invoice number |
| Sinv PAYG |
PAYG on talent supplier invoice |
| Sinv Suppliers |
Supplier name |
Tasks
| Field Name |
Description |
| Task Hours |
Planned hours for task |
| Task Value |
Total value of task |
Organise training or need more help
Please contact support 02 8115 8090 or email support@jobbag.com
