MS Excel, tracking project month, weekly financials incl. contracted work, forecasts, actuals, variance, expenses, pivot

Overview

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. Purchase also includes other budget tracker examples.

Benefits

1. Offers tight control, monitoring, and reporting of project finances for stakeholder updates on budget used and forecast.

2. Provides multiple charts that can be incorporated into status reports and senior management reports for the project cost status.

3. Incorporates all the typical project actual and forecast items and saves time from having to construct project finance trackers from scratch.

Tab 1: Main finance tracker scrollable by month, including 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 months is included on the far right of the spreadsheet for all the headings above.

Tab 2: Finance summary tab containing a graphical view by way of charts of all details in Tab 1 above for reporting purposes.

Tab 3: Larger finance dashboard of charts to summarize project forecasts and costs in various ways for different reporting requests by stakeholders.

Tab 4/5: Spreadsheet pivots of the information in Tab 1.

Tab 6: Comprehensive annual leave / sickness worksheet by resource, viewable in summary in Tab 1 by resource.

Tab 7: Any supplier costs.

Tab 8/9/10: Rate card changes across the financial calendar.

About the Author

A Senior Project Manager with 31 years of experience in delivering projects, a PRINCE2 Practitioner, and experienced in Agile SDLCs.

This Best Practice Includes

Several comprehensive MS Excel spreadsheets for tracking project budgets.

Objectives

1. Offers tight control, monitoring, and reporting of project finances for stakeholder updates on budget used and forecast.

2. Provides multiple charts that can be incorporated into status reports and senior management reports for the project cost status.

3. Incorporates all the typical project actual and forecast items and saves time from having to construct project finance trackers from scratch.

Use It If

Those looking for tight and comprehensive project budget tracking or estimating project bids.

Don’t Use It If

Requires an understanding of MS Excel.