P & L Reports

The Profit & Losses Report provides functionality to view the Profits & Losses at a Site level, including the Profits & Losses for Materials, Labour, Consumables, and Variations on the Site. The P&L Report provides two different views, displaying either a multiple Site Summary when multiple Sites are selected, or a detailed single Site breakdown when only one Site is selected, as described below.

The user can generate a P&L Report by selecting the P & L Reports button located above the left-hand side of the Sites table. The system then displays the P&L Report Site Selection popup.

The popup contains a Filter field which the user can type into, filtering the table by Site Name so the relevant Site or Sites can be located.

The popup contains a Start Date and End Date field, which determine the period in which Sales Prices and Costs are calculated.

The P&L Report displays the Sales Prices from Applications raised within the selected period, along with the Material and Labour Costs incurred within the same period from Purchase Orders and Work Submissions. If no dates are entered, the report displays Costs to date.

Singular Site Breakdown

Each Site within the P & L Reports popup has a checkbox within the Include? column. If only one Site is selected when the report is downloaded, the system extracts the Singular Site Breakdown, which provides a detailed breakdown of the Profits & Losses for the selected Site.

To download the Singular Site Breakdown, the user can select the desired Site and then select the Download Report button located in the bottom-right corner of the popup.

The Singular Site Breakdown P&L Report is an Excel spreadsheet and contains five different tabs, each displaying key information relating to the selected Site, as described below.

Site

The Site tab is initially displayed when the report is opened and acts as a Summary for the Site. Each section within this tab displays key information relating to the Site and its Profits & Losses data.

At the top of the page there is some necessary information such as:

• Client – Displays the associated Client that the Site relates to for which the report has been generated.
• Site Code – Displays the Site Code associated with the Site for which the report has been generated.
• Site Name – Displays the Site Name associated with the Site for which the report has been generated.

Below this is the Site Summary, which lists the Revenue, Costs, and Gross Profits for each Plot, including breakdowns for Consumables, Variations, Sales Extras, and Contra Charges.

• Plot – Lists the non-deleted Plots on the selected Site, displayed by their Plot Numbers.
• House Type – Displays the House Type associated with the Plot.
• Revenue – Displays the Revenue amount, which is the total claimed amount within the Application. For Plot Revenue, this is the amount claimed against the Plot within the Application Build Stages section. For Variations Revenue, this is the amount claimed against the Variations within the Application Variations section. For Sales Extras, this is the amount claimed against the Sales Extra within the Application Sales Extras section. For Contra Charges, this is the amount claimed against the Contra Charge(s) within the Application Contra Charges section.
• Materials – Displays the Cost of Materials that have been Approved and Sent within a Purchase Order.
• Materials % – Displays the Material percentage, calculated by dividing the Material Cost by the Revenue.
• Labour – Displays the Labour Cost for Labour Items that have been Accepted within a Work Submission.
• Labour % – Displays the Labour percentage, calculated by dividing the Labour Cost by the Revenue.
• Gross Profit – Displays the Gross Profit, calculated by subtracting the Material and Labour Costs from the Revenue.
• Gross Profit % – Displays the Gross Profit percentage, calculated by dividing the Gross Profit by the Revenue.
• Consumables – Displays the Consumables Cost for the Site, calculated using Consumables Orders that have been Approved and Sent.
• Variations Total – Displays the combined total of the Variations Chargeable and Variations Non-Chargeable figures.
• Variations Chargeable – Displays data from Variations marked as Builder Variations.
• Variations Non-Chargeable – Displays data from Variations not marked as Builder Variations.
• Sales Extras – Displays the value of Sales Extras claimed within the Application Sales Extras section.
• Contra Charges – Displays a negative figure representing internal deductions, based on Contra Charges claimed within the Application Contra Charges section.

Materials

The Materials tab displays the Purchase Orders and Credit Orders that have been Approved and Sent for the selected Site against Plot Build Stages. Each column within the table is described as below.

• PO Number – This displays the PO Number for the Purchase or Credit Order, which is generated once they have been Approved and Sent.
• Supplier – Displays the Supplier associated with the Purchase or Credit Order, selected within the Purchase Order Details or Credit Order Details page.
• Plot – Displays the Plot associated with the Purchase or Credit Order, selected within the Purchase Order Details or Credit Order Details page.
• Record – Displays the Record associated with the Purchase or Credit Order, selected within the Purchase Order Details or Credit Order Details page.
• Sent Date – Displays the Sent Date for the Purchase or Credit Order, which is the date it was Approved and Sent.
• Delivery Requested For – Displays the Delivery Requested For date associated with the Purchase or Credit Order, selected within the Purchase Order Details or Credit Order Details page.
• Delivery Date – Displays the date the Purchase Order or Credit Order was marked as Delivered, based on the Delivered checkbox within the Purchase Order Details or Credit Order Details page.
• Cost – Displays the total Cost for the Purchase or Credit Order, representing the cost of the Materials included. Credit Order Costs are displayed as a negative red figure.

Labour

The Labour tab displays any Accepted Work Submissions for the selected Site against Plot Build Stages. Each column displays key information relating to the submissions, as described below.

