How Profitability Values Are Calculated On The Job-to-date Profitability Dashboard Section
The Job-to-date Profitability section is available on the Job Management tab in the Jobs Navigation Center.
No. This section and the report present the information in slightly different ways. The Job Profitability Report breaks the job profitability out by GL account. The Job-to-date Profitability section does not do this. The total profitability for the job will be the same on the section and the report if they are for the same dates.
Note: The information on this section is based on the As of date. For example, only transactions dated on or before the As Of date are included in the calculations.
These are the calculated values that are available on the Job-to-date Profitability section:
| Value | Calculation |
|---|---|
| Actual Revenue |
This comes from Sales Invoices, Credit Memos, and Receipts that have been created for this job. It also includes Beginning Balances and amounts from Journal Entries made to Income accounts for this job. |
| Actual Expenses |
This comes from Purchases, Vendor Credit Memos, Payments, Payroll Checks, and Inventory Adjustments that have been created for this job. It also includes Beginning Balances and amounts from Journal Entries made to Expense accounts for this job. |
| Gross Profit $ |
Actual Revenue minus Actual Expenses |
| Gross Profit % |
(Gross Profit $/Actual Revenue )*100 |
| Est. Revenue |
This comes from the Estimated Expenses and Revenue tab on the Job Record. |
| Est. Expenses |
This comes from the Estimated Expenses and Revenue tab on the Job Record. |
| Est. Profit $ |
Est. Revenue minus Est. Expenses |
| Est. Profit % |
(Est. Profit $/Estimated Revenue)*100 |
| Committed Rev. |
This comes from open Sales Orders and open accepted Proposals that have been created for this job. Note: Once a Sales Order or Proposal has been applied to an invoice, it will no longer be included in Committed Revenue as of any date. |
| Committed Exp. |
This comes from open Purchase Orders that have been created for this job. Note: Once a Purchase Order has been applied to a purchase, it will no longer be included in the Committed Revenue as of any date. |
| Revenue: Act. + Committed |
Actual Revenue + Committed Revenue |
| Expenses: Act. + Committed |
Actual Expenses + Committed Expenses |
| Profit $: Act. + Committed |
(Actual Revenue + Committed Revenue)-(Actual Expenses + Committed Expenses) |
| Profit %: Act. + Committed |
((Profit $:Act.+Committed)/(Actual Revenue+Committed Revenue))* 100 |