Overview
This report is prepared for monitoring only collection of cash and as well as deposit this to the government authorized bank (Treasury Bank). This report prepared on the monthly basis but show the daily collection and deposit to the bank. This report also required to send COA for monitoring.
A screenshot of the Cash Receipts Records 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: Receipt Management ►Reports ►Philippines ►Reports Cash Receipts Records Report
Filters
The following table lists and describes all filter for the Cash Receipts Records Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.
Field | Description |
---|
Fiscal Year | Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year. |
Operating Unit | Lookup filter criteria for operating unit. |
Funding Source | Lookup filter criteria for operating unit. This is a mandatory filter. |
From Date | Cash receipts from date filter. |
To Date | Cash receipts to date filter. |
Comment | Allows users to add a custom comment to the generated report. |
Visible Fields
A sample of the Cash Receipts Records Report output is available here. The following table lists and describes all visible fields for the Cash Receipts Records Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
Field | Description |
---|
Filter By | The filter criteria describing how the given report has been filtered based on the user’s preferences. |
Group By | The criteria describing how the report has been grouped based on the user’s preferences. |
Name of the collecting Officer | Shows name of the collecting officer. |
Designation of the collecting officer | Shows designation of the collecting officer. |
Division name of the collecting officer | Shows division name of the collecting officer. |
Balance Forwarded | Shows accumulated amount of undeposited before the from date based on selection. |
Undeposited Collection | Shows the those amount where revenue receipt voucher or invoice where the payment method is cash and the revenue receipt voucher or invoice screen bank deposit field. |
Date | Shows bank deposit date. |
Reference No.OR/ No.DS (1) | Show the ID of the revenue receipt voucher. Where the payment method is cash. |
Deposit | Show the deposit amount from the bank deposit screen where amount is deposited based on the payment method is cash. |
Reference No.OR/ No.DS (2) | Shows the ID of the revenue receipt voucher. Where the payment method is credit. |
Collection | Shows the header amount of the revenue invoice where invoice type is credit. |
Payor | Shows the name of the customer selected in the revenue invoice. |
MFO/PAP | Shows the MFO/PAP code from the coding block field of the revenue invoice. |
Object Code | Shows the object code of the revenue invoice. |
Nature of Collection | Shows the header description of the revenue invoice. |
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 Cash Receipts Records 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. |