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
- From the Payments menu, select Bill Payments, followed by Bill Payments Import
- 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
- Payment Company
- The file name can be 64 characters maximum, including the extension of file
- Choose the appropriate file format
- Fixed Length Text (default)
- Comma Separated
- Click on the Import button
- 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
- Rejection messages: