Debt Register
BTMS Philippines Reports
Debt Servicing Requirements Report
Overview
This report shows debt servicing requirements for the month, quarter, year at aggregate level or at donor or executing agency level by debt instrument type, based on the debt servicing requirements data. It provides different filters which help users to generate the report as per their requirements.
A screenshot of the Debt Servicing Requirements 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 Requirements Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► BTMS Philippines Reports ► Debt Servicing Requirements Report.
Filters
The following table lists and describe all filter fields for the Debt Servicing Requirements 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 |
|---|---|
| Report Type | It lists the report type for selecting as a report filter. |
Fiscal Year | It lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal year is set as a default filter. |
Fiscal Period From | The current fiscal period is set as the initial range by default. Based on the requirement user can select another fiscal period from the list. |
Fiscal Period To | The current fiscal period is set as the end range by default. Based on the requirement user can select another fiscal period from the list. |
Debt Type | It lists the debt type for selecting as a report filter for the report. |
Creditor Agency | It allows selecting the creditor agency using lookup feature as a report filter. |
| Executing Agency | It allows selecting the executing agency using lookup feature as a report filter. |
Visible Fields
The following table lists and describes all visible fields for the Debt Servicing Requirements 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.
| Field | Description |
|---|---|
| Code | Instrument ID. |
| Description | Description of the Debt Instrument. |
| Debt Instrument Type | The debt instrument type. |
| Maturity Date | The date of maturity. |
| Amount | The total amount as per the filter selection in instrument type. |
| Forecast Principal Expected Transaction Date | Expected transaction date for principal. |
| Forecast Principal Amount | Forecast principal amount. |
| Forecast Interest Expected Transaction Date | Expected transaction date for interest as per debt transaction forecast. |
| Forecast Interest Amount | Forecast interest amount depends on the debt transaction forecast filter selection. |
| Total Forecast | The total of forecast principal amount and forecast interest amount. |
| Actuals Principal Transaction Date | The actuals principal transaction date. |
| Actuals Principal Amount | The actual principal amount. |
| Actuals Interest Transaction Date | The actuals interest transaction date. |
| Actuals Interest Amount | The actuals interest amount. |
| Total Actuals | The total of actuals principal amount and actuals interest amount. |
| Total Forecast Principal Amount | The total forecast principal amount. |
| Total Forecast Interest Amount | The total forecast interest amount. |
| Grand Total Forecast | The total amount after adding the total forecast principal amount and total forecast interest amount. |
| Total Actuals Principal Amount | The total actuals principal amount. |
| Total Actuals Interest Amount | The actuals total interest amount. |
| Grand Total Actuals | The total amount after adding the total actuals principal and actuals total interest amount. |
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 Requirements Report feature.
| Button Image | Description |
|---|---|
 | 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 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. |
 | 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. |
 | Lookup allows user to select existing item from the list as a filter. |
