Import Transactions - Payment

Related Topics

Before attempting to import data, be sure that the appropriate import file mapping (comma separated or fixed-width) has been set up based on the format and record position of the data in the file being imported.  If importing a file in NACHA format, an import mapping is not required.  Refer to the following for details on setting up File Mappings:

Add a File Mapping

File Mapping Overview

ACH Overview

TIP: Transactional data imported into a payment are valid/active for this submission only.  If you wish the changes to be a permanent addition to the database, complete the import as an edit to the appropriate profile.  Refer to Import Transaction - Profile Help topic for information regarding this option.

To import transaction data from a file created outside the application.

  1. Select the ACH Tab and choose the Create Payment option from the list presented.  The ACH: Select Profile page is displayed.

  2. Click at the right of the Profile field to display the list of available Profiles.  Click on the appropriate profile name (for the payment being created) to auto-fill the field.  The Information contained in the selected profile auto-populates the remainder of the fields on this page.

  3. Click to proceed.


    General Tab
     

  4. Enter the Value Date (Effective Entry Date) for this payment.  Click to use the browse date function to select an appropriate date for this field.

    The remainder of the fields on this tab are pre-filled, and not accessible, based on the criteria contained in the profile selected in step 2.

  5. Click the Transaction tab to display the transaction level for this payment.


    Transaction Tab

  6. The Transaction tab contains detail information about the transactions contained in this payment (based on the profile selected in step 2).   The Transaction Recap Table is displayed in the upper right of the tab.

  7. Click to access the Import dialog.

  8. In the Select File To Import field, enter the path (location) and file name of the file to be imported.  You may use the Browse... button to locate the file path and name.

  9. Click at the right of the Select Import File Mapping field to display the list of available file mappings.  Click on the appropriate mapping for this file/import.  The mapping setup must match the content/format structure of the file being imported.

  10. Click OK.  The system will access the designated file, reviewing/validating the information contained therein.  If errors are discovered during the review/validation, a message will presented identifying the error, and causing the process to terminate.  If no errors are encountered, the data will be queued for entry into the payment during the next execution at the bank of the import event.  During this time the status of the payment will be Import.  When the event executes, the transactions will be written to the payment.  After the execution of the event by your bank, you should return to this payment and by clicking the transaction tab, review the imported data.  Once the imported transactions are displayed, the payment is ready for the next step in the operational process (approval, prenoting [if required], payment submission, etc.

  11. Click the Transaction tab again to review the items imported.

  12. Click Save to complete the process.  The payment will be queued for approval, or if no further approval is required, for processing by your financial institution.