Use Case: Build Variance Reports Using an Excel Report Template

Financial professionals in these roles who are responsible for carrying out each step of the Build Variance Reports Using an Excel Report Template process:

Financial Analyst
Financial Planner

Your organization might use different names for these roles.

Variance reports compare planned and actual financial outcomes. You can use variance reports to analyze the difference between budgets or forecasts and actual performance. This use case provides an example of the steps involved in calculating the variance between different segments with different time elements using an Excel report template. There are many other ways to do your variance analysis.

Watch the video: 3m 50s

For detailed information, see Example: Build a Variance Report Using a Report Template.

For more information about building variance reports, see:

Add Variances to Matrix Reports
Create a Variance Between Two Different Versions and Time Periods
Display As a Percent of Actual Spend Against Budget