Cash Planning Scenarios
Cash planning scenarios entities.
Create Cash Plan From Cash Plan
Overview
Allows users to create, review, update and delete Cash Plan From Cash Plan.
Navigation
Treasury Management ► Cash Planning ► Cash Planning Scenarios ► Create Cash Plan From Cash Plan
Create Cash Plan From Cash Plan Screen fields and tabs
| Fields | Descriptions |
| Code | A unique identifier, it is system generated. |
| Fiscal Year | Fiscal Year of the destination cash plan. The default fiscal year is the system current year. The fiscal year should be open for the regular transaction. |
| Source Cash Planning Management | Source cash plan to copy, cash plan must be Approved. |
| Destination Cash Planning Management | Destination cash planning management information. It is read-only field. |
| Destination Cash Plan Type | Type of the Destination Cash Plan. |
| Copy Cash Plan Type | Sets what data will be copied to the new cash plan. |
| Is Executed | It is generated by the system. |
| Executed By | The user details fetch by the system when it got executed. |
| Executed Date | The execution date system automatically fetches the current system date. |
| Language | The default language is English. The user can select another language from the drop-down list. |
| Description | Description relates to Create Cash Plan From Cash Plan. |
Imprest Control
Overview
It enable the system to record imprest control. It is generated through a business process generate imprest control account. Imprest control accounts will be used to establish a cap to multi bank transfer regarding specific expenditure.
Navigation
Treasury Management ► Cash Planning ► Cash Planning Scenario ► Imprest Control ► Imprest Control
Imprest Control Screen Fields and Tabs
| Fields | Descriptions |
| Application Id | A unique identification code generated by the system. |
| Active | The default value of it is True. When cash Management Fiscal Year becomes not eligible for Budget Execution, the attribute value is to be set to False. |
| Workflow Status | It displays the current status of the workflow. It changes as per the approval of the workflow. |
| Cash Planning Management | It stores the Cash Planning Management source of this imprest control. |
| Fiscal Year | The Fiscal Year of this imprest control. The fiscal year should be open for the transaction. |
| Accounting Office | Stores the Accounting Office of this imprest control. |
| Currency | The default value is the country's domestic currency. The user can change it if the transaction is in foreign currency. |
| Exchange Rate | It fetches the foreign currency exchange value from the exchange rate table. |
| Language | The default language is English. The user can select another language from the drop-down list. |
| Description | The description relates to imprest control. |
| Created By | The system automatically fetches the user id of the creator. |
| Create Date Time | The system fetches the system current date. |
| Approved By | The system automatically fetches the approver Id when it gets approved. |
| Approved Date Time | The system automatically fetches the current system date when it gets approved. |
| Planned Accumulated Net Current Domestic Amount | The accumulated net current domestic amount. |
| Planned Accumulated Net Current Foreign Amount | The accumulated net current foreign amount. |
| Accumulated Paid Domestic Amount | The accumulated paid amount in domestic currency. |
| Accumulated Paid Foreign Amount | The accumulated paid amount in foreign currency. |
| Accumulated Balance Domestic Amount | The accumulated balance domestic amount. |
| Accumulated Balance Foreign Amount | The accumulated balance in foreign amount. |
| Imprest Item Tab | The imprest items details. |
Imprest Item
Overview
This tab allows the user to store Imprest Items details.
Imprest Item Screen Fields and tabs
| Items | Descriptions |
| Serial Number | A unique serial number of the imprest item. |
| Planned Accumulated Net Current Domestic Amount | It displays the categories aggregated amount per imprest control, that is, displays the Planned Accumulated Net Current Amount per imprest control. |
| Planned Accumulated Net Current Foreign Amount | It displays the categories aggregated amount (foreign) per imprest control, that is, displays the Planned Accumulated Net Current Foreign Amount per imprest control. |
| Accumulated Paid Domestic Amount | It displays the categories aggregated amounts per imprest control, that is, displays the Accumulated Paid Amount per imprest control. |
| Accumulated Paid Foreign Amount | It displays the categories aggregated amounts per imprest control, that is, displays the Accumulated Paid Foreign Amount per imprest control. |
| Accumulated Balance Domestic Amount | This displays the Accumulated Balance Amount; Accumulated Balance Amount is calculated regarding the subtraction of Accumulated Paid Amount from Planned Accumulated Net Current Amount. |
| Accumulated Balance Foreign Amount | display the Accumulated Balance Foreign Amount; Accumulated Balance Foreign Amount is calculated regarding the subtraction of Accumulated Paid Foreign Amount from Planned Accumulated Net Current Foreign Amount. |
| Imprest Item Category Tab | The imprest item category details. |
Imprest Item Category
Overview
This to store Item Category amounts per imprest control.
Imprest Item Category Screen Fields and Tabs
| Fields | Descriptions |
| Serial Number | A unique identification id for the imprest item category. |
| Category Code | It dispalys the category code which is generated for the imprest control. |
| Planned Net Current Domestic Amount | It displays the planned net domestic amount for the imprest control category. |
| Planned Net Current Foreign Amount | It displays the planned net foreign amount for the imprest control category. |
| Own Sources Domestic Amount | This field is used by the user to input the Own Sources Amount per imprest category. |
| Cash Requirement Domestic Amount | This field displays the calculated amount regarding the subtraction of Own Sources from Planned Net Current Amount per imprest category. |
| Cash Requirement Foreign Amount | This field displays the calculated amount regarding the Subtraction of Own Sources (foreign) from Planned Net Current Amount (foreign) per imprest category. |
| Paid Domestic Amount | It displays the paid amount per period aggregated at category level. |
| Paid Foreign Amount | It displays the paid amount per period foreign aggregated at category level. |
| Accumulated Cash Requirement Domestic Amount | This field display the calculated amount regarding the subtraction of the Paid amounts from the Cash Requirement per imprest category. |
| Accumulated Cash Requirement Foreign Amount | This field displays the calculated amount regarding the subtraction of the Paid amounts (foreign) from the Cash Requirement (foreign) per imprest category. |
| Imprest Item Category Details Tab | It allows the user to store the imprest item category details. |
Imprest Item Category Details
Overview
The purpose of this tab is to store the Imprest Item Category Details.
Imprest Item Category Details Screen and Tabs
| Fields | Descriptions |
| Serial Number | A unique serial number for Imprest Item Category. |
| Fiscal Period | It displays the fiscal Period belonging to the Cash Planning Detail. |
| Planned Net Current Domestic Amount | The field displays (Period)Planned Net Domestic Amounts for the imprest control, that is, the Planned Net Current Amount distributed accordingly to Fiscal Period. |
| Planned Net Current Foreign Amount | This field displays (Period) Planned Foreign Net Amounts for the imprest control, that is, the Planned Foreign Net Current Amount distributed accordingly to Fiscal Period. |
| Own Sources Domestic Amount | This is used by the user to input the (Period) Own Sources Domestic amount at period level. |
| Own Sources Foreign Amount | This is used by the user to input the (Period) Own Sources Foreign amount at period level. |
| Cash Requirement Domestic Amount | This field displays the calculated amount regarding the subtraction of (Period) Own Sources from (Period) Planned Net Current Amount. |
| Cash Requirement Foreign Amount | This field displays the calculated amount regarding the subtraction of (Period) Own Sources Foreign from (Period) Planned Net Current Foreign Amount. |
| Paid Domestic Amount | It displays the paid domestic amount, that is, the Category released amount per period. |
| Paid Foreign Amount | It displays the paid foreign amount, that is, the Category released amount per period. |
| Accumulated Cash Requirement Domestic Amount | It displays the calculated amount regarding the subtraction of the Paid amounts detail from the Cash Requirement detail with the addition the amount of the previous period Accumulated Cash Requirement detail. |
| Accumulated Cash Requirement Foreign Amount | It displays the calculated amount regarding the subtraction of the Paid Foreign amounts detail from the Cash Requirement Foreign detail with the addition the amount of the previous period Accumulated Cash Requirement Foreign detail. |
Imprest Control Category
Overview
It enables the user to define the Imprest Control Categories per Fiscal Year. It use to aggregate Imprest Control Accounts budget control lines per category accordingly to the Generate Imprest Control Accounts Business Process.
Navigation
Treasury Management ► Cash Planning ► Cash Planning Scenario ► Imprest Control ► Imprest Control Category
| Fields | Descriptions |
| Code | Unique Identification code of the Imprest Control Category. |
| Active | The default value is true. |
| Fiscal Year | This field stores the Fiscal Year available for the current year budget execution. |
| Imprest Categories Tab | This collection enables the user to create the set of categories, per fiscal year, that would be used to group the Imprest Control items under Imprest control Accounts. |
Imprest Categories
Overview
This tab screen is to enable the user with the possiblity of create Imprest Categories.
Imprest Categories Screen and Tabs
| Fields | Descriptions |
| Serial Number | A unique identification serial code for Imprest Category. |
| Concept | It allows the user to select the category chart of account concept. |
| Element | It allows the user to select the Chart of Account element releated to selected concept. |
| Language | The default language is English. User can change it. |
| Name | The name of the Imprest Category. |
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
| Fields | Descriptions |
| Fiscal Year | The 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 Type | It allows the user to select the account type as report filter. |
| Institution | The user can enter the Institue or by using lookup feature they can select to generate the report. |
| COA Organization Structure | User 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.
| Filter | Description |
|---|---|
| Fiscal Year | This field shows the current fiscal year as a report filter. |
| Fiscal Period | This field shows the current fiscal period as a report filter. |
| Date | This field shows the current system date as a 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 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.
| Field | Description |
|---|---|
| Borrowing limit | It is sum of the objects which starts with code 14 from budget control. |
| Borrowing actuals | This section of the report shows the actual borrowing amount. |
| Forecast | It shows the forecasting amount of borrowing. |
| Summary | In summary, it shows the actual borrowing amount and forecasted amount. |
| Excess | It 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 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. |
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.
| Field | Description |
|---|---|
| Fiscal Year | This 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 Format | This 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 Type | It allows users to select the instrument type from the dropdown list. |
| Comment | It 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 By | It 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 Image | Description |
|---|---|
| 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.
Support Entities
The system support entities.
Cash Flow Calendar
Overview
This feature is used to store a calendar of cash flows for a particular fiscal year and cash plan type.
Navigation
Treasury Management ► Cash Planning ► Cash Planning Scenarios ► Support Entities ► Cash Flow Calendar
Asset Items screen Fields and Tabs
| Fields | Descriptions |
| Application Id | A unique identity code. It depends on the system setting which allows the user to enter manually or the system automatically generate it. |
| Fiscal Year | The default value is the current fiscal year. The fiscal year should be open for the transaction. |
| Cash Planning Type | Cash planning type. Only one Calendar can be active for the combination of Fiscal Year and Cash Plan Type. |
| Active | By default, it is checked. If the user unchecked it then it will be not available for the transaction. |
| Language | The language default value is English. The user can change the language from the drop-down list. |
| Name | Name of the calendar. |
| Calendar Item Tab | It allows adding the calendar items. |
Calendar Items
Overview
It allows the user to add the Calendar Items for the Cash Flow Calendar.
Calendar Items screen Fields and Tabs
| Fields | Descriptions |
| Calendar Coding Block Serial Number | Automatically generated by the system. User can not modify it. |
| Use Coding Block or Rule Expression | Defines if the calendar will be defined by a coding block or an expression. |
| Coding Block | Coding block it can be full or partial. |
| Coding Block Items | Coding Block items. |
Coding Block Items
Overview
Cash Flow Calendar coding block items.
Coding Block Items screen Fields and Tabs
| Fields | Descriptions |
| Calendar Item Number | Automatically generated by system. The user can not change it. |
| Fiscal Period | Fiscal period. |
| Date | The system automatically fetch the system date. It should be within the selected fiscal year. |
| Percentage To Distribute | Percentage of the distribution. By default value is Zero. |