Cash Planning
Applying Cash Planning Budget Adjustment
Overview
System goes through each coding block which have been selected for adjustments. If attribute- Automatically Apply Adjustments is set to FALSE, then by default the system applies ‘Evenly Distributed’ Method. If the mentioned attribute is set to TRUE, system applies method selected in attribute- Default Method to Apply Adjustments.
Navigation
Applying Cash Planning Budget Adjustment screen include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year for Cash planning is to be selected from dropdown box. |
| Cash Planning Type | Relevant Cash planning type is to be selected. |
| Budget Adjustments | Budget adjustments are to be retrieved regarding cash planning. |
Cash Plan Update
Overview
After a Cash Planning gets Approved, the only way to update cash planning information is through this update cash plan transaction. It is important to mention that no new coding blocks can be inserted from this transaction. As even if Cash Planning is already approved, inserting new details is still possible through process 'Populating Cash Planning With Budget Information'.
Navigation
Cash Plan Update screen include the following fields:
| Fields | Description |
| Code | Unique identification code automatically generated by the system. |
| Workflow Status | Workflow status are: Created, Approval Requested, Cancelled and Approved. |
| Workflow Process Status | Workflow process status are: Created, Approval Requested, Cancelled and Approved. |
| Cash Planning Management | This reference is used to apply security and also to avoid mixing details of different cash plannings. |
| Fiscal Year | Default value is Current Fiscal Year. |
| Fiscal Period | Default value is Current Fiscal Period which depends of the selected Fiscal Year. This attribute is read-only. |
| Transaction Date | Default value is system date. |
| Currency | Showed only if Parameter System Allow Multicurrency Transactions is TRUE. If user selects a foreign currency, then system will allow selecting coding blocks with amounts expressed in currency selected here. |
| Cash Planning Type | User must select from a drop down list. |
| Fiscal Period To Update | User must select from a drop down list. |
| Domestic Amount Before Update | Refers to the total domestic amount before it has been updated. Read Only for the User. Automatically calculated by the system when Created. |
| Foreign Amount Before Update | Refers to total foreign amount before it has been updated. |
| Domestic Amount After Update | Refers to total domestic amount after it has been updated. |
| Foreign Amount After Update | Refers to total foreign amount after it has been updated. |
| Created By | User by whom it is created. Automatically populated by the system. |
| Created Date | Date of creation automatically populated by the system. |
| Approved By | User by whom it is approved automatically populated by the system. |
| Approved Date | Date of Approval. |
| Cash Plan Update Detail | Details regarding Cash Plan Update. |
Cash Planing Scenarios
Reports
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. |
Cash Planning
Overview
This entity represents the aggregated level which is going to be linked with a budget control type which has ‘Is Cash Management Level’ as true to set the level. This entity/screen does not have a button to Add records, as adding a Cash Planning Detail is done through the process- 'Populating Cash Planning with Budget Information'.
Navigation
Cash Planning screen include the following fields:
| Fields | Description |
| Cash Planning Management | Cash planning management is to be selected from the lookup button. |
| Automatically Apply Adjustments | Whether adjustment should apply automatically, is mentioned. |
| Currency | Default value is ‘Domestic’. If Parameter 'System Allow Multicurrency Transactions' is set to TRUE, then user can change this value, otherwise this will be read only. |
| Exchange Rate | Showed only if Parameter 'System Allow Multicurrency Transactions' is set to TRUE. If applicable, system will default the most recent exchange rate for the currency selected (if different than domestic). User can change it. Values are allowed only if Currency is different than ‘Domestic’. |
| Year Ago | Planned amount a year ago. This should be manually entered by users. This information is for comparison purposes.Value is Zero by default. |
| Original Approved this year | Read only for Users. This attribute will be automatically populated from Budget Control. |
| Current Approved this year | Read only for the User. This attribute will be automatically populated from Budget Control. |
| Actual This Year | Read only for the User. It is intended to be displayed only for users with real time information from Budget Control. |
| Planned Original Amount | Defines the planned original amount. Value is Zero by default. |
| Planned Current Amount | Defines the planned current amount. It is Showed only if Parameter 'System Allow Multicurrency Transactions' is set to True. |
| Freebalance Amount | This is a Calculated field. Read only for Users. |
| Threshold Percentage | Value is Zero by default. This value can not be negative and cannot be higher than 100. If this value is entered then next two attributes are read only. System does not allow to enter a value in this attribute. |
| Minimum Threshold Amount | System alerts when this threshold is reached. Value is Zero by default. If this value remains zero, it means no threshold has been configured. |
| Planned Freebalance Amount | This is Calculated field. Value is Zero by default. Read only for Users. It is intended to be displayed only for users. |
| Method To Apply Adjustment | Methods to apply adjustments: Even Distribution, Weighted Average and Prorated. |
| Weighted Average Distribution Method | Weighted average distribution method to be selected from lookup button. |
| Created Date | Date of creation of Cash planning. |
| Created By | Users who created Cash planning. |
| Coding Block | Coding Block of Cash planning. |
| Cash Planning Detail | Details of Cash planning. |
Cash Planning Management
Overview
This represents the highest level of the Cash Planning information. This is the first entity to be configured after chart of accounts has been configured and entering information in catalogues like Cash Planning Type is done, and before start entering distribution cash amounts, etc.
It is important to mention that only one record per Cash Planning Type can exist per Fiscal Year.
Navigation
Cash Planning Management screen include the following fields:
| Fields | Description |
| Code | Unique identification code of Cash Planning Management. |
| Workflow Status | Defines the workflow status of Cash planning management. Defalut value is Created. Other status are: Approval Requested, Cancelled and Approved. |
| Workflow Process Status | Defines workflow process status. Available status are: Created, Approval Requested, Approved and Cancelled. |
| Fiscal Year | Fiscal Year of the Cash planning management. |
| Cash Planning Type | User must select a Cash Planning Type, look up by relevant criteria should be provided. |
| Budget Control Type | Association of the present Cash Planning Management to a specific Budget Control type such as Financial Budget, Budget of Expenses, Budget of Revenues, etc. This attribute allows to users to define different Cash Planning Managements (CPM) such as CPM of Expenses, CPM of Revenues, etc. |
| Is date analysis needed? | FALSE by default. If users switches this to true, system validates that General Parameter ‘Dates Configuration is Mandatory for Fiscal Period’ is TRUE and Fiscal Periods have their date range configured. |
| Automatic Adjustment Default Value | It’s a Boolean parameter, TRUE by default. If user switches this to FALSE, then system will not run automatic process, in that case such adjustments can be done only through manual user intervention. |
| Distribute Cash Planning Detail Based On Budget Control | Indicates if the distribution of the cash planning detail is based on budget controls or not. If this is TRUE, the system could consider budget control distribution. If this is FALSE, the system won't consider budget control distribution. |
| Method To Apply Adjustment | Possible values are: Even Distribution, Weigthed Average, Prorated. Default value is: 'Even Distribution'. |
| Weighted Average Default Value | Needed only if previous attribute is set to 'Weighted Average'. |
| Cash Planning | One or more Cash planning may be related to one Cash planning management. If needed several cash planning can be entered. Consolidation can be done through reports if applicable. |
Cash Planning With Budget Information
Overview
When users select this menu option, system presents a screen to select the Cash Planning Type and Fiscal Year (default is ´Current´ but users can select a Fiscal Year ´New´ as well) users would like to work on, with that information system comes to know which Cash Planning Management is needed (it is important to mention, not all users have access to all Cash Planning Type, as it will be a DAS (Data Access Security) discriminator so then only authorized users can select a certain Cash Planning Type). To avoid possible problems of many records, system should allow users to select/filter coding blocks similar to the option used in CoA restriction.
Navigation
Cash Planning With Budget Information screen include the below mentioned fields:
| Fields | Description |
| Fiscal Year | Fiscal Year of Cash planning type to be selected from dropdown box. |
| Cash Planning Type | Cash planning type to be selected from dropdown box. |
| Cash Planning Management | Cash planning management gets selected from the attributes selected in the above fields. |
| Is Included Existing Cash Planning | To be checked as to whether it has included the existing cash planning. |
Managing Cash Plan Update
Overview
After a Cash Planning has been Approved, the only way to update cash planning information is through this update cash plan transaction. It is important to mention that no new coding blocks can be inserted from this transaction, as even if Cash Planning is already approved, inserting new details is still possible through process populating Cash Planning With Budget Information.
Navigation
Managing Cash Plan Update screen include the following fields:
| Fields | Description |
| Cash Planning Management | Cash planning management to be updated, is to be selected from lookup button. |
| Fiscal Period To Update | The fiscal period regarding which updation is to be made, is to be selected from dropdown box. |
| Currency | Currency in which cash planning is stated. |
| Managing Cash Plan Updates Details | Details regarding updated cash plan is retreived and shown here. |
Reports
Cash Planning Execution Report
Overview
This report shows information related with the cash plan execution for a specific cash plan type (plan of receipts, plan of payments, etc.). Displayed information includes: budget amounts (original and current), cash plan amounts (original and current) and execution amounts (actual, accounts payable and accounts receivable). The report can be filtered by fiscal year, cash plan type, status, detail level (annual, fiscal period or date), coding block or fiscal period. Also, the report can be group by any CoA concept (level) for each segment in the cash management CoA group. This allows analyzing the displayed amounts at different levels of segregation. Using the filtering functionality such as coding block, this report allows generating information by different criteria such as source of financing, institution, agency, cost center, expense/revenue type, etc. (basically by any of the elements including in the CoA).
Navigation
Cash Plannning Execution Report screen include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year for which Cash Planning Execution Report is to be generated. |
| Fiscal Period | Fiscal period for which Cash Planning Execution Report is to be generated. |
| Cash Planning Type | Cash planning type of Cash plan which has been executed, is to be selected. |
| Cash Plan Status | Status of Cash plan is to be selected. |
| Detail Level | Details on the basis of which the report is to be generated. Options available are: Annual, Fiscal period and date. |
| Currency | Currency in which the report is to be generated. |
| Comment | Comment on the report to be generated. |
Cash Planning Report
Overview
This report shows detailed information for a Cash Plan including budget amounts (original, current, actual, etc.) and cash plan amounts (original, current). It shows information for a specific cash plan type such as plan of receipts, plan of payments, etc. not for consolidated cash plans. The report can be filtered by fiscal year, cash plan type, status, detail level (annual, fiscal period or date), coding block or fiscal period. Also, the report can be group by any CoA concept (level) for each segment in the cash management CoA group. This allows analyzing the displayed amounts at different levels of segregation. Using the filtering functionality such as coding block, this report allows generating cash plan information by different criteria such as source of financing, institution, agency, cost center, expense/revenue type, etc. (basically by any of the elements including in the CoA).
Navigation
Cash Planning Report screen include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year for which cash planning report is to be generated. |
| Fiscal Period | Fiscal period relating to cah planning report is to be generated. |
| Cash Planning Type | Cash planning type of Cash planning is to be selected from dropdown box. |
| Cash Plan Status | Status of Cash plan is to be selected from the dropdown box. |
| Detail Level | Details to be shown in the report which may be annual, based on fiscal period or date, is to be selected from this field. |
| Currency | Currency in which the report is to be generated. |
| Comment | Comment on the report is mentioned in this field. |
Consolidated Cash Planning Report
Overview
This report shows the consolidated cash plan which incorporates the information of all the individual cash plans for a specific fiscal year such as Plan of Receipts, Plan of Payments and Plan of Receipts and Payments by Source of Financing. Report information is presented to the Fiscal Year level (consolidated).
The report is broken down by revenues and expenses. Each coding block included in the individual cash plans is displayed inside one of these main groups (revenues, expenses, other). Some of them can be splitted into sub-groups. Report shows all the hierarchy if applies.
A sum of cash plan amounts is displayed for each group and sub-group. The report can be filtered by fiscal year and cash plan status. Due to the information include in this report, it is particularly oriented to Managers.
Navigation
Consolidated Cash Planning Report screen include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year for which consolidated cash planning report is to be generated. |
| Cash Planning Status | The status of cash planning is to be selected in this field from dropdown box. |
| Currency | Currency in which the report for consolidated cash planning is to be generated. |
| Comment | Comment on the report is to be made in this field. |
Fiscal Period Consolidated Cash Planning Report
Overview
This report shows the consolidated cash plan which incorporates the information of all the individual cash plans (plan of receipts, plan of payments and plan of receipts and payments by source of financing, etc.) for a specific period. Usually a fiscal period corresponds to a month, for that reason this report can be used as monthly consolidated cash plan.
The report is broken down by revenues and expenses. Each coding block included in the individual cash plans is displayed inside one of these main groups (revenues, expenses, other). Some of them can be splitted into sub-groups. Report shows all the hierarchy if applies.
A sum of cash plan amounts is displayed for each group and sub-group. The report must be filtered by fiscal year, fiscal period and cash plan status. Due to the information include in this report, it is particularly oriented to Managers.
Navigation
Fiscal Period Consolidated Cash Planning Report screen include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year for which consolidated cash planning report is to be generated. |
| Fiscal Period | Fiscal period for which consolidated cash planning report is to be generated. |
| Cash Planning Status | Status of Cash planning is to be selected for which report is to be generated. |
| Currency | Currency in which the report is to be generated. |
| Comment | Comment on the report is to be made in this field. |
SriLanka Reports
It contains all SriLanka report for Cash Planning module.
Cash Flow Performance Summary Report
Overview
This report helps users comparing estimated cash flows with the actual cash flows for receipts, outflows and debt are broken down under defined categories and reflecting the performance under each category which is the ratio of actual with the estimate. It provides different filter option to generate a very specific report.
A screenshot of the Cash Flow Performance Summary 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 Cash Flow Performance Summary Report from within the menu through this navigation path: Cash Planning ► Reports ►SriLanka Reports ► Cash Flow Performance Summary Report.
Filters
The following table lists and describes all filter fields for the Cash Flow Performance Summary 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 report filter. The default value is set as current open fiscal year. |
| Fiscal Period | It lists the fiscal period and allows users to select a fiscal year from the list as a report filter. The default value is set as current open fiscal period. |
| Date | It shows the current system date. |
| Institution | It lists institution and allows users to select the institution as a report filter. It allows users to define a range of the institution. |
| Cash Planning Type | It lists the cash planning type. It allows users to select as a filter. |
| Print Amount | It lists and allows users to select the scale of the amount. |
| Comment | Allows users to add a custom comment to the generated report. |
Visible Fields
The following table lists and describes all visible fields for the Cash Flow Performance 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. A sample of the Cash Flow Performance Summary Report is available here.
| Field | Description |
|---|---|
| COA Codes | Shows the coding block in the report. |
| Description COA | It shows the description of coding block. |
| Actual | It shows the opening balance. |
| Deviation | It shows the calculated actual amount as per deviation formula. |
| % of Annual Estimates | It shows the calculated annual percentage estimates. |
| Inflow Subtotals | Shows subtotal of inflows. |
| Outflow Subtotal | Shows subtotal of outflows. |
| Surplus/Deficit | Shows the total surplus or deficit amount. |
| Total Financed Borrowing | Shows the total borrowing amount. |
| Difference | Shows the difference amount by adding surplus/deficit and total financed borrowings. |
| Closing Cash Balance | Shows the closing balance by adding actual and difference amount. |
| Total Bank Balance | Shows the total bank balance. |
| Deviation In Balance | It dispalys the deviation balance. |
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 Cash Flow Performance Summary 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. |
Support Entities
Cash Planning Type
Overview
Cash Planning Type refers to a catalogue which classifies Cash Plan accordingly as defined by users. Plan of receipts, plan of regular payments, plan of specific payments are some examples of Cash Plan Type.
Navigation
Cash Planning Type screen include the following fields:
| Fields | Description |
| Id | Unique identification code for Cash Planning type. |
| Active | Indicates whether Cash Planning is active or not. If checked, it signifies, it is available for use. |
| Language | Language used to describe Cash planning type. |
| Abbreviation | Short form for Cash planning type. |
| Description | Description regarding Cash planning type created. |
Weighted Average Distribution Method
Overview
It refers to catalogue defined by users to set different methods to automatically distribute adjusted amounts to Cash planning whenever there is change in budget.
Navigation
Weighted Average Distribution Method screen include the following fields:
| Fields | Description |
| Code | Unique identification code for Weighted Average Distribution Method. |
| Active | Indicates whether this entity is active or not. If checked, it represents that it is available for use. |
| Language | Language used to describe Weighted Average Distribution Method. |
| Abbreviation | Short form of Weighted Average Distribution Method. |
| Description | Description of Weighted Average Distribution Method. |
| Weighted Average Distribution Configuration | Percentage or weight assigned for each period in a fiscal year is configured through this tab. |