This Help Article covers:
General/Overview:
The Profit & Loss Summary Report displays as one part:
List View - A list of Job(s) "In Progress" for the last 180 days, OR a User selected period
For the detailed Profit & Loss Report of an individual Job, see the More > Reports Top Tab of that Job.
💡 TIP: The detailed Profit & Loss Report of an individual Job can be accessed from the Profit & Loss Summary List by pressing the Arrow to the right of the Job's Profit & Loss Summary Line.
To display the Profit & Loss Summary Report List
Displaying a List of Jobs to view the Profit & Loss is done from the Reports Side Menu's "Profit & Loss" Option.
⚠️ NOTE: The Profit & Loss Summary List values are updated overnight and by default display a snapshot of the previous day's P&L. Press on the Arrow to the right of a Job's Profit & Loss Summary Line to display that Job's detailed Profit & Loss Report and trigger a data update to display that Job's current P&L values on the Profit & Loss Summary List.
Quick Flow:
Reports Side Menu
"Profit & Loss Summary" Option
1. From the Side Menu, Hover over Reports and Select the option "Profit & Loss Summary" to display the Reports: Profit & Loss Summary Window
💡 TIP: The Reports: Profit & Loss Summary Page by default displays a list of Jobs “Stage: In Progress”, and "Last Modified: Last 180 Days", you can customize the view by Pressing the Refine button, Selecting from the array of filters, then Pressing the [VIEW RESULTS] button.
Profit & Loss Summary
The Profit & Loss Summary displays differently for:
Charge Up Jobs - Actual values only
Quoted Jobs - Quoted values plus Actual values
Estimated Jobs - Actual values only
Charge Up Jobs:
Charge Up Job's Summary Line displays:
Actual Hours,
Actual Costs (Timesheets, Purchases, Site/Ad-Hoc Costs entries),
Actual Sell,
Actual Profit, and
Actual Margin
Because you use a Price Rule Book that is set to, or above your Minimum Margin % requirement, all Jobs should be running at the Gross Profit you want.
If a Job is not running at your Minimum Margin %, drill down to check if:
There are Costs allocated to the Job that have NOT been sold, this is normal if there is Work In Progress (WIP),
There are Costs allocated to the Job that do not belong to the Job, or
You have overlooked Invoicing
Quoted Jobs:
With a Quoted Job, as you have Quoted it, Katipolt displays the same information as Charge Up Jobs (Actual values), but we also display the Quoted values.
Quoted Job's Summary Line displays:
Quoted Hours V Actual Hours,
Quoted Costs V Actual Costs (Timesheets, Purchases, Site/Ad-Hoc Costs entries),
Quoted Sell V Actual Sell,
Quoted Profit V Actual Profit, and
Quote Margin V Actual Margin
💡 TIP: The "Actual Profit" $ value displays red until it reaches the "Quoted Profit" $ value.
💡 TIP: Additional columns can be displayed that take into consideration un-invoiced retentions on a Quoted Job, Press "Change Display Settings" to toggle "On"/"Off" the:
Actual Sell (with retentions) column
Actual Margin (with retentions) column
Retentions (Accumulated to Date) column
If a Job is not running at your Minimum Margin % (Or Quoted Margin %), drill down to check if:
There are Costs allocated to the Quoted Job that have NOT been claimed, this is normal if there is Work In Progress (WIP),
There are Costs allocated to the Quoted Job that do not belong to the Job,
There is a Progress Claim you have overlooked Invoicing,
Staff are taking more hours to do the Job than were allowed in the Quote
Materials being purchased are not those, or are costing more than those allowed in the Quote
Estimated Jobs:
With an Estimate Job, although created using Katipolt's Quotes feature, it is Invoiced as a Charge Up Job, so the Profit & Loss Summary Line displays as a Charge Up Job.
Estimated Job's Summary Line displays:
Actual Hours,
Actual Costs (Timesheets, Purchases, Site/Ad-Hoc Costs entries),
Actual Sell,
Actual Profit, and
Actual Margin
💡 TIP: The Profit & Loss Summary Report List can be exported as CSV or Excel file.
