---
title: "Translation worksheets (CM304000)"
description: "In this window, you can view the details of existing translations and to edit translation details."
lang: en
languages:
  en: https://docs.vismasoftware.no/visma-net-erp/help/currency-management/currency-management-windows/translation-worksheets-cm304000/index.md
lastmod: 2026-02-19
---

> Documentation index: https://docs.vismasoftware.no/visma-net-erp/help/currency-management/currency-management-windows/llms.txt


# Translation worksheets (CM304000)

Last modified February 19, 2026

> In this window, you can view the details of existing translations and to edit translation details.


This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

In this window, you can view the details of existing translations and to edit translation
details.
When a translation is created, the debit total is equal to the
credit total, because one of the values contains the translation gain or loss
calculated as the difference between the credit total and the debit total.

However,
after you finish editing the translation worksheet, the totals may differ.
If they
do, enter a new translation control total before you save the worksheet.
When you
save it, a new gain or loss will be calculated to compensate for the difference, and
the translation will become balanced again.

This window is available only if the **Translation of financial statements** functionality is enabled in the [Enable/disable functionalities (CS100000)](https://docs.vismasoftware.no/visma-net-erp/help/common-settings/enable-or-disable-functionalites/enable-disable-functionalities-cs100000/index.md) window.

## Search line in list window

If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.

There are two types of search fields:

+ White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or **%** and get different results:

  + space: the result contains the words in any order,
  + **%**: the result contains the words in the specific order, and the **%** functions as a wildcard as well.
+ Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.


## The window toolbar

<table class="vismanet-table">
  <colgroup>
    <col class="vismanet-table__col--key">
    <col>
  </colgroup>
<thead class="vismanet-table__head">
  <tr class="vismanet-table__header-row">
<th class="vismanet-table__cell vismanet-table__cell--header">Button</th>
<th class="vismanet-table__cell vismanet-table__cell--header">Description</th>
</tr>
</thead>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Release</td>
<td class="vismanet-table__cell">Releases the translation and initiates the creation of the appropriate batch.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Reports</td>
<td class="vismanet-table__cell">Provides the <strong>Translation details</strong> menu command, which you can click for quick access to the <a href="/visma-net-erp/help/currency-management/currency-management-reports/translation-details-cm651500-report/index.md">Translation details (CM651500)</a> report for the translation.</td>
</tr>

</table>


## The top part

In this area, you can select a translation that has been prepared in the [Prepare translation (CM501000)](https://docs.vismasoftware.no/visma-net-erp/help/currency-management/currency-management-windows/prepare-translation-cm501000/index.md) window and view the settings of the translation.

<table class="vismanet-table">
  <colgroup>
    <col class="vismanet-table__col--key">
    <col>
  </colgroup>
<thead class="vismanet-table__head">
  <tr class="vismanet-table__header-row">
<th class="vismanet-table__cell vismanet-table__cell--header">Element</th>
<th class="vismanet-table__cell vismanet-table__cell--header">Description</th>
</tr>
</thead>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translation number</td>
<td class="vismanet-table__cell">The unique number assigned to the translation in accordance with the numbering series.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Status</td>
<td class="vismanet-table__cell">The status of the translation, which can be <strong>Balanced</strong>, <strong>Unposted</strong> (the status of a released translation), or <strong>Posted</strong>.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translation date</td>
<td class="vismanet-table__cell">The date when the translation was generated.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Currency effective date</td>
<td class="vismanet-table__cell">The date for the destination currency rate change.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Period</td>
<td class="vismanet-table__cell">The period for which the translation is performed.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Description</td>
<td class="vismanet-table__cell">The detailed description of the translation type.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translation ID</td>
<td class="vismanet-table__cell">The ID of the type of translation, which was defined in the <a href="/visma-net-erp/help/currency-management/currency-management-windows/translation-definition-cm203000/index.md">Translation definition (CM203000)</a> window.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Branch</td>
<td class="vismanet-table__cell">The branch of the company.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Destination ledger ID</td>
<td class="vismanet-table__cell">The destination ledger (which should have a <strong>reporting</strong> type) where the results of the translation will be stored.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Destination currency</td>
<td class="vismanet-table__cell">The currency of the destination ledger.
This is the
currency to which all the amounts should be translated.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translation batch number</td>
<td class="vismanet-table__cell">The number of the batch that implements the
translation transactions upon release.
You can click the batch
number to view details of the batch.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Debit total</td>
<td class="vismanet-table__cell">The debit total for the translation.
The translation
gain or loss amount is added to balance the credit and debit totals.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Credit total</td>
<td class="vismanet-table__cell">The credit total for the translation.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Control total</td>
<td class="vismanet-table__cell"><p>The translation control total.</p>
<p>When the translation worksheet is
saved, the system checks whether the debit total is equal to the
credit total and whether they both are equal to the control total.</p>
<p>If there is any difference resulting from manual editing, you must
enter a new control total.</p>
</td>
</tr>

</table>


## The table

This table displays the list of account balances translated to the specified currency in accordance with the translation settings.

<table class="vismanet-table">
  <colgroup>
    <col class="vismanet-table__col--key">
    <col>
  </colgroup>
<thead class="vismanet-table__head">
  <tr class="vismanet-table__header-row">
<th class="vismanet-table__cell vismanet-table__cell--header">Column</th>
<th class="vismanet-table__cell vismanet-table__cell--header">Description</th>
</tr>
</thead>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Account</td>
<td class="vismanet-table__cell">The particular account for which the balance for the specified subaccount was converted into the destination currency.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Description</td>
<td class="vismanet-table__cell">The description of the account.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Subaccount</td>
<td class="vismanet-table__cell">The subaccount for the account.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translation method</td>
<td class="vismanet-table__cell">The translation method used for the account.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Source amount</td>
<td class="vismanet-table__cell">The period-to-date (PTD) or year-to-date (YTD) balance of the account in the base currency.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Translated amount</td>
<td class="vismanet-table__cell">The PTD or YTD balance of the account in the reporting currency.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Orig. translated amount</td>
<td class="vismanet-table__cell"><p>The account balance in the reporting currency after the previous translation.</p>
<p>For the first translation, all account-subaccount pairs
involved have zero balances.
For the first translation in the
period, all account-subaccount pairs for which the PTD method is
used have zero amounts in the column.</p>
</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Rate type</td>
<td class="vismanet-table__cell">The rate type used for translation of the balance.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Currency rate</td>
<td class="vismanet-table__cell">The effective exchange rate for the destination currency.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Transaction debit amount</td>
<td class="vismanet-table__cell"><p>The debit amount of an adjusting transaction for the account-subaccount pair, which is calculated as the currently translated amount minus the result of the previous translation.</p>
<p>If the difference is positive, it is recorded as the debit amount, and if the difference is negative, the debit amount is set to zero.</p>
</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Transaction credit amount</td>
<td class="vismanet-table__cell"><p>The credit amount of an adjusting transaction for the account-subaccount pair, which is calculated as the currently translated amount minus the result of the previous translation.</p>
<p>If the difference is negative, it is recorded as the credit amount; if the difference is positive, the credit amount is set to zero.</p>
</td>
</tr>

</table>




<h2>Related pages</h2><h3>Concepts</h3>
<ul><li><a href="/visma-net-erp/help/currency-management/manage-translations/about-translations/index.md">About translations</a></li>
</ul><h3>Windows</h3>
<ul><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/translation-definition-cm203000/index.md">Translation definition (CM203000)</a></li><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/currency-management-preferences-cm101000/index.md">Currency management preferences (CM101000)</a></li><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/prepare-translation-cm501000/index.md">Prepare translation (CM501000)</a></li><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/translations-history-cm401000/index.md">Translations history (CM401000)</a></li><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/revalue-general-ledger-accounts-cm506000/index.md">Revalue general ledger accounts (CM506000)</a></li><li><a href="/visma-net-erp/help/currency-management/currency-management-windows/release-translations-cm502000/index.md">Release translations (CM502000)</a></li><li><a href="/visma-net-erp/help/general-ledger/general-ledger-windows/journal-transactions-gl301000/index.md">Journal transactions (GL301000)</a></li>
</ul>


---

[View this page](https://docs.vismasoftware.no/visma-net-erp/help/currency-management/currency-management-windows/translation-worksheets-cm304000/)
