Monthly Revenue Forecast Report

Overview

This report presents the monthly revenue forecast for the specified spending agency broken down into revenue categories for that agency with each revenue category further broken down to the budget revenue codes pertaining to that revenue category.

A screenshot of the Monthly Revenue Forecast Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Cash Management  Cash Planning  Cash Planning Scenarios Reports  SriLanka Reports Monthly Revenue Forecast Report

 

Filters

The following table lists and describes all filter for the Monthly Revenue Forecast Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

FieldDescription
Fiscal YearDrop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Fiscal PeriodDrop down filter criterion for the fiscal period. This is a mandatory filter.
Revenue AgencyLookup filter criterion for revenue agency.
Cash Planning TypeDrop down filter criterion for the cash planning type.
Print Amount
Drop down filter criterion for the amount unit in the output report.
Available options are:
  • In Billions
  • In Millions
  • Hundreds
  • In Thousands
  • Unit
  • Tens
CommentAllows users to add a custom comment to the generated report.
Hierarchically COA elements selectionAllows users to select any concept and elements of the chart of account given a predefined COA group.

 

Visible Fields

A sample of the Monthly Revenue Forecast Report output is available here. The following table lists and describes all visible fields for the Pre Payroll Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

FieldDescription
Filter ByThe filter criteria describing how the given report has been filtered based on the user’s preferences.
Group ByThe criteria describing how the report has been grouped based on the user’s preferences.
Fiscal YearShows the fiscal year of the report.
Revenue Category/ Revenue CodeRevenue category and revenue code information of monthly revenue forecast.
DayShows day wise breakup of the monthly revenue forecast.

 

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Monthly Revenue Forecast Report.

Button ImageDescription
This button allows users to generate the report as PDF.
This button allows users to generate the report as MS Excel.
This button allows users to generate the report as MS Excel (XLSX format).
This button allows users to generate the report as RTF.
This button allows users to generate the report as MS Word.