When your company sells products or services in a transactional currency that is different from the company functional currency, the transactions are automatically booked in the transactional currency. The accounting engine converts the transactional currency to the functional currency by using the appropriate exchange rate on the transaction dates. You can use a data loader, such as the Apex Data Loader, to upload these exchange rates from a spreadsheet into Kenandy.
The exchange rate to convert the transactional currency to the functional currency is the IN exchange rate. Subsequent changes to this IN exchange rate are compared this IN exchange rate. These exchange rate changes result in foreign exchange (FX) expose for the transactions. FX exposure is the potential for gains or losses on the transactions, and starts when title of the goods transfers from the seller to the buyer (when your company ships the product) or when you create the accounting entries for the transactions. Your company can incur gains or losses associated with FX exposure until the transactions are settled.
Generally Accepted Accounting Principles (GAAP) and International Financial Reporting Standards (IFRS) require that financial statements at the end of each period show the gains or losses associated with FX exposure on some open transactions that are not settled before the last day of the period. Kenandy uses the exchange rate at the end of the period to revalue the transactions in the appropriate balance sheet accounts on the last date of the period so that you can report the gains or losses associated with FX exposure on the transactions. In this revaluation, unrealized foreign exchange (UFX) gains or losses are automatically calculated on the transactions.
Because UFX is an estimate, accrual accounting entries for the transaction revaluations and associated UFX gains or losses are booked at the end of the period, and automatically reversed on the first day of the next period. You cannot recognize realized foreign exchange (RFX) gains or losses for these transactions until you settle the transactions.
The following image illustrates the time line for an accounts payable transaction, and shows calculations applicable to unrealized foreign exchange gain for this transaction and the realized foreign exchange gain for this transaction:
In this example, 100 GBPs (Great Britain pounds) for an accounts receivable transaction is converted to 120 USDs (United States dollars) on January 10th, the initial transaction date. At the end of the period on January 31st, the 100 GBPs are worth 150 USDs. Consequently, the amount of functional currency for the initial transaction in accounts receivable is increased by 30 USDs. The offset to this increase is the account on the income statement for the unrealized foreign exchange gain.
When the transaction is settled on February 21st, the 100 GBPs are worth 170 USDs. Consequently, the previous entry for the unrealized foreign exchange gain is reversed because the amount for this entry is an estimate. Also, the amount of the functional currency for the initial transaction in accounts receivable is increased by 50 USDs. The offset to this increase is the account on the income statement for the realized foreign exchange gain.
To learn more about FX types, see GL Accounts and Applicable Foreign Exchange for FX Types.
Only one active GL account can have an FX Type field value of RFX (realized foreign exchange), and only one active GL account can have an FX Type field value of UFX (unrealized foreign exchange).
The following table shows the GL accounts for the FX types. It also shows the applicable foreign exchange for the FX types. The applicable foreign exchange includes realized foreign exchange (RFX), unrealized foreign exchange (UFX), or no foreign exchange (No FX).
| FX Type | GL Accounts | Applicable Foreign Exchange |
|---|---|---|
| Monetary Non-cash | Accounts for assets and liabilities that you can easily convert to cash (for example, short-term accounts receivable and short-term accounts payable). |
RFX. Calculated when you settle the transactions. UFX. Calculated when you click the UFX Revaluation button. |
| Non-monetary | Accounts for assets and liabilities that you cannot easily convert to cash (for example, accounts for fixed assets, inventory, and some prepaid charges). | No FX. |
| RFX |
Account for the realized foreign exchange gain or loss. No further foreign exchange calculations apply to this account because this account balance is the result of the foreign exchange calculations. |
No FX. |
| UFX |
Account for the unrealized foreign exchange gain or loss. No further foreign exchange calculations apply to this account because this account balance is the result of the foreign exchange calculations. |
No FX. |
| P/L Non-monetary | Accounts for the income statement that are recognized in a transactional currency that is the same as the functional currency (for example, accounts for cost of goods sold, depreciation expense, and local tax expense). | No FX. |
| Historical | Accounts that are recognized in a transactional currency that is different from the functional currency and that are not revalued when foreign exchange rates change (for example, accounts for equity, intercompany investments, and variance). Accounting entry lines in these accounts clear for the same amounts that they are posted to the GL. | No FX. |
The following processing occurs when unrealized foreign exchange is automatically revalued in Kenandy:
The source documents relating to these accounting entry lines are used to determine matches.
For example, if the exchange rate on the transaction date for an accounting entry line is an increased rate on the balance sheet date, then the functional currency of the accounting entry line is revalued to reflect the increase. The transactional currency is not revalued.
This accrual and offset are automatically reversed on the first day of the next period.
You can run unrealized foreign exchange (UFX) on the balance sheet any time during a period if the period is open.
The functional currency for accounting entry lines (in the GL accounts with a value of Monetary Non-cash in the FX Type field) is revalued to reflect the current exchange rate (between the transactional currency and the functional currency). The results of the revaluation are displayed.
In the results, the GL Account field shows the GL account, company, and transactional currency for the for the revaluation, and the Revaluation rate field shows the current exchange rate for the revaluation.
You can click the link again to hide these details.
The journal entry details are displayed in a new tab. Each journal entry line is associated with a source document, and the offset for the total amount of the journal entry lines for the source documents is posted to the GL account with a UFX value in the FX Type field. The amount of a journal entry line for a source document increases or decreases the original amount of the accounting entry line for the source document.
As with all journal entries, you can click the Generate Accounting Entry custom link to create accounting entries for this journal entry that applies to the UFX revaluation.
Because UFX for accounting entry lines is an estimate, it is automatically reversed when realized foreign exchange (RFX) is calculated at the time the transactions are settled. If multiple periods pass before RFX is calculated for an accounting entry line, then the previous UFX for the accounting entry line is automatically reversed before the current UFX for the accounting entry line is recognized.
After you revalue unrealized foreign exchange for balance sheets during the period close process, you close the GL area for journal entries. To learn more, see Period Close.
_________________________________
To search the KnowledgeBase and documentation, ask a question, or log a case, please visit the Kenandy Community. To access our online training, visit the Kenandy Learning Center.
Version: Spring 2017