Job reports relate to the daily management and monitoring of a job, including schedules, backlogs, and change orders.

Audit costs report

The Audit Costs report contains detailed transaction information for a job with subtotals by cost element and cost code. You can sort this report by job, cost code, cost element, or a date range.

Choose Reports > Job Cost > Job Reports > Audit Reports > Audit Costs.
Choose a Job Number Range radio button. If you choose Job Number, select a Job. If you choose Range, enter a Range.
Choose a Date Range radio button and enter the dates.
Choose a Range radio button and enter a cost element type or cost code.
You can mark the Exclude Inactive check box to exclude inactive cost codes from the report.
Choose Print.

Audit billing report

The Audit Billing report contains billing information for a specified job, and includes change order amounts, net billed-to-date amount, current amount due, gross billed-to-date amount, and estimated amounts.

Choose Reports > Job Cost > Job Reports > Audit Reports > Audit Billing.
Enter a Job Number.
Choose Print.

Audit cash receipts report

The Audit Cash Receipts report displays cash receipt information for the selected job, including transaction information and billable costs.

Choose Reports > Job Cost > Job Reports > Audit Reports > Audit Cash Receipts.
Enter a Job Number.
Choose Print.

Audit cost variance report

The Audit Cost Variance report shows detailed transaction information for a job with estimate variances by cost code and cost element. The variance is between the expected costs and actual costs.

Choose Reports > Job Cost > Job Reports > Audit Reports > Audit Cost Variance.
Choose a Job Number Range radio button. If you choose Job Number, select a Job. If you choose Range, enter a Range.
Choose a Date Range radio button. If you choose Range, enter a Start Date and End Date.
Choose a Range radio button and enter a cost element type or cost code.
You can mark the Exclude Inactive check box to exclude inactive cost codes from the report.
Choose Print.

WIP reports

At month end, you may want to make sure that the WIP accounts updated in Job Cost balance with the WIP accounts updated in the general ledger (GL). You can run reports that show you which Job Cost transactions have and have not been posted through to the GL - and which transactions have been posted in the GL, but not to Job Cost.
Note: When transactions are posted that are applied to a job, the JC20001 table will be updated with the ORTRXSRC (originating transaction source) from the GL20000 table, and with the JRNENTRY (journal entry) number. In addition, transactions in the GL10001 (so all batches must be posted in GL) and GL30000 (for transactions in closed years) are checked.

Using WIP reports at month end

Job Cost provides the following reports to help you reconcile Job Cost with the general ledger:

WIP reportPrinted by year and period, this report shows amounts for each job, grouped by division. This is to give you an idea of amounts that are currently unbilled. You can print a summary or detailed version of this report.
Exception reportsThe exception reports how which costs have been posted in the GL but have NOT been posted in Job Cost, and vice versa.

For example, for costs that are in Job Cost but not the GL, you may have posted to the GL, but did not post the GL batch yet. Conversely, for costs in the GL but not in Job Cost, you may have posted costs from any other module to those accounts, for example, an adjustment entry to the account not assigned to a job.

Sample report sequence

The following steps demonstrate how these reports can be used to help reconcile WIP and Progress Billings accounts as part of month end reconciliation.
Step 1: Run the WIP reconciliation Summary report
Run the summary version of the WIP reconciliation report to see which amounts balance; you can filter the report for the month you are reconciling. If you open the Summary Inquiry window to view GL activity (Inquiry > Financial > Summary), the Net Change for a period should match the same account's total for the same date range on the reconciliation report.
Step 2: Run the WIP reconciliation Detail report
If summary report totals do not balance, you can view transaction-level detail for the period. This may help identify discrepancies.
Step 3: Run the Exception reports
If you still cannot pinpoint the issue, these reports identify transactions that were posted to your Job WIP accounts but not to the GL, and vice versa. These reports check all accounts that are used in the current setup or data set as WIP or Progress Billing accounts, as well as AR invoices, cost tables for open and closed jobs, and the POC revenue recognition entry, will be checked.
Note: The Job to Date or JTD line of the Job Percentage of Completion report can also be used to identify the balance in other accounts, such as Over Billing, Under Billing, and Progress Billing. In addition, the Month to Date (MTD) line shows activity for the year and period.
The exception reports identify journal entries along with the type of transaction and the user who posted it. For example, the issue may be a payable that debited WIP without the job number filled in, or a journal entry that was made directly to the GL instead of through Job Cost. The report helps you identify the transaction and assess user training needs.
Step 4: Make any adjustments to GL or Job Cost accounts

Posting setup

Before you run the WIP reconciliation reports, your posting options must be set up to create journal entries for transactions. You must set this up for the following product series: Inventory (with an origin of Transaction Entry) and Sales (with an origin of Sales Transaction Entry). These may have already been set up, but we recommend that you double-check the setup.

