Reports

Monthly Comparison Report

Overview

This report provide the data of the Average percentage of actual revenue receipts in comparison with the monthly projections for last three years and average percentage of actual disbursements for PS, MOOE and CO in comparison with the monthly disbursement programs (at aggregate level) for last three years.

Navigation

Treasury Management ► Cash Planning ► Cash Planning Scenario ► Report ► Philippines Report ► Monthly Comparison Report

Monthly Comparison Report Screen 

FieldsDescriptions
Fiscal YearThe Fiscal year to generate the report. The default fiscal year is the current fiscal year.
Fiscal Period
The Fiscal period to generate the report. User has to select the fiscal year.
Account TypeIt allows the user to select the account type as report filter.
InstitutionThe user can enter the Institue or by using lookup feature they can select to generate the report.
COA Organization StructureUser can select the COA Organization structure.

 

SriLanka Reports

Borrowings Summary Report

Overview

This report shows the summary of borrowings of the Government of Sri Lanka. It displays the domestic and foreign borrowings and the forecasts as well as the projected borrowings at the end of the year.

The report shows the following details:

  • Borrowing limit for fiscal year
  • Borrowing actuals
  • Forecast
  • Summary

A screenshot of the Borrowings Summary Report 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 Borrowings Summary Report from within the menu through this navigation path: Treasury Management ►  Cash Planning ► Cash Planning Scenarios ► Reports ► SriLanka Reports ► Borrowings Summary Report.

 

Filters

The following table describes all filter fields for the Borrowings Summary Report screen, 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.

FilterDescription
Fiscal YearThis field shows the current fiscal year as a report filter.
Fiscal PeriodThis field shows the current fiscal period as a report filter.
DateThis field shows the current system date as a report filter.
CommentAllows users to add a custom comment to the generated report.


Visible Field

The following table lists and describe all visible fields for the Borrowings Summary Report, in their default order. Note that some fields depend on Filters selection.The language of the report depends on the configuration of the system.

FieldDescription
Borrowing limitIt is sum of the objects which starts with code 14 from budget control.
Borrowing actualsThis section of the report shows the actual borrowing amount.
Forecast It shows the forecasting amount of borrowing.
SummaryIn summary, it shows the actual borrowing amount and forecasted amount.
ExcessIt shows the excess amount of borrowing.

 

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 Borrowings Summary Report feature.

Button ImageDescription
The pdf button allows users to generate the report in the pdf format.
The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 97-2003 or higher version.
The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 2003 or higher version software.
This RTF button allows users to generate the report in RTF format.
The Word button allows the users to generate the report in word format. This format is compatible with Microsoft Office 97-2003 or higher version.
This ODT button allows users to generate the report in ODT format. This format is compatible with word processing software such as Microsoft Office, Open Office or Libre Office.
This ODS button allows users to generate the report in ODS format. This format is compatible with spreadsheet software such as Microsoft Office, Open Office or Libre Office.

 

Debt Servicing Report

Overview

This report generates the Summarized/Detailed information regarding the principal and interest payments made by the Government of on its Debt. The system provides various report format like Excel, pdf, RTF, ODS, etc. User can generate the report using the different report filters which give sorted report data.

A screenshot of the Debt Servicing Report 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 Debt Servicing Report from within the menu through this navigation path: Treasury Management ►  Cash Planning ► Cash Planning Scenarios ► Reports ► SriLanka Reports ► Debt Servicing Report.

 

Visible Fields

The following table lists describe all visible fields for the Debt Servicing 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
Fiscal YearThis field stores the fiscal year. The user can change the fiscal year. The default value is set to the current fiscal year which is open for the transaction.
Report FormatThis field allows users to select the report format i.e. Summary or Details. The summary report type provides the summarized report data and if user wants details information then they can select it as Detail from the dropdown list. The default value is set to the Summary.
Instrument TypeIt allows users to select the instrument type from the dropdown list. 
CommentIt contains users comment for the report which appears on the report comment section. User can enter the comment or may leave it as a blank.
Sort ByIt help user to sort as per the report data as per the selection.

 

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 Debt Servicing Report feature.

Button ImageDescription
The pdf button allows users to generate the report in the pdf format. The pdf reader software should be installed in the system to open the generated report.
The Excel button allows users to generate the report in the excel format. This report is compatible with Microsoft Office 97-2003 or higher version. To open this file user should have Microsoft Office 97 or Higher version installed in the system.
The Excel button allows users to generate the report in the excel format. This report compatible with Microsoft Office 2003 or higher version software. To open this file user should have Microsoft Office 2003 or Higher version installed in the system.
This RTF button allows users to generate the report in RTF format which is similar as Word. User can open this report with Microsoft Office, Open Office or Libre Office.
The Word button allows the users to generate the report in word format. To open this file user should have Microsoft Office 2003 or Higher version installed in the system.
This ODT button allows users to generate the report in ODT format which is similar as Word. User can open this report with Microsoft Office, Open Office or Libre Office.
This ODS button allows users to generate the report in ODS format which is similar as Excel. User can open this report with Microsoft Office, Open Office or Libre Office.
The Refresh Sorting Order button helps user to refresh the sorting selection.

 

Frequently Asked Questions

Do every user can generate this report?

No, only authorized user can generate this report. User can request the access right of this report to the system Super User.

How many report can we generate in a day?

There is no particular limit. It depends upon the configuration made on the report control.

How much time it takes to generate a report?

There is no fixed time duration, it takes time as per the size of the data available for the report.

How long user can enter comment for the report?

Comment section allows users to enter the comment which is relevant and meaningful and it should not exceed more than 250 characters.

What will happen if user exceeds the characters limit for comment?

The system will not allow user to exceed the characters limit. The system automatically concatenates the comment from the last where 250 characters count completes and keeps up to 250 characters as max.

How user can move their sorting selection one-by-one or once at a time?

The user have to select the sorting item and then click on the button Move Selected Item to Other list to move once at a time. To move all items at a time user have to click on the button Move all items to other list.