Bank file upload info:
For more information regarding wire transfers and payment allocations see Wire transfers and Payment allocations along with links for other related how to pages.
Choose the ‘File delimiter’ from the drop down. A file delimiter is used to define the end and the beginning of a new field, most CSV files will use comma delimiters to separate columns.
To find the delimiter of a file open the file using Notepad, the delimiter symbol will be shown between each field.
Choose if the upload file contains a header row that should be excluded from upload. Choosing ‘Yes' results in the first row excluded from upload. See example files below:
Choose the ‘Decimal separator’ used to show the fraction of an amount, for example: 100.50 (for decimal point separator), 100,50 (for decimal comma separator).
Amount column type
Single column with Negative Or Positive Amounts: File has a single column for positive and negative payment amounts.
Single column with text indicator: File has a single column for amounts and another column indicating if amount is positive or negative.
Two columns: File has two separate columns for positive and negative amounts.