Before entering multi-currency transactions it is necessary to define the parameters of the used currencies in the Exchange rates table.
Columns of the Exchange rate table
The date for the exchange rate.
For each foreign currency, there must be one row without a date for the transaction.
This is the currency that serves as the basis for the exchange rate (the CHF in our example.)
This is the destination currency, the one into which the value of the “Ref. Currency” will be converted.
A text to indicate the foreign currency that we are dealing with
True or false. If there is a fixed exchange rate, enter Yes in this column. The used exchange rate is specified in the Exchange Rate column.
The multiplier is usually 1, 100 or 1000 and is used to obtain the effective exchange rate. The multiplier is used for currencies which have a very low unit value in order to avoid having to insert exchange rates with many zeros. The multiplier can also be negative (-1). In this case, the program will use an inverted exchange rate or else it will act as if the currencies inserted in the Currency and Reference Currency columns had actually been inverted. Do not alter the multiplier once there are already transactions in the same currency, otherwise the program will signal a transaction error due to erroneous exchange rates.
This column shows the actual exchange rate for the currency compared to the reference currency.
It is also being used for calculating the exchange rate differences. Before calculating the exchange rate differences or closing the accounting, this value must be updated by entering the closing exchange rate.
The exchange rate and the multiplier are being applied according to the following formulas
- With multiplier > 0
Currency amount = Ref. currency amount* (exchange rate / |mult.|)
- With multiplier < 0
Ref. currency amount = Currency amount * (exchange rate / |mult.|)
Opening Exchange rate
This is the exchange rate at the moment the accounting is opened. To be indicated only on a row without date.
- It is used to convert the opening amount of the currency into the opening amount of the accounting’s basic currency.
- Should be corresponding to the closing exchange rate of the preceding year.
- The opening exchange rate should never be changed in the course of the year, otherwise exchange rate differences are being created in the total of the opening balances.
- When creating a new year or when updating the opening balances, the program defines the opening exchange rate with the value indicated in the Exchange rate column (row without date) of the accounting of the previous year.
This column shows the minimum exchange rate accepted. If a lesser exchange rate is used during the entry, there will be a warning.
This column shows the maximum exchange rate accepted. If a greater exchange rate is used during the entry, there will be a warning.
This column shows the number of decimal points to be used when rounding the amounts in currency2.
Rows without date
For each used currency, it is necessary to have a row in the Exchange rate table without a date, with the following values:
- The Opening Exchange rate
It is used to convert to the opening balance in basic currency.
It should be set at the begin of the year and not be changed over the year.
- The Current Exchange rate and the Closing Exchange rate (to be updated before calculating the exchange rate differences and before closing the accounting)
Rows with date
From on version 7.04, for each currency a list with exchange rates with the related date can be kept.
The data column is visible in the History or Complete view.
- The value in the Exchange rate column will be proposed as default change when you insert a new transaction. The program chooses the exchange rate with a the date equal to the transaction row or with the closest preceding date to that row.
- When entering an exchange rate with a date, an Opening exchange rate should not be indicated.
Modifications in the Exchange rate table
- Modification of the Opening exchange rate
The next time you recalculate the accounting, the balances in basic currency of the accounts will be recalculated with the new exchange rate. Therefore, pay attention when modifying the Opening exchange rates once you have inserted the opening balances.If you modify the Opening exchange rates and there are opening balances, it is important to recalculate the accounting.
- Modifying the multiplier
When changing the multiplier of a currency already used in the Transactions table, the program will report a warning as soon as the accounting is being recalculated or will move to the transaction row.The transaction amount and the correct amount in the basic currency will have to be reentered.
- When the accounting is being recalculated, as a result the opening balances in basic currency will be recalculated.
Direct an indirect exchange rates
- Direct exchange rates are those where the basic currency and the foreign currency are being indicated on the same row.
In the example below there are direct exchange rates USD->EUR and USD->TRL.
- Indirect exchange rates are those where a direct exchange between two currencies is not being indicated (not recommended).
The exchange rate is deducted by the programn based on other combinations of entered exchage ratesIn this example, the EUR->TRL exchange rate has not been defined, and the program relies on combining the USD-EUR and USD-TRL.
Kabla ya kuingia shughuli nyingi sarafu ni muhimu kufafanua vigezo vya sarafu kutumika katika meza Exchange viwango. Safu ya meza ya kiwango cha ubadilishaji Tarehe kwa ajili ya kiwango cha ubadilishaji. Kwa kila sarafu ya kigeni, lazima kuwe na safu moja bila tarehe kwa ajili ya shughuli. Hii ni sarafu ambayo hutumika kama msingi kwa ajili ya kiwango cha ubadilishaji (CHF katika mfano wetu.) Hii ni sarafu ya marudio, moja ambayo katika thamani ya <unk>Ref. Fedha <unk> itakuwa kubadilishwa. Nakala kuonyesha sarafu ya kigeni kwamba sisi ni kushughulika na kweli au uongo. Kama kuna kiwango cha kubadilishana fasta, kuingia Ndiyo katika safu hii. Kiwango cha kubadilishana kutumika ni maalum katika safu ya Kiwango cha kubadilishana. Kwa kawaida, multiplier ni 1, 100 au 1000, na hutumiwa kupata kiwango cha kubadilishana cha ufanisi. Multiplier ni kutumika kwa ajili ya sarafu ambayo kuwa na thamani ya kitengo chini sana ili kuepuka kuwa na kuingiza viwango vya kubadilishana na sifuri nyingi. Multiplier pia inaweza kuwa hasi (-1). Katika kesi hii, programu itatumia kiwango cha kubadilishana kilichobadilishwa au vinginevyo itafanya kama sarafu zilizoingizwa katika safu ya sarafu na sarafu ya kumbukumbu zilikuwa zimebadilishwa. Je, si kubadilisha multiplier mara moja kuna tayari shughuli katika sarafu hiyo hiyo, vinginevyo programu itaonyesha kosa shughuli kutokana na viwango vya kubadilishana makosa. Safu hii inaonyesha kiwango cha kweli cha kubadilishana kwa ajili ya sarafu ikilinganishwa na sarafu ya rejea. Pia ni kutumika kwa ajili ya kuhesabu tofauti ya kiwango cha ubadilishaji. Kabla ya kuhesabu tofauti ya kiwango cha ubadilishaji au kufunga uhasibu, thamani hii lazima kusasishwa kwa kuingiza kiwango cha ubadilishaji wa kufunga. Kiwango cha kubadilishana na multiplier ni kutumika kulingana na formula zifuatazo: Pamoja multiplier > 0 kiasi cha sarafu = REF. (Cash rate = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency = currency) Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha: Kiwango cha fedha. Ili kuonyeshwa tu juu ya safu bila tarehe. - Ni kutumika kugeuza kiasi cha ufunguzi wa sarafu katika kiasi cha ufunguzi wa sarafu ya msingi ya uhasibu. - Inapaswa kuwa sambamba na kiwango cha kubadilishana kufunga ya mwaka uliopita. - Kiwango cha ufunguzi cha kubadilishana haipaswi kubadilishwa wakati wa mwaka, vinginevyo tofauti za kiwango cha kubadilishana zinaundwa katika jumla ya mabaki ya ufunguzi. Wakati wa kuunda mwaka mpya au wakati wa kusasisha mabaki ya ufunguzi, programu hufafanua kiwango cha ubadilishaji cha ufunguzi na thamani iliyoonyeshwa katika safu ya kiwango cha ubadilishaji (safu bila tarehe) ya uhasibu wa mwaka uliopita. Safu hii inaonyesha kiwango cha chini cha kubadilishana iliyokubaliwa. Kama kiwango cha chini cha kubadilishana ni kutumika wakati wa kuingia, kutakuwa na onyo. Safu hii inaonyesha kiwango cha juu cha kubadilishana iliyokubaliwa. Kama kiwango cha kubadilishana kubwa hutumiwa wakati wa kuingia, kutakuwa na onyo. Safu hii inaonyesha idadi ya alama za decimal ambazo zinatumiwa wakati wa kuzungusha kiasi cha fedha2. Kwa kila sarafu kutumika, ni muhimu kuwa na safu katika meza ya kiwango cha kubadilishana bila tarehe, na maadili yafuatayo: - Kufungua kiwango cha kubadilishana ni kutumika kubadilisha kwa usawa wa ufunguzi katika sarafu ya msingi. Inapaswa kuwekwa mwanzoni mwa mwaka na isiwe na mabadiliko wakati wa mwaka. "Kama ilivyoelezwa hapo juu, ""Mabadiliko ya sasa ya kiwango cha fedha na kufungwa kwa kiwango cha fedha (kufanywa upya kabla ya kuhesabu tofauti za kiwango cha fedha na kabla ya kufunga uhasibu) "" ni orodha ya viwango vya fedha na tarehe inayohusiana na kila sarafu." safu ya data ni kuonekana katika Historia au kukamilika mtazamo. - Thamani katika safu ya kiwango cha ubadilishaji itakuwa mapendekezo kama mabadiliko default wakati wewe kuingiza shughuli mpya. Programu huchagua kiwango cha ubadilishaji na tarehe sawa na safu ya shughuli au na tarehe ya karibu zaidi ya awali kwa safu hiyo. - Wakati kuingiza kiwango cha ubadilishaji na tarehe, kiwango cha ubadilishaji wa ufunguzi haipaswi kuonyeshwa. Mabadiliko katika meza ya kiwango cha ubadilishaji - Mabadiliko ya kiwango cha ubadilishaji cha ufunguzi Wakati mwingine unapoongeza hesabu, mabaki katika sarafu ya msingi ya akaunti yatahesabiwa upya na kiwango kipya cha ubadilishaji. Kwa hiyo, makini wakati wa kurekebisha kufungua viwango vya kubadilishana mara moja umeweka kufungua mabaki.Kama kurekebisha viwango vya kubadilishana kufungua na kuna kufungua mabaki, ni muhimu kwa kuhesabu upya uhasibu. Wakati kubadilisha multiplier ya sarafu tayari kutumika katika meza ya shughuli, programu itaripoti onyo mara tu uhasibu ni kuwa recalculated au itabidi kuhamia mstari shughuli. kiasi cha shughuli na kiasi sahihi katika sarafu ya msingi itakuwa na kuingia tena. - Wakati wa uhasibu ni kuwa recalculated, kama matokeo ya mabaki ya ufunguzi katika sarafu ya msingi itakuwa recalculated. Kiwango cha moja kwa moja cha kubadilishana - Kiwango cha moja kwa moja cha kubadilishana ni wale ambapo sarafu ya msingi na sarafu ya kigeni zinaonyeshwa kwenye safu moja. Katika mfano hapa chini kuna viwango vya moja kwa moja vya kubadilishana USD-> EUR na USD-> TRL. - Indirect viwango vya ubadilishaji ni wale ambapo ubadilishaji wa moja kwa moja kati ya sarafu mbili si kuonyeshwa (haipendekezi). Kiwango cha kubadilishana ni deducted na programu kulingana na mchanganyiko mwingine wa viwango vya kubadilishana aliingia. katika mfano huu, EUR-TRL kiwango cha kubadilishana haijafafanuliwa, na programu hutegemea kuchanganya USD-EUR na USD-TRL.