Hey there project managers!
Sick of trying to keep track of the expenses in your project and remembering EXACTLY what needs to be paid when? This is always even more complicated when a project is being funded from a range of diferent cost centres or funders.
Here is your solution!
This sheet is an project management costs dashboard is an EXCEL Download that will help you to easily record and update ll your PROJECT EXPENSES whilst creating a data set that can be interrogated by the summary sheet for reporting purposes. It’s aim is to reduce the reliance on manual tasks, and enable a clear an concise reporting vehicle that requires very little maintenance.
1. See all your PROJECT EXPENSES IN ONE PLACE & track them by month
2. View everything by date, Qtr, Year and month on the dashboard
3. Select any information in the slicers and what all the summary charts change automatically
This sheet can NOT be opened with google sheets and earlier versions of excel as it uses macros and a query table to perform its functions – please see my other listings for simpler versions of this tool designed for google sheets
This sheet has been created for use in the latest (2020) version of excel MS365- PLEASE be aware of this before you make your purchase.
The download bundle will include:
• 1 x excel workbook with 4 sheets
o 1 Dashboard
o 1 financial data tab
o 1 instruction sheet
o 1 extra sheet to assist you in adding rows if you run into any problems
The instructions are very detailed so it’s very user friendly – but if i have missed anything, please do let me know – I’m constantly evolving my products so I love a good challenge!
Due to the DIGITAL nature of the purchase, we are not able to accept returns, exchanges or cancellations.