English | English
German | Deutsch
Indonesian | Bahasa Indonesia
Italian | Italiano
Spanish | Español
Turkish | Türkçe
Calculation formulas for amounts and exchange rates
In 1C:Drive, foreign exchange accounting can be applied (the Foreign exchange accounting checkbox is selected in Settings > Cash management). If so, cash management documents include payment amounts in one of the following currency pairs:
- Payment currency and settlement currency
- Payment currency and presentation currency
where payment currency is the currency of the account selected in a document's general details.
The currency pair in a document depends on the operation selected in the document. The document also includes currency exchange rates and multipliers. If needed, 1C:Drive automatically recalculates exchange rates or amounts.
To learn more about calculation formulas and conditions for recalculation, see the subsections below.
Calculation formulas for Payment allocation tab
Tables in this section describe calculation formulas for the fields of the Payment allocation tab in bank payments, cash vouchers, and cash receipts.
- Bank payment where Operation is Payment to supplier, Refund to customer, or Miscellaneous payables.
- Cash vouchers where Operation is Payment to supplier, Refund to customer, or Miscellaneous payables.
- Cash receipts where Operation is Payment from customer, Refund from supplier, Miscellaneous receivables, or Payment from third party.
| Contract amount details | |||
| Condition | Formula for Amount | Formula for Exchange rate | |
| A company’s exchange rate method is Divisor. | Amount = ((Payment amount / Payment currency exchange rate) × Payment currency multiplier) × (Settlement currency exchange rate / Settlement currency multiplier) | Exchange rate = (Amount in settlement currency × Settlement currency multiplier × Payment currency exchange rate) / (Payment amount × Payment currency multiplier) | |
| A company’s exchange rate method is Multiplier. | Amount = ((Payment amount × Payment currency exchange rate) / Payment currency multiplier) × (Settlement currency multiplier / Settlement currency exchange rate) | Exchange rate = (Settlement currency multiplier × Payment amount × Payment currency exchange rate) / (Amount in settlement currency × Payment currency multiplier) | |
- Bank payments where Operation is To expenses.
- Bank receipts where Operation is Other.
- Cash vouchers where Operation is Taxes or To expenses.
- Cash receipts where Operation is Other.
| Condition | Formula for Amount in presentation currency | Formula for Exchange rate |
|---|---|---|
| A company’s exchange rate method is Divisor. | Amount in presentation currency = (Payment amount / Payment currency exchange rate) × Payment currency multiplier | Exchange rate = (Payment amount × Payment currency multiplier) / Amount in presentation currency |
| A company’s exchange rate method is Multiplier. | Amount in presentation currency = (Payment amount × Payment currency exchange rate) / Payment currency multiplier | Exchange rate = (Amount in presentation currency × Payment currency multiplier) / Payment amount |
- Bank receipts where Operation is Payment from customer, Refund from supplier, Miscellaneous receivables, or Payment from third party.
| Settlement amount details | |||
| Condition | Formula for Amount | Formula for Exchange rate | |
| A company’s exchange rate method is Divisor. | Amount = ((Payment amount / Payment currency exchange rate) × Payment currency multiplier) × (Settlement currency exchange rate / Settlement currency multiplier) | Exchange rate = (Amount in settlement currency × Settlement currency multiplier × Payment currency exchange rate) / (Payment amount × Payment currency multiplier) | |
| A company’s exchange rate method is Multiplier. | Amount = ((Payment amount × Payment currency exchange rate) / Payment currency multiplier) × (Settlement currency multiplier / Settlement currency exchange rate) | Exchange rate = (Settlement currency multiplier × Payment amount × Payment currency exchange rate) / (Amount in settlement currency × Payment currency multiplier) | |
Calculation formulas for Payment details tab
The table in this section describes calculation formulas for the fields of the Payment details tab in bank payments, cash vouchers, and cash receipts.
- Bank payments where Operation is Taxes.
- Bank receipts where Operation is Foreign currency acquisition or Taxes.
- Cash vouchers where Operation is Transfer to cash register.
- Cash receipts where Operation is Withdrawal from cash register, Withdrawal from cash register (RIM), or Foreign currency acquisition.
| Condition | Formula for Amount in presentation currency | Formula for Exchange rate |
|---|---|---|
| A company’s exchange rate method is Divisor. | Amount in presentation currency = (Payment amount / Payment currency exchange rate) × Payment currency multiplier | Exchange rate = (Payment amount × Payment currency multiplier) / Amount in presentation currency |
| A company’s exchange rate method is Multiplier. | Amount in presentation currency = (Payment amount × Payment currency exchange rate) / Payment currency multiplier | Exchange rate = (Amount in presentation currency × Payment currency multiplier) / Payment amount |