Declining Balance

The Declining Balance report is used in conjunction with the EPEP function (Expected Period end Profitability) to help you track expenditures based on your original budget for the month / period. This report requires that your system be set up to import or load actual results during the course of the month.

Click image to view a sample report.

Key Information

Displays the variance between the budget for the month and the actual results period-to-date.

Report Options

Display

Allows you to choose additional options to be displayed in the report.

Summary-Rollup Level P&L View. Displays budget line totals by period.
Detail-Account Level Data. Displays amounts and KBIs by detail for each by profit center.
Lines with Zero Values. Allows you to display all budget lines even if the data entered is zero
Comments. Displays any comments that are associated with the line
Budget Lines. Displays the selected the budget lines.

Dataset

Allows you to select the data you wish to be displayed. Datasets consist of a Year and Type of data that are grouped in an organized manner.

Year. Allows you to choose which year of the dataset you view.
Type. Allows you to choose which type of dataset you wish to view.
Period. Allows you to choose which period of the dataset you wish to view.

Variance

Allows you to select whether you wish to view the variances as Dollars or Percentages.

Running the Report

To run the report:

Choose Comparative from the Reports menu.
Click Declining Balance. The report options screen is displayed.
Select the appropriate View.
Select either Summary-Rollup Level P&L View or Detail-Account Level Data.
Select Lines with Lines with Zero Values and/or Comments if desired.
Select or de-select Budget Lines as needed.
Select the Year, Type and Period for your Dataset.
Select either Dollars or Percentages for the Variance.
Click the Run icon. The report is displayed.

Related topics: