A monthly status report can allow for the succinct summary of actions taken in the month in relation to a specific project, team, department, or program to relevant stakeholders. Such practice can be a powerful tool to manage goals, expectations, and ensure desirable outcomes. To facilitate reporting in a standardized fashion, GPetrium has designed a free monthly status report template on excel to drive organizational success.
GPetrium’s Monthly Status Report Template (Monthly Status Template) is a free excel tool that facilitates the creation of a progress report. It is designed to track organizational, departmental, or project progress to ensure clear communication between stakeholders that may range from managers, coordinator, teams, sponsors and executives. The printable report is meant to provide a one-pager high-level view update for quick reporting and feedback. The backend database can be used to get in a little more detail or to write key points that may not fit into the report. Before implementing such tool/process, it is important to consider current organizational needs, processes, culture, goals and technology used.
The tool is divided into 3 key segments, the ‘Report’, ‘Database’ and ‘Config’. The information written in the database helps to populate the report. In the future, GPetrium will release a premium version of the tool which features a dashboard to support a historical visual understanding of your Monthly status reports.
The report is segmented into 5 differing parts: Health Card, Last Month’s Accomplishments, Plans for the Month, Risk Monitoring and Control, and Notes.
Below are some information on each column and circled item depicted in the image above:
Trending: A (often subjective) confidence level of where the item will move towards in the upcoming month in relation to expected timeline. This is auto-populated based on the ID input in the ‘Database’ tab.
6. Resources: Name of external link to supporting documentation. This is auto-populated based on the ID.
7. Mitigation: Type of mitigation used in relation to the item row. This is auto-populated based on the ID.
Action: The action that needs to be done in relation to the risk monitoring and control item.
For an easy print shortcut, press CTRL+P. Otherwise, go to File > Print. Once in the print pane, follow these settings: “print active sheet, collated, landscape orientation, letter, normal margins, and no scaling (as stipulated in the picture below).
The information seen in the ‘Report’ tab is populated through the ‘Database’ tab. There are currently 11 columns that can be populated into the ‘Database’ table. Below we will look at each column:
This section helps to configure the drop-down list for [Mitigation], [Status], [Trending] and [Type]. If you would like to decrease or increase the number of options in the config tab, you will need to change the Data Validation for that column, please refer to the Q&A for more information on how to modify such columns.
A good Monthly Status Report can be a part of the solution to drive increased organizational productivity, clarity and visibility. The Monthly Status report in excel provides a baseline for clients of all sizes to move in the right direction towards maintaining better data control, improved processes, automating tasks and facilitating Monthly report creation. For those interested in the Weekly Status Report, please refer to this link. For more information on tool’s that can help managers navigate through their daily activities successfully, visit “Toolkit for a Successful Manager”.
Q: I tried to add a new drop-down item to [Status], [Trending], and [Mitigation] in the Config tab, unfortunately, it does not appear on the ’Database’ tab.
A: The drop-down system is based on the ‘Data Validation’ excel feature, it restricts the entries based on a subset of cells that have been chosen. To recalibrate, you will need to choose all cells in that respective column then on the access toolbar go to ‘Data->Data Validation->Settings’ and change the Source to cover all the items you expect to have on the drop-down.
Q: My Accomplish/ Progression/ Plans/ Risk/ Notes are not visually appealing or are being cut-off and I think the culprit is the length of the sentence. What can I do?
A: The tools is meant to be short and concise to facilitate end-user reading and creation of report. If there is a need to write more, GPetrium encourages users to use the Notes column to provide further context or use the comments column in the ‘Database’.