Creating Currency Revaluation Templates

When you create a Currency Revaluation (CRV) template, you create the template details first and then assign companies and general ledger accounts separately.

Note:

This functionality is only available in Lightning and must be enabled using Feature Console.

Warning:

If you have upgraded from a previous version of Accounting and have existing currency revaluation templates, you must update the new fields that have been added.

Tip:

If you work in multi-company mode with local companies, we recommend that you create a different template for each local company.

Creating CRV Template Details

For more information, see Currency Revaluation Template Fields.

Note:

The processes that run when you generate revaluation documents are determined by the template type. Certinia recommends that:

• If you have documents that are not in Home currency, first, always select a Currency Revaluation or Currency Revaluation and Translation to dual template type with the same parameters.

• If the template type is "Currency Translation", you only include companies where the Document and Home currency values are the same or run it after a revaluation process that is run with the same parameters.
• If all the documents of the companies are in Home currency, the revaluation process is not applicable, therefore, select the template type "Currency Translation".
• If the template type is Currency Translation to Reporting, the translation process must run after a revaluation process with the same parameters.

To create a currency revaluation template based on transactions lines:

1. On the Currency Revaluation Templates tab, click New.
2. Enter the name in the Currency Revaluation Template Name field. This must be unique.
3. Select the Revaluation Type. You can select "Income Statement", "Balance Sheet" or Both.
4. Select the Template Type. The template type determines the processes that you can run when creating currency revaluation criteria from the template. You can select:
   • Currency Revaluation: Enables you to run revaluation only.
   • Currency Translation: Enables you to run translation only.
   • Currency Revaluation and Translation to Dual: Enables you to run revaluation and translation using the Dual currency.
   • Currency Translation to Reporting: Enables you to run translation using the reporting currency.
5. In the Currency Revaluation Method field, select Transaction Lines.
6. [Optional] If you want to view unused currency information, clear the Ignore Unused Currencies checkbox.
7. [Optional] Select Exclude CRV Transactions if you do not want to revalue or translate existing currency revaluation transactions.
8. [Optional] In the Exclude Revalued Lines field, select how you want the process to handle transaction lines that have already been revalued. There are three options:
   • "None"
   • "Exclude from selection"
   • "Fail with an error"
9. [Optional] In the Analysis section:
   1. Select the Revaluation Exchange Rate Type. Defaults to Average. This is optional for Translation.
   2. Select the Summary/Detail analysis type. You can select "Summarize lines with the same analysis" or "List all revaluation detail lines individually".
   3. Select Unrealized Gains/Losses GLA. This is only required if you selected Currency Revaluation or Currency Revaluation and Translation to Dual as the Template Type. If for the accounting company you select the Use Unrealized Losses GLA checkbox, only use this field for the unrealized gains. Use the Revaluation Unrealized Gains GLA field for the unrealized gains, and the Revaluation Unrealized Losses GLA field for the unrealized losses.
   4. Select Unrealized Losses GLA. This is only required if you selected Currency Revaluation or Currency Revaluation and Translation to Dual as the Template Type.
   5. Select the Dual Translation Exchange Rate Type. Defaults to Translation. This is optional for Revaluation.
   6. Select Dual Currency Adjustment GLA. This is only required if you have selected Currency Translation or Currency Revaluation and Translation to Dual as the Template Type.
   7. Select a value in the Dimension Analysis field.
   8. [Optional] Select the Analysis Breakdown. This is required if you have selected List all revaluation detail lines individually option in the Summary/Detail field.
   9. [Optional] Select the Dimensions 1-4 that you want to use. You must enter at least one dimension if you have selected Analysis Breakdown - Specify Dimensions.
10. Click Save. The Currency Revaluation Template page displays, so that you can assign companies and general ledger accounts to your template.

To create a currency revaluation template based on GLA balances:

1. On the Currency Revaluation Templates tab, click New.
2. Enter the name in the Currency Revaluation Template Name field. This must be unique.
3. In the Revaluation Type field, select the revaluation type. You can select any one from the following options: "Income Statement", "Balance Sheet", and "Both".
4. In the Template Type field, select the template type. The template type determines the processes that you can run when creating currency revaluation criteria from the template. You can select any one from the following options:
   • Currency Revaluation: Enables you to run revaluation only.
   • Currency Translation: Enables you to run translation only.
   • Currency Revaluation and Translation to Dual: Enables you to run revaluation and translation using the Dual currency.
   • Currency Translation to Reporting: Enables you to run translation using the Reporting currency.
