Agora, usando na sua maioria, programas standards da JD Edwards, os clients brasileiros têm em suas mãos a funcionalidade de Conciliação Bancária Automática.

O processo de Conciliação Bancária Automatica, desenvolvido pela MPL, foi criado para atender aos requisitos de vários de nossos clients e preencher uma lacuna de funcionalidade do JD Edwards. O resultado final é apresentado como uma funcionalidade adicional do sistema, uma vez que foi desenvolvido utilizando ferramentas do próprio JD Edwards, com os mesmos padrões de aplicativos online e batch.

1. Benefits

• Allows automatic bank reconciliation.
• From the bank statement records and their transaction type, it is possible to automatically generate accounting entries for interest, fees, bank fees and others.

2. Key Features

• Import of Bank Statement;
• Consultation of Imported Bank Statement Records;
• Automatic Bank Reconciliation between the Bank Statement and the Accounting Entries in the General Accounting Module;
• Consultation of Accounting Entries for manual reconciliation of pending items;

3. How It Works

The Automatic Reconciliation process starts with the JD Edwards standard program for updating the G/L Entries Reconciliation table (GL Reconciliation File – F0911R) and continues with the bank statement import.

After importing the bank statement, a new batch program is run to match the journal entries, marking them as matched in table F0911R.

Automatic reconciliation is performed using the accounting date and value as parameters. If there is more than one entry on the bank statement or account ledger with the same information, the reconciliation process will match the oldest entry among those found.

O programa de conciliação automática também irá gerar lançamentos contábeis automáticos de acordo com os registros do extrato bancário identificados como “registros independentes”, tais como juros, tarifas ou qualquer outro tipo de taxa que possa ser cobrada pelo banco e não tenha relacionamento com recebimentos de clients ou pagamentos a fornecedores. Estes registros independentes são identificados pelo seu tipo de transação e a geração do lançamento contábil obedece às configurações feitas pelo usuário.

After running the automatic matching process, users – through standard JD Edwards programs – can query the matched records, undo the matching, and mark any pending records as matched.

4. Assumptions

• The Automatic Bank Reconciliation product is supported from version 9.0 of JD Edwards;
• Due to the different levels of ESUs installed in each client, some type of adjustment to the Automatic Banking Conciliation programs may be necessary;
• Before starting the Bank Reconciliation project, we have to ensure that no objects customized by the client match the objects created by MPL;
• The Automatic Bank Reconciliation process can be executed as often as desired by the user;
• The import of the Bank Statement is now ready for Banco Itaú. Programs for importing extracts to other banks will be developed when necessary.

5. Deployment Service

Considering that there will be no coincidence of objects between those developed by MPL and those already customized by the client, the project lasts approximately 15 working days. The project duration can be revised according to the scope agreed between MPL and the client, and will be part of the first project activity.