This applies to version 3.3.0 and later versions.
...
| Table of Contents |
|---|
...
Overview
In most cases when you enter foreign currency bank transactions it is valued at the exchange rate at the date of the transaction. Entities in Poland are required to perform currency revaluation periodically. Foreign currency-denominated bank accounts in Poland must be revalued using First-In, First-Out (FIFO) method.
The out-of-the-box currency revaluation feature from NetSuite can only revalue transactions based on the current rate at the end of the period. For this reason, Poland Localization contains a feature that allows users to generate the revaluation entries from NetSuite based on the FIFO method.
Setting up Polish Bank Accounts for FIFO Revaluation
Przeszacowanie FIFO must be created first in order to generate FIFO revaluation. This record serves as a configuration record and record where all the schedules and entries will be consolidated.
...
Go to Transactions > Poland Localization > Przeszacowanie FIFO > New (using an administrator role).
Under the Primary Information field group, select the following:
Subsidiary *
Bank Account *
Last Revaluation Period — this defaults to the current period. If the last revaluation period was for the previous month, select the previous month. If no revaluation has been done, clear this field.
Under the Default Entry field group, select the following:
Gain (Loss) Account * — this is the account where the gain or loss will be posted.
Department — this is the department where the adjustment line will be posted.
Class — this is the class where the adjustment line will be posted.
Location — this is the location where the adjustment line will be posted.
Click the Save button.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Make sure to review the list of FIFO Revaluation before creating the record to avoid duplicates. |
Generating FIFO Revaluation Schedule and Entries
To generate a revaluation schedule and entries:
...
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Make sure that all previous revaluation entries have been approved when valid. |
The following records will be created:
FIFO Revaluation Schedule
FIFO Revaluation Entry → Book Value Adjustment
FIFO Revaluation Entry → LILO Value Adjustment
FIFO Revaluation Schedule
Conditions | Revaluation | ||||||
|---|---|---|---|---|---|---|---|
Total Amount | Total Amount (Foreign Currency) | Foreign Currency Balance | Book Value | LILO Value | Gain (Loss) | Book Value Adjustment Entry | LILO Value Adjustment Entry |
Not equal to 0 | Greater than 0 | Total Amount (Foreign Currency) | Total Amount | Search LILO Amount (Debit) (Foreign Currency) → Amount column equivalent | LILO Value | Dr. Gain (Loss) Account | Dr. Bank Account |
Not equal to 0 | Less than 0 | Total Amount (Foreign Currency) | Total Amount | Search LILO Amount (Credit) (Foreign Currency) → Amount column equivalent | LILO Value | Dr. Bank Account | Dr. Gain (Loss) Account |
Not equal to 0 | Equal to 0 | 0 | 0 | 0 | 0 | <none> | <none> |
Equal to 0 | Equal to 0 | 0 | 0 | 0 | 0 | <none> | <none> |
Field Definitions
Period — the period the FIFO revaluation relates.
Foreign Currency Balance — the foreign currency balance as of the period.
Book Value — the base currency balance as of the period.
LILO Value — the calculated “should be” base currency value based on the indirect FIFO method.
Gain (Loss) — LILO value less Book Value
Book Value Adjustment — this entry removes the current base currency balance before adjustment.
LILO Adjustment — this entry replaces the foreign currency balance with the correct value based on FIFO.
| Info |
|---|
The net between Book Value Adjustment Entry and LILO Value Adjustment Entry should be equal to the Gain (Loss). |
Rerunning the FIFO Revaluation for the Previously Revalued Period
If there are instances when you have to rerun the FIFO revaluation for a previously run period, you will need to delete the records that were created that need to be replaced.
...