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.
Prerequisite:
Table of Contents
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 DEAR 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 DEAR support.