Bank Reconciliation
Reconciliation Source
Overview
A Reconciliation Source is the source that performs a Bank Reconciliation. The reconciliation of data can be performed by either a bank or a group of banks. Groups of banks are linked together by a common object code.
Navigation
Treasury Management ► Bank Reconciliation ► Reconciliation Source
Reconciliation Source screen fields and Tab
| Fields | Description |
| Code | Unique identification code manually entered by the user. |
| Reconciliation Source Type | Type of the Reconciliation Source whether it is from ‘Bank Account’ or ‘Object Code’. |
| Treasury Bank Account | Corresponds to the ID of the Treasury Bank Account. System will allow selecting Treasury Bank Account when type of Treasury Bank Account is "Physical". |
| Object Code | Automatically populated when user selects Treasury Bank Account. Value is the object code element of the coding block referenced by the selected Treasury Bank Account’s GL Offset Code. |
| Institution | The code of the ministry or office for which the reconciliation is done. |
| Language | Language used to describe Reconciliation Source. |
| Description | Description of Reconciliation Source. |
| Currency | Corresponds to the currency of the Treasury Bank Account. |
| Financial Institution | Display only field, automatically populated from Treasury Bank Account Id. |
| Branch Code | Display only field, automatically populated from Treasury Bank Account Id. |
| Bank Account | Display only field, automatically populated from Treasury Bank Account and reference to Bank Account entity. |
| Active | True by default, if user switches this to False, this record can no be used in future transactions other than just reference. |
Reconciliation Transaction Type
Overview
Transactions received through the bank statements gets identified by a Reconciliation Transaction Type. These types will identify the Journal voucher type to reconcile with automatically, and is also used to determine the JV template which will be used for any accounting entries that need to be created when the reconciliation process is executed.
Navigation
Reconciliation Transaction Type screen include the following fields:
| Fields | Description |
| Code | Code of transaction type contained in the Bank Statements which is manually entered by the user. |
| Language | Language used to describe Reconciliation Transaction Type. |
| Abbreviation | Abbreviation of transaction type contained in the Bank Statement. |
| Description | Brief description of the Reconciliation Transaction Type. |
| Transaction Type | Brief description of the reconciliation transaction type. Options are: Balance, Debit and Credit. |
| Journal Voucher Type | Journal Voucher Type is to be selected. Possible values: Adjustment, cheque, deposit, etc. |
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 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. |