The Direct Deposit Import file is used to add, update or delete employee Net Pay Direct Deposits. This file allows direct deposit additions, changes and deletions, including changes to the bank routing and transit number, bank account number, and bank account type for existing direct deposits.
It is not used for direct deposit of individual earnings or deductions. You must enter this information manually.
The Direct Deposit product must be active to import data using this file.
Columns can be in any order and non-required columns can be left off entirely.
Column names have to be labeled exactly as shown in the specification sheet in order for the file to be imported.
The first row of the file must contain a header line identifying the column names the user would like to import.
File must be uploaded in .csv format.
Direct Deposit Information
Net Pay direct deposit can be split between multiple bank accounts.
Deposits can be set up by percent of Net Pay, Dollar Amount, or Remainder. Percent direct deposits cannot total more than 100%.
The Priority field determines the order the deposits are taken from Net Pay. A Deposit set up for Remainder will always be the last priority.
If there is not a Remainder direct deposit set up for the employee, a paycheck will be produced for any amount that is not direct deposited.
The provided template, Template for Direct Deposit, defines the fields that are allowed in the file and their correct header values. Columns in this file can be in any order and non-required columns can be left off entirely.
The first row of the file must contain a header line identifying the column names the user would like to import. All column names must be identical to the column name provided in the specification sheet for this file type.
Review the Direct Deposit Specification Sheet for specific field information.
For questions regarding general information that affects all SEDI files or errors in running the Direct Deposit Import, review General Information.