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.

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. FinancialForce recommends that if the template type is "Currency Translation Only", you only include. companies where the Document and Home currency values are the same. If a company has documents that are not in the Home currency, we recommend that you select a template that has "Currency Revaluation and Translation" as the template type to run Revaluation and Translation together.

To create a currency revaluation template.

  1. On the Currency Revaluation Templates tab, click New.
  2. Enter the Currency Revaluation Template Name. This must be unique.
  3. Select the Revaluation Type. You can select Income Statement, Balance Sheet or Both.
  4. [Optional] Select how you want the process to handle transaction lines that have already been revalued.
  5. [Optional] If you want to view unused currency information, clear the Ignore Unused Currencies checkbox.
  6. 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:
  7. [Optional] Select Exclude CRV Transactions.
  8. Select the Revaluation Exchange Rate Type. Defaults to Average. This is optional for Translation.
  9. Select the Translation Exchange Rate Type. Defaults to Translation. This is optional for Revaluation.
  10. Select Unrealized Gains/Losses GLA. This is only required if you selected Currency Revaluation or Currency Revaluation and Translation as the Template Type.
  11. Select Translation Adjustment GLA. This is only required if you have selected Currency Translation or Currency Revaluation and Translation as the Template Type.
  12. Select the Summary/Detail analysis type. You can select Summarize lines with the same analysis or List all revaluation detail lines individually
  13. [Optional] Select the Analysis Breakdown. This is required if you have selected List all revaluation detail lines individually.
  14. [Optional] Select the Dimensions 1-4 that you want to use if you selected Analysis Breakdown - Sub-Analysis.
  15. Click Save. The Currency Revaluation Template page displays, so that you can assign companies and general ledger accounts to your template.

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 Ledgers 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.