Location
Tools >> Routines >> Financial >> Advanced Bank Reconciliation >> Extract Transactions
Layout
Overview
The Extract Transactions window is used to load GL transactions into ABR for reconciliation. Once transactions have been extracted, they can not be extracted again.
Fields
From Date – The date to begin extracting transactions from the GL. If left blank, the default is the first day of the current open year.
To Date – The date to end extracting transactions from the GL. If left blank, the default is the current system date.
From Bank – The beginning Bank Account ID to start extracting transactions from the GL. If left blank, GL transactions for all the Bank Accounts will be extracted.
To Bank – The ending Bank Account ID to stop extracting transactions from the GL. If left blank, GL transactions for all the Bank Accounts will be extracted.
Buttons
Extract – Extract the GL transactions for the selected date range and bank accounts
Cancel – Exit the window without processing
Currency conditions:
Depending on the use of multicurrency and the settings in the ABR Setup, the following table describes the currency combinations and how ABR handles them.
Currency combination table
Notes:
- An exchange rate between the functional currency and bank currency must be supplied, or the transaction is recorded as an exception.
- The fixed euro relationships will be used to translate between the transaction currency and bank currency.
- If the currencies are the same, the amount is extracted without conversion. If two different euro denomination currencies are involved, the euro relationships between them and the euro will be used to translate the amount into the bank currency.
- An exchange rate between the functional currency and the euro currency must be supplied, and the
fixed euro relationships will then be used to complete the conversion to the bank currency. - If the currencies are the same, the amount is extracted directly. If not, an exchange rate must be supplied as per note 1.
When extracting, transactions identified as ‘exceptions’ (the transaction does not contain enough information to allow an amount in the bank currency to be determined) can either be processed via the exchange rate assignment window, or recorded as currency exceptions. This is controlled through the ABR Setup window.
