Currency exchange changes in f. currency bank accounts cause increases or decreases in their balances.
These increases/decreases are recorded by calculating exch. rate differences. When exchange rate difference is calculated through bank account transactions, the difference between the day of calculation and the exchange rate of the transaction is processed for exchange rate difference calculations. The exchange rate difference results in debit or credit depending on the decrease or increase in the exchange rate.
For the exch. rate diff. calculation for bank accounts, the Bank Exch. Rate Diff. Calculations option located in the Operations menu of the Finance section is used.
As the calculation results can be collected in a single exchange rate difference slip belongs to calculation date, also they can generate slips that include separate exchange rate differences for all bank account transaction dates by "Generating Consecutive Exchange Rate Differences" facility of program.
The following filter options are used to specify the exch. rate diff. calculation conditions:
Calculation Date: Indicates the date of which the daily exchange rate will be used for the calculation. The exchange rate value is read from the foreign currency file.
Bank Account Code: Used to filter the bank or bank accounts to which the exchange rate difference calculation will be applied. Conditions are set by defining groups or ranges.
Bank Account Aux. Code: Bank accounts for which the difference will be calculated can also be filtered by bank account aux. code. The filter is applied by making a group or range definition.
Trading Group: Used to filter the trading groups to which the exchange rate difference calculation will be applied. The filter is applied by making a group or range definition.
Division: This filter line is used to specify the transactions performed by which division(s) will be processed for the calculation.
Department: This filter line is used to specify the transactions performed by which department(s) will be processed for the calculation. Only the transactions performed through the departments specified on this field are scanned for each account, and the rate difference is calculated only for these transactions.
F. Currency Type: This filter line is used to specify the transactions performed in which currency will be processed for the calculation. More than one currency type can be selected on this field. In such cases, exchange rate difference is calculated separately for each currency type.
Exc. Rate Diff. Limit: This line is used to specify a limit in order to prevent the exchange rate difference to be reflected on the Exch. Rate Diff. Slip to be generated when the exchange rate calculated in the currency type selected for the calculation is under a specific limit. If the calculated exchange rate difference is smaller than the amount entered on this field, the resulting exchange rate difference is not processed.
Description: The information required to be included in the line description of the exchange rate difference slip is entered into this filter line as default.
Exc. Rate Diff. Type: This filter line is used to specify the transactions to be processed in exchange rate difference calculations. The exchange rate difference can be calculated only for bank accounts with only debit or only credit balances, or can contain both.
Exchange Rate Type: Used to specify exchange rate type to be considered in exch. rate diff. calculations.
Exchange Rate Difference Control: Used to determine whether the Exchange Rate Difference will be done or not. Includes "Will be done" and "Will not be done" options. Used to record exchange rate difference slip in user control generated at the end of the calculation.
When "Will be done" is selected, each exchange rate difference slip comes to screen before it is saved and user saves it.
If "Will not be done" is selected, at the end of the exchange rate difference calculations, the slips are generated and saved automatically.
Generate Consecutive Exchange Rate Differences: Used to generate separate exchange rate difference slips for each day when transactions done in f. currency. The option contains Yes and No options.
If "Yes" is selected, for each day (when f. currency transactions belong to accounts (receivable/payable)), between specified date in "exchange rate different beginning date" filter line and calculation date, a separate slip is generated.
If "No" is selected, considering the calculation date, a single exchange rate difference slip is generated for transactions in f. currency.
Calculation Start Date: Used in consecutive exchange rate difference calculations. In the event of approving "Generate Consecutive Exchange Rate Differences" filter, it indicates the starting date of the calculation.
Check / P. Note Status: Used to filter check and p. notes, which will be considered during bank exchange rate calculation, according to their statuses. This filter line contains the following options:
- All
- Being Collected from Bank
- Collected from Bank
Once the conditions are set for the exchange rate difference calculation, clicking on "OK" button starts the transaction. Calculated exchange rate differences are inserted into the Bank Exchange Rate Difference Slip generated by the application. The date of the Exchange Rate Difference Slip is the date specified on the Exchange Rate Difference window.
When the exchange rate value of a given date cannot be read from the exchange rate table during the calculation or when accounts are not processed through the specified F. currency type, the application displays "No account found with exchange rate difference" warning message.
Likewise, exchange rate difference calculations cannot be performed when a date different than the working days specified on "Company Parameters" is entered.