Completing the Staff Bank Accounts (direct deposit) Template

Modified on Fri, Jul 24 at 11:01 AM

Instructions for completing the template:

Expected file format:

Excel File
Columns may appear in any order
First row must contain the column names as described below
All required columns must appear in the file. Other columns are optional.
Columns are not case sensitive. Description is the same as DESCRIPTION.
Existing staff are located by Staff Id or SSN
New staff bank accounts are created.
Staff bank accounts will only be created if the staff has no accounts in the system.

Details for data in the template:

Column	Sample Data	Required?	Notes
Staff Id	1000	YES	Staff Id field or SSN field is required.
SSN	123-45-6789	YES	Staff Id field or SSN field is required, Must be in the format '###-##-####'.
Last Name	Doe	No
First Name	John	No
Enabled	Y	No	If field is empty, imports as Y. Options are 'Y' (Yes), 'N' (No).
Account Name	Wells Fargo Bank	No
NACHA Bank ID	123456789	YES	NACHA Id is a required field. NACHA Id must match a bank in this country. Must be 9 numerical digits.
Account Number	7654321	YES
Account Type	CHECKING	No	Options are 'CHECKING', 'SAVINGS', 'PN_CHECKING', 'PN_SAVINGS', or 'CHECK'
Percent	100.00	YES	Percentage cannot lie outside of 0-100%. Must be in the format ###.##. If a staff member has multiple staff bank accounts, they MUST add to 100.00. If a staff member has a single staff bank account, value MUST be 100.00. If the staff bank account has an Amount, the Percent MUST be blank.
Amount	25.00	No	Fixed Amount must be a currency amount in the format #,###.##. Fixed Amounts CAN NOT have a Percent on the same staff bank account.
Used for Payroll	Y	YES	Options are 'Y' (Yes), 'N' (No).
Used for 2nd Check	Y	YES	Options are 'Y' (Yes), 'N' (No).

Attachments (1)

StaffBankAccountsImportTemplate.xlsx
10.6 KB