BUY WITH CONFIDENCE
BENEFITS OF DOCUMENT
DESCRIPTION
A comprehensive editable, table MS Excel spreadsheet for tracking project monthly financials including summary view tab, contracted work, forecasts, actuals, variance, expenses, annual leave, suppliers and pivot tab.
Tab 1: Contains the main finance tracker scrollable by month and includes; resource summary, grade and role on project, expenses incurred, annual leave, sickness, original bid days (from SoW), forecast days, actual days worked, hours, variance, actual internal cost, forecast revenue, actual revenue and revenue variance. The sum total of all the months is also included on the far right of the spreadsheet for all the headings above.
Tab 2: The finance summary tab contains a graphical view by way of charts of all details in Tab 1 above for reporting purposes.
Tab 3: A larger finance dashboard of charts to summarize the project forecasts and costs in various different ways for different reporting requests by stakeholders.
Tab 4/5: Spreadsheet pivots of the information in tab 1.
Tab 6: A comprehensive annual leave / sickness worksheet by resource which is viewable in summary in tab 1 by resource.
Tab7: Any supplier costs.
Tab 8/9/10: Rate card changes across the financial calendar.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Project Planning Workbook, Project Management Excel: Project Finance Tracker Including Forecasts & Actuals Excel (XLSM) Spreadsheet, i_Pro_PM_Templates
OVERVIEW
(XLSM)
ABOUT THE AUTHOR
i_Pro_PM_Templates is an Flevy seller and an experienced Senior Project Manager, who has been working at ascending points in software development lifecycle projects for over 30 years.
The Flevy seller has impressive credentials in the delivery of highly complex projects in challenging conditions.
[read more]
Ask the Author a Question
This document is available as part of the following discounted bundle(s):
Save %!
FREE upgrades, PRINCE2 & Agile Project Management Templates
This bundle contains 10 total documents. See the additional documents to the right.
Project Management Project Planning Workbook PRINCE2 Gantt Chart Templates Agile Consulting Project Management
![]() |
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |