Cash Forecast Report

The Cash Forecast report helps your team understand when open receivables are likely to turn into cash. It gives you a forward-looking view of expected payments so you can better plan for upcoming cash flow, spot gaps early, and focus follow-up where it matters most.

Use this report to review predicted payment timing across projects, monitor overdue expected payments, and keep your team aligned on what cash is expected in the coming weeks.

The Cash Forecast report gives you an aggregate view of predicted payments across the projects you have access to. It combines expected payment dates from open pay apps into a weekly cash forecast so you can see what cash is expected to come in over the next three months.

At a glance, this report helps you see:

Go to Reporting and select Cash Forecast. From there, you can view the overall cash forecast for all projects you have access to.

You can also export the cash forecast for a single project from the project home page by clicking the three dots next to Add new pay app and selecting Export cash flow forecast.

Access to the Cash Forecast report depends on your permissions in Siteline. Users will only see the projects they have access to in Reporting.

To populate the cash forecast, you need to add a predicted payment date to your pay apps.

To do this:

Siteline suggests predicted payment dates based on the best information available at the time. If you hover over the suggestion, Siteline explains how that date was selected. You can choose the suggested date or manually select a different one, and you can update it at any time.

In the Cash Forecast tab, you can review the overall cash forecast for all of your accessible projects. The graph and table show the next three months of predicted payments.

The Open invoice amount in the top-right corner shows the sum of all unpaid pay apps, not just the invoices currently visible on the screen.

You can also quickly add suggested payment dates to all open pay apps with the click of a button.

If you scroll all the way to the right of the cash forecast table, you will see an Unknown column. This column includes all open invoices that do not have a predicted payment date attached to them.

In the Excel export, invoices with missing predicted payment dates also appear in the Unknown column.

If you click on a project name in the Cash Forecast table, Siteline opens a drill-down modal with more information about the project’s outstanding invoices. From there, you can click into individual pay apps to open them directly.

You can also leave notes within the cash forecast table by hovering over a project name and clicking the comment icon. Once a comment has been added, the icon remains visible.

If the expected payment date for a pay app has passed and payment still has not been received, Siteline adds a calendar label to the project name in the Cash Forecast view. It also adds a label directly on the pay app.

Use this to quickly spot invoices that were expected to pay by now but still need follow-up.

If you use the Vendor module to send lien waiver requests with the joint check option enabled, Siteline labels the project with Joint check in the Cash Forecast tab.

If you request conditional lien waivers and the amount owed to vendors on that project exceeds the invoice amount outstanding from the GC, Siteline flags that in the report.

The Cash Forecast report helps answer questions like:

Here are a few ways to get more value from the Cash Forecast report:

Start with the graph and table to understand what cash is expected to come in over the next three months. This gives you a quick view of upcoming inflows and potential gaps.

Check the Unknown column to identify open invoices that still need a predicted payment date. Filling those gaps makes the forecast more complete and more useful.

Review invoices with passed expected payment dates to identify where follow-up may be needed. These are strong signals that payment timing is slipping.

Click into a project name to review the outstanding invoices behind the forecast and understand what is driving the projected cash timing.

The Cash Forecast report is only as accurate as the predicted payment dates behind it. Review and update dates regularly so the forecast stays useful for planning and collections.

To export the aggregate cash forecast, click the Export button in the top-right corner of the Cash Forecast tab in Reporting. The export includes all weeks for which there is a predicted payment date.

If you export the forecast to Excel, the file includes every unpaid invoice, regardless of date. Invoices without a predicted payment date appear in the Unknown column.

The Cash Forecast report works well alongside other Siteline reports: