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.

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 Exchange Cheques Inconsistent And Conciliated 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.