5. In the Currency Revaluation Method field, select "GLA Balances" or GLA Balances and Dimensions 1-4"
6. [Optional] Select Bank Account Balance Revaluation to revalue bank accounts. If you select this checkbox, the template type must be "Revaluation" or "Revaluation and Translation" and the revaluation method must be "GLA Balances".
7. [Optional] If you want to view unused currency information, deselect the Ignore Unused Currencies checkbox.
8. Deselect the Exclude CRV Transactions checkbox.
9. In the Exclude Revalued Lines field, select "None".
10. [Optional] In the Analysis section:
    1. In the Revaluation Exchange Rate Type field, select any one option. Defaults to "Average". This is optional for translation.
    2. In the Summary/Detail field, select "None" or leave blank.
    3. In the Unrealized Gains/Losses GLA field, search for and select the unrealized gains or losses GLA. This is only required if you select "Currency Revaluation" or "Currency Revaluation and Translation to Dual" as the template type. If the template has accounting companies with the selected Use Unrealised Losses GLA checkbox, use this field only for the unrealized gains GLA for those companies. This means, use the revaluation Unrealized Gains/Losses GLA field for the unrealized gains, and the revaluation Unrealized Losses GLA field for the unrealized losses.
    4. In the Unrealized Losses GLA field, search for and select the unrealized losses GLA. This is only required if you selected "Currency Revaluation" or "Currency Revaluation and Translation to Dual" as the template type. If the template has accounting companies with the selected Use Unrealized Losses GLA checkbox, the value in this field is used only for those companies. For companies with deselected Use Unrealised Losses GLA checkbox, this field is ignored, and only the value in the Unrealized Gains/Losses GLA is used.
    5. In the Dual Translation Exchange Rate Type field, select the dual translation exchange rate type. Defaults to "Translation". This is optional for revaluation.
    6. In the Dual Currency Adjustment GLA field, select a GLA. This is only required if you have selected "Currency Translation" or "Currency Revaluation and Translation to Dual" as the template type.
    7. In the Dimension Analysis field, select "None" or leave blank.
    8. In the Analysis Breakdown field, select "None" or leave blank.
    9. [Optional] Select the Dimensions 1-4 that you want to use.
11. Click Save. The Currency Revaluation Template page displays. You can assign companies and general ledger accounts to your template.

Notes:

• When you create currency revaluation criteria, the GLAs and the companies associated with the selected template must be either corporate or local.
• When you use GLA Balances template with template type "Currency Revaluation and Translation" in a currency revaluation criteria and generate the journals, first the revaluation journal is created and posted, then the transaction of the revaluation journal is retrieved for the translation process. The revaluation transaction will be considered by the translation process only if the selected GLAs on the template have the Allow Revaluation checkbox selected and the Trial Balance 1 field does not have the value “Equity”.
• If you select the Bank Account Balance Revaluation field, each bank account general ledge account must have the Trial Balance 3 field set to "Bank and Cash". We recommend that each general ledger account represents a single bank account.
  • If the Trial Balance 3 field is set to "Bank and Cash", transaction lines where the Bank Account Currency is the same as the Company's Home Currency but the Document Currency is different these, transaction lines are not revalued.
  • If the Trial Balance 3 field is not set to "Bank and Cash", transaction lines where the Bank Account Currency is the same as the Company's Home Currency but the Document Currency is different, these transaction line items are revalued using the Document Currency.
• If you select the Bank Account Balance Revaluation field. only transaction line items with bank account value will be included in the revaluation. You should avoid using a bank account general ledger account in a manual journal line that is not Bank Account line type. Those GLAs will be excluded from both bank account and the normal revaluation.

Assigning Companies and General Ledger Accounts to a CRV Template

You must meet all three criteria below to assign companies and general ledger accounts to a currency revaluation template:

• The selected companies must either be all corporate or local.
• The selected GLAs must either be all corporate or local.
• Companies and GLAs must be of the same type, either corporate or local.

Assigning Companies to a CRV Template

It is recommended that you assign a maximum of 30 companies to a template.

To assign companies to a currency revaluation template.

1. [Optional] On the Currency Revaluation Templates tab, click the name of the template that you want to assign companies to. The Currency Revaluation Template page displays.
2. On the Select Companies pane, click Manage.
3. Select the companies that you want to assign.
4. Click Save.

Assigning General Ledger Accounts to a CRV Template

If you select a revaluation type of either Income Statement or Balance Sheet, you can select the general ledger accounts used by the revaluation.

If you select a revaluation type of both Income Statement and Balance Sheet, all eligible general ledger accounts are automatically selected.

To assign general ledger accounts to a currency revaluation template.

1. [Optional] On the Currency Revaluation Templates tab, click the name of the template that you want to assign general ledger accounts to. The Currency Revaluation Template page displays.
2. On the Select General Ledger Accounts pane click Manage.
3. Select the general ledger accounts that you want to assign.
4. Click Save.

Notes:

• For the Currency Revaluation template type, the selected general ledger accounts must have the Allow Revaluation checkbox selected.
• For the Currency Translation template type, the Trial Balance 1 field on the selected general ledger accounts must not have the value “Equity”.