Pueblo Bank and Trust Bank Business Online User Guide for Desktop

37

Import Delimited File Delimited files must include the following columns: • Amount: Format column as dollars in Excel. • Reference number: Employee ID, Invoice Number, etc. • Type of payment: Must read Consumer for PPD or Business for CCD. • Name of person receiving funds • Account number where funds will be sent: Format column as text in Excel so that leading zeros populate correctly. This will ensure they are mapped correctly. • Routing Number where funds will be sent: Format column as text in Excel so that leading zeros populate correctly. This will ensure they are mapped correctly. • Account Type: Checking or Savings • Payment Type: Credit/Y/True or Debit/N/False

Note : Columns do not have to be in this order and do not require a heading.

Business Banking: Importing an ACH Batch from File

Made with FlippingBook flipbook maker