Differences

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

--- en:fin_kanne [2022/08/12 12:50] – [2.2. Row fields] triinp
+++ en:fin_kanne [2025/03/07 10:54] (current) – [6. Fine-tuning] kellylytom
@@ Line 31: / Line 31: @@
   * **Bulk insert** - allows to fill/place rows based on a spreadsheet (mostly excel). The order in which the columns should be is listed in the HELP under the Bulk insert button.
   * **Paste recipe** - to place a recipe.
-  * **Split from Resource** - divides the rows marked with the resource number (the resource must be verified) by the rows of the corresponding resource. The amount is divided by the quantities of resource rows. Object, project, customer, and vendor from the resourse rows are placed on the transactions rows.
+  * **Split from Resource** - divides the rows marked with the resource number (the resource must be verified) by the rows of the corresponding resource. The amount is divided by the quantities of resource rows. Object, project, customer, and supplier from the resource rows are placed on the transactions rows.
   * {{:et:evelint20211122-164558.png}} - these buttons affect the height of the rows.
@@ Line 68: / Line 68: @@
   * **Date** - row date. If empty, the date of the header applies to the row.
   * **Customer** - customer code.
-  * **Supplier** - vendor code.
+  * **Supplier** - supplier code.
   * **Resource** - resource number. Must be filled to divide row with "Split from Resources" button.
   * **Cur. Debit** - debit * rate.
@@ Line 75: / Line 75: @@
   * **Rate** - row currency rate. Placed automatically when placing the currency (if the currency and currency rate are in the base).
   * **Qty** - row quantity.
