Cash Flow Projection

Cash Flow Project is a new feature integrated with Estimate 2.0 - this guide is intended to give you a quick run down of the functions and give you a HOW TO.

In examples below, we will use a project that ONLY have Mechanical and Electrical scope to demonstrate the functions. The demonstration will focus on how to use the software instead of how the project should be projecting cash flow.

Generate Cash Flow Initialization Sheet:

Change line item name and line total

For a project on going, and you are asked to switch to this Cost Projection tool, you can use template provided and change the line item name and total to suite your project.

Change name and total cost

Generate Cashflow Initialization Sheet.

When Estimate was completed, budgets will get uploaded from Estimate 2.0 to Viewpoint through a sheet called Consolidation. Once Consolidation is completed, you can go to the Cash Flow Functions located under Budget/CashFlow Ribbon Tab to access cashflow functions. Click on "CashFlow" Button to generate the cash flow initialization sheet.

Generate CashFlow Initialization Sheet

Populate Cashflow monthly

Manually Changing Cashflow by Month.

With this sheet, you can manually change amount assigned to each month. Once amount entered, you will see the Remaining field of this line item changed, which shows either a + (under) or - (over). The final goal is to have the remaining field be 0.

Manually adding monthly billing

Auto Populate the monthly billing by changing settings.

With this sheet, you can change setting items such as "Front Load", "Back Load", "From Date" and "To Date" to auto populate the monthly billing. The durations between two dates calculated is based on WORKING DAYS, which is calendar days excluding weekends, and Canadian Holidays.

CashFlow_Initialization_ChangeDates

While changing Front Load and Back Load, the monthly will also update to reflect this change. this will reset the remaining to 0. if on Monthly amount you see negative (-) numbers, it means the end loads are over the total budget. It worth noting that the front load and back load at initialization works slightly different than when tracking actuals.

CashFlow_Initialization_UseSettingtoPopulate

Add additional month

When dates entered is not valid, or pass beyond the last column, the software will prompt for adding more columns.

When Date is invalid or needs more columns

You can do so by clicking on the "Add Month" Button.

Add month

Show or Hide Line Items

You can hide selected lines by how you typically do in Excel. I recommend use the checkboxes to keep the Format Consistent.

Show or hide items