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


The E&IG 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 which projects are in Development Phase, and which are in Delivery. This allows us to separate them out on the Monthly Review excel sheet to match the formatting.


Note:


1. Typically for Defence, Development and Delivery phases are set up as separate projects on Mastt and are not combined.


2. If you're downloading it for a Project, the Monthly Review excel will populate with cash flow just for that project. 


3. If your project has Development and Delivery Phase projects separate in Mastt, you'll need to go to the 'My Programs' aggregated view to download the excel so that we have all the Development and Delivery data.



Step 4: You'll need to give it a second, but the excel sheet will download (Voila!). Note we changed pink to green and maroon text to dark blue :)



Step 5 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.