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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
Overview:
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. |
Overview:
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. |
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. |
Overview:
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
Overview:
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 |
Overview:
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. |
Overview:
Navigation:
List of Monthly Fee Collection Per Ross Client Report screen fields:
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. |
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:
|
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. |