en:mr_aru_reskontro
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
en:mr_aru_reskontro [2021/07/30 19:45] – [1. Filters and filter options] jane | 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 1: | Line 1: | ||
- | FIXME **This page is not fully translated, yet. Please help completing the translation.**\\ //(remove this paragraph once the translation is finished)// | ||
- | |||
====== Sales Ledger ====== | ====== Sales Ledger ====== | ||
Line 6: | Line 4: | ||
=====1. Filters and filter options ===== | =====1. Filters and filter options ===== | ||
- | + | {{: | |
- | + | Picture(1) | |
***Customer** - Customer’s code on Document (invoice or proceeding). | ***Customer** - Customer’s code on Document (invoice or proceeding). | ||
Line 18: | Line 15: | ||
***Account manager** - shows invoices that have account manager marked on Document. | ***Account manager** - shows invoices that have account manager marked on Document. | ||
***Reg No** - Customer’s registration number. | ***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. |
- | ***D account** - Customer’s debt account on the invoice. | + | ***D account** - Customer’s debt account on the invoice. The D account filter works with both a comma list (for example - 12000, |
***Time** - the time of report. | ***Time** - the time of report. | ||
Line 35: | Line 32: | ||
***Total** - "total sums by" - Customer, Class, Country, Salesman, Account manager, Reg no. | ***Total** - "total sums by" - Customer, Class, Country, Salesman, Account manager, Reg no. | ||
- | ***Sorted by** - report can be sorted by conditions in the options. | + | |
+ | | ||
- | =====2. | + | =====2. |
- | ***Ainult ettemaksuarveid** - kuvab arved millel | + | ***Only prepayment invoices |
- | ***Ainult ületähtaja**- näidatakse ainult neid laekumata arved, mis on üle tähtaja. | + | ***Only overdue |
- | ***Kande aja järgi** - aruannet vaadeldakse arve kande mitte arve aja järgi. | + | ***By Transaction time** - report shows invoices according to the invoice transaction time not invoice creating time. |
- | ***Valuutas** - saldole lisaks näidatakse ka valuuta tulpa, ettemakse kursi kaupa ning lõpus valuutat kokku ja võrdluses hetkekursiga. | + | ***Currency** - besides balance currency is added to the report. By the prepayment currency and currency together and compared to current rate. |
- | ***Jaga** - jaotab aruande kokkuvõtte laekumata arvete summa ajalises lõikes laiali. Nt jaga 3x7 näitab maksetähtajast lähtudes oodatud laekumisi kolme möödunud ja kolme tulevase nädala jooksul. | + | ***Customer data** - report shows customers address, phone number, fax number and e-mail. |
- | ***Kliendiandmed** - näitab aruandes ka kliendi aadressi, telefoni, faksi ja e-maili. | + | ***Invoice project |
- | ***Näita (lisavälja)** - kuvab valitud arve lisavälja sisu. | + | ***Invoice object |
- | ***Arve projekt** - Näidatakse, | + | ***D account** - Report shows debt account. |
- | ***Tellija** - Näidatakse arvel tellijat. | + | ***Orderer** - Report shows Orderer |
- | ***Näita nimi lähetusel** - Näidatakse lähetusel olev nimi. | + | ***Show delivery name ** - report shows delivery name on the invoice. |
+ | ***Edit** - can write and edit Customer internal comment. | ||
+ | :!: Write the text (or edit the text), leave the cell with the mouse, click on the coloured surface of the report and the text will be saved. | ||
- | =====3. Lingid===== | + | :!: If the right to change ´´customers´´ module is removed, the option to ´´edit´´ the sales ledger will disappear. If you have this right and the edit box is checked, |
+ | can write a comment after the customer int comment in the report, which is saved automatically. | ||
- | ***Arve number** | + | {{: |
- | | + | =====3. Links===== |
- | ***Tasuda** - avab arve saldo | + | |
- | ***Ettemaks** - avab kliendi ettemaksude nimekirja | + | |
- | =====4. | + | ***Invoice No** - opens invoice |
- | {{: | + | ***Customer code ** - opens customer card |
- | Pilt(1) | + | ***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. | ||
- | ***Seadistus{{:et:peenh22lestus_ikoon.png?|}}** - Võimalus valida oma personaalseid seadistusi. | + | {{:et:triinp20221101-112859.png}} |
+ | Picture(2) | ||
- | ***Exceli tabel {{: | + | ***Setting{{: |
- | ***Salvesta aruanne | + | ***Excel sheet {{: |
+ | ***Save report | ||
- | | + | {{: |
- | {{:et:myygireskontro_pilt2.png?|}} | + | Picture(3) |
- | Pilt(2) | + | |
+ | {{:et:triinp20221101-120515.png}} | ||
+ | {{: | ||
+ | Picture(4) | ||
- | {{: | + | ***Customer data field with invoice receiver e-mail** - add the invoice receiver’s e-mail |
- | Pilt(3) | + | |
+ | ***Currency** - EUR (default) | ||
- | ***Kliendi lisaväli**, | + | =====5. Examples===== |
- | | + | ====5.1 Filtering options |
- | ***Jaga** sisaldab maksegraafikut - (ei ole arendatud) | + | |
- | ***Valuuta** - EUR (vaikimisi) | + | |
- | =====5. Näited===== | ||
- | ====5.1 Filtreeringute võimalused ==== | ||
+ | === 5.1.1. Sales Ledger regular report with currency option === | ||
- | 5.1.1 Müügireskontro algne aruanne valuuta valikuga: | + | {{:et:triinp20221101-121049.png}} |
- | {{:et:jane: | + | Picture(5) |
- | Pilt(4) | + | |
- | __//**5.1.2 Näita ainult | + | === 5.1.2. Show only SEK and USD invoices === |
- | Kui soov näha ainult USD arveid siis kirjuta " | + | |
- | {{: | + | For this separate currency codes with commas without space „SEK, |
- | Pilt(5) | + | |
- | " | + | {{: |
+ | Picture(6) | ||
- | __//**5.1.3 Ära näita EUR ja SEK arved**//__ - selleks kirjuta ette välistuse märk "!" | + | :!: Filtering with "comma" |
- | {{: | + | === 5.1.3. Don’t show EUR and SEK invoices === |
- | Pilt(6) | + | |
- | "!" märgiga välistuse filtreering töötab ka Müüja kliendikaartil/ | + | For this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR, |
- | + | {{: | |
- | __//**5.1.3 Kuupäev täidetud valuuta linnuke**// | + | Picture(7) |
- | {{:et:jane20210706-184409.png}} | + | :!: Filtering with exclusion mark " |
- | Pilt(7) | + | |
- | __//**5.1.4 Kuupäev täitmata valuuta linnuke**// | ||
- | {{:et:jane20210706-223221.png}} | + | === 5.1.4. Date added and Currency selected === |
- | Pilt(8) | + | |
+ | 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. | ||
+ | |||
+ | {{: | ||
+ | Picture(9) | ||
+ | |||
+ | |||
+ | === 5.1.6 Overlaps are possible === | ||
+ | |||
+ | Works with filter Total - customers. Only customers with both debt and prepayment can be filtered out. | ||
+ | |||
+ | {{: | ||
+ | Picture (10) | ||
+ | |||
+ | ==== 5.2. Using the customer' | ||
+ | |||
+ | The customer' | ||
+ | |||
+ | As an option, information on overdue invoices when customers are called or the customer' | ||
+ | |||
+ | 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", | ||
+ | |||
+ | === 5.2.1. Add a customer debt comment to sales ledgers === | ||
+ | |||
+ | {{: | ||
+ | Picture (11) | ||
+ | |||
+ | Also visible when grouped by customers. | ||
+ | {{: | ||
+ | Picture (12) \\ | ||
+ | |||
+ | :!: If there is no change option, the user does not have the right to change the client card. | ||
+ | {{: | ||
+ | Picture (13) | ||
+ | |||
+ | ===5.2.2. The customer' | ||
+ | |||
+ | {{: | ||
+ | Picture (14) | ||
+ | |||
+ | ==== 5.3 Payment schedule information ==== | ||
+ | |||
+ | If the invoice is received based on a payment schedule, the payment schedule note is added to the end of the invoice data. | ||
+ | |||
+ | {{: | ||
+ | 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, | ||
+ | |||
+ | If you use allowance as a group of unpaid invoices from buyers, you can use Directo' | ||
+ | |||
+ | === 5.4.1 Settings === | ||
+ | System settings | ||
+ | {{: | ||
+ | Picture (16) | ||
+ | |||
+ | ***Bad and Doubtful Debts** | ||
+ | ***Doubtful debts expense** | ||
+ | |||
+ | 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 | ||
+ | ***Allowance for doubtful debts - groups of overdue invoices** - allows you to set groups of overdue invoices in days. | ||
+ | |||
+ | Example: | ||
+ | {{: | ||
+ | Picture (17) | ||
+ | |||
+ | If the number of entered data is unequal, you will receive an error message: | ||
+ | {{: | ||
+ | Picture (18) | ||
+ | |||
+ | === 5.4.2 Accounts | ||
+ | Since doubtful debts accounts must not have previous transactions, | ||
+ | |||
+ | |||
+ | 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, | ||
+ | |||
+ | === 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 '' | ||
+ | |||
+ | If " | ||
+ | *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 | ||
+ | *__" | ||
+ | |||
+ | {{: | ||
+ | Picture (19) | ||
+ | |||
+ | If there is not an equal amount of data in the setting " | ||
+ | {{: | ||
+ | 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" | ||
+ | |||
+ | :!: **Important to know** before making a transaction: | ||
+ | * Transactions | ||
+ | * Transactions to the reserve for doubtful debts can also be made manually, but in this case it must be done __consistently__, | ||
+ | * //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. | ||
+ | |||
+ | **" | ||
+ | |||
+ | *Using the "Make 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", | ||
+ | *Transactions can be deleted and recreated if needed. | ||
+ | |||
+ | Before you start making a doubtful dept transaction, | ||
+ | {{: | ||
+ | Picture (21) | ||
+ | |||
+ | Example: The sales ledger is taken as of 31.12.2023 and a reserve transaction is created based on it: | ||
+ | {{: | ||
+ | Picture (22) | ||
+ | |||
+ | Transaction: | ||
+ | {{: | ||
+ | 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, | ||
+ | {{: | ||
+ | Picture (24) | ||
+ | Transaction: | ||
+ | {{: | ||
+ | Picture (25) |
en/mr_aru_reskontro.txt · Last modified: 2024/05/17 10:54 by vilja