Choose Microsoft Dynamics GP > Tools > Setup > Posting > Posting. The Posting Setup window opens.
In the Series drop-down menu, select Sales.
In the Origin drop-down menu, select Sales Transaction Entry.
Under Create a Journal Entry, select the Transaction radio button.
In the Series drop-down menu, select Inventory.
In the Origin drop-down menu, select Transaction Entry.
Choose OK.

Running the JC WIP reports

Choose Reports > Job Cost > Job Reports > Audit Reports > Job WIP Reports. The JC WIP Reports window opens.
Enter a Start Date and End Date.
Select to run by all or individual Division, Job, and/or Cost Element.
Select an Account Number.
Select to run a WIP report (summary or detail) or Exception report.
Choose Print.

If you are using SSRS reports, these Dexterity reports are replaced with the SSRS versions; refer to WIP reports for information about the SSRS WIP reports for Job Cost.
Summary

Detail

Exception Report - Job Cost costs not in GL

Exception Report - GL costs not in Job Cost

Profit and loss report

The Profit and Loss report contains the actual percentage complete, contract earned amount, actual cost to date, actual billed to date, and amounts received for the selected job range. The report also provides a snapshot of whether a job is operating at a profit or loss.
When you print the report for a single period, the percent complete is based on costs incurred for that period only. This is also true for cost accumulated and amount earned. To view this information for a specific job, the selected range must include all periods since the job was opened. For example, you may complete 40% of your job in Period 1 and 60% in Period 2. If the report is restricted to Period 2, it will only show the 60% that was completed in that period. If you include both periods in the report, it will show the job as 100% complete.

Choose Reports > Job Cost > Job Reports > Profit and Loss.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Job reference report

The Job Reference report contains information you enter in the Job Maintenance window, including estimate cost and estimated cost-plus-profit amounts by cost element for the selected job. You can print a Job Reference report for each job you set up. In addition, you can view actual and forecasted cost amounts by cost element.

Choose Reports > Job Cost > Job Reports > Reference.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Job schedule report

The Job Schedule report contains the job status, costs, profit, and contract-to-date information.

Choose Reports > Job Cost > Job Reports > Job Schedule.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Job status report

The Job Status report lists the information displayed in the Job Status window. The report contains committed, posted, estimated, and forecasted costs for each cost element. In addition, you can view estimated gross profit, change order, and other job information.

Choose Reports > Job Cost > Job Reports > Job Status.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Quantity variance report

The Quantity Variance report compares the estimated unit to date for each cost element with the actual units to date used. The report shows an estimated project variance for each cost code. Total projected variance amounts calculate automatically for all cost elements.

Choose Reports > Job Cost > Job Reports > Variance Reports > Quantity Variance.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Projected variance report

The Projected Variance report includes the projected field cost-to-date amount, based on the estimated percent complete, for each cost code and compares the amount to actual cost-to-date amounts. The report shows a percentage variance and an estimated variance for each cost code, calculated for each phase of the job.

Choose Reports > Job Cost > Job Reports > Variance Reports > Projected Variance.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Estimate cost variance report

The Estimate Cost Variance report shows the cost estimate for each cost code, the actual cost to date, the percent variance, and estimate variance. The report also shows total amounts calculated for the entire cost element.

Choose Reports > Job Cost > Job Reports > Variance Reports > Estimate Variance.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Job analysis report

The Job Analysis report provides cost element phase totals and cost code detail breakdown for the current period costs, and year-to-date costs of all cost codes. The report shows job-to-date totals, including the estimate, posted cost, percentage complete, and estimated cost remaining for each phase and totals for the entire job.

Choose Reports > Job Cost > Job Reports > Variance Reports > Job Analysis.
Enter the Year and use the lookup button to select a Period.
Use the lookup button to select a Job and choose Print.

Estimate analysis report

The Estimate Analysis report compares the estimate amount with the actual amounts by job number, cost code number, cost element, and period.
Costs must be posted and an estimate entry for a given period must be made for this report to show data.

Choose Reports > Job Cost > Job Reports > Variance Reports > Estimate Analysis.
Enter the (R) and use the lookup button to select a (R).
Use the lookup button to select a Job and choose Print.

Backlog report

The Backlog report shows original contract amount, contract earned, and backlog amount for all jobs in the selected range. A backlog amount is determined by subtracting the contract earned amount from the job's contract-to-date amount.

Choose Reports > Job Cost > Job Reports > Backlog.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Backlog by period report

The Backlog report shows original contract amount, contract earned, and backlog amount for all jobs in the selected range for a specified fiscal period. A backlog amount is determined by subtracting the contract earned amount from the job's contract-to-date amount. This report matches the contract earned with the POC posting.

Choose Reports > Job Cost > Job Reports > Backlog by Period.
The Year fills automatically with the system year.
Enter a Fiscal Period.
Enter a Job Number.
Choose Print.

Committed costs report

You can print the Committed Costs report if you use a Purchase Order module that integrates with Job Cost. The report shows quantity ordered, expected unit costs, and committed costs for each purchase order.

Choose Reports > Job Cost > Job Reports > Committed Costs.
Enter a Job Number.
Choose Print.

Payables aged trial balance report

