Options {FCBO-21}, {FCBO-22}, {FCBO-23} and {FCBO-24} are used to process and reconcile bank statement downloaded electronically.
On converting an
electronic bank statement, the system attempts to match all deposits
and cheques. Any cheques or deposits that couldn’t be matched and
other transactions on the statement is written into a table which can
be maintained in this option.
In order to
process these transaction the cashier will must enter the appropriate
transaction type and or cost centre and account or linking the journal
number before running the match electronic bank statement program
{FCBO-22} which will generate cash book journals.
On
reconciliation of a bank statement the closing statement balance is
inserted into the table and all records written to the table for the
bank statement excluding the closing balance are
deleted.
Field | Type & Length |
Description |
---|---|---|
Buttons | ||
Cashier Login | Users with access to cash book options are allowed to query cash book transactions but to process a transaction the user must be a cashier that is logged on. | |
Panel Box : Search | ||
Cash Book Code | A5 | Allows the user to search on an cash book code. The list of values will display the code, description, CB Gla and CB currency code. |
Bank Statement Number | N10 | Allows the user to search on bank statement number or cash book and bank statement number. The list of values will displays the statement number, maximum reference date and statement closing balance. |
Panel Box : Bank Statement | ||
Cash Book Code | A5 | The cash book code returned through a search. |
Cash Book GLA | The cash book cost centre and account as defined on the cash book definition. | |
CB Currency Code | A3 |
The currency code of the currecny in which the the cash book is defined. |
Statement Number | N10 | Displays the bank statement numbers returned through teh search. |
Opening Balance | N15.2 | Displays a statements Opening Balance. |
Closing Balance | N15.2 | Displays a statements Closing Balance. |
Start Statement Date | DD-MON-YYYY | The minimum reference date on the bank statement. |
End Statement Date | DD-MON-YYYY | The maximum reference date on the bank statement. |
Panel Box : Statement Detail | ||
Cash book journals cannot be maintained in screen below and the cashier must use the Edit Bank Statement buttonto open the edit screen. | ||
Buttons | ||
Match Bank Statement | Selecting the button navigates to the "Match Electronic Bank Statements option {FCBO-22} which allows the user with access to run the option to convert a bank statement. | |
Edit Bank Statements | Selecting the button opens the "Edit
Electronic Bank Statements” screen which allows the user to
maintain the journals searched displayed in this screen. Cash book
journals cannot be maintained in table described below. |
|
Payments | ||
Deposits | ||
EFT | ||
Document Type | A1 | The valid document types are:
Journals, deposit and cheques are inserted through the statement conversion programs. Transactions are displayed in the above order on the screen. |
Journal Number | N6 | The Reference Journal number of an item that already exists on {FCBO-1}. If this field is null, the bank reference will be used for matching purposes. This field can only be updated for Document Types “J” and “D”. |
Bank Reference | A12 | The bank reference number is displayed. |
Bank Reference Date | DD-MON-YYYY | The date on which the item appears on the bank statement is displayed. |
Transaction Type | N4 | The transaction type code to be used for this specific transaction. This field can only be updated for document type “J”. |
Person Type | A1 | The person defaults from the transaction type. . |
Person Number | N9 | A valid person number for the person type. Person number may only be updated for document type "J" where the person type is not "O". |
Account Type | A4 | The account type will default from the transaction type: it can be updated by the user if so defined on the transaction type definition. The account type field is mandatory if the person type of the transaction is (S)tudent, (D)ebtor or (C)reditor. For (P)ersonnel and (O)ther this field is also mandatory if the card indicator in the transaction type definition is (Y)es. If this indicator on the transaction type definition is (N)o, an account type is not needed. If person type is (S)tudent, (C)reditor or (D)ebtor a list of valid account types for that person type will be available, which will also show the balance for the account type / payment agreement combination. The user will only be able to process a transaction on one of these valid account types or on the default account type defined for the student debtor subsystem. The program will validate that the sub-system / account type combination is valid and active. |
Payment Agreement | A4 | Whenever a transaction is processed for person type (S)tudent, the user will have to enter a payment agreement for the transaction. A list of valid values for the specific student will be available from which to choose from. This is a mandatory field for person type (S)tudent unless the transaction is processed against the default account type, in which case this field will be null. |
Loan Code | N5 | The Loan code of the Debtor, if applicable. This field can only be entered for document type “J” and then only if the account type used is linked to “S” (Staff loans) or “L” (student loans). |
GLA to be | GLA to be DEBITED / CREDITED is displayed depending on the transaction type definition | |
Cost Centre | The Cost Centre to be DEBITED / CREDITED. These fields can only be updated for document type “J”. | |
Account | The Account to be DEBITED / CREDITED. These fields can only be updated for document type “J”. | |
Value in CB Currency | The transaction value in the cash book currency. | |
Note | A40 | The note for the sub-system. This note can only be updated for document type “J”. |
Hidden Fields | ||
Descriptions | Code description for visible columns where applicable i.e. cost centre desciption. | |
GL Note | A40 | The note to accompany the transaction to the Ledger. |
Person Currency Code | A3 | The currency code of the person type and number. |
Person Currency Rate | N5.3 | The currency rate obtained from the system for the currency code linked to the person type and number. |
Value in Foreign / Given Currency | N15.2 | The value of the transaction, in a given currency. Given currency value is the value of the transaction in the currency of the Debtor / Creditor after converting the Cash book amount received to local currency and the local currency value to the debtor / creditor currency. |
Local Currency Amount | N15.2 | The CB currency amount converted in the currency of the institution. |
CB Currency Code | A3 | The currency code of the cash book. |
CB Currency Rate | N5.3 | The rate of the currency code for the cashbook. |
VAT Code | A2 | ??????? |
VAT Rate % | N5.2 | The VAT percentage of the corresponding VAT code is displayed. |
VAT Apportionment % | N5.2 | For money received the VAT apportionment always defaults to 1, meaning that no apportionment is applicable. For payments the percentage apportionment associated with the VAT code above is displayed. This field can be updated. |
Bank Stmt
Debit/Credit Indicator |
A1 | The debit/credit indicator on the Bank Statement |
Taxable Supply Indicator | A1 | Taxable supply indicator is used to classify a transaction in
terms of its treatment for VAT / GST purposes. The taxable
supply indicator is linked to the GST / VAT code and by selecting
a GST / VAT code the taxable supply indicator is set.
The concept of supply is integral to the application or VAT / GST and
can be broken down into:
|
Vendor Registered | A1 | Vendor registered only applies to SA clients registered for VAT where the journal relate to input. In order to claim the input VAT on the journal the field vendor registered must be set to (Y)es. If the field is "Y" the cashier will be required to enter the vendors VAT registration number. This forces the cashier to enter a VAT registration number where input tax will be claimed. |
VAT Registration Number | A12 | If the field vendor registered is set to (Y)es, the cashier must enter a VAT registration number. The program will validate that the number is a valid VAT number applying the SARS modules check. |
Input Denied | A1 | The indicator defaults from the account definition. If the journal relate to a taxable supply on the input side and and the indicator is (Y)es, GST / VAT will not be processed when the journal is saved. The journals will be marked as input being denied. |
Asset Y/N | A! | If the journal relates to the sale or purchase of an asset the indicator should be set to (Y)es. The indicator will be used to identify capital items for GST / VAT reporting purposes. The value defaults according to the asset categories as defined on the SOD codes AV and AW. |
R/D Indicator | A1 | Must the R / D indicator be set for this student ((Y)es/(N)o): can only be updated for document type “J”. |
Cheque Number | A16 | If a cheque was returned from the bank, the cheque number of the returned cheque can be entered here. |
Cheque Date | DD-MON-YYYY | The date of the returned cheque can be entered here. |
Branch | A11 | The branch code of the returned cheque can be entered. |
Transfer Cash Book | A5 | If a transfer between bank accounts, the cash book code of the other Cash Book. This field can only be updated for document type “J”. |
Tax Certificate | A1 | Must a tax exemption certificate be generated for this receipt ((Y)es/(N)o). The system default is “N”. If the account type of the debtor code is linked to category (C)ontact then the system will default to the indicator as set up in {FCTM-1} The tax certificate indicator can only be updated to “Y” if the debtor type is (O)ther, (A)lumnus, (P)ersonnel or (D)ebtor where the category is (C)ontact. |
|
Processing Rules |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Receive money for student with action 'S" | A system operational definition 'C7' for subsystem 'CB' (Receive
money for student with action 'S') exists in {FCSM-1} that will determine
if the user may accept money for a student with a status with action 'S'
linked. If (N)o, the user will not be able to receive money for a student
linked to a status with action 'S'. If (Y)es, the user will only receive a
warning that the student is linked to a status code with action 'S'. |
Field | Type & Length |
Description |
---|---|---|
Panel Box: Edit Electronic Bank Statements | ||
Document Type | A1 | Indicates if the record related to journal, deposit or payment. Only journals can be maintained in this option |
Journal Number | N7 | The unique transaction number, which is allocated programmatically when a journal is created. |
Match indicator | A1 | Indicates if the transaction has been matched on a bank statement. |
Reconciled | A1 | Indicates whether the bank statement on which this transactions appears has been reconciled. |
Transaction Type | N4 | Journal processing is driven by the transactions type. The transaction type indicates the person type and other subsystem is affected by using the transaction type. The transaction type also determines which of the fields that follow are required and / or updateable and whether the journal relates to input or output for VAT / GST purposes. The transaction types are defined in {FCSO-7}. |
Person Type | A1 | Depending on the transaction type definition, one of the following values will be displayed:
|
Person Number | N9 | The person number field is mandatory if the person type of the transaction is (S)tudent, (D)ebtor, (C)reditor, (P)ersonnel and (A)lumni. For person type (O)ther, this field is not mandatory, but a number can be used if the person was created on the system and has a biographical record. |
Bank Reference | A12 | The reference number of the transaction as it appears on the bank statement. |
Bank Reference Date | (DD-MON-YYYY) | The transaction date as it appears on the bank statement. |
Match Date | (DD-MON-YYYY) | The date the journals was processed.On creating a journal the date will default to system date and is not updateable. |
Input / Output | A1 | Indicates if the journals relates to input output for VAT / GST purposes. |
Account Type | A4 | The account type will default from the transaction type, but can be updated by the user if so defined on the transaction type definition. The account type field is mandatory if the person type of the transaction is (S)tudent, (D)ebtor or (C)reditor. For (P)ersonnel and (O)ther, this field is also mandatory if the card indicator on the transaction type definition is (Y)es. If this indicator on the transaction type definition is (N)o, an account type is not needed. If person type is (S)tudent, (C)reditor or (D)ebtor, a list of valid account types for that person type will be available. It will also show the balance for the account type / payment agreement combination for (S)tudents. The user will only be able to process a transaction on one of these valid account types or the default account type defined for the student debtor subsystem. The program will validate that the subsystem / account type combination is valid and active. |
Payment Agreement | A4 | When a transaction is processed for person type (S)tudent, the user will have to enter a payment agreement for the transaction. A list of valid values for the specific student will be available from which to choose. This is a mandatory field for person type (S)tudent unless the transaction is processed against the default account type, in which case the field will be null. |
Loan Code | N5 | The staff loan code or student loan code, if applicable, can be entered here. For staff debtors, the cumulative principal repayment and the reducing principal (outstanding amount) {FARPD-2b2} will then be updated with the amount of the payment. It is essential that the account type used be linked to a category “S” (Staff Loans) otherwise the user will not be allowed to enter a loan code. For student loans, the real payment amount, as indicated on the amortisation schedule {FBLO-22b4}, will be updated with the payment amount when the next amortisation calculation is run. Again it is essential that the account type used be linked to a category “L” (Student Loans) otherwise the system will not allow the user to enter a loan code. |
GLA |
Debit/Credit | GLA to be DEBITED / CREDITED is displayed depending on the transaction type definition |
Cost | A6 | The cost centre to be debited or credited. The cost centre and account is not updateable if the person type above is Student, Creditor or Debtor or where an account type is used. |
Account | A8 | The account to be debited or credited. The cost centre and account is not updateable if the person type above is Student, Creditor or Debtor or or where an account type is used. |
Input Denied | A1 | The indicator defaults from the account definition. If the journal relate to a taxable supply on the input side and and the indicator is (Y)es, GST / VAT will not be processed when the journal is saved. The journals will be marked as input being denied. |
Asset Y/N | A1 | If the journal relates to the sale or purchase of an asset the indicator should be set to (Y)es. The indicator will be used to identify capital items for GST / VAT reporting purposes. The value defaults according to the asset categories as defined on the SOD codes AV and AW. |
Vendor Registered | A1 | Vendor registered only applies to SA clients registered for VAT where the journal relate to input. In order to claim the input VAT on the journal the field vendor registered must be set to (Y)es. If the field is "Y" the cashier will be required to enter the vendors VAT registration number. This forces the cashier to enter a VAT registration number where input tax will be claimed. |
VAT Registration Number | A12 | If the field vendor registered is set to (Y)es, the cashier
must enter a VAT registration number. The program will validate that
the number is a valid VAT number applying the SARS modules check. |
Vat Code | A2 | |
Taxable Supply Indicator | A1 | Taxable supply indicator is used to classify a transaction in
terms of its treatment for VAT / GST purposes. The taxable
supply indicator is linked to the GST / VAT code and by selecting
a GST / VAT code the taxable supply indicator is set.
The concept of supply is integral to the application or VAT / GST and
can be broken down into:
|
Vat Rate | N4.2 | The VAT percentage linked to the VAT code will default but can be updated by the user. It is the user's responsibility to ensure the VAT rate is correct on commit of the transaction. |
VAT Apportionment % | N3.3 | Where a journal is directly attributed to
the making of a taxable supply there is no apportionment and the
apportionment is 100% rate = 1, however if the journal relate to
the making a mixed supplies which cannot directly
be attributed to the making of a taxable
supply, apportionment applies and only a portion of the input tax
can be claimed. Tthe portion that can be claimed is referred to a apportionment. Apportionment rates to be applied should be obtained from the local tax authority. Apportionment is only applicable if the journal relate to input. The apportionment rate defaults from the rate definition but it is the cashier’s responsibility to ensure the GSWT / VAT apportionment is correct on commit of the transaction. The rate is entered a fraction i.e. 75 % - 0.75 |
Value in CB Currency | N15.2 | The transaction value in cash book currency (the amount as it appears on the bank statement). |
Transaction Value | N15.2 | The CB currency amount converted in the currency of the institution. |
Valie in Foreign / Given Currency | N15.2 | The value of the transaction, in a given currency. Given currency value is the value of the transaction in the currency of the Debtor / Creditor after converting the Cash book amount received to local currency and the local currency value to the debtor / creditor currency. |
Vat Amount | N15.2 | The VAT amount, if VAT is applicable will display. |
CB Rate | N5.3 | The cash book currency exchange rate. |
CB Currency Code | A3 | The currency code of the cash book. The cash book currency defaults from the cash book definition and cannot be updated. |
Given Currency Rate | N5.3 | The exchange rate of the currency the Debtor / Creditor is defined in. |
Currency Code | A3 | The currency code of the currency the person, Debtor / Creditor, is defined in. The code defaults from the persons biographical definition and cannot be updated. |
Note | A40 | A note for the subsystem transaction may be entered. If the debtor / creditor is a (S)tudent, the note will default from the transaction type note, but may be updated. |
General Ledger Note | The debtor number and name will default to this field but may be updated by the user. This note will be entered in the General Ledger. | |
Panel Box: Payments Returned Information | ||
R/D Indicator | A1 | If an R / D cheque is processed this indicator may be set to (Y)es. |
Cheque Number | A16 | If a cheque was returned from the bank, the cheque number of the returned cheque can be entered here. |
Branch | A11 | The branch code of the returned cheque can be entered here. |
Cheque Date | (DD-MON-YYYY) | The date of the returned cheque can be entered |
Panel Box: Cash Book Transfers | ||
Transfer Cash Book | A5 | The Cash Book code from / to which money is transferred. |
|
Date | System Version | By Whom | Job | Description |
---|---|---|---|---|
26-Jan-2007 | v01.0.0.0 | Charlene van der Schyff | t133225 | New manual format. |
05-Dec-2007 | v01.0.0.0 | Amanda Nell | t133225 | Add new functionality |
07-Dec-2008 | v01.0.0.0 | Charlene van der Schyff | t151710 | Edit language obtained from proof read language Juliet Gillies. |
03-Sep-2013 |
v03.0.0.0 |
Christel van Staden |
t189862 |
Add SOD C7 for subsystem CB |
01-Jun-2016 | v04.0.0.0 | Marchand Hildebrand | t200598 | Convrt to ADF |
05-Dec-2016 | V04.0.0.1 | Morgan Ntshabele | T208911 | Removed Investment Number Field. |