Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Bank file upload info:

  • Uploading bank statements allow is available in the Payments (Back office) page allowing for batch creating payments for allocation.

  • Bank costs can be accounted for automatically against a received payment.

  • File upload settings allow for high flexibility for supporting different file formats and layouts from various banks.

  • File upload settings are saved and referenced automatically on next upload from the same bank.

  • Bank file statements can usually be downloaded from your bank website, accepted file types for upload are CSV, TAB, STA, TXT (if has a delimiter).

...

Tip

For more information regarding wire transfers and payment allocations see Wire transfers and Payment allocations along with links for other related how to pages.

...

Setting

Description

Example

File delimiter

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.

Has headers

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:

Image RemovedImage RemovedImage AddedImage Added

Decimal separator

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).

Currency

  • Choose the amount currency for the upload file from the drop down.

Info

Note: Available currencies are defined in the Currencies (Administration) page. Ensure that exchange rates are set if allocating payments to invoices in different currencies from upload file, see Exchange rates (Administration) page.

...

Setting

Description

Example

Amount column type

Single column with Negative Or Positive Amounts: File has a single column for positive and negative payment amounts.

  • Amount column: Choose the column index number that contains the payment amount for each payment.

Image RemovedImage Added

Single column with text indicator: File has a single column for amounts and another column indicating if amount is positive or negative.

  • Text indicator for Paid in: Enter the text indicator for payments that are paid in (positive amounts received). For example ‘Credit’ or ‘Received’.

    • Text indicator column: Choose the column index number that contains the text indicator for paid in. If text indicator is not found for payments, they are considered as 'paid out' (negative payments).

    • Amount column: Choose the column index number that contains the payment amount for each payment.

Image RemovedImage Added

Two columns: File has two separate columns for positive and negative amounts.

  • Paid out column: Choose the column index number that contains payments paid out (negative payments).

    • Paid in column: Choose the column index number that contains payments paid in (positive payments).

...