Sales analysis - budget, forecast, and actuals

You can ask questions related to your sales/revenue performance, using key financial data such as budget information, actuals, and prior period historical data. Use this when you want to gain insights on how your company is performing currently comparing to the prior year, how the sales number look comparing to your estimation, and what are the root causes of sales performance issues.

Notes:

• This analysis is currently available for only sales/revenue, not expenses.
• This feature currently covers only one entity and one currency.
• This feature does not help you to create a budget or forecast. It helps you to analyze the performance of your sales/revenue against the budget and forecast.

Setting up

Your admin must set up the data source for this analysis. Check with your professional services contact or IT contact for more on how to set this up.

Sample questions and responses

• A question that asks to compare actuals versus budget returns an answer with variance data in a table column or a chart annotation.

  

• A question that asks to return a top or bottom number of performers returns achievement data in a table column or a chart annotation.

  

• Other sample questions include:

  • Show me sales by products with actuals, budget and prior year for Q2 FY24.
  • Compare sales by customers between FY 24 budget and prior year.
  • Show top 5 products by percentage of actual divided by budget for FY24.
  • Show products where actual sales is less than budget for April of 2024.
  • Show me actual sales by customers for Q1 FY24 along with budget, prior year, with variance % between actuals and prior year, and percentage of actual sales divided by budget.