Understanding Electronic Funds Transfer (EFT) - generated .DAT files

How to verify that the information in the Sage 50 Accounting EFT-generated DAT file is correct.

All the files have the following information:

EFT INFO:
Windows date settings are YY.MM.DD (may or may not matter).
The current date is 14.05.29.
Creation date is also May 29, 2014.
COMPANY MAINTENANCE INFO:
Name: 16 files
Originator Number: 2222222222
Abbreviate: FILE16
Institution No. For Returns: 0-815-11011
Account No. For Returns: 111222333
Data Centre No.: 81510
EMPLOYEE MAINTENANCE INFO:
Ashcroft:
0-869-65456
444555666

Belanger:
0-869-98789
777888999
POSTED PAYCHEQUE INFO:
Paycheque date is April 17, 2015.
Period end date is April 10, 2015.
Ashcroft: $1,144.73
Belanger: $2,959.20
Period end date is April 10, 2015.

• Open the file relating to your bank (numbers 1 to 16)
• Compare the sample .DAT file to yours to verify that the information is correct
• The transaction details for every DAT file will be different but the format is the same
  
  1. CPA Standard
  2. Alberta Treasury Branch
  3. Bank of Montreal (BMO)
  4. Bank of Nova Scotia
  5. National Bank - 96-bytes format
  6. National Bank - CPA format
  7. BC Central Credit Union
  8. Caisse Desjardins, Laurentian Bank
  9. Canadian Imperial Bank of Commerce (CIBC)
  10. First Chicago NBD Bank, Canada
  11. Honk Kong Bank of Canada
  12. HSBC - New ASCII Format
  13. Existing Royal Bank
  14. New Royal Bank
  15. TD Bank
  16. Ontario Central Credit Union
• The sample files originally had a DAT extension. We renamed them with a TXT extension to allow easy viewing in notepad 
• The extension DAT means data. These DAT files are just text files
• You can open DAT files with the Microsoft Word XLM compatibility view mode, Notepad, or WordPad
• All 16 files are viewable and downloadable at the end of this article
• CIBC and Caisse Desjardins must have a Data Centre number

 

Attachment: 348_20230425121624_PRDI0010.TXT
Attachment: 348_20230425121624_PRDI0014.TXT
Attachment: 348_20230425121624_PRDI0001.TXT
Attachment: 348_20230425121625_PRDI0005.TXT
Attachment: 348_20230425121625_PRDI0013.TXT
Attachment: 348_20230425121625_PRDI0003.TXT
Attachment: 348_20230425121626_PRDI0007.TXT
Attachment: 348_20230425121626_PRDI0011.TXT
Attachment: 348_20230425121626_PRDI0015.TXT
Attachment: 348_20230425121626_PRDI0004.TXT
Attachment: 348_20230425121627_PRDI0008.TXT
Attachment: 348_20230425121627_PRDI0012.TXT
Attachment: 348_20230425121627_PRDI0016.TXT
Attachment: 348_20230425121627_PRDI0002.TXT
Attachment: 348_20230425121628_PRDI0006.TXT
Attachment: 505_20230425121628_PRDI0009.TXT