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

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.

Cause
Resolution
  • 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

Steps to duplicate
Related Solutions