Treasury Management

The Treasury Management module integrates management of payment processes, bank reconciliations, payment follow-ups, custody of securities and guarantees, financial programming and cash flows, and allows interacting with multiple users of different dependencies naturally.

It allows the management of payments through the administration of essential elements through the use of general use and support catalogs, bank reconciliations, administration of bank accounts, management of simple and multi-bank transfers, custody of securities and guarantees, among others.
Treasury management in any governmental administrative unit requires the management of payment processes and income programming in order to take advantage of the benefits and potential of the GRP.

Cash Flow Forecasting Report

Cash Flow Forecasting Import

Overview

The system allows to import the cash flow forecasting report, the treasury users will provide an excel file containing a specific format that contains several calculations for each group.

Navigation

Treasury Management ► Cash Flow Forecasting Report ► Cash Flow Forecasting Import

Cash Flow Forecasting Import Screen and Tabs

Fields	Descriptions
Fiscal Year	By default, the fiscal year is the current fiscal year which is open for the transaction. The user can select another fiscal year to import.
Version	Information about the version.
Upload File	This feature allows you to import excel file to import.

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: In Billions In Millions Hundreds In Thousands Unit Tens
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.

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

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.

Payments

Create Payment Extracts

Overview

This mode of extraction allows to create draft payments for all expense vouchers within a specified fiscal year, or a specific range of expenses. The Payment process provides an intuitive step-by-step approach to selecting expense vouchers for payment, verifying the accuracy of all draft payments that are generated by the system, approving them, then releasing them for payment to the proper vendors or beneficiaries.

Navigation

Treasury Management ► Payments ► Create Payment Extracts

Payment Extract Generation screen Fields

Field	Description
Fiscal Year	The fiscal year for which the payment extract is to be generated. Default is current fiscal year. However, the user can specify the previous year as long as it is still open.
Fiscal Period	Fiscal period of the extract. Default is current period.
Accounting Office	Accounting Office Code related to the Expense voucher for which the extract is to be generated.
Date	The date the extract was created. Default is Current date.
Payment Type	The type of expenditure for which the extract was generated.
Grouped Cheques	Indicates if multiple invoices having common criteria have been grouped into one cheque. Default as defined in the Expenditures Parameters. The system must apply the following rules for grouping: same Vendor, same Treasury Bank Account ID, same Currency, and same Payment Method.
Due Date From	Earliest due date of payments to be included in extract.
Due Date To	Latest due date of payments to be included in extract.
Vendor	User can select a specific vendor by populating the Vendor ID of vendor whose invoices are to be included in the extract.
Pay Agent	Person who delivers cash or cheque is known as Pay Agent. Appropriate Pay Agent is to be selected for Payment Extract.
Treasury Bank Account	Treasury Bank Account assigned to the payments to be included in the extract.
Financial Institution	Appropriate Financial Institution where treasury have its account should be selected to extract Payment Voucher.
Currency	Currency of the payments to be included in the payment extract.
Payment Mode	Mode of the payments that will be included in the extract.
Payment Location	Location of the payments to be included in the extract.
Payment Method	Method of the payments that will be included in the extract.
Domestic Amount From	Minimum domestic amount for the payments that will be included in the extract. Default is Zero.
Domestic Amount To	Maximum domestic amount for the payments that will be included in the extract. Cannot be less that the value in the ‘Domestic Amount From’ field. Default is Zero.
Language	Country specific Language used to register the Description.
Description	Short description of the Payment Extract.
Expense Voucher Payment Detail	Expense Vouchers details list out Expense voucher, invoice no., payment/ due date. Upon clicking on details button, payment details is shown in view mode.

Finalize Transfer

Overview

Once a transfer is released, the last step is finalize the transfer in order to generate an output file format as Electronic Fund Transfer (EFT), including different encrypted security methods (if applicable) prior to be sended to the appropriate bank. This step will finish the payment cycle for Treasury department.

Navigation

Treasury Management ► Payments ► Finalize Transfer

Finalize Transfer screen Fields

Field	Description
Fiscal Year	Extract Fiscal Year. Default is current fiscal year. However users can specify the previous year as long as it is still open.
Fiscal Period	Refers to the fiscal period of the selected fiscal year. Default is current period.
Accounting Office	Refers to the institution falling under the type Accounting office applicable to the Expense Voucher.
Treasury Bank Account	Users needs to select the appropriate Treasury Bank account applicable to the Expense Voucher.
Transfer Number	The transfer number given for every finalization.
Extract number	Users are to select the appropriate Payment Extract number.
Payment Method	The payment method for which the finalization was.
Vendor	The vendor ID against whom the transfer was finalized.
Expense Voucher	The Expense Voucher ID to be selected here.

View Payment Extracts

Overview

The View Payment Extract displays all information pertaining to calculation and finalization processes that have been executed. It is used to view the status of the process that was launched. It also displays any errors that occurred during the process in order to allow modifications to be performed for those employees prior to re-calculating or finalizing.

Navigation

Treasury Management ► Payments ► View Payment Extract

View Payment Extracts screen Fields

Field	Description
Id	Unique identification code, manually entered by users.
Active	If checked, indicates that payment extract is active.
Grouped Cheques	Indicates if multiple invoices having common criteria have been grouped into one cheque. Default as defined in the Expenditures Parameters. The system must apply the following rules for grouping: same Vendor, same Treasury Bank Account ID, same Currency, and same Payment Method.
Fiscal Year	Extract Fiscal Year. Default is current fiscal year. However users can specify the previous year as long as it is still open.
Fiscal Period	Fiscal period for which the Payment Extract is to be viewed. Default is current period.
Accounting Office	The accounting office institution necessary for viewing Payment Extract. The Office code from where the payment extract was generated.
Date	Date on which the Payment Extract was generated. Default is Current date.
Created By	Users who created the Payment Extract is mentioned.
Created Payments	Number of total payments created when extract was created.
Created Amount	Total Domestic amount of payments created when extract was created.
Approved Payments	Number of total payments approved to date.
Approved Amount	Total Domestic amount of payments approved to date.
Cancelled Payments	Number of total payments cancelled to date.
Cancelled Amount	Total Domestic amount of payments cancelled to date.
Released Payments	Number of total payments released to date.
Released Amount	Total Domestic amount of released rejected to date.
Voided Payments	Number of total payments Voided to date.
Voided Amount	Total Domestic amount of released Voided to date.
Delivered Payments	Number of total payments Delivered to date.
Delivered Amount	The total amount of payments delivered to date.
Language	Country specific Language used to register the description.
Description	Short description of the Payment Extract.
Payment Extract Payment	Collection of one to many payments extract payments.

Payment Extract Payment

Overview

The payment approval process allows users to verify the information related to all draft payments which are contained into the Extract Payment. A decision can then be made to approve or cancel a Payment Extract. Approval affects General Ledger through automatic generation of Journal Vouchers for the payments.

The payment Extract - Payments contain the information regarding cheques or electronic transfers, and the workflow control of Extracts. A Cheque/Transfer register could be the summary of several invoices related to a single vendor.

Navigation

Treasury Management ► Payments ► Payment Extract Payment

Payment Extract Payment Fields

Field	Description
Id	The system generates a unique id for PEP.
Workflow Status	Depending on the Workflow Configuration Setting for this Entity the basic Stages are: Created, canceled, approval requested, etc.
Payment Extract	Payment Extract to be selected from the lookup button.
Payment Method	Method of payment is to be selected which may be Cash, Cheque, EFT, etc.
Accounting Office	Accounting Office Code. It is updated according to the Payment Extract Payment process.
Treasury Bank Account	Treasury Bank Account relating to Payment Extract is selected from the lookup button.
Bank Account	Bank account relating to Payment Extract is to be selected from the dropdown box.
Note Reference Number	The reference number for "payment with the note".
Note Date	It allows the user to enter the note reference date.
Is Accounting	This attribute is marked when the expense voucher to pay is configurated as "Accounting".
Bank Account Name	Name of the bank account is entered in this field.
Branch	Branch to which the bank account relates is entered in this field.
Beneficiary	Vendor to whom the Payment is made is selected from this field.
Cheque Series	The series to which the cheque issued belongs.
Cheque Number	Cheque number which is issued.
Transfer Number	Number identifying the transfer transaction.
Transfer Package Number	It is updated when Allow Generate Transfer Package is set as true in the system setting.
Release Date	Date on which payment is released.
Number Of Releases	A number of times in which the total payment was released. The default value is Zero.
Printed Date	It is updated by the system. The user can't change it.
Delivered Date	Date of delivery of the payment amount.
Currency	Currency in which the payment was made.
Exchange Rate	The exchange rate on the date of payment is entered.
Domestic Amount	Total amount in domestic currency.
Foreign Amount	Payment amount expressed in foreign currency.
Handling Indicator	Special indicator defined by the user in Expense Vouchers. Will be used to give more flexibility to group payments.
Expense Voucher Classification	The user can select the expense voucher classification using the drop-down button.
Created On	Date of creation of Payment Extract.
Created By	The user who created the Payment Extract.
Approved On	Date on which the payment was approved.
Approved By	The user who approved the payment.
Payment Journal Voucher	Automatically assigned by the system when this payment is approved
Expired Cheque Journal Voucher	After marked as Expired Cheque the automatic JV generated will be referenced in this attribute.
Cheque Lot Number	After marked as part of the cheque lot the system auto-generates the number.
Invoice	List of Invoices linked with the Payment
Rejection Description	Description corresponding to the rejection code received in the bank notification.
Payment Invoices	Invoices related to the payment gets added here.

Payment Extract Payment Target Stage

Overview

The payment Extract - Payments contains the information regarding to cheques or electronic transfers, and the workflow control of Extracts. A Cheque/Transfer register could be the summary of several invoices related to a single vendor. This screen helps to retrieve the payment extract payment details and approve those in a bulk.

Navigation

Treasury Management ► Payments ► Payment Extract Payment Target Stage

Payment Extract Payment Target Stage screen Fields

Fields	Description
Fiscal Year	Fiscal year of the Payment Extract is selected here.
Fiscal Period	Fiscal Period for the Payment Extract is selected from the drop down box.
Target Stage	The stage to which the Payment Extract is to be brought to, is selected from the dropdown box.
Payment Method	Method of Payment is to selected. Options include cash, cheque, EFT, tec.
Payment Extract	Required Payment Extract is to be selected.
Treasury Bank Account	Treasury Bank Account related with the Payment Extract is to selected from the lookup button.
Beneficiary	Vendor who will receive the payment is to be selected from the lookup button.
Currency	Currency in which the payment is to be made, is selected in this fields
Search Domestic Amount	Amount mentioned in Payment Extract in domestic currency.
Search Foreign Amount	Amount mentioned in Payment Extract expressed in foreign currency.
Total Selected Domestic Amount	Total selected amount in domestic currency in Payment Extract.
Total Selected Foreign Amount	Total selected amount in foreign currency in Payment Extract.

Payment Extract Payment Target Stage Log

Overview:

This entity keeps track of PEPs with errors that were created during the PEP Target Stage Process. Data on this entity is used for controlling and auditing purposes.

Navigation:

Treasury Management ►Payments ► Payment Extract Payment Target Stage Log

Payment Extract Payment Target Stage Log screen Fields:

Fields	Description
Id	Id of the Payment Extract Payment Target Stage Log.
Job Execution Id	ID of the Job that was created to execute the target stage process. This is an internally generated field.
Payment Extract Payment Id	PEP that is included in the ID.
Date processes started	Timestamp when the process started.
Date process ended	Timestamp when the process ended.
Message	Describes the error that was encountered.

Payment Order

Overview

The function of this screen is to group the payment extracts that are ready to send to bank through web services. It includes all information related with Payment Extract Payment like Vendor, Treasury Bank Account, Swift Code etc. and send to bank.

Navigation

Treasury Management ► Payments ► Payment Order

Payment Order screen Fields

Field	Description
Code	Payment Order ID automatically generated by the system.
Payment Order Status	Users can search the Payment Order by its status like Completed, Confirmed and Sent to Payment System etc.
Payment Order Issue Date	Default by the system to current date and time, this is the Date and Time when this payment order was issued.
Expense Voucher Application Id	Users can select the Expense Voucher Code from where the payment is generating.
Vendor Application Id	Select the Vendor ID for which the payment was made.
Institution Application Id	Select the Institution ID for which the payment was made.
Okpo	The external web-service system to which the payment to be sent
Inn	To select Vendor Tax Identification Number.
Social Fund	Select the Social Fund number manually.
Source Bic Code	Code of Financial Institution corresponding to Treasury bank account field of entity Payment Extract Payment.
Source Account Number	The bank account number of the treasury.
Beneficiary Account	Refers to Bank Account for the Vendor.
Beneficiary Name	Refers to the Bank Account name of the Vendor.
Beneficiary Address	Refers to the Bank Address of the Vendor.
Destination Bic Code	Code of Financial Institution Branch corresponding to Treasury bank account field of entity Payment Extract Payment.
Amount	The amount to be paid to the vendor.
Payment Extract Payment	Users can select the Payment Extract Payment ID to filter the search.
Payment Type	The Payment Type defines the payment to be made for Vendor or for Payroll.
Payroll Id	Select the Payroll ID if the payment type was selected as Payroll.
Financial Institution	Financial Institution for payment required in Payment order.
Swift Message Source	The source of generating the swift message.
Payment Order Message Type	The type of the Payment Order message.
Reason Of Rejection	Users need to specify the reason for rejecting the payment.
Delivery Date	The delivery date of the payment.
Container Message Reference	Automatically assigned by bank interface when this payment order is converted into a SWIFT outgoing message.
Package Id	Package id in the container message. Automatically assigned by bank interface when this payment order is converted into a SWIFT outgoing message.
Confirmation Or Rejection Date	The date of Confirming or rejecting the payment.
Employee Application Id	The application ID of the employee who created the payment.

