Branch Reporting - Financial - Cost to Complete

Accessing the Reporting Module

To begin:

1. Click on ‘Reporting’ at the top-right of your Rave screen.

2. Depending on your permission level, you will see tabs for:

   • Company

   • Branch

   • Salesperson

For this guide, we are focusing on the Branch tab.

Navigating to FINANCIAL Reports

1. In the Reporting Module, click on the Financial tab (left-hand side).

2. You will now see a list of available Financial reports.

3. The Cost to Complete report is the one you need for this guide 

Purpose of the Report
This report provides a “Current Position for each project” — showing real-time financial performance and whether the project is in a profit or loss position.

Report Structure and Calculation Breakdown

1. Total Project Value (Client Total)

   • Includes the base quote, variations, and markup.

   • This is the total expected income from the client.

2. Invoiced to Date

   • Total amount already invoiced to the client.

3. Uninvoiced Total (Balance to be Invoiced)

   • Calculated as:
     Total Project Value – Invoiced to Date

   • Can be negative if more has been invoiced than the total project value.

4. Quote Total (Approved Budget)

   • The internal approved budget for delivering the project.

   • Does not include markup as this is the Raw cost.

5. Billed Total

   • Reflects the amount billed by your suppliers/contractors.

6. Cost to Complete Total

   • Represents the estimated remaining cost to finish the project.

   • Overspends already incurred are excluded.

   • This value reflects the money still needed to complete the work.

7. Current Position (Profit or Loss)

   • Calculated as:
     Total Project Value – (Cost to Date + Cost to Complete)

   • Indicates if the project is tracking toward a surplus or deficit.

Special Case: Over-Invoicing
If more has been invoiced than the total project value:

• The Current Position will show a positive balance, indicating you're ahead.

• The Uninvoiced Total will appear as a negative, as the invoiced amount exceeds the agreed project value.

Example

Tip: Due to its width, this report is often easier to review when downloaded as a CSV and opened in a spreadsheet tool like Excel or Google Sheets.