Debt Instrument
Overview
This entity stores the register of debt instruments.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Debt Instrument
Debt Instrument Screen Fields
Fields | Description |
Code | Unique Identification code of the Debt Instrument. |
Instrument Type | Refers to the instrument type entity in order to classify the debt instrument. |
Currency | Currency of the Debt Instrument. |
Debt Instrument Status | Indicates if the Advance is Open and transactions can be posted against it or it is closed and no transactions ca be posted against it. Default is Open. |
Maturity Date | Indicates the Instrument maturity date. |
Creation Date | Indicates the Instrument creation date. System populated current system date. |
Instrument Issuance Date | Issuance date of the debt instrument. |
Terms Of Bond | Calculated/Display only amount |
Exchange Rate | The exchange rate for the chosen currency. |
Principal Coding Block | Debt Instrument principal coding block. |
Principal Coding Block Cash Inflow Account | Only FULL Coding Block allowed |
Principal Coding Block Cash Outflow Account | Only FULL Coding Block allowed |
Interest Coding Block | Debt Instrument principal coding block. |
Creditor Agency | Associated with vendor |
Interest Rate | Rate of interest applies to the instrument. |
Principal Domestic Opening Balance | Principal Opening Balance of the Debt Instrument in domestic currency. |
Principal Foreign Opening Balance | Principal Opening Balance of the Debt Instrument in foreign currency. Applicable only when the instrument is in foreign currency. |
Principal Domestic Transaction Balance | This is a system calculated display only field. Shows the principal transaction balance. |
Principal Foreign Transaction Balance | This is a system calculated display only field. Shows the principal transaction balance in foreign currency. |
Principal Outstanding Domestic Balance | This is a system calculated display only field. Shows the outstanding principal amount of the instrument. |
Principal Outstanding Foreign Balance | This is a system calculated display only field. Shows the outstanding principal amount of the instrument if it is in foreign currency. |
Language | Country specific language used to register the description. |
Name | Name of the Debt Instrument |
Description | Description of the Debt Instrument. |
Created By | System will automatically populate this attribute. |
Debt Transaction Forecast Tab | Collection of 0 to N forecasts for the debt instrument. |
Debt Transaction Actual Tab | Collection of 0 to N transaction actuals. This is a display only tab, automatically populated by the system through process. |
Attachment Tab
Attachment Tab Screen Fields
Fields | Description |
Id | Consecutive number auto generated by the system. It will be unique within the system. |
Language | The system will suggest the default language; however the user can change such language. It represents the language of the document. |
Title | Title of the document |
Description | User defined. Description of the Attachment. |
Attachment | Complete reference to the file attached |
Date Time | Date and Time of the last operation performed on the attachment document. Visible for the user. Automatically assigned by the system. |
Date | It will be used as a reference for Reports and Forms |
User | Last user who uploaded or updated the document. Visible for the user. Automatically assigned by the system. |
Debt Transaction Forecast Tab
Debt Transaction Forecast Tab Screen Fields
Fields | Description |
Id | Refers to Debt Instrument code. |
Serial Number | Auto generated item serial number starts with 1 for every new Debt Instrument. |
Type of Transaction | Type of transaction. Possible values are Principal/Interest. Default is Principal. |
Expected Transaction Date | Expected date for the transaction. |
Currency | Currency of the Debt Instrument |
Exchange Rate | Shows the latest active exchange rate for the selected currency. |
Domestic Debit Amount | Transaction Debit Amount in domestic currency. |
Foreign Debit Amount | Transaction Debit Amount in foreign currency. |
Domestic Credit Amount | Transaction Credit Amount in domestic currency. |
Foreign Credit Amount | Transaction Credit in foreign currency. |
Generate Journal Entries For Debt Securities
Overview
This feature allows users to generate interest accrual or amortization of premium/discount for debt securities.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Generate Journal Entries For Debt Securities
Generate Journal Entries For Debt Securities Screen Fields
| Fields | Description |
| Fiscal Year | Default value is current fiscal year, applicable fiscal years where status of fiscal year must be Open and fiscal year is open for budget execution are presented. |
| Fiscal Period | Default value is current fiscal period .Only fiscal periods with status Open are available. |
| Debt Instrument | Optional attribute to run the process for a single debt instrument. Only open instrument with category “Securities” or “Zero Coupon Securities” are displayed. |
| Generate JV For Interest Accrual | Default is ‘Null’. If it is 'True' then it will consider only 'REGULAR_SECURITY','ZERO_COUPON_SECURITY' as Debt Instrument Category |
| Generate JV For Amortization Of Premium Or Discount | Default is ‘Null’. If it is 'True' it will consider only 'REGULAR_SECURITY' as Debt Instrument Category. |
Guarantee Annual Ceiling
Overview
This entity should have a normal CRUD and should be subject to Audit Trail.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Guarantee Annual Ceiling
Guarantee Annual Ceiling Screen Fields
Fields | Description |
Code | Unique identifier. System generated |
Active | Default is True |
Fiscal Year | Fiscal Year of the Annual Ceiling |
Ceiling Amount | Default Zero |
Reserved Amount | Display only, dummy field. Calculated amount, Default Zero |
Approved Amount | Display only, dummy field. Calculated amount, Default Zero |
Unreserved Ceiling Amount | Display only, dummy field. Calculated amount, Default Zero |
Issued Amount | Display only, dummy field. Calculated amount, Default Zero |
Language | Country specific language |
Description | Full description of the Annual Ceiling. |
Sri Lanka Reports
Debt Service Payment Report
Overview
This report retrieves information about all the loan instruments that have securities or loans. It displays data from the annual provision, expenditure and balance provision, etc. It allows users to create reports based on their requirements.
A screenshot of the Debt Service Payment 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 Service Payment Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► SriLanka Reports ► Debt Service Payment Report.
Filters
The following table lists describe all visible fields for the Debt Service Payment 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 |
|---|---|
| Fiscal Year | It shows a list of the fiscal years that allow users to select it as a report filter. The current fiscal year is set as a default report filter. |
| Fiscal Period | It shows a list of the fiscal period that allow users to select it as a report filter. The current fiscal period is set as a default report filter. |
| Comment | Allows users to add a custom comment to the generated report. |
Visible Field
The following table lists and describe all visible fields for the Debt Service Payment 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.
| Field | Description |
|---|---|
| Loan Repayments - Domestic | It is a report label. |
| Loan Repayments - Domestic Codes | It shows the item coding block for the loan repayment. |
| Loan Repayments - Domestic (Annual Provision) | It shows the current budget for the loan repayment. |
| Loan Repayments - Domestic (Expenditure Up to Previous Month) | It shows the expenditure loan repayment up to the previous month. |
| Loan Repayments - Domestic (Expenditure Up to This Month) | It shows the expenditure loan repayment up to this month. |
| Loan Repayments - Domestic Total | Empty space, manually filled after generating the report. |
| Loan Repayments - Domestic Balance Provision | Empty space, manually filled after generating the report. |
| Loan Repayments - Foreign | This is kept as a row lable for the report. |
| Loan Repayments - Foreign Codes | It shows the item coding block for the loan repayment. |
| Loan Repayments - Foreign (Annual Provision) | It shows the current budget for the loan repayment. |
| Loan Repayments - Foreign (Expenditure Up to Previous Month) | It shows the expenditure loan repayment up to the previous month. |
| Loan Repayments - Foreign (Expenditure Up to This Month) | It shows the expenditure loan repayment up to this month. |
| Total Capital Expenditure | This is kept as a row lable for the report. |
| Total Capital Expenditure Annual Provision | It shows the total annual previous capital expenditures. |
| Total Capital Expenditure Up To Previos Month | It shows the total capital expenditures up to the previous month. |
| Total Capital Expenditure Up To This Month | It shows the total capital expenditures up to current month. |
| Total Capital Expenditure - Total | It shows the total expenditure up to the previous month and total expenditure up to the current month. |
| Total Capital Expenditure - Balance Provision | It shows the total capital expenditures balance. |
| Interest Payment on Domestic Loans | This is kept as a row lable for the report. |
| Interest Payment on Domestic Loans - Codes | It shows the interest payment on domestic loan. |
| Interest Payment on Domestic Loans (Annual Provision) | The current budget for interest payment on domestic loans. |
| Interest Payment on Domestic Loans (Expenditure Up to Previous Month) | It shows the interest payment on domestic loans up to the previous month expenditure. |
| Interest Payment on Domestic Loans (Expenditure Up to This Month) | It shows the interest payment on domestic loans up to this month expenditure. |
| Interest Payment on Domestic Loans Total | Empty space, manually filled after generating the report. |
| Interest Payment on Domestic Loans Balance Provision | Empty space, manually filled after generating the report. |
| Interest Payment on Foreign Loans | This is kept as a row lable for the report. |
| Interest Payment on Foreign Loans - Codes | The interest payment on foreign loans code. |
| Interest Payment on Foreign Loans (Annual Provision) | The current budget for interest payment on foreign loans. |
| Interest Payment on Foreign Loans (Expenditure Up to Previous Month) | The interest payment on foreign loans it includes expenditure upto the previous month. |
| Interest Payment on Foreign Loans (Expenditure Up to This Month) | The interest payment on foreign loans it includes expenditure upto this month. |
| Interest Payment on Foreign Loans Total | Empty space, manually filled after generating the report. |
| Interest Payment on Foreign Loans Balance Provision | Empty space, manually filled after generating the report. |
| Total Interest Payment | This is kept as a row lable for the report. |
| Discount Amortization | This is kept as a row lable for the report. |
| Discount Amortization - Codes | The amortization discount code for item code 21603. |
| Discount Amortization (Annual Provision) | The current budget for discount amortization. |
| Discount Amortization (Expenditure Up to Previous Month) | Sum of the discount amortization up to the previous month expenditure. |
| Discount Amortization (Expenditure Up to This Month) | Sum of the discount amortization up to this month expenditure. |
| Discount Amortization Total | Empty space, manually filled after generating the report. |
| Discount Amortization Balance Position | Empty space, manually filled after generating the report. |
| Loan Flotation Expenditure | This is kept as a row lable for the report. |
| Loan Flotation Expenditure - Codes | The loan flotation expenditure code for item code 21701. |
| Loan Flotation Expenditure (Annual Provision) | The current budget for loan flotation expenditure. |
| Loan Flotation Expenditure (Expenditure Up to Previous Month) | The loan flotation expenditure up to the previous month. |
| Loan Flotation Expenditure (Expenditure Up to This Month) | The loan flotation expenditure up to this month. |
| Loan Flotation Expenditure Total | Empty space, manually filled after generating the report. |
| Loan Flotation Expenditure Balance Provision | Empty space, manually filled after generating the report. |
| Total Recurrent Expenditures | This is kept as a row lable for the report. |
| Total Recurrent Expenditures Annual Provision | It is the sum of the interest payment on domestic loans (expenditure up to previous month), interest payment on foreign loans (expenditure up to previous month), discount amortization (expenditure up to previous month) and loan flotation expenditure upto previous month. |
| Total Recurrent Expenditures Up to Previous Month | It is sum of all interest payment, discount amortization and loan flotation expenditure up to previous month. |
| Total Recurrent Expenditures Up to This Month | It is sum of all interest payment, discount amortization and loan flotation expenditure up to this month. |
| Total Recurrent Expenditures Total | It is the sum of the total recurrent expenditures up to previous month and total recurrent expenditures this month. |
| Total Recurrent Expenditures Balance Provision | It is the total balance amount of recurrent expenditure provision. |
| Total Debt Service Payments | This is kept as row lable for the report. |
| Total Debt Service Payments Annual Annual Provision | It is sum of total capital expenditure annual provision and total recurrent expenditures annual provision. |
| Total Debt Service Payments Up to Previous Month | It is sum of the total capital expenditure up to previous month and total recurrent expenditures up to previous month. |
| Total Debt Service Payments Up to This Month | It is sum of the total capital expenditure up to this month and total recurrent expenditures up to this month. |
| Total Debt Service Payments Total | It is sum of the total capital expenditure and total recurrent expenditures total. |
| Total Debt Service Payments Balance Provision | It is total debt service pament balance provison of all expenditures. |
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 Service Payment Report feature.
| Button Image | Description |
|---|---|
| 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. |
Guarantee Ceiling Report
Overview
This report shows status of the guarantees issued by the government as of the current date.
A screenshot of the Guarantee Ceiling 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 Guarantee Ceiling Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantee Ceiling Information Report.
Visible Fields
The following table lists and describes all visible fields for the Guarantee Ceiling Report, in their default order. The language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Report Date | The current system date. |
| Report Time | The current system date. |
| User Code | Information of the user who has generates the report. |
| Current Date | The current date, up to when the report is generated. |
| Guarantee Ceiling | It shows the guarantee ceiling amount. |
| Guarantees Issues Previous Fiscal Year | It is the sum of the previous fiscal year domestic guarantee issued amount. |
| Guarantees Issues Current Fiscal Year | It is the sum of the current fiscal year domestic guarantee issued amount. |
| Letter of Comfort Issued | It is the sum of domestic guarantee issued amount for the instrument. |
| Total of Guarantees Issued & Letter of Comfort Issued | It is the grand total amount of all letter of comfort issued, previous year and current year guarantees issued. |
| Balance Available | It shows the calculated balance amount. |
| Guarantees Approved - To be Issued | It shows the creditor agency with project name. |
| Foreign Amount | It displays the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Guarantees Approved - Tranches to be Issued | It shows the creditor agency with project name. |
| Foreign Amount | It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Treasury Guarantees - Pending Cabinet Approval | It shows the creditor agency with project name, where cabinet decision on status is pending. |
| Foreign Amount | It display the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Sovereign Guarantees - Pending Cabinet Approval | It shows the creditor agency with project name, where cabinet decision on status is pending. |
| Foreign Amount | It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Reserved Balance | The grand total amount. |
| Total Guarantees Issued & Reserved | The sum of the reserved balance and total of guarantees issued & letter of comfort issued. |
| Balance Available for New Issues | The available balance amount for new issues. |
| Percentage of Total Guarantees Issued & Reserved | Percentage of total guarantees issued and reserved. |
| CBSL Exchange Rates as at (Current Date) | All the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantee Ceiling Report feature.
| Button Image | Description |
|---|---|
| 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 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. |
| 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. |
Guarantee Type Report
Overview
The report shows the total guarantee issued by debt types and the issued amount as a % of the total guarantees issued.
A screenshot of the Guarantees Type Report feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Type Report.
Filters
The following table lists and describes all filter for the Guarantees Type 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 |
|---|---|
| Creditor Agency | It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report. |
| Status | It is a mandatory field. It refers the status open or close of the guarantees. |
| Issue Date | Refers to the issue date of the guarantees. |
| Expiry Date | Refers to the expiry date of the guarantees. |
Visible Fields
A sample of the Guarantee Type Report output is available here. The following table lists and describes all visible fields for the Guarantees Type 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 |
|---|---|
| No. | Indicates serial numbers. |
| Name of Institution | Creditor Agency names of the guarantees. |
| Treasury Guarantees | Amount for the domestic guarantees issued. |
| Sovereign Guarantees | Amount for the foreign guarantees issued. |
| Total (Column) | This is a calculated field, shows sum of domestic and foreign guarantees. |
| Issued % | Ths is percentage of total guarantees issues for the institution over the total gurantees issued. |
| Total (Row) | This is calculated field, shows the sum of columns. |
| CBSL Exchange Rates as at (Current Date) | This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantees Type 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. |
 | This button allows users to generate the report in ODT format. |
 | This button allows users to generate the report in ODS format. |
