Bank Reporting Procedure

EBS-RCM OPERATIONAL PROCEDURES FOR BANK
AMENDED SEPTEMBER 2003

  1. All account transactions must be captured and reported in the format specified.

  2. The bank must print customized serially numbered deposit slips in 5 copies.

  3. Revenue collection must be captured only once at the customer-teller interface and integrated seamlessly with the bank's normal operational procedures.

  4. The bank must install a software system to validate integrity of data at the point of data capture (i.e. in the teller module) and before transmitting to ABC.

  5. All account transaction data must be automatically extracted and transmitted to ABC on an hourly basis.

  6. ABC to receive hard-copy printout of daily transactions sorted by value date together with daily account closing balances. This copy will be acknowledged by ABC and receipts prepared within 2 working days after transaction value - date. If there are no transactions on a given day, a written notification of this should be sent.

  7. The bank must deliver weekly statement before 10.am on Mondays.

  8. The bank must deliver monthly statement within 2 working days of end of month.

  9. The bank must provide a PC with a 24 x 7 direct internet Connectivity.

  10. Bank must be upto-date in remittance of all taxes due to lasg, and in compliance with filing of returns on new accounts (as required by sections 48 (1) and 49 (1,2) of the personal Income Tax Decree).

  11. Bank must be able to provide electronic copy of supporting detail information on WHT and PAYE as indicated in attached format for Analysis Data

DATA FORMAT REQUIREMENTS
ASCII CSV DELIMITED FILE LAYOUT
Analysis Data for PAYE and WHT

  1. ProcessorID (ABC Assigned) **

  2. BeneficiaryID (ABC Assigned) **

  3. AppliedDate (DD/MM/YYYY)

  4. EntryDate (DD/MM/YYYY)

  5. AmountDeducted

  6. RevCode

  7. Total Remittance

  8. BankTransID

  9. AccountNumber

  10. BankCode

Note: Z-NNNNNNNN(BBBB)/ Payer Name
          Where Z is entity type (C-Company or Regd Business, N-individual)
          NNNNNNNN is the entity unique ID assigned by Alpha-Beta Consulting (ABC)
          BBBB - is the branch ref Code assigned by Alpha-Beta Consulting (ABC)
          NNNNNNNN, BBBB - Can be obtained on this site (www.lagos.ebs-rcm.com) for registered TaxPayers


Item 1: Unique identification Code for the Company/Individual Processing this transaction

Item 2: Unique identification Code for the Company/Individual, from whom amount was deducted,

Item 3: AppliedDate indicates the date amount was deducted from indicated PayerID (2).

Item 4: Entry Date indicates the date amount was remitted to the lasg.

Item 5: AmountDeducted is the actual amount deducted from PayerID (2) for the month indicated inAppliedDate (3).

Item 6: See attached list of valid revenue codes (applies only to PAYE & WHT).

Item 7: Total Remittance is the total actual amount remitted by the CoyID (1) for the month indicated in the AppliedDate (3).

Item 8: BankTransID represents Unique Entry No (3) shown in Remittance Data.

Item 9: Account Number refers to the lasg account number in the Remitting bank (4) shown in Remittance Data.

Item 10: BankCode is the CBN Assigned bank code of the remitting bank (1) shown in Remittance Data

DATA FORMAT REQUIREMENTS
ASCII CSV DELIMITED FILE LAYOUT
Remittance Data

  1. BANK CODE (CBN Assigned)

  2. BRANCH NAME (Location)

  3. UNIQUE ENTRY NO (Sequential)

  4. ACCOUNT NUMBER

  5. DEPOSIT SLIP NO / CHEQUE NO

  6. ENTRY DATE (DD/MM/YYYY)

  7. VALUE DATE(DD/MM/YYYY)

  8. AMOUNT

  9. AGENCY CODE

  10. REVENUE CODE

  11. PAYER ID/NAME

  12. NARRATION

  13. REVERSAL ENTRY NO

  14. ASSESSMENT REFERENCE

  15. APPLIED DATE

Note:
Item 5: For withdrawals enter lasg Cheque No; for all deposits enter Deposit Slip No (which should be unique and sequential)
Item 9: Refer to Agency Codes List
Item10: Refer to Revenue Codes List
Item 11: Z-NNNNNNNN(BBBB)/Payer Name
Where Z is entity type (C-Company or Regd Business, N-individual)
          NNNNNNNN is the entity unique ID assigned by Alpha-Beta Consulting (ABC)
          BBBB - is the branch ref Code assigned by Alpha-Beta Consulting (ABC)
          NNNNNNNN, BBBB - Can be obtained from ABC web site (www.lagos.ebs-rcm.com) for registered TaxPayers
Item 12: For Property Tax, indicate address and Local Government Area
            For Waste Billing, Enter Ref Code - Example 022/SH171/D014/6
Item 13: Use the previous Unique Entry No. in (Item-3) for the following:
a) Correction of Bank Posting Errors
b) Reversal of collection
c) Reversal of payment
Item 14: For Waste, enter Invoice No/Assessment Ref No and for Tenement Rate, enter Assessment Ref No
Item 15: For PAYE, WHT or Direct Assessment, please indicate the Applicable Period exactly as you wish it to
               appear on the receipt e.g. "June 2005"
               For NTDA, please indicate pbt & block no & whether full or part payment.