| How to generate Electronic Funds Transfer (EFT) .DAT files |
Description | Sage 50 allows you to export EFT .DAT files for the bank to process: |
Resolution | Vendor Payments - Set up EFT.
- Post your direct deposit payments.
- Go to File, Import/Export, Upload Direct payments, Vendor Direct Deposit.
- Select the appropriate Dated between: dates and click Refresh.
- Select the checkbox next to the customer transactions.
- Click Upload.
- Select the deposit date.
- Use Transaction Date is the date on the invoice
- Use Funds Available Date is the date that you request to have the bank take the funds
- Leave the Creation No.: - this number increases on it own every time you do a new generation.
- Set the Creation Date and click Next.
- Click Save this EFT Direct file and select a location to save the file.
- Preferably create and save to a folder on the C:\ named EFT
- It will default to the name APDIRECT.DAT
- Click Save.
- Select the Open the Direct Deposit Log report for this EFT file after clicking Finish checkbox.
- Click Finish.
- Go to the folder created in step 10 and there will be two .DAT files.
- APDI000x.DAT
- APDIRECT.DAT
- Log in to the bank website for EFT or CAFT and upload the APDIRECT.DAT file.
- Generating a new EFT overwrites the old APDIRECT.DAT file and saves a APDI000x.DAT copy for your records.
- If your EFT file gets rejected by your bank, follow these steps.
Customer Pre-Authorized Deposits (PAD) - Set up EFT.
- Record your pre-authorized debit transactions.
- Go to File, Import/Export, Upload Direct Payments, Pre-Authorized Debits.
- Select the appropriate Dated between: dates and click Refresh.
- Select the checkbox next to the customer transactions.
- Click Upload.
- Select the deposit date.
- Use Transaction Date is the date in the invoice
- Use Funds Available Date is the date that you request to have the bank take the funds
- Leave the Creation No.: - this number increases on its own every time you do a new generation.
- Set the Creation Date and click Next.
- Click Save this EFT Direct file and select a location to save the file.
- Preferably create and save to a folder on the C:\ named EFT
- It will default to the name ARDIRECT.DAT
- Click Save.
- Select the Open the Direct Deposit Log report for this EFT file after clicking Finish checkbox.
- Click Finish.
- Go to the folder created in step 10 and there will be two .DAT files.
- ARDI000x.DAT
- ARDIRECT.DAT
- Log in to the bank website for EFT or CAFT and upload the ARDIRECT.DAT file.
- Generating a new EFT overwrites the old ARDIRECT.DAT file and saves a ARDI000x.DAT copy for your records.
Employees Paycheques - Set up EFT.
- Post your payroll deposit cheques.
- Go to File, Import/Export, Upload Direct payments, Employee Direct Deposit.
- Select the desired date range.
- Select Not Generated from the Status drop down, then Display.
- Select the checkbox next to the employees.
- Click Upload.
- Select the deposit date: UseTransactions Date or Use Funds available date.
- Click Next.
- 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
- Click Save.
- Select the Open the Direct Deposit Log report for this EFT file after clicking the Finish checkbox.
- Click Finish.
- Go to the folder created in Step 10. You'll find two .DAT files in this folder.
- PRDI0001.DAT
- PRDIRECT.DAT
- Log in to the bank website for EFT or CAFT and upload the PRDIRECT.DAT file.
- Generating a new EFT overwrites the old PRDIRECT.DAT file and saves a PRDI0001.DAT copy for your records.
|
|