Unapplied Payment

Overview

This entity will store all payments that were set as rejected in Payment Control Table.

Navigation

Treasury Management ► Payments ► Unapplied Payment

Unapplied Payment screen Fields

Field	Description
Code	Code of the unapplied payment automatically generated by the system.
Payment Order	Refers to the Payment Order ID that users can select.
Payment Extract Payment	Refers to the Payment Extract Payment ID that users can select.
Payment Type	Select the Payment type for which the payment was made. It can be for Vendor or Payroll.
Payroll Id	Select the Payroll ID if the payment was made for Payroll purpose to the employee.
Employee Id	Select the Employee ID if the payment type is Payroll.
Financial Institution	Refers to Bank of the treasury from where the payment to be made.
Payment Order Issue Date	The issuing date of the payment order.
Beneficiary Name	Name of the Vendor bank.
Beneficiary Account	The account number for the vendor.
Amount	The amount of the extract.
Reason Of Rejection	Reason for rejecting the payment order is entered in this field.
Rejection Date	The date on which the payment order was rejected.
Unapplied Payment Status	The present status of unapplied payment.
Expense Voucher Id	Expense Voucher Id for which the payment was to be made.
Adjustment Journal Voucher	Appropriate adjustment journal Voucher for unapplied payment is to be selected from lookup button.
Correction Journal Voucher	Appropriate correction journal Voucher for unapplied payment is to be selected from lookup button.
Correction Payment Order	Corrected Payment Order is selected from the lookup button.

Unidentified Rejected Payment

Overview

This entity will store all payments that were rejected but the system could not find any payment order to match in Payment Control table.

Navigation

Treasury Management ►Payments ► Unidentified Rejected Payment

Unidentified Rejected Payment screen fields:

Fields	Description
Id	Unique identifier automatically generated by the system when a new unidentified payment order is received.
Financial Institution	Bank which rejected the payment order.
Beneficiary Name	Beneficiary Name inside the rejected message.
Beneficiary Account	Beneficiary Account inside the rejected message
Amount	Amount to be paid inside the message
Reason Of Rejection	Reason for rejection inside the message.
Rejection Date	Date and Time when the payment order was Rejected.
Status	Status may be either "identified" or "unidentified".
Match Payment Order	The relevant Payment Order regarding Undentified Rejected Payment is selected from dropdown box.

Payment Approved Batch Process

Overview

The information regarding the process of approval of payment in batch gets generated in Payment Approved Batch Process.

Navigation

Treasury Management ► Payments ► Payment Approved Batch Process

Payment Approved Batch Process screen fields:

Fields	Description
Batch Id	Unique identifier automatically generated by the system when a new Payment Approved Batch process is completed.
Batch Date	The date on which batch process of approval for payment is completed.
Created By	Users by whom the batch process was executed.
Accounting Office	Accounting office of Approved payment is mentioned from lookup button.
Fiscal Year	Fiscal year to which the payment relates is selected from dropdown box.
Treasury Bank Account	Treasury Bank Account related to the approved payment.
Payment Type	Payment type of approved payment is selected from dropdown box.
Payment Extract	Relevant Payment Extract related with Approved Payment, is selected from lookup button.

Admin Cheque

Cheque Lot

Overview:

This mode of extraction allows you to group CHEQUE payments in a Lot Number; this works for all Cheque payment details within a specified fiscal year or a specific range of amount.

Navigation:

Treasury Management ► Payments ►Admin Cheque ► Cheque Lot

Check Lot Screen Fields:

Fields	Description
Fiscal Year	Filter criteria for the Fiscal Year, default fiscal year is the current fiscal year.
Fiscal Period	Filter criteria for the Fiscal Period, default fiscal period is the current fiscal period.
Payment Method	Read Only default “CHEQUE”.
Treasury Bank Account	System will filter the PEP by Treasury Bank account parent to match the records with the selected TBA
Payment Extract Payment	Filter criteria for the Payment Extract Payment ID.
Workflow Status	Payment Extract Payment Workflow Status, Read Only Default “RELEASED”.
Cheque Series	Payment Extract Payment Cheque Series Number.
Cheque Number From	Filter criteria for Payment Extract Payment Cheque Number from
Cheque Number To	Filter criteria for Payment Extract Payment Cheque Number to
Cheque Or Deposit Date From	Filter criteria for Journal Voucher Item Cheque or Deposit date from
Cheque Or Deposit Date To	Filter criteria for Journal Voucher Item Cheque or Deposit date to
Release Date From	Filter criteria for Payment Extract Payment Payment Release Date from
Release Date To	Filter criteria for Payment Extract Payment Payment Release Date to
Currency	Filter criteria for Currency.
Payment Amount From	Filter criteria for Payment Extract Payment Payment Amount from
Payment Amount To	Filter criteria for Payment Extract Payment Payment Amount to
Accounting Office	Filter criteria for Payment Extract Payment Accounting Office
Beneficiary	Filter criteria for Payment Extract Payment Beneficiary.
Total Domestic Amount by Selection Items	Auto update field, when the currency is not domestic.
Total Foreign Amount by Selection Items	Auto update field, when the currency is not domestic.
Total Selection Items	Auto update field, total selected cheque lot items.
Lot Detail	Cheque lot details results.

Deliver Cheque

Overview

Using this entity, system is able to show a list of selection criteria where users can choose a specific field or some combination of them in order to Sent or Deliver a single or group of Cheques.

Navigation

Treasury Management ► Payments ► Admin Cheque ► Deliver Cheque

Deliver Cheque screen fields

Fields	Description
Fiscal Year	Default current fiscal year to be selected as filter criteria.
Fiscal Period	Default current fiscal period to be selected as filter criteria.
Cheque Lot Number	User given Cheque Lot Number to be given as filter criteria.
Cheque No From	To define the starting cheque number of the range.
Cheque No To	To define the end cheque number of the range.
Payment Extract Payment	Payment Extract Payment can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Payment Method	Payment Method can be selected froom the dropdown.
Cheque Or Deposit Date	Cheque or Deposit Date to be given by user which retrieves the records from Journal Voucher based on the given date.
Release Date	Release Date to be given by user which retrieves the records from Payment Extract Payment based on the given date.
Currency	Selected Currency from dropdown can be sued as the filter criteria.
Payment Amount	User given Payment Amount which retrieves the records from Payment Extract Payment based on the given amount.
Payment Foreign Amount	User given Payment Foreign Amount which retrieves the records from Payment Extract Payment based on the given amount.
Accounting Office	Accounting Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Beneficiary	Beneficiary Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Treasury Bank Account	Treasury Bank Account can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Total Domestic Amount by Selection Items	Field Calculated Automatically based on the retrieved records. It is the Sum of Domestic amounts of all the selected items.
Total Foreign Amount by Selection Items	Field Calculated Automatically based on the retrieved records. It is the Sum of Foreign amounts of all the selected items.
Total Selection Items	Field Calculated Automatically based on the retrieved records. It is the Sum of all the selected records.

Manual Expire Cheque

Overview:

The Expired Cheque provides an automatic process to mark the cheques as expired when the due date is done, the process also will create a new double entry accounting transaction in order to reissue a new cheque to the original beneficiary. This process will be executed through the workflow of Payment Extract Payment after reach a Released, Sent or Delivered Status, and it will identify all the cheques still not conciliated within a specific number of days of delay for example: 6 months / 180 days, etc.

Further, the system will change the cheque status as expired when the due date is done.

The user will be able to replace an expired cheque through a new screen, and this process will generate a new Expense Voucher to re-process the payment.

Navigation:

Treasury Management ► Payments ► Admin Cheque ► Manual Expire Cheque

Manual Expire Cheque screen fields:

Fields	Description
Fiscal Year	Default current fiscal year to be selected as filter criteria.
Fiscal Period	Default current fiscal period to be selected as filter criteria.
Workflow Status	Read Only field. Value selected as "Expired". It will retrieve only those records from Payment Extract Payment where workflow status is set as "Expired".
Cheque Series Number	User given Cheque Lot Number to be given as filter criteria.
Cheque No	To define the cheque number.
Cheque Or Deposit Date	Cheque or Deposit Date to be given by user which retrieves the records from Journal Voucher based on the given date.
Currency	Selected Currency from dropdown can be sued as the filter criteria.
Payment Domestic Amount	User given Payment Domestic Amount which retrieves the records from Payment Extract Payment based on the given amount.
Payment Foreign Amount	User given Payment Foreign Amount which retrieves the records from Payment Extract Payment based on the given amount.
Accounting Office	Accounting Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Beneficiary	Beneficiary Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Treasury Bank Account	Treasury Bank Account can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.

Replace an Expired Cheque

Overview

The system will show the information of the below table, and the user should be able to select a single row if query returns more than one expired cheque. The system will apply the security restrictions to this screen.

Navigation

Treasury Management ► Payments ► Admin Cheque ► Replace an Expired Cheque

Replace an Expired Cheque screen fields

Fields	Description
Fiscal Year	Default current fiscal year to be selected as filter criteria.
Fiscal Period	Default current fiscal period to be selected as filter criteria.
Workflow Status	Read Only field. Value selected as "Expired". It will retrieve only those records from Payment Extract Payment where workflow status is set as "Expired".
Cheque Series	User given Cheque Lot Number to be given as filter criteria.
Cheque Number	To define the cheque number.
Cheque Or Deposit Date	Cheque or Deposit Date to be given by user which retrieves the records from Journal Voucher based on the given date.
Currency	Selected Currency from dropdown can be sued as the filter criteria.
Payment Domestic Amount	User given Payment Domestic Amount which retrieves the records from Payment Extract Payment based on the given amount.
Payment Foreign Amount	User given Payment Foreign Amount which retrieves the records from Payment Extract Payment based on the given amount.
Accounting Office	Accounting Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Beneficiary	Beneficiary Office can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.
Treasury Bank Account	Treasury Bank Account can be selected using the lookup button. Selected record can be used as the filter criteria to retrieve the cheques to be delivered.

Central Bank Transfer

Overview

This mode of extraction allows creating draft payments for all expense vouchers within a specified fiscal year, or a specific range of expenses.

Navigation

Treasury Management ► Payments ► Central Bank Transfer

Central Bank Transfer screen Fields and Tabs

Fields	Description
Transfer Number	The transfer number for the central bank transfer.
Fiscal Year	It allows the user to select the fiscal year for the Central Bank Transfer. The default fiscal year is the current fiscal year which is open for the regular transactions.
Fiscal Period	It allows the user to select the fiscal period for the Central Bank Transfer. The default fiscal period is the current fiscal year which is open for the regular transactions.
Workflow Status	It shows the Central Bank Transfer workflow status which is updated by the system according to the approval process completed.
Accounting Office	It allows entering the accounting office code for the CBT. The user can select the accounting office code using the lookup feature.
Treasury Bank Account	This box allows the user to enter the treasury bank account id for CBT. The User can select the treasury bank ID using the lookup button.
CBT Date	The date when the extract was created.
CBT Rejection Code	Rejection code received from Central Bank.
Language	The user can select the language using the drop-down button. The default language is English.
Description	The description for the CBT.
CBT Rejection Description	This attribute must be retrieved from the entity Transfer Rejection Classifier for the corresponding 'CBT Rejection Code' above
Currency	The currency for the CBT, the default currency is the domestic currency of the country.
Total Amount Domestic	The total calculated amount for the Central Bank Transfer in domestic currency.
Total Amount Foreign	The total calculated amount for the Central Bank Transfer in foreign currency if the user has selected the currency as foreign.
Created By	The user information of the CBT creator.
Creation Date	The date of the CBT creation the system fetch the current system date.
Approved By	The system populates the user information when CBT get approved.
Approved Date	The system fetches the date of the CBT approval.
Reference Number	The reference number of the CBT.
Origin	The default value is TEF, the possible values are TRL and TEF.
Is Confirmed	The default value is unchecked.
Rejection Code	The system shows the rejection code which is updated by the Commercial bank.
Rejection description	The description of the rejection of the Central Bank Transfer.
Transfer Number	The Transfer number of the CBT.
Is Reconciled	It is populated by reconciliation process. The default value is unchecked.
Reconciliation Serial Number	It Assigned by the reconciliation process. By default it is blank.
Reconciliation Date	Date of the reconciliation.
Reconciliation Type	The reconciliation type.
Is Rejected	TRUE when the attribute CBT Rejection Code above corresoponds to a record with 'Origin' = 'CENTRAL BANK' and 'Is success code' = FALSE. Otherwise this attribute must be set as FALSE.
Central Bank Transfer Detail Tab	This tab allows the user to add information about CBT Details.

