This report displays total amount invoiced less actual costs of time, materials and purchase orders to show profit and loss on a job.

To access this report go to Reports > Job Performance > and select Profitability by Job

You can run this report using the following criteria:
 Date Range
 Client or Supplier Name
 Client to Invoice
 Job Status
 Active Jobs
 Invoice Status
 Job Number
 Project Number
 Branch
 Client Manager
 Sales Code

Note: If you enter a date range the report will return all jobs that have been invoiced in this date range. Streamtime will then ask if you wish to see all costs and invoices on these jobs or only those matching the chosen date range.

You can choose to preview your report, print it, make a PDF or export your report to Excel so you can use the data to create your own reports

This report displays comparison data for all jobs found within the criteria specified.

Each line displays the Job Number and Job Name

The Invoice Date will show the date the job was invoiced

Note: If there is more than one invoice on a job, it will show the date of the latest invoice

Total Invoice will show the total amount of all invoices on the job

Note: If there is more than one invoice on the job and you have used a date range in your search criteria, it will only show the total of invoices within that date range

Total Actual Cost is based on the cost value of all time and materials plus the cost values of all active orders for each job

The cost value is based first on the cost assigned to the staff member in Setup > System Setup > Users

or if this is left blank, Streamtime will use the cost price for the item in the Cost Matrix

Note: If you have no costs rates in Streamtime, then the report will return no costs for your time & materials

For the purchase order to appear as a cost in this report, you need to ensure your order has an active or reportable status.
 For more information on active statuses click here

Profit/Loss is Total Invoiced less Total Actual Cost

Note: All non-home branch figures are converted to the home branch currency using the exchange rate values entered against a branch.

Finally there is field with the title Custom3. If you don't see any information in this field do not be alarmed. This is a field which can be customised to suit your own needs. For example some clients like to see which account manager is responsible for each job, so they can customise the field to pull this information on the report.

To customise the field you need to go to Setup > System Setup > Jobs and go to the Custom Fields area. The field you want to edit is the Custom3 field as this is the field that pulls onto the report.

Once you have create the custom field in the Setup tab you can then go to Jobs > Custom and use that field so it can be utilised on the report.
 See below

Did this answer your question?