Sri Lanka Reports
It contains all custome reports for Sri Lanka.
Annual Cash Flow Report
Overview
This report gives the monthly forecast and the actual amounts for expenditures and receipts. It provides various filters to generate the report in an optimized way.
A screenshot of the Annual Cash Flow Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to installed revision, System Parameters and Rendering Control configuration.
Users access Annual Cash Flow Report from within the menu through this navigation path: Treasury Management ► Cash Planning ► Cash Planning Scenarios ► Report ► SriLanka Reports ► Annual Cash Flow Report.
Filters
The following table lists and describes all filter fields for the Annual Cash Flow Report in their default order. Note that some fields depends 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.
| Field | Description |
|---|---|
| Fiscal Year | It lists the fiscal years and allows users to select a fiscal year from the list as a filter. |
| Currency | It lists the different currencies and allows users to select it as a filter. The default value is set a the country domestic currency. |
| Fiscal Period | It lists and allows users to select a fiscal year as a filter. January is set as a default value. |
| From Date | January first of the current fiscal year is set as default value. Users are not allowed to change it. |
| To Date | It allows users to pick the end date for the report using the calendar feature. |
| Institution | It lists and allows users to select the institution as a filter. |
| Cash Plan Type | It lists cash plan type and allows users to select it as a filter. |
| Group By Institution | By default it is set as unchecked, it allows users to group the report data by the institution. |
| Comment | Allows users to add a custom comment to the generated report. |
| Scale | It lists and allows users to select the scale of the amount. |
Visible Fields
The following table lists and describes all visible fields for the Annual Cash Flow 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. A sample of the Annual Cash Flow Report is available here.
| Field | Description |
|---|---|
| COA Codes | It shows the cash planning coding blocks information. |
| Description COA | It shows the coding block description. |
| Cash Flow Estimates (Original) | It shows the original amount(domestic) approved this year. |
| Annual Budget Estimates | It shows the current approved amount from budget control. |
| Monthly Forecast | It shows the month-wise forecasted amount in the report. |
| Monthly Actual | It shows the domestic credit amount from journal voucher line items. |
| Total Forecast | It shows the sum of all monthly forecast amount. |
| Total Estimate | It shows the sum of all planned current amount. |
| Total Actual | The sum of all actual monthly amount. |
| Total Revenue and Collecting Departments | The sum at the end of the section for each column. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Annual Cash Flow Report feature.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as PDF format. |
 | This button allows users to generate the report as MS Excel format. |
 | This button allows users to generate the report in the excel format. |
 | This button allows users to generate the report in ODS format. |
 | This button allows users to generate the report in RTF format. |
 | This button allows the users to generate the report in MS Word format. |
 | This button allows users to generate the report in ODT format. |
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.
| Field | Description |
|---|---|
| Fiscal Year | Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year. |
| Fiscal Period | Drop down filter criterion for the fiscal period. This is a mandatory filter. |
| Revenue Agency | Lookup filter criterion for revenue agency. |
| Cash Planning Type | Drop 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:
|
| Comment | Allows users to add a custom comment to the generated report. |
| Hierarchically COA elements selection | Allows 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.
| Field | Description |
|---|---|
| Filter By | The filter criteria describing how the given report has been filtered based on the user’s preferences. |
| Group By | The criteria describing how the report has been grouped based on the user’s preferences. |
| Fiscal Year | Shows the fiscal year of the report. |
| Revenue Category/ Revenue Code | Revenue category and revenue code information of monthly revenue forecast. |
| Day | Shows 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 Image | Description |
|---|---|
 | 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. |