Central Bank Transfer Detail tab

Overview

It allows the user to add the Central Bank Transfer Details.

Central Bank Transfer Details Screen Fields

Fields	Description
Serial Number	Auto-Generated Correlative Number .
Bank Account Destination	Bank Account Destination, populate from Branch Bank account.
Has Rejection	It will be received by Commercial Bank web service to indicate if the bank in the detail has at least one rejection.
Currency	Currency for the central bank transfer.
Amount Domestic	The total domestic amount.
Amount Foreign	The total foreign amount.

Moving Tax Exchange Records To Bank Statement

Overview:

This functionality is a complement for Web Service that receives Tax Exchange records. It is used for reconciliation purposes.

Navigation:

Treasury Management ► Payments ► Moving Tax Exchange Records To Bank Statement

Moving Tax Exchange Records To Bank Statement screen fields:

Fields	Description
Date to move	Date of Moving Tax Exchange Records To Bank Statement
Tax Exchange Record Details	Details of Tax Exchange Record

Update Commercial Bank Information for EFTs

Overview:

This functionality is to allow treasury users to update commercial bank information that could not be updated automatically from bank notification interface. This option will allow user to search and retrieve detailed information of a concrete EFT.

Navigation:

Treasury Management ► Payments ► Update Commercial Bank Information for EFTs

Update Commercial Bank Information for EFTs screen fields:

Fields	Description
Origin	Filter criteria for Origin of the Bank transfer. Must list 'TEF' or 'TRL' from the CBT records.
Transfer Number	Filter criteria for Central Bank Transfer Number. Must match a valid Confirmed CBT Application Id.
Bank	Filter criteria for Bank. List Financial Institution Names.
Commercial Bank Information Details	Bank Transfer voucher details.

Reports

All Payment Report

Overview

Information regarding payment made on the basis of Payment Order gets generated in this report.

Navigation

Fields of All Payment Report may be described as follows:

Fields	Description
Fiscal Year	Fiscal year for payment report is to be generated.
Fiscal Period	Fiscal period for which payment report is to be generated.
Status	Status of Payment Order.
Currency	Currency in which the payment was made.
Domestic Amount From	Starting range of amount for filtering report in domestic currency.
Domestic Amount To	Limit up to which amount is entered for filtering report in domestic currency.
Extract Number	Payment Extract Id number required for filtering data.
Treasury Bank Account	Treasury bank account from where the payment is made.
Vendor	Vendor to whom the payment is made.
Financial Institution	Bank/ Financial Institution from where the payment is made.
Financial Institution Branch	Branch of Bank from where the payment is made.
Accounting Office	Accounting Office related to the payment order.
Created By	User who created the Payment Order.
Expense Voucher	Expense Voucher for which the payment is made.
Payment Mode	Mode in which the payment is made to be selected from dropdown box.
Cheque Series	Series within which the issues cheque falls under.
Contract Number	Contract number is to be mentioned for filtering data.
Comment	Comment on the Report.
Cheque From Number	Cheque number of the first issued cheque required for report filtering.
Cheque To Number	Cheque number of the last issued cheque required for filtering purpose.
From Date	Date from which Payment made, is to be filtered for report purpose.
To Date	Date up to which Payment made, is to be made
Sort By	Sorting on the basis of which the report is to be filtered.

Cash Requirement Report

Overview

Cash Requirements Report displays the cash required to pay the Epense Vouchers which have been approved for payment.

Navigation

Fields of Cash Requirements Report may be described in the following lines:

Fields	Description
Report Type	Whther the report is a summary report or details report is selected in this field from dropdown box.
Vouchers On Hold	Whether the voucher are on hold for report purpose, is mentioned.
Fiscal Year	Fiscal Year for Cash Requirements Report generation.
Payment Due Date	Due date for payment is entered on the basis of which the report is generated.
Financial Institution	Bank from where the payment is to be made.
Financial Institution Branch	Branch of bank from where the payments are to be made.
Payment Date	Date of payment for Expense Voucher.
Vendor	Vendor who shall receive the payment.
Accounting Office	Acounting office for Payment Order.
Treasury Bank Account	Treasury bank account related with Payment Order.
Payment Location	Location where the payment is to be made.
Payment Method	Method of payment for Expense Voucher is selected for report generation.
Payment Mode	Mode of payment for Expense voucher is selected for report generation.
Comment	Comment for Report.
Sort By	Sorting the data for report generation.

Cheque Printing Report

Overview

Cheque Printing Report generates the information of cheques issued for payment in printed format.

Navigation

Treasury Management ► Payments ► Reports ► Cheque Printing Report.

Fields of Cheque Printing Report

Field	Description
Fiscal Year	Fiscal Year to which the cheques relate, to be selected from drop down box.
Payment Extract	Payment Extract, to be selected from lookup button.
Payment Extract Payment	Payment Extract Payment, to be selected from lookup button.
Treasury Bank Account	Treasury Bank Account, to be selected from lookup button.
Payment Type	Type of Payment made, to be selected from drop down box.
Cheque Series	Serial number to which the series of Cheque belong to.
Print Cheque From	Starting Serial number of Cheque number tobe printed.
Print Cheque To	End Serial number of Cheque number tobe printed.
Accounting Office	Accounting Office to which the cheque relate, to be selected from lookup button.
Vendor	Vendor to whom the payment to be made, to be selected from lookup button.
Release Date From	Starting Release date of cheque to be selected from calendar button.
Release Date To	End Release date of cheque to be selected from calendar button.
Expense Voucher	Expense Voucher to which Cheque relates to be selected from lookup button.
Number Of Payments	Number of Payment made is mentioned in this field by the system.
Amount of Payment Domestic	Amount of payment expressed in terms of domestic currency is mentioned in this field by the system.
Amount of Payment Foreign	Amount of payment expressed in terms of foriegn currency is mentioned in this field by the system.
Payment Extract Payment Detail	Payment Extract Payment Details records matching the above filter criteria to be retrieved by clicking on Retrieve button.

Cheque Reprinting Report

Overview

Cheque Reprinting Report is the standard method of printing cheques or generating Electronic Fund Transfer export files which have already been released.

Navigation

Treasury Management ► Payments ► Reports ► Cheque Reprinting Report

Cheque Reprinting Report screen Fields

Field	Description
Payment Extract	Payment Extract to be selected from lookup button.
Payment Extract Payment	Payment Extract Payment to be selected from lookup button.
Treasury Bank Account	Treasury Bank Account of Expense Voucher for which Cheques are issued.
Print Cheque From	Cheque number of first cheque in the series to be re-printed.
Print Cheque To	Cheque number of the last cheque in the series to be re-printed.
Release Date From	Release date of the first cheque in the series to be re-printed.
Release Date To	Release date of the last cheque in the series to be re-printed.
Expense Voucher	Expense Voucher for which Cheque requierd to be re-printed.

Draft Payment Report

Overview

Information regarding Draft Payment gets generated in Draft Payment Report.

Navigation

Fields of Draft Payment Report may be described in brief as follows:

Fields	Description
Fiscal Year	Fiscal year for which the Draft payment report is to be generated.
Fiscal Period From	The fiscal period from which the report is to be generated.
Fiscal Period To	The fiscal period to which the report is to be generated.
Extract	Relevant Payment Extract relating to which the report is to be generated.
Comment	Comment regarding the draft payment report is entered in this field.

Extract Status Report

Overview

Information regarding status of Payment Extract generated in this report.

Navigation

Fields of Extract Status Report may be described as follows:

Fields	Description
Fiscal Year	Fiscal year for which the status report for Payment Extract is to be generated.
Fiscal Period	Fiscal period relting to which the the status of Payment Extract is to be generated.
Extract Number	Payment Extract Id is to be chosen from lookup button.
Comment	Comment on report is to be made in this field.
From Date	Date from when the data for report will be filtered.
To Date	Date up to when the data for report will be filtered.
Sort By	Criteria on the basis of which the data will be sorted.

Laos Reports

Approved Payments Batch Report

Overview

Approved Payment Extracts in Batches are displayed in this report.

Navigation

Treasury Management ► Payments ► Reports ► Laos Reports ► Approved Payments Batch Report.

Approved Payments Batch Report Fields

Field	Description
Fiscal Year	Fiscal Year when the payment is approved, to be selected from drop down box.
Payment Extract Number	Payment Extract to be selected from lookup button.
Treasury Office	Treasury Office to be selected from lookup button.
Payment Type	Type of Payment to be selected from drop down box.
Currency	Currency to be selected from drop down box.
Comment	Comment on the report is entered by users in this field.

Payment Vouchers From Accounting Division To Bank

Overview

Payment sent to bank is generated from this report.

Navigation

Treasury Management ► Payments ► Reports ► Laos Reports ► Payments Sent to the Bank Report.

Payment Sent to the Bank Report Fields

Field	Description
Fiscal Year	Fiscal Year when the payment sent to bank relate, to be selected from drop down box.
Batch Date	Batch date of bank to be selected from calendar button.
Batch Number	Batch Number to be selected from dropdown box.
Treasury Bank Account	Treasury Bank Account to be selected from lookup button.
Treasury Office	Treasury Office to be selected from lookup box.
Payment Type	Payment Type to be selected from drop down box.
Currency	Currency to be selected from drop down box.
Comment	Comment on the report is entered by users in this field.

Transfer Payment Batch Report

Overview

The Transfer Payment Batches Report is the custom report for Laos. Its generate the payment batch report of monetery transfer between main bank account to secondary bank account, between secondarys from same father (main account).

Navigation

Treasury Management ► Payments ► Reports ► Laos Report ►Transfer Payment Batches Report.

Transfer Payment Batches Report Screen Fields and Tabs

Fields	Description
Fiscal Year	By Default Shows the current Fiscal year.
Treasury Bank Account	Treasury bank account unique identification number.
Treasury Office	Treasury office unique identification number.
Batch Date	By default curret date, User can change it.
Batch Number	Batch number for report generation.
Payment Type	Type of the payment.
Comment	Comment related with report
Sort By	For sorting the report information.
Clearing Note Date	Clearing note date.

Philippines Reports

Advice Of Checks Issued And Cancelled

Overview:

The ACIC is a report prepared and submitted at least daily by an agency/entity to the GSB (government Service Bank) to enable the payees to encash/negotiate the issued checks.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Advice Of Checks Issued And Cancelled

Advice Of Checks Issued And Cancelled Report screen fields:

Fields	Description
Fiscal Year	Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify. Mandatory parameter.
Treasury Bank	Filter Criteria for Treasury Bank Account. Mandatory parameter.
Bank Account	Filter criteria. Mandatory- Drop down to select Treasury Bank account number from the treasury bank account table
Release Date	Mandatory- Date picker, Allow selecting date single selection
ACIC No.	Filter criteria for payment extract ID.
Operating Unit	Optional - Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS.
Funding Source	Mandatory- Drop down to select Fund cluster from concept "Fund category" in the "Fund" Segment of UACS.

List Of Disbursement Vouchers Originated By FTD Report

Overview:

To list down the disbursement vouchers that FTD originated during the day; DVs are for fund transfers to cover subsidies to other government agencies and Internal Revenue Allotment (IRA); IRA is the budget for local government units (provinces, cities, barangays); Major user: Director - Accounting Services.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► List Of Disbursement Vouchers Originated By FTD Report

Advice Of Checks Issued And Cancelled Report screen fields:

Fields	Description
Fiscal Year	Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify. Mandatory parameter.
From Date	Filter to from date of the report.
To Date	Filter to To date of the report.
Entity Name	Mandatory - Allow Selection from concept "Operating Unit" in the "RESP_CNTR" Segment of COA. Derive the Agency Name from the Concept "Agency" which rolls up from "Operating unit". AND concept "RESP_CNTR" in the "RESP_CNTR" Segment of COA. First display the Agency Abbreviated Name followed by a (,) and then the operating unit Abbreviated Name; Display in header
Comments	Optional. For any comment in the output reports.

Summary List of Checks Issued

Overview:

This report is prepared on monthly basis against each ACIC based on fund cluster. This report is used internally and also send to COA for verification.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Summary List of Checks Issued

Advice Of Checks Issued And Cancelled Report screen fields:

Fields	Description
Fiscal Year	Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify. Mandatory parameter.
Date	Mandatory- Date picker, Allow to select date single selection.
Treasury Bank	Filter Criteria for Treasury Bank Account. Mandatory parameter.
Organization	Mandatory filter criteria- Allow to select from concept "Department" in the "Organisation" Segment of UACS. Derived Department name from the concept "Department" which rolls up from the agency.
Fund Cluster	Mandatory filter criteria- Drop down to select Fund cluster from concept "Fund Cluster" it is roll up from "Authorisation" in the Funding source segment of UACS.
Comments	Optional. For any comment in the output reports.

