Table of Contents
- Overview
- Job Profit Summary
- Job Cost Totals
- Job Progress Report
- Job Estimate vs. Actual
- Job Over-Under Billings
Overview
In this article, we'll be discussing a series of job reports that are available to FieldEdge Premier Members utilizing custom reporting. Job reports will help you evaluate your closed jobs, for easy comparison to company and department key performance goals. View the sections below to learn the general purpose of each job report and what information can be gathered within these reports. Each report can be customized and filtered to view specific information such as filtering the view for classes like commercial vs. residential or service vs. install. Below each section is a list of the default fields and their descriptions for each job report.
Job Profit Summary
The Job Profit Summary report is used to view profit and margin for jobs with the status set to Awarded, In Progress, or Closed, It utilizes the revenue and costs included on invoices.
- Job: The name or number of the job or project that is being billed.
- Billed Revenue: The billed revenue amount that is produced through invoices.
- Cost to Date: The total cost of materials, labor, and other costs associated with the job through invoicing.
- Profit: The total profit dollar amount of the specified job.
-
Job Margin: The total profit percentage amount of the specified job.
Job Cost Totals
The Job Cost Totals report provides the cost type breakdown for costs included on invoices. This allows a company to see at a glance the labor and material cost spent for each job. You can click the total cost link for the job to be directed to the detailed cost breakdown for that specific job.
- Job: The name or number of the job or project that is being billed.
- Material Cost: Total cost of the material items that have been added to the job.
- Labor Cost: Total cost of the labor hours or items that have been added to the job.
- Subcontract Cost: Total cost of any subcontractor labor that has been added to the job.
- Other Cost: Total cost of any additional costs not listed in the above fields but have been added to the job. This could be permits, rentals, inspections, etc.
- Total Cost: The total of all cost types that have been added to the job. The total cost is what is used to determine the profit of the job.
Job Progress Report
The Job Progress Report is used to determine when you need to bill more on a job. This is great for progressive billing jobs and can be filtered by the job billing type. This report will help you identify when jobs should be billed so you don't fall behind on any earned revenue. By default, the job status filter is set to Awarded and In Progress but you can change this filter to complete to view this report for jobs that have already gone through final billing.
- Job: The name or number of the job or project that is being billed.
- Total Contract: The total contract value that is expected to be billed for this job.
- Billed Revenue: The actual dollar amount billed against the total contract for this job.
- % Billed: The percentage amount that has been billed against the total contract for this job.
- Estimated Cost: The total of any material, labor, or other costs that were estimated on the contract for this job. These costs typically come from any quotes listed for this job.
- Cost to Date: The actual cost dollar amount that has been recognized through invoicing of this job.
- % Complete: Total completed cost percentage for the job. Determined through actual cost to date vs. estimated cost.
- % Difference: The percentage completion of the status of this job. Determined through billing of the job.
Job Estimate vs. Actual
The Job Estimate vs. Actual report allows you to evaluate how close jobs are to estimates included on the original quotes. This report can also be filtered by the status and actual end date values set on the job.
- Job: The name or number of the job or project that is being billed.
- Est. Revenue: Total revenue dollar amount that is estimated to be billed on this job. This is the revenue value found from the original quote of this job.
- Est. Cost: Total cost dollar amount that is estimated to be recognized on this job. This is the cost value found from the original quote of this job.
- Est. Profit: The total estimated profit dollar amount that is determined by subtracting the estimated cost from the estimated revenue.
- Est. Margin: The total estimated profit percentage that is determined by finding the percentage profit amount of the estimated revenue subtracted by the estimated cost.
- Act. Revenue: The actual total revenue dollar amount that has been billed through invoicing.
- Act. Cost: The actual total costs in dollar amount, that has been recognized through invoicing.
- Act. Profit: The actual total profit dollar amount that is determined by subtracting the actual cost from the actual revenue.
- Act. Margin: The actual total profit percentage that is determined by finding the percentage profit amount of the actual revenue subtracted by the actual cost.
- Revenue Var: The total dollar amount revenue variance for this job. Determined by subtracting the Act. Revenue from the Est. Revenue.
- Cost Var.: The total dollar amount cost variance for this job. Determined by subtracting the Act. Cost from the Est. Cost.
- Profit Var($): The total dollar amount profit variance for this job. Determined by subtracting the Act. Profit from the Est. Profit.
- Profit Var(%): The total percentage profit variance for this job. Determined by giving the percentage value total of the Est. Profit subtracted by the Act. Profit.
Job Over-Under Billings
The Job Over-Under Billings report is used when utilizing WIP cost accounting and needing to record monthly journal entries in your accounting system for jobs that span multiple accounting periods. It provides the over and under-billing amounts for job sin progress based on the job status. This report can also be used to view at a glance what jobs may be ready for billing.
- Job: The name or number of the job or project that is being billed.
- Total Contract: The total contract value that is expected to be billed for this job.
- Billed Revenue: The actual dollar amount billed against the total contract for this job.
- Estimated Cost: Total cost dollar amount that is estimated to be recognized on this job. This is the cost value found from the original quote of this job.
- Cost to Date: The actual cost dollar amount that has been recognized through invoicing of this job.
- % Complete: Total completed cost percentage for the job. Determined through actual cost to date vs. estimated cost.
- Earned Revenue: The total revenue that should be recognized or earned for this job to date. This is determined by calculating the total contract x percent complete.
- Over Billed: This will show the revenue dollar total of earned revenue compared to the billed revenue.
- Under Billed: This will show the revenue dollar total of earned revenue compared to the billed revenue.
Comments
Article is closed for comments.