• Number – Displays the Work Submission Number associated with the Work Submission.
• Operative – Displays the Operative who submitted the Work Submission.
• Plot – Displays the Plot associated with the Work Submission, selected when the Work Submission is created.
• Record – Displays the Record associated with the Work Submission, selected when the Work Submission is created.
• Submission Date – Displays the date the Work Submission was submitted by the Operative.
• Cost – Displays the Cost of the Work Submission, which is the combined total of the Labour Items included.
• Cost with Uplift – Displays the Cost with Uplift for the Work Submission, which is the combined total of the Labour Items included with the Labour Item Uplift applied, as configured in the Settings Details page.

Consumables

The Consumables tab displays the Consumables Orders that have been Approved and Sent for the selected Site against. Each column within the table is described as below.

• Number – This displays the Number for the Consumables Orders, which is generated once they have been Approved and Sent.
• Sent Date – Displays the Sent Date for the Consumables Order, which is the date it was Approved and Sent.
• Requested For – Displays the Delivery Requested For date associated with the Consumables Order, selected within the Consumables Order Details page.
• Delivered Date – Displays the date the Consumables Order was marked as Delivered, based on the Delivered checkbox within the Consumables Order Details page.
• Cost – Displays the total Cost for the Consumables Order, representing the cost of the Consumable Items included.

Variations

The Variations tab displays the Variations for the selected Site that have been Client Approved. Each column presents key information about the Variations as described below.

• Reference – Displays the Variation Reference for each Variation.
• Name – Displays the Name for the Variation, which is entered on the Variation Details page.
• Operative – Displays the Operative that is assigned to the Variation, which is derived from the Operative dropdown in the Variation Details page.
• Created Date – Displays the Created Date for the Variation(s).
• Plot – Displays the Plot associated with the Variations, which is derived from the Plot dropdown within the Variation Details page.
• Builder – Displays a checkbox for each Variation, where the status of this checkbox is determined by the Builder Variation checkbox in the Variation Details page.
• Description of Works – Displays the Description for the Variations, as derived from the Description field in the Variation Details page.
• Status – Displays the Status for the Variation, which will only be Approved as this view only includes Client Approved Variations.
• Rate – Displays the Rate for the Variations, which represents the amount of the Variation that has been claimed in the Application Variations section.
• Cost – Displays the Cost for the Variations, which is the combined Material Costs and Labour Costs.
• Material Costs – Displays the Material Costs, which is the Cost of Materials that have been Approved & Sent within a Purchase Order for that Variation.
• Labour Costs – Displays the Labour Costs, which is the Cost of Labour that has been Accepted within a Work Submission for that Variation.
• Material Deductions – Displays Material Deductions for the Variation, where the full deductible amount is applied when a Purchase Order is created and Approved & Sent for that Variation.
• Labour Deductions – Displays Labour Deductions for the Variation, where the full deductible amount is applied when a Work Submission is created and Accepted for that Variation.
• Total – Displays the Total for the Variation, calculated by deducting Material Deductions and Labour Deductions from the Cost.

The Purchase Orders shown in the report are based on the selected date range. The report filters Purchase Orders using the Requested For date, meaning only those with a Requested For date that falls within the selected range are included.

The Work Submissions shown in the report is based on the selected date range and is filtered using the Submitted Date. Only Work Submission entries with a Submitted Date that falls within the selected range are included in the report.

The Consumables Orders shown in the report are based on the selected date range and are filtered using the Requested For date. Only Consumables Orders with a Requested For date that falls within the selected range are included in the report.

Multiple Site Summary

To download the Multiple Site Breakdown, the user can select the desired Sites and then select the Download Report button located in the bottom-right corner of the popup.

The Multiple Sites Breakdown P&L Report is an Excel spreadsheet and contains one single tab, displaying key information relating to the selected Sites, as described below.

• Builder / Client – Displays the name of the Client to which this Site belongs.
• Site Code – Displays the Site Code for the Site, which can be set on the Site Details page.
• Site Name – Displays the Site Name for the Site, which can be set on the Site Details page.
• Gross Valuation – Displays the total of all Claimed Amounts for all Sales Applications on the Site that fall within the selected Date Range.
• Materials – Displays the total of all Purchase Orders on the Site that have been Approved & Sent and fall within the selected Date Range. This figure also takes Credit Orders into account, removing their total from the final figure.
• Materials % – Displays the Material percentage, calculated by dividing the Material Cost by the Gross Valuation.
• Labour Items – Displays the total of all Work Submissions on the Site that have been Accepted and fall within the selected Date Range.
• Labour Items % – Displays the Labour Item percentage, calculated by dividing the Labour Items Cost by the Gross Valuation.
• Consumables – Displays the total of all Consumables Build Stage Amounts on the Site, as set on the Site Financials page.
• Consumables % – Displays the Consumables percentage, calculated by dividing the Consumables Cost by the Gross Valuation.
• Gross Profit – Displays the Gross Profit for the Site for the selected date range, calculated by taking the Materials Cost & Labour Items Cost from the Gross Valuation.
• Gross Profit % – Displays the Gross Profit percentage, calculated by dividing the Gross Profit by the Gross Valuation.