Report Of Cheques Issued

Overview:

This report shall be used by the Disbursing Officer to report daily or as often as necessary his/her disbursements made through checks. It shall include canceled cheques and be maintained by fund cluster.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Report Of Cheques Issued

Advice Of Cheques Issued And Cancelled Report screen fields:

Fields	Description
Fiscal Year	Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify. Mandatory parameter.
Treasury Bank	Filter Criteria for Treasury Bank Account. Mandatory parameter.
Bank Account	Filter criteria. Mandatory- Drop down to select Treasury Bank account number from the treasury bank account table
Organisation	Mandatory filter criteria- Allow to select from concept "Department" in the "Organisation" Segment of UACS. Derived Department name from the concept "Department" which rolls up from the agency.
Fund Cluster	Mandatory filter criteria- Drop down to select Fund cluster from concept "Fund Cluster" it is roll up from "Authorisation" in the Funding source segment of UACS.
Date	Mandatory- Date picker, Allow to select date single selection.
Comment	Optional. For any comment in the output reports.

SUMMARY OF LDDAP-ADAs ISSUED AND INVALIDATED ADA ENTRIES

Overview:

The SLIIAE is used by the Cash/Treasury Unit to summarize the LDDAP-ADA (Cheque) issued and the invalidated ADA (Cheque) entries.

It shall be prepared daily and supported with copy of the LDDAP-ADAs (Cheque). It is sending to the Bank along with LDDAP-ADA (Cheque).

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Summary Of LDDAP Issued And Invalidated ADA Report

Advice Of Checks Issued And Cancelled Report screen fields:

Fields	Description
Fiscal Year	Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify. Mandatory parameter.
SLIIAE Number	To Print the SLIAE Number in the output report.
Treasury Bank	Filter Criteria for Treasury Bank Account. Mandatory parameter.
Release Date	Mandatory- Date picker, Allow to select date single selection
Organization	Mandatory filter criteria- Allow to select from concept "Department" in the "Organisation" Segment of UACS. Derived Department name from the concept "Department" which rolls up from the agency.
Fund Cluster	Mandatory filter criteria- Drop down to select Fund cluster from concept "Fund Cluster" it is roll up from "Authorisation" in the Funding source segment of UACS.
Comments	Optional. For any comment in the output reports.

List of Monthly Fee Collection Per Ross Client Report

Overview:

The purpose of the report is to list down per ROSS client the monthly maintenance fee paid; ROSS client is considered as a customer from the customer table. Report will always show as on month.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ►List of Monthly Fee Collection Per Ross Client Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
Fiscal Period	Mandatory Filter criteria for fiscal period. By default show the current fiscal period. Based on requirement user can modify.
Organization	Mandatory filter for Organization.
Generic Subledger Type	Mandatory filter criteria for Generic Subledger Type.
Account of	Mandatory filter; allow to select one customer from lookup.
Comment	Comment for the output report.
Generic Subledger Register	Optional filter criteria for Generic Subledger Register - lookup for Multiple selection.

Interest Income Earned On Treasury Single Account Report

Overview:

The purpose of this report is to summarize per quarter the Gross Interest Income, Final Tax and Net Interest Income earned from its Treasury Single Account (TSA) in central bank; generated quarterly or monthly as needed; Central Bank gives interest quarterly; source document is bank statement Main Users: Deputy Treasury of the Philippines, Division Chief.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ►Interest Income Earned On Treasury Single Account Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
Date	Filter for cut-off date.
Organization	Mandatory filter for Organization.
Comment	Comment for the output report.

Aging of Cash Treasury Agency/Deposit Trust Report

Overview:

The purpose of this report is to provide the aging of the Cash Agency Deposits (whether special or trust).

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ►Aging of Cash Treasury Agency/Deposit Trust Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
Fiscal Period	Mandatory Filter criteria for fiscal period. By default show the current fiscal period. Based on requirement user can modify.
Organization	Mandatory filter for Organization.
GL Code	Filter for GL account code. Posible Values: Trust, Special, Both.
Comment	Comment for the output report.

Cash Treasury Agency Deposit Trust/Special

Overview:

The purpose of this is to provide Subsidiary Ledger balances to COA Resident Auditor; required annually and quarterly.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ►Cash Treasury Agency Deposit Trust/Special

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
As Of	Date filter for As Of date.
Organization	Mandatory filter for Organization.
Subobject Code	Mandatory filter criteria: Drop Down, Posible Values (10104030, 10104020)
Generic Subledger Type	Mandatory filter criteria for Generic Sub-ledger Type.
Comment	Comment for the output report.
Generic Subledger Register	Optional filter - Multiple selection for Generic Subledger Register.

Schedule of Sub Ledger

Overview:

To report monthly the transaction movements from beginning balance, total debits and credits and ending balance;

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ►Schedule of Sub Ledger

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
Fiscal Period	Mandatory Filter criteria for fiscal period. By default show the current fiscal period. Based on requirement user can modify.
Organisation	Mandatory filter for Organization.
Account Code	Mandatory: Look up, show the Subobject code and description from UACS. Single selection.
Sub Ledger Type	Mandatory filter criteria for Sub-ledger Type.
Comment	Comment for the output report.

Daily Cash Statement Report

Overview:

Purpose of this report is to monitor the ending balances of each cash and bank balances of the Government as of a certain date.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Daily Cash Statement Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
As of	Mandatory filter for the date.
Report Type	Mandatory filter criteria - Possible Values ('Summary', 'Details')
Organization	Filter criteria for Organization.
Comment	Comments for the output report.

Subsidiary Ledger Summary and Details Report

Overview:

This report is prepared to give details of the balances of the SLs per Subobject Code.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Subsidiary Ledger Summary and Details Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
From Date	Mandatory filter for the date - From Date Picker.
To Date	Mandatory filter for the date - To Date Picker.
Organization	Mandatory filter for Organization.
Report Type	Mandatory filter for report type - Possible Values ('Summary', 'Detail').
Include Beginning Balance	Mandatory filter criteria. This parameter indicates if the beginning balances will be displayed in the report.
Include Subtotals	This parameter will be enabled only if Report Type = 'Detail', this will indicate values for subtotals will be displayed in the report.
Generic Subledger Type	Mandatory filter criteria for Generic Subledger Type.
Comment	Comment for the output report.
Generic Subledger Register	Optional filter criteria for Generic Subledger Register - lookup for Multiple selection.

National Government Bank Accounts Report

Overview:

Since this report generates 5 different reports the purpose is multiple.

National Government Free Cash Account Balances purpose is To list down the bank accounts that are funded by loans and grants of bilateral/multilateral institutions.

National Government Cash MDS Account Balances purpose is To list down the bank accounts that are in the Modified Disbursement System (MDS) bank accounts; MDS bank accounts are used by spending agencies for their expenses; replenished regularly by BTr. Major user: Commission on Audit on annual, quarterly or as needed basis.

National Government Restricted Cash Account Balances purpose is To list down the restricted bank accounts; used for specific purpose. Major user: Commission on Audit.

