Note: This feature is only available for Estate & Infrastructure Group projects.


The Monthly Review excel is available for all projects and programs via the Cost Module's Cash Flow page. 


Step 1: Go to the Cash Flow page.



Step 2: Click 'Defence Excel' on any financial year.



Step 3: A form will open asking you to select the budgets you would like to export whether they are in Development Phase, or in Delivery Phase. This allows us to separate them out on the Monthly Review excel sheet to match the formatting.


Note:


1. Typically for a Defence Project, both Development and Delivery Phases are set up as two separate budgets on Mastt with your sub-budgets nested underneath. These sub-budgets consist of your contracts nested within too. 


2. When selecting just 'Development' or 'Delivery' - this will show all Contracts, Forecasts nested within. 



3. When clicking 'toggle' on: this will show the budgets you have selected as individual rows in the Defence Excel sheet, rather than showing contracts individually in their own itemised rows



You also have the ability to individually select sub-budgets:


Result:


_


For Managing Contractor projects: For Managing Contractor projects, all of the subcontracts are also handled in Mastt. Defence require a single row summarizing all reimbursable cash flow. To do this, all Subcontractor contracts will need to be typed as 'Reimbursable' which will summarize all Reimbursable type Contracts into one line automatically. This can be done by Editing the contracts to update the type, see this article here.