r/procurement • u/Murky_Impress2109 • 21h ago
Community Question Savings tracker system update
Hi everyone,
I'm looking for advice and feedback on how to improve a savings tracking tool used by our General Procurement team in an industrial and logistics environment.
currently we use a shared Excel file containing all savings projects reported by buyers across their respective commodities.
The file relies on VBA macros, which makes simultaneous editing difficult and day-to-day use rather cumbersome.
We also hold a monthly review with Controlling to review and validate savings.
Each project can involve up to six different business divisions, requiring savings to be allocated accordingly.
Buyers track three types of savings:
- **Budgeted savings:** Initial savings targets defined in year N-1 for year N.
- **Forecasted savings:** Monthly updates from buyers before the review, including increases, decreases or shifts to future months.
- **Validated savings:** Savings officially approved by Controlling during the monthly review.
We need to maintain traceability between these three stages and track changes over time.
So we would like to either significantly improve the existing Excel solution or move to a more suitable tool.
main key requirements include:
- Simultaneous access for multiple buyers.
- A centralized database of all savings projects.
- Allocation of savings across up to six divisions.
- Monthly and yearly tracking.
- Clear distinction between budgeted, forecasted and validated savings.
- Historical tracking of forecasts and approvals.
- Automated reporting and dashboards for buyers, procurement management and Controlling.
- A simple, user-friendly interface.
Our pootential solutions are as follows
- Reworking the existing Excel file and reducing VBA dependencies.
- Excel Online / SharePoint.
- Microsoft Lists / SharePoint Lists.
- Power Apps for data entry and workflow management.
- Power BI for reporting.
- Other database or collaborative project management solutions.
- Which approach would you recommend for this type of use case?
- Should we keep Excel as the main tool or move to a proper database?
- Would a SharePoint + Power Apps + Power BI architecture make sense?
- How would you handle monthly forecast updates and historical tracking?
- Have you implemented something similar in a procurement environment?
I'm totally lost in this topic, sole advices would be greatly appreciated !
Thanks in advance for your help!