The Payables Aged Trial Balance report contains payables transactions — including payables from Purchase Order Processing (POP) — for the selected jobs and vendors. The transactions are aged per the age ranges set up in Microsoft Dynamics GP. You can sort this report by job number or vendor ID.
Note: This report includes only functional currency amounts, not multicurrency amounts. This report will not include closed jobs.

Choose Reports > Job Cost > Job Reports > PM Aged Trial Balance.
Use the Sort drop-down to select the sorting method. You can sort by job number or vendor ID.
In the Age As Of field, enter a cutoff date for the aging. Vouchers entered after this date will not appear on the report.
Mark the appropriate Exclude check boxes. You can exclude fully paid documents and zero balance vouchers.
Select a range from the Ranges drop-down list. You can select a range by job number, vendor ID, or document number. Define the range by completing the From and To fields.
Choose Insert >>. You can create one range for each type of range.
Choose Print.

Job posted cost report

The Job Posted Cost report displays the posted costs to date for each cost code for each cost element. You can print the cost code list for actual costs. The report shows amounts totaled by cost code. You can also view the general ledger posting account debited as transactions post for each cost code.

Choose Reports > Job Cost > Job Reports > Job Posted Cost.
Enter a Job Number.
Choose Print.

Current contract report

The Current Contract report contains the cost code number, quantity, and estimated amount for each cost code assigned to a job. Report totals include the total estimated amount and the contract amount.

Choose Reports > Job Cost > Job Reports > Current Contract.
Use the lookup buttons in the From and To fields to select the print range. Choose Insert >>.
Choose Print.

Detail codes list report

The Detail Codes List report contains the setup information for a job's cost codes, sorted by cost element. This information includes the profit type and amount, the general ledger posting account assigned to the cost code, and the total cost-per-unit amount.

Choose Reports > Job Cost > Job Reports > Detail Codes List.
Enter a Job Number.
Choose Print.

Change order summary report

The Change Order Summary report lists change orders, amounts, and status for the selected job.

Choose Reports > Job Cost > Job Reports > Change Order Summary.
Select a Job.
Choose Print.

Profit and loss by period report

The Profit and Loss report contains the actual percentage complete, contract earned amount, actual cost-to-date, billed-to-date, and profit amount for jobs within a designated period.

Choose Reports > Job Cost > Job Reports > P and L by Period.
Enter From and To dates for the Year and Period.
Choose to include All jobs, Open jobs, or Active jobs.
Enter a range of job numbers.
Choose Insert >>.
Choose Print.

Costs by period report

The Costs by Period report contains the actual costs of selected jobs or a range of years and periods within those years. The report also displays the amount billed for each job for each period within the selected range. The status of the jobs, customer numbers and names, and the totals are also displayed in this report.

Choose Reports > Job Cost > Job Reports > Costs by Period.
Enter the range of years in the From and To fields. Use the lookup buttons to select a range of periods.
Choose a radio button to include All jobs, Open jobs, or Active jobs.
Use the lookup buttons to select the print range. Choose Insert >>.
Choose Print.

Current year - contracts in progress report

The Current Year - Contracts in Progress report for the current year shows amounts recognized to date, recognized for the current year, and estimated to complete. This report is similar to the Job Analysis report. To see data in the Current Year - Contracts in Progress report, the periods must be closed for the months you are selecting. In addition, you must run the Year-End Closing routine in Job Cost (Microsoft Dynamics GP > Tools > Routines > Job Cost > Year-End Closing).

Choose Reports > Job Cost > Job Reports > Current Year - Contracts in Progress.
Accept the current Year and enter the Period ID and Job Number. If the job number is left blank, the report will display all jobs. The date fields are disabled for this report.
Choose Print.

Current year - contracts closed report

The Current Year - Contracts Closed report for the current year shows revenue, costs, and margin. This report is similar to the Job Analysis report. To see data for closed contracts reports, the job must be closed.

Choose Reports > Job Cost > Job Reports > Current Year - Contracts Closed.
Enter the Job Number. If the job number is left blank, the report will display all jobs.
Choose to print All dates or a Range of dates. Enter start and end dates, if applicable.
Choose Print.

Job summary report

The Job Summary report contains a summary of the all job information for a specified job within a specified fiscal period. This includes billing information, estimates, contracts, and customers. Labor for a job is broken down by labor hours, cost per hour, and total labor cost.

Choose Reports > Job Cost > Job Reports > Job Summary.
In the Period ID field, use the lookup button to select a fiscal period ID.
Enter a Job Number. The date fields are disabled for this report.
Choose Print.

The Applied Overhead field is calculated using the Overhead Labor % field in the Job Maintenance window.
Note: Applied Overhead = Labor Cost x Overhead Labor % (Job Maintenance window)
The Assessment field is the variance between the Applied Overhead and the overhead calculated using the overhead detail codes fixed rate or percentage in the Overhead Detail Codes window.
Note: Assessment = Applied Overhead - (Labor Cost x fixed portion or percent portion)