Reports
Bank Reconciliation Report
Overview
The purpose of the "Bank Reconciliation Report" is to display a Bank Statement And Cash Book of the Reconciled transactions.
Navigation
Bank Reconciliation Report include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal Year to which Bank Reconciliation relates. |
| Fiscal Period | Fiscal Period to which Bank Reconciliation relates. |
| Reconciliation Source | Reconciliation Source is to be selected. |
| Comment | Comment on the report is to be made in this field. |
Bank Reconciliation Summary Report
Overview
This report shows the data from the Journal Voucher Items that correlate to or not to a record (i.e is not reconciled) with a record in the Bank Reconciliation Items table, and also which Bank Reconciliation items that correlate or not with Journal Voucher Items. The JV Items and Bank Reconciliation Items are then grouped according to type to display the Deposits section, the Cheque section and the Adjustments section.
The purpose of the "Bank Reconciliation Summary Report" is to display the Current Balance in the Bank and Unreconcilled transactions and the calculated balance.
Navigation
Treasury Management ►Bank Reconciliation ►Report ►Bank Reconciliation Summary Report
Bank Reconciliation Summary Report screen fields and Tab
| Field | Description |
Fiscal Year | By default it shows the current fiscal year |
Financial Institution | It provides the User's Employee's Institution |
Financial Institution Branch | It provides the User's Employee's Institution branch. |
Treasury Bank Account | Name of the associated Treasury Bank Account |
Comment | Comment regarding the report. |
Bank Reconcilled Transactions Report
Overview
The purpose of the "Bank Reconciled Transactions Report" is to display a Bank Statement and Cash Book of the reconciled transactions.
Navigation
Treasury Management ►Bank Reconcilation ► Reports ► Bank Reconcilled Transactions Report
Bank Reconciled Transactions Report screen fields and Tab
Fields | Description |
Fiscal Year | By Default Shows the current Fiscal year. |
Period Range Type | Range for the report. Possible values are Daily, Monthly. |
Start Date | Start date of the transaction. By default, it show the current date. |
End Date | End date of the transaction. By default, it show the current date. |
Treasury Bank Account | Treasury bank account unique identification number. |
Rec Method | Reconciliation method i.e. Manual or Automatic. |
Reconciliation Batch Number | It show the batch number. Every time an import is successfully finished, the system will increment this number by 1. |
Comment | Comment related to the report. |
| Reconciliation Type | Different Reconciliation Type name. |
Bank Statement Report
Overview
The purpose of the "Bank Statement Report" is to display a Bank Statement sent by the bank.This report displays the data for the Bank Statements (Bank Reconcillation And Bank Reconcillation Item)
Navigation
Treasury Management ►Bank Reconcilation ► Report ► Bank Statement Report
Bank Statement Report screen fields and Tab
| Field | Description |
Fiscal Year | By default shows the current fiscal year. |
Period Range Type | It is a closed domain whose possible values are (Daily, Monthly). |
Start Date | Start date of the bank statement . |
End Date | End date of the bank statement . |
Treasury Bank Account | Name of the associated treasury bank account |
Comment | Comment related to the report. |
Bank Transaction Summary Report
Overview
The purpose of the "Bank Reconciliation Summary Report" will display the current balance in the bank and unreconciled transactions and the calculated balance.
Navigation
Bank Transaction Summary Report include the following fields:
| Fields | Description |
| Fiscal Year | Fiscal year to which the bank transactions relate. |
| Fiscal Period | Fiscal period to which the bank transactions relate. |
| Reconciliation Source | Reconciliation Source is to slected for which the report is to be generated. |
| Comment | Comment on the report is entered in this field. |
Bank Unreconciled Transactions Report
Overview
Navigation
Treasury Management ►Bank Reconcilation ► Reports ► Bank Unreconcilled Transactions Report
Bank Unreconciled Transactions Report screen fields and Tab
Fields | Description |
Fiscal Year | By Default Shows the current Fiscal year. |
From Date | From date should be the transaction date or less than the transaction date. |
To Date | To date should be the transactions date or greater than the transaction date. |
Treasury Bank Account | Treasury bank account unique identification number. |
| Reconciliation Type | Diffrent Reconciliation type name. |
| Comment | Comment related to the report. |
Cash Book Unreconciled Transaction Report
Overview
The purpose of the Cash Book Unreconciled Transactions Report is to display the unreconiled transactions from the Cash Book.
Navigation
Treasury Management ► Bank Reconciliation ► Reports ► Cash Book Unreconciled Transactions Report
Cash Book Unreconcield Transaction Report Screen Fields and Tab
Report Field | Description |
Fiscal Year
| Default Current Fiscal Year. Can select from the dropdown menu |
From Date | By default system date will show. It should greater than equal(>=) to date of approval. |
To Date | By default it show current system date, It should not higher than the current system date. To date should be less than equal to(<=) "To date". |
Treasury Bank Account | Treasury bank account unique id. |
Comment | Comment related with the report. |
Transaction Type | Transaction type used to sort the report information. |