Guarantees Issued Bank Wise Report
Overview
This report generates the list of guarantees issued by the general treasury. It provides different filter option to generate the report.
A screenshot of the Guarantees Issued Bank Wise 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 Guarantees Issued Bank Wise Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Issued Bank Wise Report.
Filters
The following table lists and describe all filter fields for the Guarantees Issued Bank Wise 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 |
|---|---|
| Financial Institution | It allows users to select the financial institution as a filter by using the lookup feature. |
| Status | It lists the status and allows users to select it as report filter. |
| From Issuance Date | The date picker allows users to put the 'issuance date from' as a filter for the report. |
| To Expire Date | The date picker allows users to put the 'to expire date' as a filter for the report. |
| Comment | Users can enter a relevent comment, added to the generated report. |
| Sort By | It provide sorting filter for the report. |
Visible Fields
The following table lists and describes all visible fields for the Guarantees Issued Bank Wise 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.
| Field | Description |
|---|---|
| S.No | Sequence number. |
| Name of the Bank or Institution | Name of the bank/institution receiving the guarantee. |
| Name of Institution | Name of the financial institute. |
| Rs. Mn. | Guarantee issued domestic amount in millions. |
| Total per Name of the Bank or Institution | Total amount grouped as per the name of the bank or institution. |
| Grand Total Rs. Mn. | Sum of the Rs. Mn. |
| Grand Total | Grand total amount. |
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 Guarantees by SOE Report feature.
| Button Image | Description |
|---|---|
| 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 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. |
| 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. |
| The Lookup tool allows users to browse and select existing items. |
 | Allow to select a calendar date. |
