RAVE's Progress Payment Forecast Report

Select Financial from the top right hand navigation screen

Then Select Progress Payment Report

This will display the Progress Payment List page. The article for this tab is here.

Click on Progress Payment Forecast for this article.

Maintaining a healthy cash flow is critical for the success of any construction company. 

Progress payments play a key role in this, allowing companies to recover a portion of their costs as a project moves forward. These payments not only support steady cash flow but also serve as a safeguard against potential client nonpayment.

RAVE’s Progress Payment Forecast Report offers a clear snapshot of your current and upcoming financial position. It provides visibility into:

• Expected payments

• Paid payments

• Pending requests

• Requested payments

• Overdue payments

• Outstanding balances

This insight helps you stay on top of your finances and better manage your cash flow.

Setting Up a Forecast Report in RAVE

RAVE’s Progress Payment Forecast Report gives you flexibility in how you view and analyse your project payment data.

Choose a Reporting Date Range

You can filter the report using a wide range of preset date ranges via the Show Only dropdown (located at the top left of the page).

Alternatively, create a custom date range by manually editing the ‘From’ and ‘To’ date fields to suit your reporting needs.

Include or Exclude GST

By default, the report is set to Include GST, as this aligns with how figures are displayed on the Progress Payment page—both for your internal view and for clients, should you choose to share the report with them.

However, you can exclude GST from the report totals by simply unchecking the ‘Including GST’ checkbox.

Progress Payment Snapshot/Summary Table
The first (top) table in the progress payment forecast gives you a snapshot of all of your active jobs, providing a total figure for the date range period, and an explanation of what that figure is made up from:

• Expected - The total value of all progress payments linked to a task in your schedules

• Paid - The total of all payments made (received) on those progress payments

• Pending - The total of all payments yet to be invoiced/requested (sent to the client)

• Requested - The total of all payments which have been invoiced, are not yet paid, and are not yet overdue

• Overdue - The total of all invoices where the due date has passed and they remain unpaid

• Outstanding - The total of all progress payments which have not yet been invoiced, and the scheduled dates have passed

Progress Payment Forecast - Project Overview 
The second (middle) table is the same information but is separated out per project.  Looking down this table, you’ll see the project name/job number, contract value, project manager, signed contract value, and again the expected, paid, pending, requested overdue and outstanding amounts.  

You can also export this report to a csv file via the Export button.

Progress Payment Forecast

The third (bottom) table shows all expected progress payment amounts that are linked to a task in a schedule - creating a forecast of when these payments are due. 

These are all visible per job and show month by month when each staged progress payment is due. There may be multiple payments due in one month for the same project that are at different levels of completion - these are noted as the figures in brackets. 

To display these, just click on the bracket number. It will show you the specific information for those payments and highlight the status each are in.
Note: We always Prioritise the Outstanding or Overdue ones as those are where income is expected and hasn't been realised as yet. 

You can Hide Lost/Closed Projects and Exclude already paid invoices with the toggles to the top left of this table.