Cash Flow Overview

Group 1650 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. Pinning and Sorting Columns
  8. Reporting and Exporting Cash Flow
  9. Time Machine


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

If you cash flow a Budget, it will disable entering cash flow for ANY sub-budgets, contracts, or forecasts within that budget. You need to remove all budget cash flow values if you would like to enter contract, forecast, or sub-budget cash flows. 

You can easily see budget cash flows by the orange line beside the budget:

  • 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
  • Adjust your data display by configuring the decimal places and denomination to suit your preferences.

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

You can paste rows from Excel in the Cash Flow forms, speeding up cash flow entry. Why don't you give it a try? 

Contract and Forecast Cash Flow Entry

Click on the three dots menu 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

Make sure Budget Cash Flow Entry is turned on in Cash Flow Settings (see above)

Click on the three dots menu 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.

Unless you are planning on cash-flowing your Project at a Budget level, we recommend turning Budget Cash Flow Entry OFF. If Budget cash flow is saved, it will overwrite ANY Contract or Forecast cash flow within that Budget. 

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.

If a month is open but you have made payments against that month, there will be a green progress bar that will show you your payment progress against what you forecasted. You can hover over the progress bar and see how much you have paid so far:

 

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 learn more about our powerful Dashboard tool here

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

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

 

 

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.

If you would like to access the Time Machine feature to view past cash flow values, please let us know by submitting a ticket. This tool allows you to easily track and analyse previous cash flow data for better insights and decision-making.