Account Details Advanced File Exports


These formats are designed to work with specific some specific industry standard Enterprise Resource Planning (ERP) applications such as SAP, Treasury Anywhere and some smaller software packages such as Intuit Quicken & QuickBooks, Microsoft Money, and Simply Accounting.

The table below details each format and what elements of the export can be customized for each format type:

 

Advanced Export Format

Customizability

BAI2 (.DAT)

The BAI2 file export can be customized in the following ways:

 

-          Define up to an 8 digit file suffix (defaults to .DAT)

-          Define up to an 8 digit file prefix (defaults to BAI2)

-          Define date format

-          Sender ID (Defaults to 000280002)

-          Receiver ID (Defaults to your ScotiaConnect Online Service agreement number e.g. 001234)

-          Branch ID (see file specification for definition of how this is used)

-          Record length (defaults to 80 bytes)

-          File padding (spaces or nothing)

-          Record terminator LF, CR or CRLF (defaults to CRLF)

-          Record separator, forward slash, comma, asterisk and tilde (defaults to forward slash)

-          Field separator, forward slash, comma, asterisk and tilde (defaults to comma)

-          Sub String separator, forward slash, comma, asterisk and tilde (defaults to forward tilde)

-          Ultimate Receiver ID (Defaults to your ScotiaConnect Online Service agreement number e.g. 001234)

-          Originator / Bank Key (Defaults to Scotiabank’s institution code and first five digits of DDA account iiiittttt, ABA # or Swift BIC address, i = institution t = transit)

 

Note1: If you require any of the defaults options to be changed you will need to contact your Scotiabank Sales Representative.

 

Note2: You can also have an advanced file export sent to a Scotiabank generic mailbox these mailboxes are accessible using one of Scotiabank’s Standard Communication Methods. If you are interested in having a mailbox setup, please contact your Scotiabank Sales Representative.

 

Download Scotiabank’s BAI2 File Specification

 

Download Official BAI 2 File Specification from www.bai.org

 

Microsoft Money (.OFX)

 

The Microsoft Money OFX file export can be customized in the following ways:

 

- Define up to an 8 digit file suffix (defaults is .OFX)

 

No other customizability available. Scotiabank supports the latest OFX file export format for Microsoft’s supported versions of Microsoft money.

 

Download Official OFX File Specification version 2.0.2

 

Microsoft Money Support

 

Note: If you require any of the defaults options to be changed you will need to contact your Scotiabank Sales Representative.

 

Open Financial Exchange (.OFX)

See Microsoft Money

Quicken (.QFX) QuickBooks (.QBO)

The Quicken and Quickbooks OFX file exports can be customized in the following ways:

 

- Define up to an 8 digit file suffix (Quicken defaults to .OFX, Quickbooks defaults to .QBO)

 

No other customizability available. Scotiabank supports the latest OFX file export format for Intuits supported versions Quicken & QuickBooks.

 

Download Official OFX File Specification version 2.0.2

 

Intuit Support

 

Note: If you require any of the defaults options to be changed you will need to contact your Scotiabank Sales Representative.

 

Simply Accounting (.ASO)

The Sage Simply Accounting OFX file export can be customized in the following ways:

 

- Define up to an 8 digit file suffix (default is .ASO)

 

No other customizability available. Scotiabank supports the latest OFX file export format for Sage’s supported versions of Simply Accounting.

 

Download Official OFX File Specification version 2.0.2

 

Sage Simply Accounting Software Support

 

Note: If you require any of the defaults options to be changed you will need to contact your Scotiabank Sales Representative.

 

FYI: Simply Accounting does not support the export of multiple accounts in one export file. This limitation is not a Scotiabank limitation. If you have any concerns please contact Sage Simply Accounting Software Support

 

 

 

Related Topics

 

About the Account Details Report
Viewing/Printing an Account Details Report
Setting an Account Details Default
Customizing the Account Details Report
Modifying/Deleting a Custom Account Details Report ID
Custom File Exports
Download Scotiabank’s BAI2 File Specification
Download Official OFX File Specification version 2.0.2

Additional Help