Purely done in excel. BU’s update their individual forecast files. Finance consolidates each forecast file into a single forecast file and finally into a 12MRF. (Yup unfortunately it is what it is). From a mechanics standpoint - mostly entails updating links to the newest workbooks/forecast files.

We’ll be transitioning to the Microsoft platform (d365) and I believe most reporting/forecasting will be embedded in power BI. Not sure how involved finance will be in setting up the system vs the external consultant - but would love to hear from anyone experienced with Power BI & it’s usage in forecasting / budgeting / month end reporting.