-  * **PID** - purchase ID field, appears if the system setting 'Fiscal Transactions have PID' is YES.
+  * **PID** - purchase ID field, appears if the system setting 'Fiscal Transactions have PID', is YES.
-===== 3. Fine-tuning =====
+====== 3. Periodization of the transaction (NEW DESIGN) ======
+The periodization functionality of the transaction allows to periodize the financial transaction, i.e. distribute the amount over a longer period.
+:!: Only works on the new design transaction.
+===== 3.1. Periodization methodology =====
+Periodization is based on two rules: **monthly periodization** and **daily periodization**.\\
+**Monthly periodization** - period is divided into months and __all the periodized parts are equal__. Monthly periodization applies if applies the formula: periodization end date + 1 = periodization start date. Periodization  period can be divided into full months.
+These periods are for example:\\
+**Example A**: 01.02.2019-31.01.2020 (31. + 1 = 1. day) and the period is divided exactly into 12 months;\\
+**Example B**: 20.02.2019-19.12.2019 (19. + 1 = 20th day) and the period is divided exactly into 10 months.
+=> (01.03. until 30.11 = 9 months) + (20.02 until 28.02.2019 = 1/3 months) + (01.12 until 19.12.2019 = 2/3 months) = 10 months.\\
+If the periodized sum is 300 EUR, then in **example A** the period sum is: 300 EUR / 12 months = 25 EUR and the same sum applies to all periods. \\
+In **example B** the period sum is: 300 EUR / 10 months = 30 EUR.
+  *30 EUR applies to every month in period 01.03.-30.11.2019 (9x30 EUR).
+  *Between the periods 20.02 -28.02.2019 and 01.12-19.12.2019, which form an additional month, 30 EUR is divided so that the first period receives its share in proportion to the days remaining in that month and is based on a 30-day month => 30/30 * 20 days = 20 EUR. The periodization balance goes to last partial month 300 - 270 - 20 = 10 EUR.\\
+**Daily periodization** applies if the period is not divided into full months or the rule periodization end date + 1 = periodization start date does not apply, and as a result, all periodized parts have a different amount according to the number of calendar days in the month.
+===== 3.2. Periodization of the transaction =====
+Periodization of a transaction can be started from a saved transaction by pressing the "Periodize" button in the header.
+{{:et:kellylytom20240814-115848.png}}
+In the new design, pressing the "Periodize" button opens the first pop-up window where you can set the parameters of periodization. {{:et:kellylytom20240902-131600.png}}
+  ***Description** – description of the periodized transaction, with an automatically added identifier for periodization.
+  ***Side** – selectable from a dropdown menu, allowing you to choose, whether you want to periodize the debit or credit side.
+  ***Frequency of transactions (months)** – selectable from the drop-down menu between 1-12. The explanation can be seen by going to the cell with the cursor. {{:et:kellylytom20240902-131720.png}}
+  ***Start of period** – the start date of the periodization.
+  ***Number of transactions** – allows you to enter the number of times the transaction is made. The explanation can be seen by going to the cell with the cursor.{{:et:kellylytom20240902-132030.png}}
+  ***End of period** – the periodization end date, which comes automatically according to the number of times entered, but can also be written manually.
+After filling in the parameters, press the "Forward" button below, which opens the second pop-up window:
+{{:et:kellylytom20240819-150237.png}}
+  ***Account** – shows the account to be periodized (selected in the first pop-up window, whether debit or credit side is periodized).
+  ***Account VAT** – allows setting the VAT code for the account
+  ***Account objects** – allows setting objects for the account, separated by commas, which will also appear on the periodized transaction.
+  ****Corr. account** – corresponding account, mandatory field. When you go to the field with the mouse, you will see the name of the account in the tooltip.{{:et:kellylytom20240814-120157.png}}
+  ***Corr. account VAT** – allows setting the VAT code for the corresponding account.
+  ***Corr. account objects** – allows setting objects for the corresponding account, separated by commas.
+  ***Sum in base currency** – shows the amount to be periodized.
+  *e.g **01.01.2023** – shows the amount to be periodized on that date; this can be manually overwritten.
+Pressing the {{:et:kellylytom20240814-120224.png}} button will create the periodized transaction, which will be in draft form in the new design. If, upon review, the result is not as desired, pressing the {{:et:kellylytom20240814-120244.png}} button in the header will remove the periodized transaction lines, allowing you to start periodization again.
+{{:et:kellylytom20240814-120428.png}}
+With the parameters given above, a periodized transaction is created by pressing the "Save" button in the draft form:
+{{:et:kellylytom20240814-120522.png}}
+The periodized transaction will have different periods separated by dividing lines. The first section shows the original transaction lines with postings to the corresponding account and the subtraction of the periodized line to avoid double expenses/income.
+  *Line 1 and 2 – original transaction
+  *Line 3 – posting to the corresponding account to the extent of the balance of the amount to be periodized
+  *Line 4 – crediting of the expense account to be periodized, i.e. subtraction to the extent of the balance of the amount to be periodized
+If you have already saved the transaction in draft form, it is possible to delete the lines either one by one or all at once, as a result of which the "Periodize" button in the header becomes active again and it is possible to start periodization again.
+{{:et:kellylytom20240814-120622.png}}
+===== 3.3 Examples: =====
+==== 3.3.1 Entering an incorrect parameter ====
+If the entered object does not exist, the box will turn red upon leaving the field, and a corresponding error message will be displayed, similar to other fields.
+{{:et:kellylytom20240814-141033.png}}
+ ==== 3.3.2 Periodizing a transaction once per quarter over a year ====
+  *Frequency of transactions (months) – the transaction is made every 3 months
+  *Number of transactions – the transaction is made 4 times
+ {{:et:kellylytom20240902-133402.png}} {{:et:kellylytom20240814-140751.png}}
+Result:
+{{:et:kellylytom20240814-140939.png}}
+==== 3.3.3 Periodization of multiple transaction lines ====
+{{:et:kellylytom20240814-141724.png}}
+If there are more lines to be periodized, the second pop-up window shows both accounts that are periodized. If desired, different data can be assigned to them, in this example, different account objects.
+{{:et:kellylytom20240902-133535.png}} {{:et:kellylytom20240814-141956.png}}
+Pressing “Create transactions” and “Save” generates a periodized transactions, showing that each account has its object:
+{{:et:kellylytom20240814-142141.png}}
+==== 3.3.4 Daily periodization, i.e. the period amounts are not equal ====
+In this example, the periodization range cannot be divided into whole months, and periodization takes place with daily precision. The second pop-up window shows how the amounts are calculated according to the number of days.
+{{:et:kellylytom20240902-133641.png}} {{:et:kellylytom20240814-143303.png}}
+Pressing “Create transactions” and “Save” generates a periodized transaction:
+{{:et:kellylytom20240814-143346.png}}
+In the second pop-up window, you can manually overwrite the amounts yourself. If, for example, you manually enter 1000 in the cell for the amount of 19.01.2023, the last cell will contain the amount with a minus and the warning message "Check sums" will appear in the top right.
+{{:et:kellylytom20240815-103726.png}}
+==== 3.3.5 If there is also VAT on the transaction, but you do not want it to be periodized ====
+If the transaction includes VAT and you are periodizing the debit side, and you do not want the VAT to be periodized, enter the same account used for input VAT as the corresponding account.
+{{:et:kellylytom20240814-143637.png}}
+{{:et:kellylytom20240902-133745.png}} {{:et:kellylytom20240814-144132.png}}
+As a result, the transaction will be rotated on the same account:
+{{:et:kellylytom20240814-144209.png}}
+==== 3.3.6 Object level requirement ====
+**Corr. account objects**
+  *If the corr. account has object, the corr. account object is also in the periodization window.{{:et:kellylytom20250307-101410.png}}
+  *If there is no object in the corr. account, but object levels have been set, the account object will appear in the field.{{:et:kellylytom20250307-101939.png}}
+**Object of account subject to periodization**
+  *If the account is missing an object but it has object levels, the corr. account object will be placed there. {{:et:kellylytom20250307-100102.png}}
+**Error messages**
+  *If the level of the object in the field does not match, the field will be red and transactions cannot be created. This also means that objects with a different level cannot be placed. {{:et:kellylytom20250307-102902.png}}
+  *The error field has the following explanatory tooltips:
+  ***'object is invalid'** ⇒ such an object does not exist at alL
+  ***'object with required level is missing'** ⇒ the account has a specified level, but an object with that level has not been added
+  ***'invalid object level'** ⇒ the entered object level is not allowed in the account
+===== 4. Periodization of the transaction (OLD DESIGN) =====
+Periodization of a transaction can be started from a saved transaction by pressing the „Periodize“ button in the header.
+ {{:et:kellylytom20240814-120744.png}}
+In the old design, pressing the „Periodize“ button opens the first pop-up window where you can set the parameters of periodization.
+ {{:et:kellylytom20240814-120825.png}}
+  ***Description** – description of the periodized transaction, with an automatically added identifier for periodization.
+  ***Side** – selectable from a dropdown menu, allowing you to choose, whether you want to periodize the debit or credit side.
+  ***Period** – selectable from the drop-down menu between 1-12. Sets the period after which the transaction is made. For example, number 1 states that a transaction is made every month, while 12 states that a transaction is made every 12 months, i.e. once a year.
+  ***Start date** – the start date of the periodization.
+  ***Times** – allows you to enter the number of times the transaction is made.
+  ***End date** – the periodization end date, which comes automatically according to the number of times entered, but can also be written manually.
+  ***Reset accounts** – this should be ticked when expense and income accounts are periodized, so that double costs/incomes do not arise as a result of the periodized transaction.
+After filling in the parameters, press the „Forward“ button below, which opens the second pop-up window:
+ {{:et:kellylytom20240819-150142.png}}
+  ***Account** – shows the account to be periodized (selected in the first pop-up window, whether debit or credit side is periodized).
+  ***VAT** – allows setting the VAT code for the account.
+  ***Corr. account** – corresponding account, mandatory field. When you go to the field with the mouse, you will see the name of the account in the tooltip.
+{{:et:kellylytom20240814-120912.png}}
+  ***VAT** – allows setting the VAT code for the corresponding account.
+  ***Object** – account objects, must be entered directly into the transaction. In the new design, you can also add  on a pop-up window.
+  *e.g **01.01.2023** – shows the amount to be periodized on that date; this can be manually overwritten.
+if "Reset accounts" is ticked, then pressing the "Create transactions" button, button will create the periodized transaction:
+{{:et:kellylytom20240814-145307.png}}
+The periodized transaction will have different periods separated by dividing lines. The first section shows the original transaction lines with postings to the corresponding account and the subtraction of the periodized line to avoid double expenses/income.
+  *Line 1 and 2 – original transaction
+  *Line 3 – posting to the corresponding account to the extent of the balance of the amount to be periodized
+  *Line 4 – crediting of the expense account to be periodized, i.e. subtraction to the extent of the balance of the amount to be periodized
+If “Reset accounts” is not ticked, the transaction is like that:
+{{:et:kellylytom20240815-105640.png}}
+===== 5. Examples (OLD DESIGN) =====
+==== 5.1 Periodizing a transaction once per quarter over a year ====
+  ***Period** – the transaction is made every 3 months
+  ***Times** – the transaction is made 4 times
+{{:et:kellylytom20240814-141250.png}} {{:et:kellylytom20240819-150618.png}}
+Result:
+{{:et:kellylytom20240814-141136.png}}
+==== 5.2 Periodization of multiple transaction lines ====
+{{:et:kellylytom20240814-141801.png}}
+If there are more lines to be periodized, the second pop-up window shows both accounts that are periodized. If desired, different data can be assigned to them, in this example, different VAT codes.
+{{:et:kellylytom20240814-141838.png}} {{:et:kellylytom20240819-150809.png}}
+Pressing “Create transactions” and “Save” generates a periodized transactions, showing that each account has its VAT codes:
+{{:et:kellylytom20240814-145916.png}}
+==== 5.3 Daily periodization, i.e. the period amounts are not equal ====
+In this example, the periodization range cannot be divided into whole months, and periodization takes place with daily precision. The second pop-up window shows how the amounts are calculated according to the number of days.
+{{:et:kellylytom20240814-150638.png}} {{:et:kellylytom20240819-151028.png}}
+Pressing “Create transactions” and “Save” generates a periodized transaction:
+{{:et:kellylytom20240814-150827.png}}
+In the second pop-up window, you can manually overwrite the amounts yourself. If, for example, you manually enter 1000 in the cell for the amount of 19.01.2023, the last cell will contain the amount with a minus.
+{{:et:kellylytom20240819-151150.png}}
+==== 5.4 If there is also VAT on the transaction, but you do not want it to be periodized ====
+If the transaction includes VAT and you are periodizing the debit side, and you do not want the VAT to be periodized, enter the same account used for input VAT as the corresponding account.
+{{:et:kellylytom20240814-151028.png}}
+{{:et:kellylytom20240814-152102.png}} {{:et:kellylytom20240821-122909.png}}
+As a result, the transaction will be rotated on the same account:
+{{:et:kellylytom20240814-152117.png}}
+===== 6. Fine-tuning =====
 Button {{:et:evelint20211117-151117.png}} on the right side of the header opens the fine-tuning settings.
@@ Line 85: / Line 300: @@
   * **Attachment preview** - whether and where a preview of the attachment attached is displayed. Options are missing, right and bottom.
+===== 6. Bulk insert =====
+You can create transaction rows in Excel and bulk insert them directly to the transaction.
+  *If the account number is specified and the description box is empty, the account name is placed in the Description box
+  *Amounts are placed on the transaction with both a plus and a minus sign
+  *Only one amount can be bulk inserted, either in the debit or credit column
+  *Zero is not a number, i.e. it is possible to insert amounts from an Excel table with Debit 0.00 and Credit 40.00. After importing, only Debit (empty) and Credit 40.00 remain.