Skip to content
logo Knowledgebase
Page Language

ARCHIVED: How to generate EFT .DAT files to process employee direct deposits

Created on  | Last modified on 

Summary

Generate the .DAT file in Sage 50 Accounting after setting up Electronic Funds Transfer (EFT) and processing employee direct deposit cheques.

Resolution

  1. Go to File, Import/Export, Upload Direct payments, Employee Direct Deposit. 
  2. Select the desired date range.
  3. Choose Not Generated from the Status drop down, then Display.
  4. Select the employees or select all by checking the blue checkmark at the top.
  5. Click Upload.
  6. Select the deposit date: UseTransactions Date or Use Funds available date.
  7. Click Next.
  8. Select Save this EFT Direct File and the location to save the file.
    • Preferably create and save to a folder on C:\\ named EFT
    • The file name will default to PRDIRECT.DAT
  9. Click Save.
  10. Check the box Open the Direct Deposit Log report for this EFT file after clicking Finish.
  11. Click Finish.
  12. Go to the folder created in Step 8. You'll find two .DAT files in this folder.
    • PRDI0001.DAT
    • PRDIRECT.DAT
  13. Log in to the bank website for EFT or CAFT and upload the PRDIRECT.DAT file.
  14. Generating a new EFT overwrites the old PRDIRECT.DAT file and saves a PRDI0001.DAT copy for your records.