This Help Article covers:
General/Overview:
A Job's Profit & Loss is viewed from the Job Window's More/Reports Top Tab's > Profit & Loss Expandable.
The Profit & Loss Expandable displays either Three, OR Four Sub-Expandables:
Three - Charge Up Jobs, or
Four - Quoted and Estimated Jobs
⚠️ NOTE: To View a Quoted, or Estimated Job's P&L (four Sub-Expandables), the Quote or Estimate must have been [Accepted]. I.E. Until a Quote or Estimate is Accepted, the P&L view is the view of a Charge Up Job (three Sub-Expandables).
⚠️ NOTE: A Quoted or Estimated Job's Profit & Loss Expandable's forth Sub-Expandable, "Quotes", displays a list of the Accepted Quote and any Accepted Variations that are included in the P&L Report.
💡 TIP: Although an Estimated Job displays the P&L like a Quoted Job, the Invoicing of an Estimated Job is done using Charge Up Invoices, not Progress Claims like a Quote.
The Profit & Loss's "Summary" Sub-Expandable displays the Total values of Products grouped by their Top Level Product Category, I.E. a Line for Ad-Hoc, Labour, Materials and/or Other. If there are no Products for a Top Level Product Category, that Line does not display.
To View a Job's Profit & Loss
Quick Flow:
JOB: XXXX Window
More/Reports Top Tab
Profit & Loss Expandable Section
1. From a JOB: XXXX Window, Press the More > Reports Top Tab, then Press the Profit & Loss Expandable Section to display the "Summary" sub-Expandable and the sub-Expandables for either a Charge Up Job or Quoted Job.
Charge Up Job Profit & Loss Summary
1. From the Profit & Loss Expandable Section, Press the "Summary" Sub-Expandable to display the P&L Summary
The "Summary" displays columns:
Category - Top Level Product Categories (does not display if no Products in the Category)
Actual Cost - Costs to Date of Products as they are Assigned/Allocated to the Job (including Cost of Products manually added to a Sales Invoice)
Actual Sell - Sell Price of Products pulled into OR manually added to Invoices, calculated at the Customer's default Pricing Rules
Profit - Calculation of the Actual Costs V Actual Sell, displayed as a $ value
Margin - Calculation of the Actual Costs V Actual Sell, displayed as a % value
⚠️ NOTE: This is the P&L of the Job, not an individual Sales Invoice.
Charge Up Job's Profit & Loss Breakdown
1. From the Profit & Loss Expandable Section, Press on the “Costs – Sold” and/or “Costs – Unsold” Sub-Expandables
"Costs - Sold" - Displays Products of the Job that have been Sold, displaying their Cost Price and Sell Price
"Costs - Unsold" - Displays Products Assigned/Allocated to the Job, displaying their Cost Price and potential Sell Price (calculated at the Customer's default Pricing Rules)
⚠️ NOTE: When Products are Pulled into a Sales Invoice on [Get Costs], they move from "Costs - Unsold" to "Costs - Sold" display.
💡 TIP: Hover over the "Information" Icon of a Line to see the "Source" of the Item.
💡 TIP: The P&L Report can be downloaded to an MS Excel Spreadsheet for further Analysis.
Quoted/Estimated Job Profit & Loss Summary
1. From the Profit & Loss Expandable Section, Press the "Summary" Sub-Expandable to display the P&L Summary
The "Summary" displays headings:
Payment Claims to Date - Total Progress Claims to Date
Profit to Date - Calculation of the Actual Costs V Progress Claims to Date, displayed as a $ value
Margin to Date - Calculation of the Actual Costs V Progress Claims to Date, displayed as a % value
⚠️ NOTE: Should a Charge Up Invoice be Added to Quoted Job, or an Estimated Job, a new Line "Charge Up Invoices to Date" displays in the Summary headings.
The "Summary" displays columns:
Category - Top Level Product Categories (does not display if no Products in the Category)
Quoted Costs - Cost of Products used in the Quote
Actual Costs - Costs to Date of Products as they are Assigned/Allocated to the Job
Quoted Sell - Quoted Sell Price from the Quote and any Accepted Variations
Quoted Profit - Quoted Profit from the Quote and any Accepted Variations, displayed as a $ value
Quoted Margin - Quoted Profit from the Quote and any Accepted Variations, displayed as a $ value
💡 TIP: Compare the "Payment Claims to Date", "Profit to Date" and "Margin to Date" against the "Quoted Sell", "Quoted Profit" and "Quoted Margin", taking into consideration how far along the project is, to assess if the project is on track.
Quoted/Estimated Job's Profit & Loss Breakdown (Back Costing)
1. From the Profit & Loss Expandable Section, Press on the “Costs – Budgeted” and/or “Costs – Non-Budgeted” Sub-Expandables
"Costs – Budgeted" - Displays Products Assigned/Allocated to the Job where the Product Code matches a Product Code of a Product used in the Quote
"Costs – Non-Budgeted" - Displays Products Assigned/Allocated to the Job where the Product Code DOES NOT match a Product Code of a Product used in the Quote
⚠️ NOTE: Labour assigned to the Quoted Job aggregates and always displays in the “Costs – Budgeted” Section, displaying Budgeted V Actual.
💡 TIP: "Costs - Budgeted" displays the Quoted, Actual and Variance values for Products, if there are no Actuals for a Product, check "Costs - Non-Budgeted" in case Staff are purchasing items different to what was allowed in the Quote.
💡 TIP: Reviewing the "Costs - Non-Budgeted" items will highlight items possibly missed from the Quote (and Kitsets can be updated if needed) OR if Staff are purchasing items different to what was allowed in the Quote.
💡 TIP: The P&L Report can be downloaded to an MS Excel Spreadsheet for further Analysis.
