Export File Specifications

ScotiaConnect Export File Formats:

Account Balance

Field Description Field Size Field Type

Account Number 16 character

Balance Date 10 date

Currency 3 character

Closing Balance Amount 16 currency

Opening Balance Amount 16 currency

Adjusted Opening Balance Amount 16 currency

Adjusted Closing Balance Amount 16 currency

Total Debit Count 16 number

Total Debit Amount 16 currency

Total Credit Count 16 currency

Total Credi Amount 16 currency

Account Transaction ACCPAC Format Only

Field Description Field Size Field Type

Timestamp 16 YYYY-MM-DD HH:MM

Account Number 16 character

Currency 3 character

Debit/Credit Indicator 1 character

Transaction Mnemonic 3 character

Transaction Amount 16 currency

Value Date 10 date

Transaction Serial Number 9 number

Account Transaction (All other Formats)

Field Description Field Size Field Type

Account Number 16 character

Account Short Name 10 character

Timestamp 16 YYYY-MM-DD HH:MM

Value Date 10 date

Debit/Credit Indicator 1 character

Transaction Amount 16 currency

Transaction Mnemonic 3 character

Transaction English Text 50 character

Transaction Agent Id 9 number

Transaction Serial Number 9 number

Transaction Sundry Information 15 character

Cheque Reconciliation

Field Description Field Size Field Type

Account Number 16 character

Cheque Serial Number 10 character

Cheque Date 10 date

Cheque Amount 16 currency

Payee Name 32 character

Reconciliation Date 10 date

Matched Cheque Serial Number 10 character

Matched Cheque Value Date 10 date

Matched Cheque Transaction Amount 16 currency

Global Account Balance

Field Description Field Size Field Type

Ticket Number 16 character

Swift Date 10 date

Account Number 35 character

Account Name 20 character

Bank Id 20 character

Opening Balance Date 10 date

Opening Balance Amount 16 currency

Opening Balance Currency 3 character

Closing Balance Date 10 date

Closing Balance Amount 16 currency

Closing Balance Currency 3 character

Available Balance Date 10 date

Available Balance Amount 16 currency

Global Account Transaction

Field Description Field Size Field Type

Ticket Number 16 character

Swift Date 10 date

Account Number 35 character

Value Date 10 date

Transaction Amount 16 currency

Transaction Type 3 character

Debit/Credit Indicator 1 character