Guaranty Bank Better Banking Solutions For You
75
Commercial Services Upload From File
You can import a list of recipients and amounts from a 5-column Comma Separated Values (CSV) file to add recipients and amounts to a new ACH Credit Batch, ACH Debit Collection or Payroll. This allows you to import recipients and amounts swiftly and efficiently. Note : The CSV file must contain the following columns: Recipient name, Routing transit number, Account number, Account type and Amount. • Account Type is a numeric value: Checking = 1; Savings = 2; and Loan = 3 • For 5-column imports, you will be prompted to select a SEC code, select a Pay From/Pay to account, select a Subsidiary (where applicable) and select an effective date.
1
2
Creating a New File Map In the Payments tab, click ACH/Wire . Select a payment type using the New Payment button and choose ACH Credit Batch, ACH Debit Collection or Payroll.
1. Click the “Upload From File” link. 2. Click the New Mapping button. 3. Select the CSV file you would like to upload.
Getting Started: Upload From File
Made with FlippingBook Learn more on our blog