Differences

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

--- en:mr_aru_reskontro [2022/11/01 13:30] – [5.1Filtering options] triinp
+++ en:mr_aru_reskontro [2024/05/17 10:54] (current) – [5.4 Calculation of the reserve for doubtful debts based on the experiential method] vilja
@@ Line 15: / Line 15: @@
   ***Account manager** - shows invoices that have account manager marked on Document.
   ***Reg No** - Customer’s registration number.
-  ***Class** - Customer’s class on the Document. Can be separated interval with colon. Also takes into account additional customer classes.
+  ***Class** - Customer’s class on the Document. Can be separated interval with colon. Also takes into account additional customer classes. Character to search empty field works.
   ***D account** - Customer’s debt account on the invoice. The D account filter works with both a comma list (for example - 12000,12001) and an account selection (for example, 12000:14000).
@@ Line 60: / Line 60: @@
   ***To Pay ** - opens invoice balance
   ***Prepayment** - opens customer’s prepayment list
+  ***Balance** - opens customer`s periodic statement with the data of the last 2 months
+  ***Payment schedule** - the invoice payment schedule opens
 =====4. Fine tuning=====
@@ Line 84: / Line 86: @@
-__** 5.1.1.Sales Ledger regular report with currency option:**__
+=== 5.1.1. Sales Ledger regular report with currency option ===
 {{:et:triinp20221101-121049.png}} \\
 Picture(5)
-__**5.1.2. Show only SEK and USD invoices**__ – for this selection separate currency codes with commas without space „SEK,USD“. If you want to see only USD invoices then write „USD“
+=== 5.1.2. Show only SEK and USD invoices ===
+For this separate currency codes with commas without space „SEK,USD“. If you want to see only USD invoices then write „USD“
 {{:et:triinp20221101-121440.png}} \\
@@ Line 95: / Line 100: @@
 :!: Filtering with "comma" works also with Customer salesman/Invoice salesman.
-__**5.1.3. Don’t show EUR and SEK invoices**__ – for this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR,SEK“ and the report shows only USD invoices. If you want to exclude only SEK invoices, then insert „!SEK“
+=== 5.1.3. Don’t show EUR and SEK invoices ===
+For this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR,SEK“ and the report shows only USD invoices. If you want to exclude only SEK invoices, then insert „!SEK“
 {{:et:triinp20221101-121607.png}} \\
 Picture(7)
-:!: Filtering with exclusion mark "!" works also with Customer salesman/Invoice salesman.
+:!: Filtering with exclusion mark "!" works also with option Customer salesman/Invoice salesman.
-__**5.1.4. Date added and Currency selected**__ – gives the report a balance divided between currencies and calculates prepayments with the currency rate, unpaid payments and balance.
+=== 5.1.4. Date added and Currency selected ===
+Gives the report a balance divided between currencies and calculates prepayments with the currency rate, unpaid payments and balance.
 {{:et:triinp20221101-122703.png}} \\
 Picture(8)
-__**5.1.5.Date not added and currency selected**__ – gives the report all the balance dividend between currencies and calculates prepayments with today’s currency rate, unpaid payments and balance.
+=== 5.1.5. Date not added and currency selected ===
+Gives the report all the balance dividend between currencies and calculates prepayments with today’s currency rate, unpaid payments and balance.
 {{:et:triinp20221101-123010.png}} \\
 Picture(9)
+=== 5.1.6 Overlaps are possible ===
+Works with filter Total - customers. Only customers with both debt and prepayment can be filtered out.
+{{:et:triinp20221209-115203.png}}
+Picture (10)
 ==== 5.2. Using the customer's internal comment  ====
@@ Line 122: / Line 140: @@
 Often, long-term debtors are the same customers to whom reminders are sent and calls are made every week. The answers are mostly the same - "we expect to receive a large order ourselves", etc.…). You can now see such information directly from the sales ledger.
-__**5.2.1. Add a customer debt comment to sales ledgers:**__  \\
+=== 5.2.1. Add a customer debt comment to sales ledgers ===
 {{:et:triinp20221101-124225.png}}\\
-Picture (10)
+Picture (11)
 Also visible when grouped by customers.
 {{:et:triinp20221101-124349.png}}\\
-Picture (11) \\
+Picture (12) \\
 :!: If there is no change option, the user does not have the right to change the client card.
 {{:et:jane20210901-204030.png}}
-Picture (12)
+Picture (13)
-__**5.2.2. The customer's internal comment can be viewed without the possibility to change it**__
+===5.2.2. The customer's internal comment can be viewed without the possibility to change it===
 {{:et:triinp20221101-124837.png}}
+Picture (14)
 ==== 5.3 Payment schedule information ====
@@ Line 143: / Line 163: @@
 {{:et:triinp20221101-131101.png}}
+Picture (15)
+==== 5.4 Calculation of the reserve for doubtful debts based on the experiential method ====
+**In general**
+During the closing of the financial year, it is important to assess the probability of receipt of debts, and if it turns out that their value has decreased, then the debts must be adjusted for allowance. All available information must be taken into account.
+If the debt is individually significant, the decrease in its value must be assessed separately. However, for debts that are not individually significant and where it is not directly known that their value has decreased, the decrease in value can be assessed as a group. When assessing as a whole, previous statistics on doubtful debts **(indicating what percentage they constituted of total debts)** are helpful, making both the amount of doubtful debts and the expense estimate **approximate**.
+If you use allowance as a group of unpaid invoices from buyers, you can use Directo's automatic functionality of creating a reserve for doubtful debts which speeds up the calculation of the amount/change in the reserve and accounting through the "Make transaction" button. In the course of this functionality, a pre-agreed percentage of the total amount of sales invoices not received by the due date is calculated and reflected as an expense of doubtful debts by object. You can change the agreed percentage at any time as needed.
+=== 5.4.1 Settings ===
+System settings
+{{:et:kellylytom20240419-113152.png}}
+Picture (16)
+  ***Bad and Doubtful Debts**  - allows you to enter a balance sheet account, where the reserve for the cost of doubtful receipt is entered (asset account).
+  ***Doubtful debts expense**  - allows you to enter an account to which the cost of doubtful receipt is entered (expense account).
+The following 2 settings go hand in hand, i.e. an equal number of data must be filled in:\\
+  ***Allowance for doubtful debts - experiential allowance %** - allows you to determine   how much of the corresponding group of overdue invoices in % is transferred to the reserve for doubtful invoices.
+  ***Allowance for doubtful debts - groups of overdue invoices** - allows you to set groups of overdue invoices in days.
+Example:
+{{:et:kellylytom20240419-122255.png}}
+Picture (17)
+If the number of entered data is unequal, you will receive an error message:
+{{:et:kellylytom20240419-124454.png}}\\
+Picture (18)
+===  5.4.2 Accounts  ===
+Since doubtful debts accounts must not have previous transactions, create a new balance sheet and income statement account.
+If you are __a starting company__ and there are no previous transactions on these accounts, you do not need to create new accounts. \\
+:!: If you still want to use existing accounts, then before making the first transaction, __zero the balances of the accounts in such a way that the balances of the accounts also go to zero across objects__.
+===  5.4.3 Calculation of the amount of the reserve for doubtful debts  ===
+**Sales ledger report**
+The calculation and transaction of the amount of the reserve for doubtful depts is done in the Sales ledger report, which you can find ''Sales > Reports > Sales ledger''.\\
+If "Allowance for doubtful debts - groups of overdue invoices" and "Allowance for doubtful debts - experiential allowance %" are filled in the system settings, selecting "Doubtful Debts" from the filter and "Object" in total will result in a view where:
+  *at the bottom of the sales ledger report, the calculations of the amounts to be recorded as doubtful appear by __groups of overdue invoices__
+  *in the right side of the report of the sales ledger report, the calculations of doubtful amounts to be transferred __by objects__, which is comparable to the balance sheet, if no direct entries have been made to the accounts, and
+  *__"Make transaction"__ button.
+{{:et:kellylytom20240419-133359.png}}
+Picture (19)
+If there is not an equal amount of data in the setting "Allowance for doubtful debts - groups of overdue invoices" and "Allowance for doubtful debts - experiential allowance %", you will receive an error message:
+{{:et:kellylytom20240419-133640.png}}
+Picture (20)
+=== 5.4.4 Transactions of the reserve for doubtful debts ===
+A transaction for the reserve for doubtful accounts is created by pressing the "Make transaction" button.
+:!: **Important to know** before making a transaction:
+  * Transactions  for the reserve of doubtful debts __must not be created with an object filter__. One transaction must be made at a time, because selecting a filter will give the transaction an incorrect result. Transactions will not be correct even if __"transaction objects" are assigned to the accounts__.
+  * Transactions to the reserve for doubtful debts can also be made manually, but in this case it must be done __consistently__, not mixed with the "Make transaction" functionality.
+  * //In the future//, when creating a transaction for the reserve of doubtful debts, it will also be possible to choose whether you want to create the transaction via the object level or with a specific given object.
+**"Make transaction" button**:
+  *Using the "Make transaction" button, transactions are made by __the objects of the invoice headers__ ("Object" column). In the case of multi-level objects, all levels of the object are included in the transaction.
+  *Transactions are created according to the logic that if the balance of the reserve changes (increases or decreases), then the amounts of the change go to the transaction __by object__.
+  *You can create the transaction multiple times on the same date by pressing "Make transaction", and if there are changes, the entry lines are overwritten.
+  *Transactions can be deleted and recreated if needed.
+Before you start making a doubtful dept transaction, you can see how the transaction is divided between objects:
+{{:et:kellylytom20240419-140745.png}}
+Picture (21)
+Example: The sales ledger is taken as of 31.12.2023 and a reserve transaction is created based on it:
+{{:et:kellylytom20240419-141113.png}}
+Picture (22)
+Transaction:
+{{:et:kellylytom20240419-143223.png}}
+Picture (23)
+Next time, the sales ledger is taken as of 30.06.2024 and based on it, a reserve transaction is created, which contains the change in the reserve > the initial balance of the reserve was 316,133.18 minus the final balance of the reserve 613,698.97 = an increase in the reserve 297,565.79
+{{:et:kellylytom20240419-142637.png}}
+Picture (24)
+Transaction:
+{{:et:kellylytom20240419-143658.png}}
+Picture (25)