Guarantees Summary Report
Overview
The report shows the total guarantee issued to institutions or creditor agencies by banks or financial institutions.
A screenshot of the Guarantees Summary Report feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Summary Report.
Filters
The following table lists and describes all filter for the Guarantees Summary 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 |
|---|---|
| Creditor Agency | It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report. |
| Status | It is a mandatory field. It refers the status open or close of the guarantees. |
| Issue Date | Refers to the issue date of the guarantees. |
| Expiry Date | Refers to the expiry date of the guarantees. |
| Comment | Allows users to add a custom comment to the generated report. |
Visible Fields
A sample of the Guarantees Summary Report output is available here. The following table lists and describes all visible fields for the Guarantees Summary 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 |
|---|---|
| No. | Indicates serial numbers. |
| Name of Institution | Creditor Agency names of the guarantees. |
| Name of the Bank or Financial Institution | This refers to the financial institutions or banks that issues the guarantees. |
| Total (Column) | This is a calculated field, displaying the sum of all the bank or financial institutions for the Creditor agency. |
| Total (Row) | This is a calculated field, displaying the sum of all the creditor agencies for the bank or financial institution. |
| CBSL Exchange Rates as at (Current Date) | This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantees Summary 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. |
| This button allows users to generate the report in ODT format. |
| This button allows users to generate the report in ODS format. |
Guarantees by SOE Report
Overview
This report retrieves information on all debt instruments that have been guarantees. It provides different filters which help users generate the report as per their requirements.
A screenshot of the Guarantees by SOE 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 Guarantees by SOE Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees by SOE Report.
Filters
The following table lists and describe all filter fields for the Guarantees by SOE 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 |
|---|---|
| Creditor Agency | It allows users to select the creditor agency using the lookup feature. |
| Status | It lists and allows users to select the guarantee status from the list as filter. A value for this field is mandatory. Open status is set as default value. |
| Issue Date | It allows to enter the guarantees issue date using the date picker. |
| Expiry Date | It allows to enter the guarantees expiry date using the date picker. |
| Comment | Users can enter a comment for the report. |
| Sort By | It provide sorting filter for the report. |
Visible Fields
The following table lists and describes all visible fields for the Guarantees by SOE 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.
| Field | Description |
|---|---|
| Report Date | The current system date appears on the report. |
| Report Time | The current system time appears on the report. |
| User Code | The user code who generates the report. |
| Issue Date | The issue date. |
| Fiscal Year | Fiscal year from filter criteria. |
| Sequence Number | Sequential row number. |
| Creditor Agency (SOE) | The creditor agency name. |
| Name of Bank/Institution | The name of the bank/institution associated with the creditor agency. |
| Rs. Mn. | Sum of guarantee issued amount in millions. |
| Total Rs. Mn. | Sum of guarantee issued amount in millions. It is grouped by creditors agency. |
| Total Rs. Mn. Amount | It is sum of all Rs. Mn. |
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 Guarantees by SOE Report feature.
| Button Image | Description |
|---|---|
| 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 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. |
| 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. |
Recurrent Expenditure On Borrowings Report
Sector Wise Guarantees Issued And Reserved Report
Support Entities
Debt Instrument Type
Overview
This entity lists all the different types of debt instruments.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Support Entities ► Debt Instrument Type
Debt Instrument Type Screen Fields
Fields | Description |
Code | Unique Identification code of the Debt Instrument Type. |
Active | Indicates if the Instrument Type is “active” True = Active, False = Inactive. |
Debt Type | Defines the Type of Debt. Possible values are, External and Domestic. Default is External. |
Type of Financial Operation Type | Indicates the financial operation type for the instrument type. Possible Values are Loan, Regular Security, Zero Coupon Security and Guarantee. |
Currency | Indicates the Currency of the Instrument Type. Default is domestic currency. |
Name | Name of the Instrument Type. |
Description | Description of the Instrument Type. |