Cash Flow Overview

Table of Contents

1. What's new in Cash Flow?
2. How to Access Cash Flow
3. Cash Flow Settings
4. Choosing Dates
5. Making changes to Cash Flow
   1. Contract and Forecast Cash Flow Entry
   2. Budget Cash Flow Entry
6. Closing and Re-Opening Months
7. Time Machine
8. Pinning and Sorting Columns
9. Reporting and Exporting Cash Flow

What's new in Cash Flow?

• A new budget-level cash flow form, allowing you to paste rows directly from Excel
• You can toggle between forecasted and paid cash flows by opening and closing the month
• A new, customisable report built on our brand-new dashboard module

---

How to Access Cash Flow

Step 1: Select the 'Hamburger Menu' on the left-hand side and navigate to the 'Cost' module

Step 2: Click on 'Cash Flow'

Cash Flow Settings

Click on the Gear icon on the top right-hand corner to customise the Cash Flow page:

Within the Cash Flow settings, you can:

• Turn on or off the Cash Flow Chart or Cash Flow Table
• Turn on or off Budget Cash Flow Entry

• Choose if you would like the Target and Baseline figures to be shown as a Line or Bar chart, or if you would like to turn them off
• Turn on or off the Cumulative Overlay
• Turn on or off showing Schedule Milestones on the cash flow chart

Choosing dates

To change the time period you see, click on the 'Range' button to open the date picker.

You have multiple range options:

• Monthly will allow you to choose the range of months you would like to see, with preset ranges to help you get to your chosen period quickly.
  • Today will show a 6 month period based around the current month
  • Calendar Year will show the current year
  • Prev FY will show the previous Financial Year, Current FY will show the current Financial Year, and Next FY will show the next Financial Year
  • All Data will show the full range of the project, from the first cash flow or payment to the final cash flow or payment within Mastt
• Yearly will show you the yearly cash flow
  
  • From Month allows you to set the first month you would like to see. Mastt will then use that as the starting month for each year (e.g. July '19 to June '20, July '20 to June '21, etc.)
  • Years to show allows you to set the number of years you would like to see. You can choose up to 15 years from the starting month
  • All Data will show the full range of the project, from the first cash flow or payment to the final cash flow or payment within Mastt

Making changes to Cash Flow

Contract and Forecast Cash Flow Entry

Click on the ellipses in the Action Column next to the Contract or Forecast to bring up the Cash Flow Form:

Once you have finished entering cash flow, click on the Confirm button in the bottom right-hand corner. Otherwise, click Not Now or the X to return to the Cash Flow page.

Budget Cash Flow Entry

Click on the ellipses in the Action Column next to the Contract or Forecast to bring up the Cash Flow Form:

Once you have finished entering cash flow, click on the Confirm button in the bottom right-hand corner. Otherwise, click Not Now or the X to return to the Cash Flow page.

Closing and Re-Opening Months

Closing a month will prevent any payments from being made against that month. It will also hide the current cash flow estimate, and will instead show only payments that have a 'paid' status. Re-opening a month will show the forecasted cash flow, and unlock the editing of payment and forecast data for that month.

To close a month, hover your cursor over the month you would like to close and click Close-off. This will change the month column to green, and add a lock symbol next to the month name to show it has been closed.

To re-open a month, hover your cursor over the month and click Re-open. Only an Admin can re-open a closed month.

Time Machine

Time Machine allows you to see the cash flow values at an earlier date. If a mistake has been made, you can easily see what the values were before the mistake using Time Machine.

After clicking Time Machine, you can select the date you want to see - only dates with saved data will be selectable. Click Confirm, and Mastt will open the earlier cash flow in a new tab.

Pinning, Sorting, Filtering and Showing Columns

You can easily customise the order of columns (that aren't the monthly or yearly cash flow columns), and even hide those you don't want to see. Just hover your cursor over the header row of any non-cash flow column and click the traffic light button to bring up the different options: 

• Sort by ASC and Sort by DESC allow you to sort the Title or Unassigned columns. You can also click the Arrow button in those columns.
• Filter allows you to filter the Title, Depth or ID columns using rules.
• Pin to Left and Pin to Right allow you to choose which Columns will always be visible when scrolling horizontally and which side of the screen they will be on.
• Unpin allows you to have columns scroll off the page when you are scrolling horizontally

 

Reporting and Exporting Cash Flow

You can easily Report and Export your cash flow using Mastt's in-built tools. If you click  Create Report, it will create a Cash Flow Report on our powerful Dashboard tool and open it in a new tab. This report is fully customisable and exportable to a PDF, and you can easily add additional tiles to build a report that meets your needs. 

 You can easily export your Cash Flow to a CSV file by clicking Export Current View or Export All Rows:

Export Current View will export only what you have filtered or unravelled in cash flow, and Export All Rows will export everything in cash flow. Both export options will respect the range you have selected.