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.