Electronic Interface or DMT?

Epicor ERP 10
1

We have a bank that will be sending us a CSV file with A/P info. These are things taht need to be entered into Epicor as they reflect the status of the account. Example: The bank will be setup for Bill Pay to pay several monthly recurring bills automatically. This will bypass Epicor upfront but needs to be entered into Epicor.

Question: Electronic interface or DMT? Or some other way? We are using 10.2.300.0. Also, if DMT which heading under Financials do I use?

2

Actually, the Bank Statement Process (Bank Reconciliation Processing) will do this. You end up with items that are not in Epicor and you can add them directly from this program. And at the same time, you’ll be reconciling your bank account.

Mark W.

2 Likes
3

So, in this I can import the CSV? Where can I find info on what fields are needed for the import? The bank is willing to give us just the fields we are needing.

4

Start here in Help. You’ll need to go to Electronic Interfaces eventually but they provide a CSV version.

Bank Statement Processing

Use Bank Statement Processing to create a new bank statement either via import of electronic statement files from the bank into the Epicor application or via manual entry of new bank statements and statement lines, review the information, search for the Epicor transactions available for matching, and create new transactions. It is possible to perform bank reconciliation either in automatic (using reconciliation algorithm) or manual (matching the transactions to statement lines) modes.

The main functions of Bank Statement Processing include the following:

  • Import of an electronic bank statement or manual creation of a new statement.* Automatic matching of statement lines to unmatched transactions. Line status icons help you to quickly review the results of automatic matching.* Manual matching of statement lines to unmatched transactions.* Quick (“one-click”) manual matching of existing transactions to the statement lines.* Quick search of partners by a partner name (identifier) during reconciliation* Automatic creation of new transactions.* Manual creation of new transactions.* Posting new transactions to a current bank account and general ledger (GL) accounts specified in the GL controls attached to the bank account.

The bank statement lists the activity in the bank account as well as the balance in the bank account. The bank usually mails a bank statement to the company. The company does a bank reconciliation - it verifies the amounts on the bank statement are consistent with the amounts in the company’s account and vice versa. In most cases you handle statements imported from the bank. However, sometimes you may want to create a new statement - this operation is discussed separately. To make sure the bank reconciliation process is done accurately, you must perform settings in the Epicor programs. These recommendations describe basic steps you need to take when using this functionality and point out important information specific to those steps.

Bank Statement Processing is a powerful functionality which enables you to take full advantage of the Epicor potential during reconciliation. The following sections explain how to start working with this functionality and how to tailor it to your needs.

Importing a bank statement

Before you start working with the statement prepared by the bank, you must perform the following preliminary settings:

  1. Configure an electronic interface the bank uses to generate statements.* Set up a bank account to which bank transactions post.* Perform reconciliation settings in Bank Account Maintenance.* Import the statement.
2 Likes