Differences

This shows you the differences between two versions of the page.

--- en:raamatupidaja_nipinurk [2022/09/20 14:44] – [How can I compare the income statement with the budget by object ?] triinp
+++ en:raamatupidaja_nipinurk [2026/09/24 11:55] (current) – [Example] lauratam
@@ Line 253: / Line 253: @@
   * If **split objects** is not selected, the same report will show all object combinations in a separate row
-{{:et:triinp20220920-133627.png}}
+{{:et:triinp20220920-144926.png}}
@@ Line 709: / Line 709: @@
 {{:et:jane20220708-195820.png}}
+==== What does "Difference" show? ====
+{{:et:lauratam20260924-110955.png}}
+It is a misconception that the **difference** only reflects gains/losses from exchange rate changes and that in the base currency the difference must always be 0. The difference **cannot always be 0**, because it actually shows:
+  * For **payments**: the difference, in base currency, between the amount actually paid and the balance of liabilities (purchase invoices)
+  * For **receipts**: the difference, in base currency, between the amount actually received and the balance of receivables (invoices)
+**Difference sum arises, for example, in these situations:**
+  * Paying/receiving an invoice in a foreign currency (due to an exchange rate change, a commercial rate, or payment in a different currency)
+  * Paying/receiving a prepayment (without a prepayment invoice, or for a purchase/ sales order)
+  * Partial payment/receipt of an invoice
+  * Paying/receiving an invoice together with fines
+  * Netting with a Prepayment ID (PreID)
+**Example 1. Paying prepayments and purchase invoices**
+{{:et:lauratam20260924-113854.png}}
+The difference is calculated from document columns that cannot be edited directly:
+  * **Invoice balance EUR:** the row's purchase invoice balance in the base currency at the time of payment. If there isn't a purchase invoice on the row, the value is 0. The header field Purchase invoices shows the total.
+  * **Paid EUR:** the row's paid amount in the base currency. The header field Paid shows the total.
+  *** Difference:** the difference between the paid amount and the invoice balance, in the base currency.
+**Negative difference, meaning less was paid than the liability balance:**
+  * Partial payment
+  * Netting with a prepayment
+  * Exchange rate gain
+**Positive difference, meaning more was paid than the liability balance:**
+  * Prepayment
+  * Late payment fine paid
+  * Exchange rate loss
+:?: When netting prepayments or credit invoices, the **Paid** field shows whether the purchase invoice and prepayment amounts are equal. If they are, the amount to be paid is 0. For netting, use a payment method whose type is set to **EQUAL**. The system then automatically checks that the final total is 0 when the prepayment is cleared.
+**Example 2. Receiving prepayments and invoices**
+{{:et:lauratam20260924-115256.png}}
+The difference is calculated from document columns that cannot be edited directly:
+  * **Inv. Balance EUR:** the row's invoice balance in the base currency at the time of receipt. If there isn't an invoice on the row, the value is 0. The header field Invoices sum shows the total.
+  * **Received EUR:** the row's received amount in the base currency. The header field Received shows the total.
+  * **Difference:** the difference between the received amount and the invoice balance, in the base currency.
+**Negative difference, meaning less was received than the receivables balance:**
+  * Partial receipt
+  * Netting with a prepayment
+  * Exchange rate loss
+**Positive difference, meaning more was received than the receivables balance:**
+  * Prepayment received
+  * Late payment fine received
+  * Exchange rate gain