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

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.

Solution Properties

Solution ID
221924260113534
Last Modified Date
Tue Sep 03 17:12:17 UTC 2024
Attributes
Product Details
Views
0