Job Costing Profit & Loss Report

This report shows the profit/loss for each Job. Use this report to view all income, expenses and profits associated with job costing transactions. Output can be filtered by customer, supplier, time period, milestone, status and more.

This report is only available to users with Financial Reporting permissions.

Prerequisites

Data from this report can be exported in Excel, PDF or RTF format.

Input:

Reporting Period	Allow user to select the reporting period from a list of options are set custom a custom date range.
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving of a layout for potential future use.
Reset Layout	Resets layout to the default layout or selected saved layout.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

The following output fields are available for this report.

Fields
Customer	Name of customer the job was done for.
Job #	Job number.
Job	Job description.
Status	Status of the job.
Milestone	Job milestone profit/loss transaction is related to.
Type	Type of profit/loss transaction.
Date	Effective Date of profit/loss transaction.
Reference	Transaction document number reference.
Address	Job address.
Contact	Job contact details.
Supplier	Supplier name for transaction type "Purchase".
Start	Date when job started.
Finish	Date when job has been completed.
Year	Year of Effective Date of profit/loss transaction.
Quarter	Quarter of Effective Date of profit/loss transaction.
Month	Month of Effective Date of profit/loss transaction.
Data Headers
Expense	Expense associated with the transaction in base currency without tax.
Tax	Tax associated with the transaction in base currency.
Income	Income associated with the transaction in base currency without tax.
Profit	Profit = Income - Expense.

FAQs

The Profit by Sales Representative Report for December 2018 shows nil COGS for an invoice, yet the Job Costing Profit and Loss Report for December 2018 shows Expenses (i.e. job costs). Why aren't the job costs reported as COGS in the Profit by Sales Representative Report?

This happens when an invoice is actually a service sale. COGS are not assigned to a service item as price is essentially the cost of the item. Thus it can be viewed on the "Job Costing Profit and Loss Report" but not in the COGS column of "Profit by Sales Representative Report".

I am trying to complete the Job Costing profit and Loss report however there is no income showing up on most jobs.

Completion date is needed on the job for the income to be computed. If it is yet to be completed, you can still set it to current date and save job to see profit on the Job Costing Profit & Loss Report. Status can be left as In Progress.

I have run this report, but it isn’t showing the invoices raised against the job only the costs.

Invoices using New Quote in the Job are not automatically included in the Job Costing Profit and Loss Report - it is merely a convenient way to select correct customer in new sale. These invoices must be linked to the Job before they appear in the report. Use "Link expenses to an existing invoice" option to do this.

Still no answer to your question? Please do not hesitate to get in touch with Cin7 Core support.

Job Costing Profit & Loss Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?