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.

FieldDescription
Fiscal YearIt lists the fiscal years and allows users to select a fiscal year from the list as a filter.
CurrencyIt lists the different currencies and allows users to select it as a filter. The default value is set a the country domestic currency. 
Fiscal PeriodIt lists and allows users to select a fiscal year as a filter.  January is set as a default value.
From DateJanuary first of the current fiscal year is set as default value. Users are not allowed to change it.
To DateIt allows users to pick the end date for the report using the calendar feature. 
InstitutionIt lists and allows users to select the institution as a filter.
Cash Plan TypeIt lists cash plan type and allows users to select it as a filter.
Group By InstitutionBy default it is set as unchecked, it allows users to group the report data by the institution.
CommentAllows users to add a custom comment to the generated report.
ScaleIt 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 Reportin 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.

FieldDescription
COA CodesIt shows the cash planning coding blocks information.
Description COAIt shows the coding block description.
Cash Flow Estimates (Original)It shows the original amount(domestic) approved this year. 
Annual Budget EstimatesIt shows the current approved amount from budget control.
Monthly ForecastIt shows the month-wise forecasted amount in the report.  
Monthly ActualIt shows the domestic credit amount from journal voucher line items.
Total ForecastIt shows the sum of all monthly forecast amount.
Total EstimateIt shows the sum of all planned current amount.
Total ActualThe sum of all actual monthly amount.
Total Revenue and Collecting DepartmentsThe 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 ImageDescription
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.