National Government Bank Accounts - Working Funds purpose is To provide COA and other donors a list of working funds used in projects;

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► National Government Bank Accounts Report

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Report Type	Mandatory filter criteria - Possible Values ('Summary', 'Freebalance', 'MDS', 'Restricted Accounts',
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
As of	Mandatory filter for the date
Organization	Filter criteria for Organization.
Comments	Comments for the output report.
Bank Accounts	Lookup for filtering different Treasury Bank Account

Letter Authority

Overview:

The Letter Authority is a form used as a payment instruction the for bank to pay a particular vendor.

It is an authorization by a spending Agency to a bank to debit a specified amount to pay its creditors/payees.

Navigation:

Treasury Management ►Payments ►Reports ►Philippines Reports ► Letter Authority

List of Monthly Fee Collection Per Ross Client Report screen fields:

Fields	Description
Fiscal Year	Mandatory Filter criteria for fiscal year. By default show the current fiscal year. Based on requirement user can modify.
Fiscal Period	Mandatory Filter criteria for fiscal period. By default show the current fiscal period. Based on requirement user can modify.
Payment Extract Payment	Mandatory Filter criteria for Payment Extrract Payment.
Addressee Name	Mandatory. This is a string entered by the user for the output report.
Position Title	Mandatory. This is a string entered by the user for the output report.
Department Name	Mandatory. This is a string entered by the user for the output report.

Nicaragua Reports

Account Verification On Commercial Bank Report

Overview:

Navigation:

List of Monthly Fee Collection Per Ross Client Report screen fields:

Comparative Of Executed Cash Flow Report

Overview

Shows comparative information of the Executed Cash flow for two fiscal years at a set fiscal period.

Navigation

Cash Management ► Payments ► Reports ► Nicaragua Reports ► Comparative Of Executed CashFlow Report

Comparative Of Executed Cash Flow Report screen fields

Fields	Description
Fiscal Year	Fiscal Year filter for this report. It is a mandatory parameter.
Fiscal Period	Fiscal Period filter for this report. It is a non mandatory parameter.
Institution	Optional parameter. If left blank, all OCE/OEP institutions are taking into consideration. Users can only select valid OCE/OEP institutions.
Comment	Any comment to add in the output report.

Exchange Cheques Inconsistent And Conciliated Report

Overview

The purpose is to list of cheques reported through bank statement showing all that are conciliated or inconsistent (not conciliated).

A screenshot of the Exchange Cheques Inconsistent And Conciliated 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: Treasury Management ► Payment ► Reports ► Nicaragua Reports ► Exchange Cheques Inconsistent And Conciliated Report

Filters

Field	Description
Financial Institution	Lookup button to select Financial Institution for which users wants to view the consolidation report. It is a Non Mandatory field and users can select only a single value.
Treasury Bank	Lookup button to select Treasury Bank Account under the selected Financial Institution above for which users wants to view the consolidation report. It is a Non Mandatory field and users can select only a single value. Selection of TBA depends upon selection of the Currency.
State	Users can select any between following consolidation options: Conciliated, Inconsistent
No. Exchange	Users are allow to define the Exchange No. as a filter criteria.
No. Check	Users are allow to define the Check No. as a filter criteria.
Currency	Users are allow to select the Currency as a filter criteria.
Date From	Users can define the start date from where they want to generate the report. It is a mandatory field.
Date To	Users can define the end date to which they want to generate the report. It is a mandatory field.
Comment	Users can add custom comments which displays on the generated report as a reference.

Visible Fields

A sample of the Exchange Cheques Inconsistent And Conciliated Report output is available here. The following table lists and describes all visible fields for the Exchange Cheques Inconsistent And Conciliated 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	Displays the selected Fiscal year as filter criteria by user.
Filter Criteria	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Date From	The start date of the generated report data.
Date To	The end date of the generated report data.
Comments	Displays additional comments added by user.
No. Exchange	Exchange no. of the report of each data row of the generated report.
No. Check	Check no. of the report of each data row of the generated report.
Date	Date of the transcation displays in each row.
Currency	Currency of each transcation.
Credit Amount	Credit amout (if applicable) for each transaction.
Debit Amount	Debit amout (if applicable) for each transaction.

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

FreeBalance Help documentation for the Cash Planning module is included within.

Cash Planning

Entities list of cash planning.

Cash Planning Voucher

Overview

Cash planning voucher details are saved in this screen.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Cash Planning Voucher

Cash Planning Voucher screen Fields and Tabs

Fields	Descriptions
Code	Voucher unique id which is entered by the user or system generated. It depends on the system settings.
Workflow Status	The workflow status of the Cash Planning voucher. It depends on the workflow status settings. The value changes according to the approval. Possible values are Created, Approval Requested and Approved, etc.
Fiscal Year	The default value of the fiscal year is the current fiscal year which is open for the transactions. User can select it using the drop-down button.
Voucher Type	The type of cash planning voucher. The default value is Programming.
Posting Status	Posting status provides the status of the cash planning voucher. It is updated by the system when the voucher is either saved or temp saved.
Cash Plan Type	Cash plan type, it can be selected using the drop-down list.
Funding Source	The funding source for the cash planning voucher. User can select it using the lookup button feature or enter manually.
Copy Annual Programming	It is used to indicate if the Quarterly programming must be copied of Annual programming. By default, it is a read-only mode.
Not Posted Reason	The user will select a reason for not posting the voucher when the voucher is Temp Saved, the field should be cleared automatically when the voucher is completely saved.
Institution	The institution code for the cash planning voucher. The user can enter manually or select it using the lookup feature.
Voucher Date	It automatically fetches the system current date.
Temp Number	The serial number generated by the system when the voucher is Temp Saved status.
Language	The default language is English. User can change the language using the drop-down button.
Description	Description of the cash planning voucher.
Currency	By default, it shows the country's domestic currency. If the cash planning voucher is created with foreign currency user need to select it using the drop-down list.
Exchange Rate	It displays the active exchange rate for foreign currency. It fetch the exchange rate from the exchange table.
Is Consolidated	Value “True” indicates that the Cash Planning Voucher is consolidated in another (in superior level), “False” is not consolidated.
Programming to Reprogramming	Default value is zero.
Grouping Cash Planning Voucher	This attribute should be used to identify the document that groups or contains different Cash Planning vouchers.
Distributed	By default it is False. It indicates if the amount was distributed if the amount approved was different to request for higher level only. The system will update automatically.
Is Update Higher Level Budget Controls	An indicator to allow updating the higher level Cash Controls once the lower control is updated through this voucher.
Total Amount Requested(Domestic)	Total of Domestic Amount Requested of all line item. Default is Zero.
Total Amount Requested(Foreign)	Total of Foreign Amount Requested of all line item. Default is Zero.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all line item. Default is Zero
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all line item. Default is Zero
Consolidated Total Amount Approved(Domestic)	Total of Domestic Amount Consolidated and approved in the High level. Default is Zero
Consolidated Total Amount Approved(Foreign)	Total of Foreign Amount Consolidated and approved in the High level. Default is Zero
Created By	The user id of the creator, the system automatically displays the information.
Creation Date	Date of the Cash planning voucher creation.
Approved By	The user id of the approver. The system automatically fetches the approver information.
Approved Date	System fetch the current system date when Cash Planning Voucher got approved.
Is Consolidated to High Level	Value “True” indicates that the Cash Planning Voucher is consolidated in another (in superior level), “False” is not consolidated. The Default value is “False”.
Consolidated High Level Voucher	This attribute should be used to identify the document that groups or contains different Cash Planning vouchers consolidated to High Level.
Cash Planning Voucher Details	Collection of one or more line items of type Cash Plan Detail.

Cash Planning Voucher Details

Overview

This tab stores Cash Planning Voucher Details.

Cash Planning Voucher Details Screen and Tabs

Fields	Descriptions
Correlative	Auto-Generated Correlative Number.
Fiscal Period	Fiscal Period of the Cash Planning. User can select it using drop-down list.
Coding Block	The coding block structure for cash planning voucher.
Language	The default language is English. The user can select other language from the drop-down list.
Description	The small description related to cash planning voucher.
Total Amount Requested(Domestic)	The Total of Domestic Amount Requested of all Line Item Distribution. By default value is Zero.
Total Amount Requested(Foreign)	The Total of foreign Amount Requested of all Line Item Distribution. By default value is Zero.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all Line Item Distribution. Default value is Zero.
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all Line Item Distribution. Default value is Zero.
Consolidated Voucher Detail	Parent Voucher Detail.
Distributed	The default value is False. It Indicate if amount was distributed if the amount approved was different to requested.
Cash Planning Voucher Detail Distribution Tab	The tab allows to store cash planning voucher details.

Cash Planning Voucher Details Distribution

Overview

The tab store Cash Planning Voucher Details Distribution details.

Cash Planning Voucher Details Distribution Screen and Tabs

Fields	Distributions
Fiscal Period	Auto-Generated Correlative Number.
Total Amount Requested(Domestic)	The Total of Domestic Amount Requested of all Line Item Distribution. The default value is zreo.
Total Amount Requested(Foreign)	The Total of Foreign Amount Requested of all Line Item Distribution. The default value is zreo.
Total Amount Approved(Domestic)	The Total of Domestic Amount Approved of all Line Item Distribution. The default value is zreo.
Total Amount Approved(Foreign)	The Total of Foreign Amount Approved of all Line Item Distribution. The default value is zreo.

Consolidate Cash Planning Voucher

Overview

Allows user to create a consolidate cash planning vouchers at lower level.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Consolidate Cash Planning Voucher

Consolidate Cash Planning Voucher screen fields

Fields	Description
Voucher Type	Type of voucher can be selected from the dropdown list. It can be wither 'Programming' or 'Reprogramming'.
Budget Office	Budget Office to Consolidate can be selected using the lookup function. Syatem allows to filter by Parent level and display same and inferior levels (Childs).
Cash PlanType	Allows users to select the Cash Plan Type based selected Voucher type.
Currency	Applicable currency can be selected from the dropdown list.
Funding Source	Displays the funding source. It shows the Elements restricted to definition where Concept Id is equal to' Financing Source' parameter. If Cash Plan Type attribute selected on their Cash Plan Group attribute is 'Accounting' this attribute should be hidden and clear information selected it self.

Consolidate Cash Planning Voucher to High Level

Overview

Allows user to create a consolidate voucher to high level, grouping cash planning vouchers at next lower level, after create this new Cash Planning voucher system must update all Cash Planning voucher consolidated with the corresponding ID on Voucher.

Only the Cash Planning Voucher documents of Expenditures can be consolidated to high level (Institutional - Programming and reprogramming).

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Consolidate Cash Planning Voucher To High Level

Consolidate Cash Planning Voucher To High Level screen fields

Fields	Description
Voucher Type	Type of voucher can be selected from the dropdown list. It can be wither 'Programming' or 'Reprogramming'.
Budget Office	Budget Office to Consolidate can be selected using the lookup function. Syatem allows to filter by Parent level and display same and inferior levels (Childs).
Cash Planning Voucher Type	Allows users to select the Cash Plan Voucher Type based selected Voucher type.
Currency	Applicable currency can be selected from the dropdown list.
Funding Source	Displays the funding source. It shows the Elements restricted to definition where Concept Id is equal to' Financing Source' parameter. If Cash Plan Type attribute selected on their Cash Plan Group attribute is 'Accounting' this attribute should be hidden and clear information selected it self.

Import Cash Planning Voucher From Financial Programming Of Payments

Overview

The cash planning voucher using the data from budget control, the status of the workflow should be Approved.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Import Cash Planning Voucher From Financial Programming Of Payments

Import Cash Planning Voucher From Financial Programming of Payment screen Fields and Tabs

Fields	Descriptions
Source Fiscal Year	It is retrieved from the fiscal year, the fiscal year must be open for the transactions. The default value is the current fiscal year.
Source Budget Control Type	The budget control type. It can be selected from the drop-down list.
Institution Id	Institution code. It can be manually entered by the user or can select it with the lookup feature.
gea_CreateCashPlanningVoucherFrom FinancialProgrammingOfPayments_distributionMethod	It allows selecting the distribution method from the drop-down list. The possible value is "Pondered and First Period".
Cash Planning Voucher Type	It shows a list with Cash Plan Type.
Currency	It shows the country default currency which is active. It allows the users to select the other currency if the transaction is in foreign currency.
Funding Source	It displays the funding source.

Payment Quota Mapping

Overview

This entity allows user to allocate payment quota from one bank account to another bank account for a specific coding block. Using this entity, system creates a Bank Account Transfer described as below:

This process should be run through batch jobs, with the default scheduled day and time
System allow to select a TBA type main(physical / Secundary) and transfer to one or many TBA type secondary
System must create One Voucher by Accounting Office and TBA as per the quota mapping with Approved status
System must validate the current fiscal period is not processed yet
When BATV is approved (through BATV automatic WF) system will insert the current fiscal period on

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Payment Quota Mapping

Payment Quota Mapping screen fields

Fields	Description
Application ID	Unique code of each individual record. It can be either system generated or manual based on Appropriation parameters, if system generated then each voucher type will have different serial.
Fiscal Year	Current Fiscal year on which the mapping takes place.
Active	Indicate whether the record is active or not to use as a reference in other entities.
Source Bank Acocunt	Source Bank Account code can be selected using the lookup function from which the amount will be transferred.
Description	A description about the transfer.
Destination Bank Account tab	Destination Bank Account code can be added using the "Add New" button under the tab to which the amount will be transferred.

Planning through Implementing Agencies Voucher

Overview

This entity hepls the spending agencies to provide fund to the other Implementing Agencies for Cash Planning with following requirements:

This screen will be entered by Spending Agency which give funds to Implementing Agencies.
There should be a workflow process needs to be implemented.
This screen needs to include FR 208 Coding block and once the approval done from Spending Agency system needs to create commitment for that coding Block
Security needs to be skipped based on this FR 208 Control screen. That is once the FR 208 Control is approved, implementing agency users should have access to FR 208 Control coding Block

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Enable Planning Through Implementing Agencies

Planning through Implementing Agencies Voucher screen fields and tab

Fields	Description
Code	Unique identification, entered by the user
Workflow Status	Displays the current workflow status of the record. Depending on the workflow configuration setting, the basic stages are: Created, Request for Approval, Active.
Originating Institution	Originating Institution, a look up for selection of Institution is needed. By default current user's institutiion. User can update.
Amount	Voucher amount, calculated field. Read Only.
Coding Block	Coding Block Information.
Initiated Date	System given current date assigned automatically.
Description	Description of the record.
Created By	Name user who creates. Populated automatically by the system at creation time of the record.
Created Date	Read only. Will be automatically populated by the system at creation time of the record.
Approved By	Populated automatically by the system at approval time of the record.
Approved Date	Populated automatically by the system at approval time of the record.
Planning Through Implementing Agencies Details tab	This entity will record the information regarding the Implementing Agencies
Attachments tab	To add any related documents.

Planning through Implementing Agencies Detail

Overview

This entity will record the information regarding the Implementing Agencies

Planning through Implementing Agencies Detail screen fields

Fields	Description
Serial Number	Auto generated item serial number starts with 1 for each Journal Voucher
Implementing Agency	Implementing Institution can be selected using the lookup function.
Amount	Amount that Implementing Agency will manage.

Support Entities

Cash Planning Support entities.

Cash Planning Voucher Seasonality Factor

Overview

Stores the Seasonality factor of the Cash Planning Voucher.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Support Entities ► Cash Planning Voucher Seasonality Factor

Cash Planning Voucher Seasonality Factor screen Fields and Tabs

Fields	Descriptions
Application Id	Automatically assigned by the system or manually entered by the user, depending on the system parameter setting.
Fiscal Year	Fiscal Year of the Cash Planning, default current Fiscal Year. The fiscal year should be open for the transaction.
Fiscal Period	The default value is the current fiscal period. The fiscal period should be open for the transaction.
Cash Planning Voucher Type	This field should display the "Cash Planning voucher type".
Budget Office	Budget Office Code. By default use current employee institution.
Application Language	The default value is English. User can change it.
Description	Description relates to Cash Planning Voucher Seasonality Factor.
Currency	By default, this field displays the country domestic currency. If the transaction is in a foreign currency system allows selecting the foreign currency from the drop-down menu.
Coding Block	Coding block structure. User can select it using lookup feature.
Created By	The system automatically fetches the user id of the creator.
Created Date Time	The system automatically fetches the current date and time.
Cash Planning Voucher Seasonality Factor Distribution	Collection of one or more line items of Cash Planning Voucher Seasonality Factor Distribution.

Cash Planning Voucher Seasonality Factor Distribution

Overview

This tab storage the Seasonality factor of the Cash Planning Voucher.

Cash Planning Voucher Seasonality Factor screen Fields and Tabs

Fields	Descriptions
Correlative Id	A unique identification id.
Fiscal Period	It dispalys the current Fiscal period.
Percentage Factor	The percentage of the cash planning voucher seasonality factor.

Cash Planning Voucher Type

Overview

Cash Planning voucher type allows the users to classify Cash Planning Voucher for data entering, searching and reporting purposes. Examples of cash plan types can be Annual Cash Planning for Revenues, Annual Cash Planning for Expenditures, Monthly Cash Planning for Revenues, etc.

Navigation

Treasury Management ► Cash Planning ► Cash Planning ► Support Entities ► Cash Planning Voucher Type

Cash Planning Voucher Type screen Fields and Tabs

Fields	Descriptions
Id	Automatically assigned by the system or manually entered by the user, depending on the system parameter.
Active	The default value is true. If this is False, then this Cash Plan Type cannot be used in future transactions
Language	The Default value is English. The user can change the language.
Name	Name of the Cash Planning Voucher Type.
Description	Description of Cash Planning Voucher Type.
Budget Control Type	Limited to Budget Control Type Where Used to Create Manual Cash Planning Voucher True.
Period Level	Period Level Which Cash Plan Type will use.
Cash Plan Group	The cash plan group by default value is Revenues.
Voucher Execution Type	The voucher execution type. The possible values are 'PROGRAMMING OF PAYMENTS', 'PROGRAMMING OF REVENUES', and 'REPROGRAMMING OF PAYMENTS', etc.
Is ApplySeasonality Factor	The default value is False. If user make it false then it would be not applied for seasonality factor.

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

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.

Bank Reconciliation

Overview

The Bank Reconciliation process focuses on reconciling the Bank transactions which are imported from the Bank Statement with the relevant General Leger transaction in the Journal Voucher Item entity (Cash Book).

In the Financial System, when any transaction is posted against a Bank Account, the system creates a Journal Voucher which debits or credits the Coding Block related to the Treasury Bank Account (through the GL offset code). For example, when users create a Receipt Voucher when the money is deposited in a specific Treasury Bank Account against a revenue item, the system creates a Journal Voucher to debit the Bank Account Coding Block of the Treasury Bank Account (each Treasury Bank Account is linked to GL Offset Code which is by itself linked to Coding Block) to record the deposited amount, and the offset Credit side of the Journal Voucher is the revenue item.

At the same time, when the money is deposited in the bank, the bank records this transaction as Credit to the Bank Account i.e. the deposited amount is recorded as Debit in the Government’s books and Credit in the Bank’s books.

The objectives of Bank Reconciliation are to make sure that the JV entries related to the Bank Accounts in the Government’s books (in the above example the Debit amount of the JV) has been realized and recorded in the Bank’s books and vice versa.

Navigation

Treasury Management ► Bank Reconciliation ► Bank Reconciliation

Bank Reconciliation screen fields and Tab

Fields	Description
Reconciliation Source	Unique identification number will show after selection of reconciliation source.
Treassury Bank Account	The Treasury Bank Account for which the reconciliation is been done.
Fiscal Year	Fiscal year related to Bank Reconciliation is to be made.
Fiscal Period	Fiscal period name related to Bank Reconciliation is made.

Bank Reconciliation Process

Overview

The Bank Reconciliation process is basically about reconciling the Bank transactions which will be imported from the Bank Statement with the relevant General Ledger transaction in the Journal Voucher Item entity (Cash Book).

Navigation

Treasury Management ► Bank Reconciliation ► Bank Reconciliation Process

Bank Reconciliation Process screen fields and Tab

Fields	Description
Application ID	User-defined, unique ID. Code of transaction type contained in the Bank statements. Manually entered by users.
Reconciliation Transaction Type	The type of the Journal Voucher used in transaction. The Possible values are Cheque, Deposit, and Adjustment etc.
Reconciliation Type	Type of reconciliation can be selected from the dropdown list. It can be Manual or Auomatic.
Reconciliation Process Type	Type of reconciliation process can be selected from the dropdown list.
Language	Users can lookup and select the country specific Language to register the abbreviation and description from drop down list.
Description	Users can enter brief description of the reconciliation transaction type.

Bank Statements

Overview

Bank Statement refers to the statement sent by bank showing the past transactions regarding deposits, withdrawals and standing balance as on the date specified.

Navigation

Treasury Management ► Bank Reconciliation ► Bank Statements

Bank Statement screen fields and Tab

Fields	Description
Fiscal Year	Fiscal year to which Bank Statement relates.
Fiscal Period	Fiscal period to which Bank Statement relates.
Reconciliation Source	Reconciliation Source is to be selected which defines the Treasury Bank Account for which reconciliation process is carried on.
Treasury Bank Account	Treasury Bank Account for reconcililation is made.
Treasury Bank Account Number	Treasury Bank Account number for reconcililation is made.
Financial Institution Name	The name of the financial institute
Batch Number	Batch number of Bank Statement.
Start Date	Start date of bank statement.
End Date	End date of bank statement.
Opening Balance	Opening balance of account.
Closing Balance	Closing balance of account.
Total Debit	Total debit balance.
Total Credit	Total credit balance.
Bank Statement Fiscal Year	Fiscal year of the bank statement.
External Batch ID	External batch Id of bank statement.
Reference Number	Reference number of bank statement.
File Name	File name of Bank statement which is to be imported.
Imported By	By whom file is imported.
Import Date	Date of import of file.

Error Log

Overview

This entity will be used to register failure messages that occur during the update process of Bank Accounts. The entity is updated from the processes and validations executed by the Web Service.

Navigation

Treasury Management ► Bank Reconciliation ► Error Log

Error Log screen fields and Tab

Fields	Description
Is Active	If it is checked, it indicates that records are available
Origin	Select the value from a drop down option
Financial Institution	Display a list of values of available Financial Institutions name
Creation Date	Date and Time in which the update failure occurs
Transaction Date	Browse for a bank statement file to import. It is a mandatory field
Error Code	Error code assigned by the system based on the error codes definition in valudation rules.
Error Description	Error description that corresponds to the code.

Reconciliation Predefinied Transaction

Overview

The reconciliation transactions received through the bank statements will be able to be reconciled among bank statements only, is not needed to reconcile agains the JV records. In order to determine the reconciliation transaction type is necessary to predefine the combination of transaction types that are able to be reconciled by a user.

Navigation

Treasury Management ► Bank Reconciliation ► Reconciliation Predefinied Transaction

Reconciliation Prdefined Transaction screen fields and Tab

Fields	Description
Code	User-defined, unique ID. Code of reconciliation source. Manually entered by users.
Language	Country specific language used to enter the description information. Users can lookup and select language from drop down list.
Abbreviation	The detailed description of the Reconciliation Predefined Transaction.
Reconciliation Transaction Type for Debits	Display a list of values of Transaction type applicaton ID and Abbreviation.
Reconciliation Transaction Type for Credits	Display a list of values of Transaction type applicaton ID and Abbreviation.
Active	If checked, indicates that the Reconciliation Transaction Predefined is active and available for use.

Reconciliation Source

Overview

A Reconciliation Source is the source that performs a Bank Reconciliation. The reconciliation of data can be performed by either a bank or a group of banks. Groups of banks are linked together by a common object code.

Navigation

Treasury Management ► Bank Reconciliation ► Reconciliation Source

Reconciliation Source screen fields and Tab

Fields	Description
Code	Unique identification code manually entered by the user.
Reconciliation Source Type	Type of the Reconciliation Source whether it is from ‘Bank Account’ or ‘Object Code’.
Treasury Bank Account	Corresponds to the ID of the Treasury Bank Account. System will allow selecting Treasury Bank Account when type of Treasury Bank Account is "Physical".
Object Code	Automatically populated when user selects Treasury Bank Account. Value is the object code element of the coding block referenced by the selected Treasury Bank Account’s GL Offset Code.
Institution	The code of the ministry or office for which the reconciliation is done.
Language	Language used to describe Reconciliation Source.
Description	Description of Reconciliation Source.
Currency	Corresponds to the currency of the Treasury Bank Account.
Financial Institution	Display only field, automatically populated from Treasury Bank Account Id.
Branch Code	Display only field, automatically populated from Treasury Bank Account Id.
Bank Account	Display only field, automatically populated from Treasury Bank Account and reference to Bank Account entity.
Active	True by default, if user switches this to False, this record can no be used in future transactions other than just reference.

Reconciliation Statement Import

Overview

Users will be able to import the detailed information from bank statements. This includes the bank account information, the deposits received by the bank, the checks cleared, service fees, interest and the bank adjustments. The file structure for the bank statement must confirm to the formats pre-defined. The import will consist of 2 import text files having file names ending with BANKHDR.txt and BANKITM.txt. The two files will be compressed together in .zip format for import into the application.

Navigation

Treasury Management ► Bank Reconciliation ► Reconciliation Statement Import

Reconciliation Statement Import Screen Fields and Tab

Fields	Description
User	System user name will be displayed.
Batch Number	First Batch number start with 1. Every time an import is succesfully finished, the system will increment this number by 1.
Upload File	When the user clicks the ‘Choose File’ button, a file dialog window will be shown, allowing the user to select any file with an extension = “.zip”.

Reconciliation Transaction Type

Overview

Transactions received through the bank statements gets identified by a Reconciliation Transaction Type. These types will identify the Journal voucher type to reconcile with automatically, and is also used to determine the JV template which will be used for any accounting entries that need to be created when the reconciliation process is executed.

Navigation

Reconciliation Transaction Type screen include the following fields:

Fields	Description
Code	Code of transaction type contained in the Bank Statements which is manually entered by the user.
Language	Language used to describe Reconciliation Transaction Type.
Abbreviation	Abbreviation of transaction type contained in the Bank Statement.
Description	Brief description of the Reconciliation Transaction Type.
Transaction Type	Brief description of the reconciliation transaction type. Options are: Balance, Debit and Credit.
Journal Voucher Type	Journal Voucher Type is to be selected. Possible values: Adjustment, cheque, deposit, etc.

Reconciliation among Bank Statement

Overview

This process intented to generate automatically a Bank Account Transfer Voucher originated from the Manual Bank Reconciliation process. This process will use two data set from bank statements, and will be for Domestic and Foreign Currency. This process also will be able to unreconcile the bank reconciliation items and to generate a reversal Bank Account Transfer Voucher.

Navigation

Treasury Management ► Bank Reconciliation ► Reconciliation among Bank Statement

Reconciliation among Bank Statement screen fields and Tab

Credit

Fields	Description
Fiscal Year	Fiscal year related to which Bank Reconciliation is to be made.
Financial Institution	Display a list of values of available Financial Institutions name.
Reconciliation Predefined Transaction	Reconciliation transactions received through the bank statements will be able to be reconciled among bank statements only, is not needed to reconcile agains the JV records.
Currency	The currency of the Reconciliation Source.
Treassury Bank Account	The Treasury Bank Account for which the reconciliation is been done.
Date From	Current Date from which the records will generate.
Date To	Date to which the records will generate. Should be greated than the current date
Is Recociled	If it is yes then it is recociled.

Debit

Fields	Description
Financial Institution	Display a list of values of available Financial Institutions name.
Treasury Bank Account	System will show only Treasury bank accounts related to Financial Institution.
Date From	Current Date from which the records will generate.
Date To	Date to which the records will generate. Should be greated than the current date

Reject Bank Statement Record

Overview

The purpose of this functionality is to allow the user to reject a group of bank reconciliation records received through the Bank Statement Web Service. The group of records must be filtered by bank and account. The screen will retrieve the records for those filters with the latest date received, no other previous date may be retrieved for rejection.

Navigation

Treasury Management ► Bank Reconciliation ► Reject Bank Statement Record

Reject Bank Statement Record screen fields and Tab

Fields	Description
Bank	Select the Bank from the existing list by clicking on the look up button.
Bank Name	Display the name of the selected Financial Institution.
Treasury Bank Account	Treasury Bank Account Number existing in Bank Reconciliation entities for the Financial Institution.
Financial Institution	Display a list of values of available Financial Institutions name.
Rejection reason	Short description.
Start Date	Date and Time in which the update failure occurs.

Reports

Bank Reconciliation Report

Overview

The purpose of the "Bank Reconciliation Report" is to display a Bank Statement And Cash Book of the Reconciled transactions.

Navigation

Bank Reconciliation Report include the following fields:

Fields	Description
Fiscal Year	Fiscal Year to which Bank Reconciliation relates.
Fiscal Period	Fiscal Period to which Bank Reconciliation relates.
Reconciliation Source	Reconciliation Source is to be selected.
Comment	Comment on the report is to be made in this field.

Bank Reconciliation Summary Report

Overview

This report shows the data from the Journal Voucher Items that correlate to or not to a record (i.e is not reconciled) with a record in the Bank Reconciliation Items table, and also which Bank Reconciliation items that correlate or not with Journal Voucher Items. The JV Items and Bank Reconciliation Items are then grouped according to type to display the Deposits section, the Cheque section and the Adjustments section.

The purpose of the "Bank Reconciliation Summary Report" is to display the Current Balance in the Bank and Unreconcilled transactions and the calculated balance.

Navigation

Treasury Management ►Bank Reconciliation ►Report ►Bank Reconciliation Summary Report

Bank Reconciliation Summary Report screen fields and Tab

Field	Description
Fiscal Year	By default it shows the current fiscal year
Financial Institution	It provides the User's Employee's Institution
Financial Institution Branch	It provides the User's Employee's Institution branch.
Treasury Bank Account	Name of the associated Treasury Bank Account
Comment	Comment regarding the report.

Bank Reconcilled Transactions Report

Overview

The purpose of the "Bank Reconciled Transactions Report" is to display a Bank Statement and Cash Book of the reconciled transactions.

Navigation

Treasury Management ►Bank Reconcilation ► Reports ► Bank Reconcilled Transactions Report

Bank Reconciled Transactions Report screen fields and Tab

Fields	Description
Fiscal Year	By Default Shows the current Fiscal year.
Period Range Type	Range for the report. Possible values are Daily, Monthly.
Start Date	Start date of the transaction. By default, it show the current date.
End Date	End date of the transaction. By default, it show the current date.
Treasury Bank Account	Treasury bank account unique identification number.
Rec Method	Reconciliation method i.e. Manual or Automatic.
Reconciliation Batch Number	It show the batch number. Every time an import is successfully finished, the system will increment this number by 1.
Comment	Comment related to the report.
Reconciliation Type	Different Reconciliation Type name.

Bank Statement Report

Overview

The purpose of the "Bank Statement Report" is to display a Bank Statement sent by the bank.This report displays the data for the Bank Statements (Bank Reconcillation And Bank Reconcillation Item)

Navigation

Treasury Management ►Bank Reconcilation ► Report ► Bank Statement Report

Bank Statement Report screen fields and Tab

Field	Description
Fiscal Year	By default shows the current fiscal year.
Period Range Type	It is a closed domain whose possible values are (Daily, Monthly).
Start Date	Start date of the bank statement .
End Date	End date of the bank statement .
Treasury Bank Account	Name of the associated treasury bank account
Comment	Comment related to the report.

Bank Transaction Summary Report

Overview

The purpose of the "Bank Reconciliation Summary Report" will display the current balance in the bank and unreconciled transactions and the calculated balance.

Navigation

Bank Transaction Summary Report include the following fields:

Fields	Description
Fiscal Year	Fiscal year to which the bank transactions relate.
Fiscal Period	Fiscal period to which the bank transactions relate.
Reconciliation Source	Reconciliation Source is to slected for which the report is to be generated.
Comment	Comment on the report is entered in this field.

Bank Unreconciled Transactions Report

Overview

The purpose of the "Bank Unreconciled Transaction Report" is to display a un-reconciled Bank Statement.

Navigation

Treasury Management ►Bank Reconcilation ► Reports ► Bank Unreconcilled Transactions Report

Bank Unreconciled Transactions Report screen fields and Tab

Fields	Description
Fiscal Year	By Default Shows the current Fiscal year.
From Date	From date should be the transaction date or less than the transaction date.
To Date	To date should be the transactions date or greater than the transaction date.
Treasury Bank Account	Treasury bank account unique identification number.
Reconciliation Type	Diffrent Reconciliation type name.
Comment	Comment related to the report.

Cash Book Unreconciled Transaction Report

Overview

The purpose of the Cash Book Unreconciled Transactions Report is to display the unreconiled transactions from the Cash Book.

Navigation

Treasury Management ► Bank Reconciliation ► Reports ► Cash Book Unreconciled Transactions Report

Cash Book Unreconcield Transaction Report Screen Fields and Tab

Report Field	Description
Fiscal Year	Default Current Fiscal Year. Can select from the dropdown menu
From Date	By default system date will show. It should greater than equal(>=) to date of approval.
To Date	By default it show current system date, It should not higher than the current system date. To date should be less than equal to(<=) "To date".
Treasury Bank Account	Treasury bank account unique id.
Comment	Comment related with the report.
Transaction Type	Transaction type used to sort the report information.

Multi Bank Account Transfer

Imprest Release

Overview

It enables the system to record Multi Transfers with reference to imprest control, it is generated by the business process.

Navigation

Treasury Management ► Multi Bank Account Transfer ► Imprest Release

Imprest Release Screen and Tabs

Fields	Descriptions
Application Id	Unique identification code for Imprest Release.
Workflow Status	The workflow status of the Imprest Release. It update automatically when it got approved.
Fiscal Year	The default value is the current fiscal year, which should be open for the transaction.
Fiscal Period	The default value is the current fiscal period, it should be open for the transaction.
Accounting Office	The accounting office institute code for the Imprest Release. The budget office is responsible for the Multi-Bank Account Transfer Utility With Transaction Log.
Source Treasury Bank Account	Source bank accounts for the Imprest Release.
Source Tba Group	The source Bank Account Group.
Destination Treasury Bank Account	The destination bank Account for the Imprest Release.
Destination Tba Group	The destination Bank Account Group.
Bank Account Transfer Voucher	It stores the Bank account transfer voucher generated for this request.
Imprest Control	The Imprest Control instance for the MTBU transaction.
Language	The default language is English. User can select another language from the drop-down list.
Description	The description is related to Imprest Release.
Created By	The user ID who has created the Imprest Release. It is automatically fetched by the system.
Created Date Time	The current system date automatically fetched by the system.
Approved By	The user ID of the approver. The system automatically fetches this information when Imprest got to approve.
Approved Date Time	The current system date fetched by the system when it got approved.
Imprest Release Item	This tab allows storing the Imprest Release item details.

Cash Book

Cash Book Diary

Overview

Cash Book Diary allow users to record any transaction related with Treasury bank Account. All TBA are configured to generate Cash Book whenever any transaction got posted. Cash Book also updates the TBA Debit, Credit and Balance amount after every transaction got posted.

Navigation

Treasury Management ► Cash Book ► Cash Book Diary

Cash Book Diary screen fields

Fields	Description
Code	It is auto-generated by the system.
Treasury Bank Account	Related TBA can be selected using lookup function. All the details of the TBA can be seen upon selecting the required record.
Origin	Origin of the Cash Book can be selected from the dropdown list.
Domestic Debit Amount	Display field shows the Total Domestic Debit amount of all line item. Default is Zero.
Foreign Debit Amount	Display field shows the Total Foreign Debit amount of all line item. Default is Zero.
Domestic Credit Amount	Display field shows the Total Domestic Credit amount of all line item. Default is Zero.
Foreign Credit Amount	Display field shows the Total Domestic Credit amount of all line item. Default is Zero.
Voucher Reference Id	Reference of Voucher if it is automatic (EV, JV, PEP).
Issue Date	Automatic / system date is shown based on the transaction.
Currency	To allow the user to select the Voucher Currency. Default is Domestic Currency. If the general parameter 'System Accepts Multi-currency Transactions' is False, then this field will be disabled and it's value is Domestic Currency.
Exchange Rate	Shows the latest active exchange rate for the selected currency which is linked to the Appropriations, users can change the rate if allowed in the Appropriations parameters, otherwise this field will be ‘Display only’ and updated only by the system when the currency is selected. Default is 1 (because default currency is Domestic). If the general parameter 'System Accepts Multi-currency Transactions' is False, then this field will be disabled.
Expense Voucher Id	Based on selected Origin (Expense Voucher), Expense Voucher ID is shown here automatically.
Journal Voucher Id	Based on selected Origin (Journal Voucher), Journal Voucher ID is shown here automatically.
Revenue Voucher Id	Based on selected Origin (Revenue Voucher), Revenue Voucher ID is shown here automatically.
Payment Extract Voucher Id	Based on selected Origin (Payment Extract Payment), Payment Extract Payment ID is shown here automatically.

Payment Tracking

Payment Request

Overview

After payment order gets approved and cash plan process has been finished, Payment request is prepared.

Navigation

Payment Request screen include the following fields:

Fields	Description
Id	Unique identification code of Payment Request.
Workflow Status	Status of the Payment order is shown in this field. For example, Request for approval, paid, approved, created, delivered, etc.
Workflow Process Status	Workflow process status is shown in this field. For example, paid (en), cancelled (en), appproved (en), etc.
Payment Request Type	Type of request for payment is selected in this field. For example, Direct payment for goods and services, payment for salary and wages, payment for pocurement, etc.
Institution	Institution for payment request is selected from the lookup box.
Vendor	Vendor to whom the payment is to be made is to be selected from the lookup button.
Vendor Name	Name of Vendor is mentioned in this field.
Currency	Currency in which payment request is made, which may be domestic currency or any other foriegn currency.
Invoice Number	Invoice number against which the payment request is prepared.
Amount Claimed	Amount claimed by Vendor is shown in this field by system.
Deduction Percentage	Deduction percentage of the invoice amount while making payment request.
Deduction Penalty	Penalty amount to be deducted is shown in this field.
Deduction Amount	Amount od deduction is calculated and shown in this field.
Deduction Penalty Amount	Amount of deduction for penalty is shown in this field.
Net Amount	Net amount for payment request is made after deducting the amount for penalty.
Drafted By	User by whom the draft for payment request is made.
Drafted By Role	Role of the user who prepared the draft. For example, administrative user.
Certified By	By which user has the payment request been certified.
Certified By Role	Role of the user by whom the payment request has been certified.
Approved By	User by whom the payment request has been certified.
Approved By Role	Role of the user by whom payment request has been approved.
Contract Number	Contract number for which payment request is prepared.
Language	Language used to describe Payment request.
Description	Description of Payment Request.
Payment Request Details	Details of the Payment request is shown under this tab.
Attachment	Any attachment regarding Payment request is made in this tab.

Payment Request Batch Generation

Overview

Payment Request Batch Generation is a batch generation process.This is required by the users in Front Office, Middle Offices and Back office to receive the PRT's in batches .The list of all PRT's assigned to a particular user needs to be generated on the page with the option to select particular PRT's and execute the 'Receive' transitions.

Navigation

Treasury Management ► Payment Tracking ► Payment Request Batch Generation

Payment Request Batch Generation Fields and tab

Field	Description
Fiscal Year	This field by default represenst the current fiscal year.
Batch Date	The date corresponding to the batch generation.
Generated by	This field states the current user by default.
Origin	It defines the origin type for example Manual,Commitment and Contract Management.
From Stage	It defines the stage from which the batch generation will be classified.
To Stage	It defines the stage from upto which the batch generation will be classified.
Payment Request Type	This is an optional field which states the Payment Request Type
Vendor	This is an optional field which denotes the Vendor related.
Institution	This is an optional field which denotes the Institution related to the Payment Request Batch Process.
Net Amount From	While the 'Net Amount From and To' are entered, system validates that 'Net Amount To' is equal or higher than 'Net Amount From'. In any case negative amounts are allowed.
Net Amount To	While the 'Net Amount From and To' are entered, system validates that 'Net Amount To' is equal or higher than 'Net Amount From'. In any case negative amounts are allowed.

Payment Tracking Reports

Payment Request Process Report

Overview

Listing a Payment Request status, workflow information, documents related like commitment, obligation, Expense Voucher, Payment, etc. are shown in this report. This report has two parts, Detailed Report and Summary Report.

Navigation

Payment Request Process Report screen include the following fields:

Fields	Description
Report Type	Type of report: Details or Summary is to be selected
Payment Request	Payment request for which the report is to be generated.
Payment Request Type	Type of Payment request is selected. Types may be: Direct payment for goods and services, payment for procurement, apyment for salaries and wages and Apyment per attached list.
Payment Request Status	Status of Payment request is selected. Status options are: Created, cashed, paid, received, approved, etc.
Request Date From	Date from which payment request for report generation are to be selected.
Request Date To	Date upto which payment request for report generation are to be selected.
From Date	Date from which data is to be selected.
To Date	Date up to which data is to be selected.
Vendor	Vendor to whom payment is to be made.
Budget Office	Budget office for Payment request is to be selected.
User	User by whom Payment request is made, to be selected.
Fiscal Year	Fiscal year to which the Payment Request relates.
Fiscal Period	Fiscal period to which the payment request relates.
Is Range	Whether the Payment request relates a range of purchase order.
PO Number From	Id of Payment order from which the Payment request relates.
PO Number To	Id of Payment order up to which the Payment request relates.
Is Range	Whether the Payment request relates a range of Commitment form.
CPV Number From	Id of Commitment form from which the Commitment form relates.
CPV Number To	Id of Commitment form up to which the Commitment form relates.
Expense Voucher	Expense Voucher to which Payment request relates, is selected in this field.
Check Number	Number of check is entered in this field.
Coding Block Filter Type	Type of coding block with which data is to be filtered. For example, coding block expression filter, hierarchical coding block element and coding block.

Payment Request Tracking for Line Ministry Report

Overview

Listing of Payment Request status, workflow information, documents related like Commitment, Obligation, Expense Voucher, Payments, etc. for Line Ministries are genrated from this report.

Navigation

Payment Request Tracking For Line Ministry Report screen include the following fields:

Fields	Description
Fiscal Year	Fiscal year to which Payment Request relate, is selected.
Payment Request Type	Whether the type of Payment Request is: Direct Payment for goods and Services, Payment for Procurement, payment for salary and Wages, payment per attached list, is selected.
Payment Request Status	Status of Payment Request is selected for report generation purpose. Status may be: By Front Office, in back Office TPO Issue, In Front office, Line ministry, etc.
Payment Request	Payment Request for which report is to be generated, is selected from the lookup button.
Vendor	Vendor to whom payment is to be made, is selected from lookup button.
Budget Office	Budget Office to which the Payment Request relates.
User	User by whom Payment Request has been approved.
From Date	Date from which Payment Request is to be selected for report generation.
To Date	Date upto which Payment Request is to be selected for report generation.
Is Range	Whether Payment Request falls within Commitment Form range, is checked.
CPV Number From	Number of Commitment form from which the range begins.
CPV Number To	Number of Commitment form up to which the range ends.

Payment Request by User Report

Overview

This Report provide the Summary report as well as Details report for the user. It consists of the total number of Payment Requests for each user in Front Office, Middle offices and Back Office in the summary report. For the details report, it consists of Front Office, Middle offices and Back Office with workflow status.

Navigation

Treasury Management ► Payment Tracking ► Payment Tracking Report ►Payment Request by User Report

Payment Request by User Report Screen Fields and Tabs

Fields	Descriptions
Report Type	It allows the user to select the type of report they want to generate i.e. Summary or Details report.
Fiscal Year	It displays a List of Fiscal Years in the system. The Default value is the current fiscal year.
Payment Request Type	Type of the payment request.
Payment Request Status	Payment Request status.
Payment Request	Payment request information. The users can select the payment request using the lookup button or user can enter the payment request details.
Vendor	Vendor details select from the lookup button or user can provide the vendor code in the input field.
Budget Office	It captures the budget office details from the commitment.
User	The user detail display in the field.
Payment Request Date From	The payment date starts From. The user selects the date using the calendar feature.
Payment Request Date To	The payment date starts To. The user selects the date using the calendar feature.
Sort By	It displays the information about the report sorting.
User Name	Sort by the user.
Status	Sort by Status.

Payment Tracking Management Report

Overview

Listing of Payment Request status, workflow information, documents related like Commitment, Obligation, Expense Voucher, Payments, etc. in order to track payment in Treasury Managment is generated as report from this screen.

Navigation

Payment Tracking Management Report screen include the following fields:

Fields	Description
Fiscal Year	Fiscal year for which Payment Tracking management report is to be generated.
Fiscal Period From	Fiscal period from when Payment Tracking management report is to be generated.
Fiscal Period To	Fiscal period up to when Payment Tracking management report is to be generated.
Payment Request Type	Type of Payment request is to be selected. Options are: Direct Payment for goods and services, Payment for procurement, Payment for Salary and Wages, Payment per attached list.
Payment Request Status	Status of Payment Request is to be selected. Options are: By Front Office, In Front Office, Line Ministry, etc.
Payment Request	Payment Request is to be selected from lookup button.
Vendor	Vendor to whom payment is to be made, is to be selected from the lookup button.
Budget Office	Budget Office to which Payment Request relates, is to be selected.
User	User by whom payment request is approved.
Request Date From	Payment Request date from when data are to be retrieved for report generation.
Request Date To	Payment request date up to when data are o be retrieved for report generation.
Is Range	Whether purchase order is in range for report generation purpose.
PO Number From	Id number of Purchase Order from which the range starts.
PO Number To	Id nummber of Purchase Order up to which the range lasts.
Is Range	Whether Commitment form falls within range for report generation.
CPV Number From	Id number of Commitment form which the range starts.
CPV Number To	Id numnber of Commitment form up to which the range lasts.

BCTL

Montran Message Log

Overview

This feature allows the system to store all exchanged messages between GRP and Montran Gateway. Users can view the timestamp of a message, the original message, the direction of the message (Montran to GRP or GRP to Montran), the error message, the payment associated with a message etc... It automatically fetches the information by STP sending and receiving messages process.

Navigation

Treasury Management ► BCTL ► Montran Message Log

Montran Message Log Screen Fields and Tabs

Fields	Description
Application ID	It is automatically generated a unique ID that identifies the Montran message log in the system.
Message Reference	This is for message reference of montran message log. It identifies the message on Montran Gateway.
Montran Message Type	The Montran Message type (supported by the Montran and ISO 20022). Drop-down allows selecting the message type i.e. ACH PACS002, ACH PACS008 etc..
Montran Message Direction	It shows the direction of the Montran Message. The message is received or sent.
Error Message	It keeps track of the error message in case of any error.
Created On	It shows the Date and Timestamp of creation.
Created By	The ID of the creator who created the message.
Treasury Bank Account	The treasury bank account of the debtor. This field was created to allow the creation of security restrictions.
IBAN	It fetches the information from Bank Account.
Message retried	Indicates if this message was retired or not.

Original Montran Message Logs Tab

Overview

Original message logs that represent the source of current message.

Original Montran Message Logs Screen Fields and Tab

Refer: Montran Message Logs

Payments Tab

Overview

This tab allows user to find a specific Payment Extract Payment record for which users want to see the log.

Payments Tab Screen Fields

Field	Description
Id	Auto-generated Payment Id.
Workflow Status	Depending on the Workflow Configuration Setting for this Entity the basic Stages are: Created, canceled, approval requested, etc.
Workflow Process Status	Depending on the Workflow Configuration Setting for this Entity the basic Stages are: Created, canceled, approval requested, etc.
Payment Extract	Payment Extract to be selected from the lookup button.
Payment Method	Method of payment is to be selected which may be Cash, Cheque, EFT, etc.
Treasury Bank Account	Treasury Bank Account relating to Payment Extract is selected from the lookup button.
Bank Account	Bank account relating to Payment Extract is to be selected from the drop-down box.
Branch	Branch to which the bank account relates is entered in this field.
Bank Account Name	Name of the bank account is entered in this field.
Beneficiary	Vendor to whom the Payment is made is selected from this field.
Cheque Series	The series to which the cheque issued belongs.
Cheque Number	Cheque number which is issued.
Transfer Number	Number identifying the transfer transaction.
Release Date	Date on which payment is released.
Number Of Releases	The number of times in which the total payment was released.
Delivered Date	Date of delivery of the payment amount.
Currency	Currency in which the payment was made.
Exchange Rate	The exchange rate on the date of payment is entered.
Domestic Amount	Total amount in domestic currency.
Foreign Amount	Payment amount expressed in foreign currency.
Handling Indicator	Special indicator defined by the user in Expense Vouchers. Will be used to give more flexibility to group payments.
Created On	Date of creation of Payment Extract.
Created By	The user who created the Payment Extract.
Approved On	Date on which the payment was approved.
Approved By	The user who approved the payment.
Payment Invoices	Invoices related with the payment gets added here.

Custody Of Written Assurance

Custody Guarantee

Overview

Custody of Assurances in treasury management allows the users to keep tracking the written assurance and guarantees admitted by Ministries and/or the Treasury Office of Government. The custody Guarantee feature contains the collection of guarantees that are in custody of Treasury.

Navigation

Treasury Management ► Custody of Written Assurance ► Custody Guarantee

Custody Guarantee Screen Fields and Tabs

Fields	Descriptions
Id	The unique identification code, visible to the user, auto-generated by the system.
Guarantee Number	The user enters the guarantee number by reference.
Workflow Status	It displays the workflow status of the custody guarantee. It updates according to the approval stage completed. For example, if the user created a new custody guarantee it shows the status as created. After approval of the transaction, it changes the status.
Guarantee Type	Reference to the Guarantee Type such as Bid Bond, Advance Payment Bond, Performance Bond, etc.
Guarantee Expired	Date when the Guarantee Period ends. It should be the greater than the system date. For example, the current system date is 2018-12-05 the guarantee period ends date should be higher i.e. 2018-12-15.
Reference Number	The reference number of the custody guarantee.
Currency	The user to select the custody guarantee Currency. By default, it shows the country domestic currency.
Exchange Rate	The feature shows the latest active exchange rate for the selected currency.
Maximum Guaranteed Domestic Amount	Maximum guaranteed domestic amount.
Maximum Guaranteed Foreign Amount	Maximum guaranteed foreign amount.
Issued By	An entity that issued of guarantee.
Beneficiary	Selects the beneficiary using the lookup button.
Beneficiary Name	Name of the beneficiary.
Institution	The user selects the institution name using the lookup button. The accounting office of the institution is allowed only that institute user can select.
Institution Name	Shows the selected institution name in the field.
Executed Domestic Amount	The domestic amount which is executed for the custody guarantee. The default value is zero with two decimals point.
Executed Foreign Amount	The foreign amount which is executed for the custody guarantee. The default value is zero with two decimals point.
Abbreviation	Title of the custody guarantee.
Description	A brief description of the custody guarantee.
Comment	Any comment about why is executed, renewed, etc. the Guarantee.
Created By	The user information who creates the custody guarantee.
Created Date	The system fetches the current date of the system.
Approved By	The approver username display in the field.
Approved Date	Approval date of the custody guarantee.

Attachment Tab

Overview

Attachment screen allows the user to attach the different type of the supporting document for the invoice items.

Attachment Screen Fields and tab

Fields	Descriptions
Id	Consecutive number auto generated by the system. It will be unique within the system. Visible to the user
Attachment Classification	Classification of the Attachment. It is useful to classify the attachment type which is predefined in the system.
Title	The title for the attached document.
Description	The attachment description.
Attachment	This feature allows the user to attach the file.
Date Time	Date and time of the attachment.
Date	Date of the attachment.
User	The Username of the attachment creator.

Bank Account Transfer

Bank Account Transfer Voucher

Overview

Bank Account Transfer Voucher contains a general data related to monetary transfer and will be completed with a Detail.

Navigation

Treasury Management ► Bank Account Transfer ► Bank Account Transfer Voucher

Bank Account Transfer Voucher Screen Fields and tab

Fields	Description
ID	It is automatically created a unique identification number or created by a user. It depends upon the setting for it by the system parameter.
Workflow Status	It is updated by the system according to the bank transfer voucher approval stage. The possible values are: Created, Approval Requested, Approved, Cancelled etc...
Fiscal Year	Fiscal Year of the Obligation, the default value is the current fiscal year which is open for the budget execution.
Accounting Office	If 'is the accounting office' feature is selected by the user. It shows the institution code here.
Description	Description of the bank deposit voucher.
Document Date	Date of the document. It shows the current system date.
Voucher Date	The default voucher date shows the current system date. The user can select the voucher date by using the calendar feature but it should be the current date or less than the current date.
Is Reversed	The default value is unchecked, when the original bank account transfer voucher is reversed then its value become checked.
Is Reversal	The default value is unchecked, when the original bank account transfer voucher is reversed then its value become checked.
Reversal Voucher	It allows selecting the reversal voucher by using lookup feature.
Generate Transfer To Central Bank	This feature is used to indicate that the "Bank Account transfer" it generates a transfer to Central Bank. The default value is Unchecked.
Posting Status	It is updated by the system when the voucher is either saved (then the attribute is updated to Saved) or temp saved (then the attribute is updated to Temp Saved).
Temp Number	The serial Number generated by the system when the voucher is Temp Saved.
Not Posted Reason	The user selects a reason for not posting the voucher when the voucher is Temp Saved, the field should be cleared automatically when the voucher is completely saved.
Origin	It is displayed by the system. The possible values for the BATV are Manual, Data_Import, Payment_Extract etc...
Total Debit Amount Dc	It displays the Total Domestic Debit amount of all line item. By default, it shows the value as zero.
Total Credit Amount Dc	It displays the Total Domestic Credit amount of all line item. By default, it shows the value as zero
Journal Voucher	This feature shows the ID of the JV auto-generated when the Bank Transfer is approved. JV ID populated by the system.
Central Bank Transfer	It shows the ID of the Central Bank Transfer auto-generated when the Bank Transfer is approved. CBT ID populated by the system.
Created By	User details who create the bank account transfer voucher.
Created Date	The system displays the date and time of the bank account transfer voucher.
Approved By	User information when a bank account transfer voucher gets approved. It is populated by the system.
Approved Date	It is populated by the system when a bank account transfer voucher gets approved. It shows the current system date.
Rejection Code	Code sent by the Central Bank when the transfer was rejected or not applied.
Rejection Description	Details information about the rejection code.
Commercial Bank Deposit Number	The number of the deposit executed by the bank when the transfer was rejected. It is populated by the system.
Is Received By Commercial Bank	By default, it is unchecked. if it is checked then it shows that the delivered transfer was read and received by the commercial bank.
Is Applied By Commercial Bank	By default, it is unchecked. If it is checked then it Indicates that the delivered transfer was successfully applied and NOT REJECTED by the commercial bank.
Commercial Bank Applied Amount	It shows the Amount applied by the bank which is populated by the system.
Commercial Bank Rejection Code	Code received from the commercial bank when "Is Applied by the Commercial Bank" feature is unchecked.
Commercial Bank Rejection Description	Description corresponding to the rejection code received in the bank notification.

Attachments

Overview

Supporting documents of Credit note are added through this tab.

Attachment Tab Screen Fields

Fields	Description
Id	Consecutive number auto generated by the system. It will be unique within the system. Visible to the user.
Attachment Classification	The format of the attachment. It allows the user to select the document type.
Title	Title of the attachment.
Description	A brief description of the attachment.
Attachment	It allows the user to select the attachment file.
Date Time	It displays the current system date and time of the attachment creation.
Date	Attachment date selects the date from the calendar feature.
User	User information of the attachment creation.

Voucher Details

Overview

Bank Account Transfer Voucher Detail, contains details of bank accounts will be made between money transfer.

Bank Account Transfer Voucher Details Screen Fields

Fields	Descriptions
Sequence #	Auto-generated, the system will read the next serial.
Treasury Bank Account	Treasury bank account of the bank account transfer voucher. The lookup feature allows the user to select the Treasury bank account.
Description	Description of the bank account transfer voucher.
Currency	To allow the user to select the Voucher Currency. The default value is Domestic Currency.
Exchange Rate	It shows the latest active exchange rate for the selected currency which is linked to the Appropriations, users can change the rate if allowed in the Appropriations.
Debit Amount Dc	The Total Domestic Debit amount of all line item. The Default value is Zero.
Credit Amount Dc	The Total Domestic Credit amount of all line item. The Default value is Zero.
Debit Amount Fc	The Total Foreign Debit amount of all line item. The Default value is Zero.
Credit Amount Fc	The Total Foreign Credit amount of all line item. The Default value is Zero.