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.


Prerequisite:


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


Input:

Reporting PeriodAllow user to select the reporting period from a list of options are set custom a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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
CustomerName of customer the job was done for.
Job #Job number.
JobJob description.
StatusStatus of the job.
MilestoneJob milestone profit/loss transaction is related to.
TypeType of profit/loss transaction.
DateEffective Date of profit/loss transaction.
ReferenceTransaction document number reference.
AddressJob address.
ContactJob contact details.
SupplierSupplier name for transaction type "Purchase".
StartDate when job started.
FinishDate when job has been completed.
YearYear of Effective Date of profit/loss transaction.
QuarterQuarter of Effective Date of profit/loss transaction.
MonthMonth 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.