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. |