Electronic bank statement processing – setup

Banks can send you an electronic statement of payments made and direct debits received, rather than a paper report. You can use the Electronic Bank Statements sessions to convert, match and post the electronically received bank statements.

To set up electronic bank statement processing, use the following sequence of sessions:

1. Bank Relations (tfcmg0510m000)

   Enter the required data in these fields:

   • Path for EBS Files

     The default directory in which LN stores the electronic bank file received from the bank.

   • Path For EBS Archive

     The default directory in which LN stores the original electronic bank file after conversion with the Convert Electronic Bank Statements (tfcmg5202m000) session.

2. CMG Parameters (tfcmg0100s000)

   In the Transaction Date in Case of Telebanking field, select the type of date that you want to use as the document date for electronic bank statements converted in the Convert Electronic Bank Statements (tfcmg5202m000) session. The document date can be the date on which the bank statement was created, or the value date.

3. Record Types for Electronic Bank Statements (tfcmg5104m000)

   For each type of bank statement file, define the records that it contains. For each record you must define the type, the start and end positions, and the value that identifies each record.

4. Conversion Data for Electronic Bank Statements (tfcmg5105m000)

   Define the layout of the bank statement file. For every transaction detail, you must indicate the record type in which it is contained, the start and end positions, and if the field has a fixed value, the value of the field. For example, the field that indicates whether the transaction is a payment or a receipt can have the fixed values IN (with a leading space) or OUT.