Bank Transfers

Bank Transfers move money from one Bank Account to another. Some of the fields used cannot be seen on the Bank Record activity screen but are used elsewhere in the system. The key fields that header records are grouped on are BankCodeFrom, BankCodeTo, Ref and Date.

The Ref field MUST be unique

Field Mapping (mandatory fields in RED)

E2S Field	SAGE Field	Location within Sage	Length	Notes
BankCodeFrom	A/C	Bank Record - Activity	8	A key field
BankCodeTo				Also a key field
Date	Date	Bank Record - Activity - Transaction Line	10	Also a key field
Ref	Ref	Bank Record - Activity - Transaction Line	30	Also a key field
ExtRef	Internal ref	n/a	30	Not visible on Bank Activity screen
Details	Details	Bank Record - Activity - Transaction Line	60
Dept	n/a Dept	Bank Record - Activity - Transaction Line	2
Value	Debit/Credit Amount	Bank Record - Activity - Transaction Line	8
ExchangeRate	n/a	n/a	8	Not visible on the Bank Activity Screen or Nominal Ledger

Notes: For transfers between the base currency and a foreign currency bank account, the ExchangeRate in the XLS/Database is used if present. If left blank, the Sage currency default rate will be used.

Transfers from one foreign currency account to a different foreign currency account are NOT supported