Regardless if your organization has a full-scale host-to-host solution or settle with a simpler bank file upload/download solution, it is possible to import return files in the Banking module.
The Banking module operates with three different types of return files:
- Account statements: An overview of all bank account movements. The most common bank file, which is in practice available to all customers regardless of their bank Examples: ISO20022 Camt.053, SWIFT MT940, EDIFACT FINSTA Imported account statements are added to the related bank account, from where they can be used to reconcile the bank account against the systems ledger transactions. To open account statements go to AMC Banking > Reconciliation > Own bank accounts
- Payment notification: An overview of payments executed by the bank. Not as common as the account statement, but often more detailed than the account statement and can contain details regarding exchange rates etc., which is useful in the further posting process Examples: ISO20022 Camt.054, EDIFACT CREMUL, EDIFACT DEBMUL, US Lockbox Import payment notifications are added as posting journals, and work as posting proposals, which are processed by the advanced auto match functionality and manual adjustments. To see imported payment notifications go to AMC Banking > Posting > Posting journal If your bank cannot provide you with a detailed payment notifications, it is instead possible to generate posting proposals from your account statements. For information about using account statements to generate payment proposals, see What to do if posting journal is not created
- Status reports: Provides status details on the outbound payments. Not very common and is usually only available on host-to-host solutions, where the status reports work as a replacement for the confirmation, that users would otherwise get, when uploading the payment files in the online bank system. Therefore, the status reports are usually available soon after the payments arrive in the bank systems. Examples: ISO20022 Pain.002, EDIFACT CONTRL, EDIFACT BANSTA Status reports updates payments in the payment journal and allows accountants to keep track of individual payment transaction, from they arrive until being executed by the bank
IMPORTING FROM HOST–TO–HOST SOLUTION
When importing return files via a host-to-host solution, there are no physical files involved, hence the fetching of return files is handled by an external bank data conversion service. The import is done using the following steps:
1. Go to AMC Banking > Posting > Import bank files
2. If required, change the import parameters (only possible in Enterprise solutions)
By default, the import will import everything new, no matter the file type,
3. Click OK
Note: If bank requires a login, the user will be prompted for username and password
AUTOMATE IMPORT VIA BATCH JOBS
If your bank does not require a login during import of return files, consider the benefits of automating the import process, by adding one or more recurring import batch jobs. This will save your users the time of executing the import, and can be scheduled outside office hours
To add the import as a batch job, do the following steps prior to above step 3:
1. Expand the Run in the background tab
2. Enable Batch processing
3. Click Recurrence
4. Configure the recurrence parameters
5. Click OK
6. Click OK
IMPORTING LOCAL BANK FILES
When importing local bank files, that has e.g. been manually downloaded from the bank system, the import is done using the following steps:
1. Go to AMC Banking > Posting > Import local bank files
2. Click Browse
3. Locate and select the local bank file to import
4. Click Open. Wait for file import to finish
Import Flowchart #
Import Log #
All imported return files, whether originating from local files or host-to-host solution, are stored in an import log. To open the import log, go to AMC Banking > Inquiries > Import log.
All imported return files, whether originating from local files or host-to-host solution, are stored in an import log. To open the import log, go to AMC Banking > Inquiries > Import log.
The import log page contains only basic data related to the individual return files, but detailed information is available by clicking Details
It is possible to manually reprocess return files. This is done by selecting the return file to reprocess and clicking the Reprocess button. If a return file, for some reason, has not been processed the Reprocess button is replaced with a Process button When running host-to-host solutions, users are sometime unsure, whether all files have been imported from the bank data conversion web service. In those cases, the Import button can be used to synchronize the list of return files. The import method will compare its imported files with the files available on the web service and import missing files, if any such files exist.