Issue/Symptom/Question

Standard Crystal Report - Job Revenue And Cost – Month End Summary

Applies To

Penta for Windows

Crystal Report - Job Revenue And Cost – Month End Summary

Project Management

Resolution/Fix/Answer

Use the Job Revenue/Cost Month End Summary report to review revenue, cost, gross margin, and billings of selected jobs for a selected date range.

Selection

You can limit records displaying on this report by:

• Period Begin Date – Use the Period Begin Date and Period Ending Date fields to specify the period for which the report is valid. The report includes transactions posted during this period.

• Period Ending Date

• Ending Date – Use the Ending Date field to specify the date through which the report is valid. That is, the report includes transactions entered through this date.

• Job Id

• OU Id

• Customer Id

• Job Status

• Job Type

• Project Manager

• Sales Person Id

Sort

Records sort in order by:

1. OU Id

1. Job Id

Totals

This report contains sub-totals for each OU Id.

Report Code: jc_jobRevCostMthEndSmy_p65_cr11.rpt

Available Parameters:

Example Report Results:

Current Period Fields

• Job Id
• The unique PENTA job identification.

Job Name - Description of the job.

Earned Revenue - The amount billed adjusted by Over/Under Billed for the period.

Actual Cost - The actual cost posted to the job for the period.

Job-To-Date Fields

Earned Revenue - The amount earned on the job based upon the amount of work performed. PENTA calculates this value through the Last Earned Revenue Recognition Date, which is the latest date from the Job’s inception through the Ending Date in the selection parameters.

Actual Cost - The actual cost posted to the job from the Job’s inception through the Ending Date in the selection parameters.

Gross Margin - PENTA calculates this value as: Earned Revenue Job-To-Date – Actual Cost Job-To-Date

Gross Margin % - PENTA calculates this value as: Gross Margin ÷ Earned Revenue Job-To-Date. If Earned Revenue is zero, then Gross Margin is zero.

Billing - The amount invoiced from the inception of the job through the Ending Date in the selection parameters.

(Over)/Under Billed - PENTA calculates this value as: Earned Revenue – Billing as of the last execution of Revenue Recognition. A negative amount indicates over billing. If a billing occurred after the last revenue recognition, Billing is greater than the Earned Revenue by this amount. A positive amount indicates under billing. Note that if PENTA calculates this amount within the range from –0.50 to +0.50, PENTA prints 0 on this report.

Invoice Fields 

Total A/R - Billings for which you did not receive payments. This amount includes unbilled retention.

60 – 90 Days O/S - Billings sent 60-90 days ago for which you have not received payments.

Over 90 Days O/S - Billings sent over 90 days ago for which you have not received payments.

Unbilled Retention - The open retention on the job.

Last Earned Revenue Recognition Date - The last date that revenue recognition ran.