There's an error in the formatting of the generated data file.

Part 1: Verify company bank information is correct.

1. From the main screen of Sage 50, click Setup then Settings.
2. Choose a company and then payment processing.
3. Confirm that EFT direct is selected at the top and then click Modify existing banks.
4. Select the banking information you’re using to generate the file and select Edit.
5. Confirm all of the information entered is accurate and all of the fields the bank requires are filled out.
   • Not all fields are required by all banks, but if a field required by your bank isn’t filled out they’ll reject the file
   • Some fields that aren’t required by Sage 50, but that are required by some banks include the Company abbreviation field and the Data Centre No. field
   • If you’re unsure if your bank requires those fields to be filled, contact your bank
6. If you found an error, correct it and click OK and then OK again to save the changes.

Part 2: Verify employee, vendor, or customer bank information is correct

1. Open your list and then select the first employee, vendor, or customer that has a pay that is included in the file that was rejected.
2. Select Direct deposit (for customer records, select Pre-Authorized Debit).
3. Confirm the banking information for the employee, vendor, or customer is correct.
4. Repeat the same steps for each record that was included in the rejected file.
5. If you found an error, correct it and note the record on which the information was changed.
6. After correcting all errors, the transactions that need to be uploaded to the bank associated with the records that were changed need to be adjusted and re posted to pull in the corrected banking information.

Part 3: Verify the information used when generating the file is correct

1. Go to File, Import/Export, Upload Direct Payments, and then the type of file you would like to generate.
2. Select the transactions you would like to include in the file.
   • You may need to change the Status from Not Generated to All to see the transactions that were already included in the rejected file
3. After all of the transactions are selected, click Upload.
4. Make sure the options selected on this screen are correct.
   • The most likely option to cause a rejection is an incorrect Creation No
   • If you’re unsure what creation number the bank is looking for, contact your bank to obtain the next creation number they’re expecting
5. Click Next, and then Save this EFT Direct file.
6. Note the file name and location where the file is being saved to ensure the newly generated file is the one you’re trying to upload to the bank.

General troubleshooting tips:

• If this is the first time setting up Sage 50 EFT Direct and the bank has never accepted a file before, then most likely the information in Part I needs to be changed. Pay special attention to the Bank name field. Some banks prefer CPA Standard, even if they have a format with their bank name listed
• If other files using the same company settings have been accepted before and no changes to the company information have been communicated by the bank, then most likely the issue is something in a new record or the information entered when the file was generated. Common problems include an incorrect creation number or saving the file in a different location than normal
• If the bank can provide a sample file, see Understanding the EFT-generated .DAT files

Data Center Numbers:

• The CPA Standard for Scotiabank should be entered as 00220