Bank Statement Reconciliation {FCBO-4}

This option can serve two purposes:

To verify the correctness of the transactions entered from the bank statement. For this purpose all the transactions in the journal, cheque and scratch pad table, linked to the specific bank statement number, will be taken into account to calculate the closing balance. If the calculated balance is the same, all the transactions were entered correctly, but all the transactions are not necessarily matched.
Once all the transactions on the scratch pad table have been cleared by either and force-matching or creating a journals and the calculated closing balance corresponds with the balance on the bank statement, the transactions are flagged to indicate that the reconciliation process was completed successfully.

When the option is selected, the cashier must log on as a cashier, a cashier login will popup. The program will validate that the user logged in to the system and the cashier ID entered refer to the same person by checking if the cashier ID as linked to the user in {FCTM-2}. Once logged on with a valid cashier ID and password the user enters the statement number range and closing statement to be reconciled.

Fields in this option:

Panel Box: Reconcile Bank Statement

When this option is selected, the system will display the following screen for the purposes of entering the transaction detail:

Field	Type & Length	Description
Cash Book Code	A5	The code of the Cash Book to be reconciled, the cash book description will be display once entered or selected from the list of values.
Bank Account Number	A15	Displays the bank account number of the cash book..
Bank Statement Number From	N10	The starting bank statement number to be reconciled.
Bank Statement Number To	N10	The end bank statement number to be reconciled. If a range is specified, the transactions of all the statements in in the range must have been entered.
Opening Balance	N17.2	The opening balance, as it appears on the first bank statement to be reconciled.
Closing Balance	N17.2	The closing balance as it appears on the last bank statement to be reconciled.
After all the above details have been completed, the user should SAVE to reconcile.
Computed Closing balance	N17.2	The system uses the opening balance (as provided) and the transactions linked to the bank code and range of statements (as provided) to calculate a closing balance. This calculated balance is displayed in this field.
Difference	N17.2	The difference between the closing balance as provided and the calculated closing balance is displayed in this field.

Example(s):

Processing Rules
	No special processing rules.

Date	System Version	By Whom	Job	Description
26-Jan-2007	v01.0.0.0	Charlene van der Schyff	t133564	New manual format.
06-Dec-2008	v01.0.0.0	Charlene van der Schyff	t151710	Edit language obtained from proof read language Juliet Gillies.
28-Jan-2016	v04.0.0.0	Marchand Hildebrand	t202883	Convert to adf