EFT Employees

Use this form to add EFT details for Employees defined in Sage 300 Payroll (US or Canada).

Main Fields

For detailed field description, see EFT Employees- Setup Screen

  • File Type is Optional . If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Payroll Tab > Primary Bank.

  • Status : select one of Entered, Active or Inactive. You can only include "Active" Employees when you create EFT File

  • You can control who is allowed to make Employees “active” and “inactive” using the Approve /View Employee Bank Account Details security group. See Step 2, Adding Security

Tip:

You can import new EFT Employees from the File > Import Menu. You cannot update details of existing EFT employees through import.

When importing EFT Banks, EFT Vendors, EFT Customers and EFT Employees, you should not import the Encrypted Bank Branch and Account number and Credit Card Number fields (fields containing an "X"). These fields should only be set using the associated views, and set to the calculated encrypted value. EFT Import functionality prevents such fields to be imported. Fields starting with X (binary XBSBNO and XACCNO) shouldn't be in the import file.

Calculation Type and Percent/Amount

The rules are applied in the order they are entered on the screen.

The rule is applied to the remainder amount after the prior rules have been applied.

Tip: In most cases, the last rule should be set to Calculation Type "% Net Pay " and Percent = 100. This means that any amount remaining after the previous rules have been applied will be transferred to the account set in that line. If the pay is to be paid to a single account, you only need to enter one line with "% Net Pay" as the Calculation Type and set the Percent to 100
Example:

In the screenshot below, EFT Payroll will create a line in the file for $300 to CIBC and the remainder of the pay will be transferred to RBC.

If the pay is $250 for the week, only one line will be created. If the pay for the period is $400, it will create 2 lines, one for $300 and one for $100.

Note: (*) Field names might be different depending on the Default Bank File Type set up in EFT Options > Payroll Tab for EFT Processing (Payroll) or File Type entered on the EFT Employee screen.