Job Cost Analysis Report

The Job Cost Analysis reports allows you to display cost, sale and margin information based upon posted, job-related transactions.  The report gathers cost and sale information directly from source documents, and not from any cost detail imported or entered onto A/R invoices.  The report can be displayed with a number of levels and depths of detail and can be used to focus on jobs that are finished as well as those that are still in progress.

Sale and Job Cost information included in the report will be gathered from:

·   Accounts Receivable Invoice—Sales information will be gathered based upon the individual Part, Labor and Miscellaneous sale amounts as well as the invoice total of all posted AR Invoices associated with a job or project.

·   Accounts Payable Invoices— Items received directly to a job on posted AP Invoices will appear as cost on the report. The cost items can be displayed by item type and further displayed by Expense Type.

·   Receipts—Items received directly to a job will appear as cost at its expected cost  (Cost listed for the item on an associated PO or items PriceBook Standard Cost if PO is not used). This Expected Cost will be updated by the Actual Cost of the item when the AP Invoice associated with the receipt is posted.

·   Inventory Requisitions—Items appearing on posted requisitions to a job will be included in the report - at their average inventory cost for valued items when inventory is active, at standard cost when inventory is not active.

·   Labor—actual labor hours and cost are recorded based upon the job/project related entries made in:

o     Timecard Entries—are used to show actual hours worked, and for hourly and salaried employees include the cost of labor as well.

o     Miscellaneous Wage Entries (non-commission)—piece rate employees have their actual labor cost applied to the job through the creation of miscellaneous wage entries. Bonuses and commissions are not counted toward labor cost.

o     Salary—In order for salaried employees to have their wages count toward project labor cost, they must be set up to expense their salary by timecard entry. They cannot be set to expense their salary as Salary Split, as this automatically applies their wages to defined departments only and not to individual jobs or projects.

Running the Job Cost Analysis Report

The Job Cost Analysis report can be found in the Management section of the Report Gallery.