Budget – XLCubed Blog ../../../ XLCubed Blog Tue, 21 Apr 2020 10:17:57 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Budget – XLCubed Blog ../../../ 32 32 Rolling Actual and Forecast Reporting ../../../2019/08/rolling-actual-and-forecast-reporting/ ../../../2019/08/rolling-actual-and-forecast-reporting/#respond Tue, 27 Aug 2019 12:24:01 +0000 https://blog.xlcubed.com/?p=5740 It’s a very common requirement in financial reporting to show actual and forecast data by month across the entire year. Often, we are focusing on the expected year end position so we will want to use the actual data where it exists, and the forecast data where it doesn’t so that the year-end total becomes […]

The post Rolling Actual and Forecast Reporting appeared first on XLCubed Blog.

]]> ../../../2019/08/rolling-actual-and-forecast-reporting/feed/ 0 Rolling Forecast reporting in Excel ../../../2013/03/rolling-forecast-reporting-in-excel/ ../../../2013/03/rolling-forecast-reporting-in-excel/#comments Wed, 27 Mar 2013 10:10:49 +0000 http://blog.xlcubed.com/?p=3827 In monthly reporting for the current year the most pertinent numbers for closed periods are the actuals, and for open or future months the forecast. In most cubes actual and forecast (or budget) are implemented as either different measures, or as part of a scenario hierarchy. This can lead to challenges in reporting, where putting […]

The post Rolling Forecast reporting in Excel appeared first on XLCubed Blog.

]]> ../../../2013/03/rolling-forecast-reporting-in-excel/feed/ 6