Monthly Budget Comparison

This report is helpful when trying to compare each month's budget to expenses. For every month shown, Martus will display Actuals, the Budget, the variance and percent variance. When rows are set to accounts, the Actual columns are drillable. 

Monthly Budget Comparison Specific Criteria:

• Periods - Controls how many months the report will display. Will default to the months that have elapsed in the fiscal year.
• Detail - provides a drop down to choose All Dimensions or Expand
  • All Dimensions - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments with the appropriate sub-totals
  • Expand - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

Monthly Budget Comparison Generic Criteria:

• Ending Date - Will show months in the fiscal year through the ending date.
• Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date. 
• Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets. 
• Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories, or any of the dimensions within the system.
• Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
• Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
•  selected, the report will show all sub-dimensions.
• Account Category - when applied, will filter the report to the selected Account Category
• Load - refreshes the report with whatever criteria have been applied
• Export - Most reports can be exported to either MS Excel or PDF.