Sales Report
Our Sales report examines leads sold that have been converted into a contract, this does not include the contracts within ‘Sales to Confirm as these have not yet reached ‘Contracts to set up’. The report is driven by the Contract date and looks at the Sold value, not the Contract value. You can report on this between two dates, defaulting to the current month.
Banking Report
This report looks at Payments allocated against invoices based on payment type and the date on which the payment was made.
Balance Outstanding Report
This report looks at the invoices raised within Business Pilot, based on the invoice type selection chosen before running such report, compared to the total balance of invoices raised on the date range selected by the user. You can report on this between two dates. The date selection on the reports page defaults to the current month and includes the Finance Note. You can also choose whether you would like to see the customers latest notes or all notes. In addition, you’ll be able to select the invoice type(s) you would like to focus on, e.g. All, Deposit, Interim and Final Balances or Chargeable Service invoices. You will still be able to see the overall total balance attributed to that contract within the report itself, even if it is not a part of the invoice selection.
Aged Debtors Report
This report looks at a selection of outstanding invoices (same criteria as our Balance Outstanding Report), broken down by the age of the debt eg. 30, 60, 90 days. Our Aged Debtors report looks at both the Contract value and Invoice value.
Orders On Hand Report
This report looks at the overall contract values of your live contracts minus any raised invoices, i.e. the balance left to invoice on those contracts.
Please note: this won’t take into account any separate line credits that could offset an unraised invoice.
Sales Invoice Report
This report looks at the invoices raised based on a date selection made when the report is run.
Fitting Schedule Report
This report is nice and simple; it displays your fitting schedule and looks at the full contract value of the jobs scheduled within the period selected. This can be filtered by individual Contract Type or All.
Financial Fitting Schedule Report
This report breaks the Fitting Schedule Report down further. It breaks down the jobs scheduled within the period selected per team and per week on a pro-rata basis to the contract value. This report is what drives the figure in the MI Ops Dashboard. It’ll let you know how much value that is still due to be scheduled. The great thing about this report is if you set a target for your teams to bring in circa £20,000 a week as a goal, you can see whether they’re on track. If the installation exceeds the time allocated, then the amount per day will reduce in accordance with the contract value.
Job Cost Report (Contract Completion Date)
This report looks at the project margin on all contracts marked as complete over a set period of time.
Job Cost Report (Revenue Recognition Date)
This report looks at the project margin on all contracts marked with a revenue recognition date over a set period of time. Great for phased works or installations that require snagging visits!
Deferred Income Report
This looks at contracts with invoices raised but with no associated costs.
WIP Report (Work in Progress)
This looks at live contracts that have costs against them based on the report date.
Completed Contract Report
This report looks at the contracts marked as complete but is ultimately driven by the revenue recognition date. You can either set a revenue recognition date inside the Finance tab of the Contract or, if this is not populated, it will automatically be driven and dated through the marking as complete status.
From all of us here at Business Pilot, we hope this explanation sheet helped! If you have any additional questions please send these to support@businesspilot.co.uk. Thank you for reading.
