Bill Payments Import

Through ScotiaConnect, a customer can now make multiple bill payments at one time.

How to make multiple bill payments at one time

  1. From the Payments menu, select Bill Payments, followed by Bill Payments Import
  2. Click Choose File to browse and select the file you would like to import.
    • Payment Company
      • Mandatory
      • Must be existing payment company already created in Payee Maintenance
      • 30 characters maximum
    • Short Name
      • Mandatory
      • Payment Group provided in the import file for that row
      • 80 characters maximum
    • Payment Account
      • Mandatory
      • 35 characters maximum
    • From Account
      • Mandatory
      • Must be an active Canadian dollar (CAD) DDA account that current user can access according to user Bill Payments user group assignment
      • 12 characters maximum
    • Account
      • Mandatory
      • Payment Account for the corresponding row
      • 17 characters maximum
      • Must be numeric value > 0.00 and <= 99,999,999,999.99
    • Payment Date
      • Mandatory
      • 10 characters maximum
      • Must be a date value in mm/dd/yyyy format
      • Must be on current or future business date, not beyond 1 year in future ( i.e. current date + 12 months)
      • Payment Date is considered to be in the past if the bill payment is being entered after the service hour on current calendar date (today) which is also business date
    • Comments
      • Optional
      • 50 characters maximum
  3. The file name can be 64 characters maximum, including the extension of file
  4. Choose the appropriate file format
    • Fixed Length Text (default)
    • Comma Separated
  5. Click on the Import button
  6. After Payments are imported, it will follow the current approval process
    • Rejection messages:
      • Reject Reason – Reason for rejection, system determined based on predefined format
      • Line # - Line number of the record which has been rejected in the import file
    • Summary Totals:
      • Record Input – Total number of records in the import file
      • Record Accepted – Number of the accepted records in the imported file
      • Record Rejected – Number of the rejected records in the import file

Related Topics

Top