EFT bank transfer files

I received an error message from my bank which refers to a line number in my upload or transfer file from Sage 50 Accounting.

Data center number not entered

Someone may not have entered the data center number. Verify the data center number contains information.

An error due to a line in the transfer of upload file

• The bank error message relates to a line in the upload file. Ensure the line matches others in the file
• Ensure that the date and account number are correct
• Check that all the information is on one line and hasn't wrapped to the second line. You can edit the line in Notepad and resend to your bank
• If the error refers to the first line or the last line, contact Sage 50 Accounting Technical Support at 1-888-522-2722

Though data fields are continuous with no spaces, each line contains the employee or company name, cheque date, cheque amount and bank account number. Verify:

• All the files have a header record in the first line and a trailer record in the last line
• All the files are ASCII or ANSI-based files
• The files are the right size, ie.80byte files etc.

Bank Outout file

Edit the DAT file in Notepad (don’t use a word processor). If a particular format doesn’t work, try the CPA standard.

1. Choose your bank output file from the list below.
2. The files originally had a DAT extension. 
3. We renamed the files with a TXT extension to open and easily view them in Notepad.

• CPA Standard
• Alberta Treasury Branch
• Bank of Montreal (BMO)
• Bank of Nova Scotia
• National Bank - 96-bytes format
• National Bank - CPA format
• BC Central Credit Union
• Caisse Desjardins, Laurentian Bank
• Canadian Imperial Bank of Commerce (CIBC)
• First Chicago NBD Bank, Canada
• Hong Kong Bank of Canada
• HSBC - New ASCII Format
• Existing Royal Bank
• New Royal Bank
• TD Bank
• Ontario Central Credit Union

To understand (or find) the information in these files:

• Originator Number: 2222222222
• Abbreviate: FILE16
• Institution No. For Returns: 0-815-11011
• Account No. For Returns: 111222333
• Data Center No.: 81510
• Ashcroft (banking info): 0-869-65456 444555666
• Belanger (banking info): 0-869-98789 777888999
• Ashcroft (paycheque amount): $1,144.73
• Belanger (paycheque amount): $2,959.20
• Paycheque date is April 17, 2015
• Period end date is April 10, 2015
• Creation date is May 29, 2014

For more info regarding electronic fund transfers visit the Canadian Payments Association - Pre-Authorized Debits