Manage Manual Bank Statements   {FCBO-2}


This option is used to match transactions on a bank statement (Cheques, Deposits and EFTs) to what exists on the system and consists of 4 panel boxes, 'Search', 'General Information', 'Match Bank Statement Transactions', & 'Matched Transactions'. Once the user selects the cash book code and the bank statement number in the 'Search' panel box, all the transactions that have been previously entered for the that cashbook/statement combination will be displayed. These transactions are broken down into 2 panel boxes which are the 'Match Bank Statement Transactions' (consisting of transactions that have not been forced matched yet) and 'Matched Transactions' (transactions that have been matched to the statement).  If no transaction appear, it means that the user will have to enter the transactions to link to the statement.



Example(s):

Example of ...fcbo-2b1



Match Bank Statement Transactions

Field Type
&
Length		 Description
Type of Transaction
The user will have to select the type of transaction that they are capturing. The options valid from the drop-down list are as follows.
"Cheque"    - Cheque payments that were made
"Deposits"  - Deposits made to the bank from money collected at the cashiers
"EFT"         - Payments that were generated electronically via tape
EFT Number
 N7 This is the journal number of an EFT that exists on the system that the user wishes to link to an EFT on the bank statement. A drop-down list is available, to view all unmatched EFTs that exist in the system.
Deposit/Payment Number A12 The transaction number, as it appears on the bank statement.
Value in CB Currency
 N17.2 The transaction amount, as it appears on the bank statement.
Date Cashed
 DD-MON-YYYY The transaction date, as it appears on the bank statement.
Status
Read only field that is used to inform the user of the status of the transaction that they have entered. The 5 statuses are as follows:

  • Matched: The Deposit/Payment/EFT Number is found and the amount is correct
  • Incorrect Value: The Deposit/Payment/EFT Number is found but the amount is incorrect
  • Unmatched: Cannot find a match for the Deposit/Payment/EFT Number and amount
  • Canceled: Cheque was found, but was canceled
  • Duplicate: More than one transaction found for Deposit/Payment/EFT Number and amount
Force Match
When the users checks the 'Force Match' check box and saves, a cashbook journal will be generated for the transaction.
If the status is 'Unmatched ' or 'Canceled', the system will use a transaction type linked to event 'C2' for deposits and 'C3' for cheques to process the cashbook journal.
If the status is 'Incorrect Value', a journal will be created for the difference in the amount. If the amount must be decreased, then the transaction type linked to event 'C3' will be used otherwise the transaction type for event 'C2' will used.
Duplicate Reference
This field will display a drop-down list if a payment number is entered and the system finds that the number exists more than once on the system. This will only occur if the cheque that was processed, was done outside the system and captured more than once in FCTO-6 as a manual cheque entry. The user will have to select the correct entry from the drop-down list and save the record. Note: the duplicate cheque will have to be reversed from the system.




Processing
Rules		  
  No special processing rules.


See Also:


History of Changes

Date System Version By Whom Job Description
26-Jan-2007 v01.0.0.0 Charlene van der Schyff t133567 New manual format.
06-Dec-2008 v01.0.0.0 Charlene van der Schyff t151710 Edit language obtained from proof read language Juliet Gillies.
22-May-2015
 v04.0.0.0
 Clinton Naidu
 t200624
 Change manual for Inti04