{"id":8865,"date":"2018-05-10T08:12:32","date_gmt":"2018-05-10T08:12:32","guid":{"rendered":"http:\/\/www.erplybooks.com\/?page_id=8865"},"modified":"2023-08-10T07:49:35","modified_gmt":"2023-08-10T07:49:35","slug":"finantsaruanded","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/juhendid\/finantsaruanded\/","title":{"rendered":"Finantsaruanded"},"content":{"rendered":"<h1>Finantsaruanded<\/h1>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Finantsaruanded on saadaval aruande moodulis, vaatamiseks ava\u00a0<b>\u201cAruanded\u201d<\/b>. Avanenud men\u00fc\u00fcst saad valida j\u00e4rgmised finantsaruanded: <\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><b>Bilanss<\/b><\/span><\/li>\n<li><span style=\"font-weight: 400;\"><b>Kasumiaruanne<\/b><\/span><\/li>\n<li><span style=\"font-weight: 400;\"><b>Rahavoogude aruanne<\/b>\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><b>Saldoaruanne<\/b><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2>Bilanss<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Bilansi avamiseks mine\u00a0<b>\u201cAruanded\u201d &gt; \u201cBilanss\u201d<\/b>. Mittedetailne bilansi vaade on toodud j\u00e4rgmisel pildil. Kui paned linnukese <b>\u201cN\u00e4ita k\u00f5iki\u201d<\/b> ette, siis kuvatakse Sulle ka nullsaldodega read.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/bilanss.png\" alt=\"Finantsaruanded\" width=\"679\" height=\"385\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Detailne bilansi vaade n\u00e4itab bilansiridasid kontode kaupa. Selline n\u00e4eb v\u00e4lja detailne bilansi vaade:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/bilanss2.png\" alt=\"Finantsaruanded\" width=\"679\" height=\"385\" \/><\/p>\n<h2><\/h2>\n<h2>Bilanss 12 kuud<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\"><b>\u201cBilanss 12 kuud\u201d<\/b> n\u00e4itab kokkuv\u00f5tet aruandeaasta kuude kohta. Lisaks on Sul v\u00f5imalus n\u00e4ha k\u00f5iki kontosid eraldi v\u00f5i neid grupeerida. Aruande avamiseks mine <b>\u201cAruanded\u201d &gt; \u201cBilanss\u201d &gt; \u201cBilanss 12 kuud\u201d<\/b>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/bilanss12kuud.png\" alt=\"\" width=\"679\" height=\"385\" \/><\/p>\n<h2><\/h2>\n<h2>Kasumiaruanne<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Ava\u00a0<b>\u201cAruanded\u201d &gt; \u201cKasumiaruanne\u201d<\/b>. J\u00e4rgnevalt pildilt n\u00e4ed, kuidas n\u00e4eb v\u00e4lja mittedetailne aruande vaade. Kui paned linnukese <b>\u201cN\u00e4ita k\u00f5iki\u201d<\/b> ette, siis kuvatakse Sulle ka nullsaldodega read.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/kasumiaruanne.png\" alt=\"\" width=\"679\" height=\"385\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Kasumiaruande detailne vaade n\u00e4itab kasumiaruande ridasid kontode kaupa. Selliselt n\u00e4eb v\u00e4lja detailne kasumiaruande vaade:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/kasumidetailne.png\" alt=\"\" width=\"679\" height=\"385\" \/><\/p>\n<h2>Kasumiaruanne 12 kuud<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\"><b>\u201cKasumiaruanne 12 kuud\u201d<\/b> n\u00e4itab kokkuv\u00f5tet kalendriaasta k\u00f5ikidest kuudest. Lisaks saad kandeid n\u00e4ha grupeeritult. Aruande avamiseks mine <b>\u201cAruanded\u201d &gt; \u201cKasumiaruanne\u201d &gt; \u201cKasumiaruanne 12 kuud\u201d<\/b>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/kasum12kuud.png\" alt=\"\" width=\"679\" height=\"385\" \/><\/p>\n<h2><\/h2>\n<h2>V\u00f5rdlev raport<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\"><b>Ava \u201cAruanded\u201d &gt; \u201cKasumiaruanne\u201d &gt; \u201cV\u00f5rdlev raport\u201d<\/b>. V\u00f5rdleva raporti abil on v\u00f5imalik anal\u00fc\u00fcsida ja omavahel v\u00f5rrelda erinevaid aruandeperioode. Omavahel saab v\u00f5rrelda n\u00e4iteks kahte kuud ja aastat.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/v\u00f5rdlevraport.png\" alt=\"\" width=\"679\" height=\"385\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Isedisainitud aruanded<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Sul on v\u00f5imalik koostada endale sobilikud bilanss ja kasumiaruanne, kus saad kontod ja nende j\u00e4rjekorra grupeerida vastavalt Sinu enda soovile. Disainimiseks on kaks meetodit: lihtne ja kompleksne meetod.<\/span><\/p>\n<h4>1. Lihtne meetod<\/h4>\n<p><span style=\"font-weight: 400;\">Selleks ava\u00a0<b>\u201cRMP\u201d &gt; \u201cKontoplaan\u201d<\/b> ja kirjuta\u00a0<b>\u201cTAG\u201d<\/b> lahtrisse enda valitud grupeeringu nimetus. K\u00f5ikidele kontodele, mida soovid \u00fches grupis n\u00e4ha, kirjuta TAG lahtrisse sama nimetus ja need kuvatakse aruandes selle nimetuse all. Kui kasutad hierarhiat, siis eralda erinevad grupid semikoolonitega (nt. EMA; T\u00fctar; T\u00fctret\u00fctar v\u00f5i AKTIVA; N\u00f5uded ja ettemaksed; Maksude ettemaksed).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Enda disainitud aruande n\u00e4gemiseks pane aruande kuvamisel linnuke <b>\u201cEnda disainitud raport?\u201d<\/b> ette ja vajuta\u00a0<b>\u201cOtsi\u201d<\/b> nuppu.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/endabilanss.png\" alt=\"\" width=\"679\" height=\"385\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/endakasumi.png\" alt=\"Finantsaruanded\" width=\"679\" height=\"385\" \/><\/p>\n<h4>2. Kompleksne meetod<\/h4>\n<p>&nbsp;<\/p>\n<p><strong>KASUMIARUANDE DISAINIMINE<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Kasumiaruande disainimiseks kirjuta pealehe otsingulahtrisse <b>\u201cOrder of profit and loss statement\u201d<\/b>. Avanenud tabelis saad m\u00e4\u00e4rata kasumiaruandes soovitud read.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/09\/Screen-Shot-2020-09-23-at-11.03.56.png\" alt=\"\" width=\"700\" height=\"550\" \/><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: justify;\"><b>Nimi<\/b> &#8211; nimi, mida soovid aruandes n\u00e4ha.<\/li>\n<li style=\"text-align: justify;\"><b>Kasumiaruande t\u00fc\u00fcp<\/b> &#8211; t\u00e4ida ainult siis, kui ei soovi k\u00f5iki kontosid sinna m\u00e4\u00e4rata.<\/li>\n<li style=\"text-align: justify;\"><b>Index<\/b> &#8211; m\u00e4\u00e4re ise ridadele positsioonid, mille j\u00e4rgi saad koostada valemeid.<\/li>\n<li style=\"text-align: justify;\"><b>Hierarchy<\/b>&#8211; kui palju paremale poole nimetus n\u00e4idatakse.<\/li>\n<li style=\"text-align: justify;\"><b>Konto<\/b> &#8211; vali konto, soovitatav on kasutada konto vahemikku (account range lahter).<\/li>\n<li style=\"text-align: justify;\"><b>Vali<\/b> &#8211; saad valida ema grupeeringu. Ema grupeering moodustatakse Sinu poolt sisestatud nimetuse p\u00f5hjal. Selle valimiseks salvesta vahepeal andmed ja seej\u00e4rel kuvatakse see valikulisti.<\/li>\n<li style=\"text-align: justify;\"><b>Special type<\/b><\/li>\n<li style=\"text-align: justify;\"><b>This is total field?<\/b> &#8211; kui on jah ja ema on m\u00e4\u00e4ratud, siis pannakse ema v\u00e4\u00e4rtus siia.<\/li>\n<li style=\"text-align: justify;\"><b>Valem<\/b> &#8211; m\u00e4\u00e4ra valem, kasutades selles ridadele m\u00e4\u00e4ratud numbreid (index). Liita saad eelnevaid ridasid, j\u00e4rgnevaid ridasid liita ei saa. Valemisse l\u00e4hevad v\u00e4\u00e4rtused j\u00e4rjekorranumbri alusel. N\u00e4iteks, kui oled elemendile m\u00e4\u00e4ranud j\u00e4rjekorra numbri 100, siis saad j\u00e4rgmisi v\u00e4\u00e4rtusi kasutada valemi koostamisel (sum100 \u2013 rea algsaldo, changeSum100 \u2013 rea muutus perioodis).<\/li>\n<li style=\"text-align: justify;\"><b>Account range<\/b> &#8211; kontode vahemik, mida saab eraldada komade ja sidekriipsudega.<\/li>\n<li style=\"text-align: justify;\"><b>Project<\/b> &#8211; kui soovid koostada kindla projekti kohta aruande.<\/li>\n<li style=\"text-align: justify;\"><b>Multiplier<\/b> &#8211; positiivselt kuvamiseks vali 0, negatiivselt kuvamiseks -1 (n\u00e4iteks kui soovid kulusid n\u00e4ha miinusm\u00e4rkidega).<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Ridadele saad lisada j\u00e4rgmisi v\u00e4\u00e4rtusi:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\">DEBIT_SUM<\/li>\n<li style=\"text-align: justify;\">CREDIT_SUM<\/li>\n<li style=\"text-align: justify;\">OPENING_BALANCE<\/li>\n<li style=\"text-align: justify;\">CLOSING_BALANCE<\/li>\n<li style=\"text-align: justify;\">PROFIT<\/li>\n<li style=\"text-align: justify;\">m\u00fc\u00fcdud toodete kogus kokku<\/li>\n<li style=\"text-align: justify;\">tootegrupi m\u00fc\u00fcdud kogus<\/li>\n<li style=\"text-align: justify;\">m\u00fc\u00fcdud kogus va kindel tootegrupp<\/li>\n<li style=\"text-align: justify;\">m\u00fc\u00fcdud kogus koos lisatingimustega (ise m\u00e4\u00e4rad tingimuse)<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><b>T\u00fchjad read<\/b> &#8211; lisa nime lahtrisse <b>EMPTY.<\/b><\/span><br \/>\n<span style=\"font-weight: 400;\"><b>Summa read<\/b> &#8211; kui soovid konkreetse koha peale summa rida, siis see peab olema mingi konkreetse rea t\u00fctar.<\/span><br \/>\n<span style=\"font-weight: 400;\">Aruannetesse saad valemitega lisada ka suhtarve.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong>BILANSI DISAINIMINE<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Bilansi saad disainida samamoodi, nagu eelnevalt on kasumiaruande kohta kirjeldatud. Kirjuta selleks pealehe otsingukasti <b>\u201cBalance sheet order of assets, liabilities and equity\u201d<\/b>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Et aruandeaasta kasum v\u00f5i kahjum j\u00f5uaks bilanssi, tuleb luua rida, kus kontode lahter j\u00e4etakse t\u00fchjaks ja <b>\u201cSpecial type\u201d<\/b> lahtrisse tuleb lisada <b>\u201cPROFIT\u201d<\/b>.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5282\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/10\/Screen-Shot-2020-10-19-at-12.13.35.png\" alt=\"Finantsaruanded\" width=\"609\" height=\"413\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Projekti ja asukohap\u00f5hine aruanne<\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Kui Sul on mitu erinevat osakonda ja soovid aruannet kuvada ainult \u00fche osakonna kohta, tr\u00fcki pealehe otsingusse <b>\u201cPrindi saldoaruanne projektide l\u00f5ikes\u201d<\/b>. J\u00e4rgnevalt saad teha kaks valikut:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\">tr\u00fcki enda disainitud aruanne kontode l\u00f5ikes.<\/li>\n<li style=\"text-align: justify;\">tr\u00fcki saldoaruanne projektide l\u00f5ikes.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8886\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/08\/raport.png\" alt=\"Finantsaruanded\" width=\"400\" height=\"200\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Finantsaruanded &nbsp; Finantsaruanded on saadaval aruande moodulis, vaatamiseks ava\u00a0\u201cAruanded\u201d. Avanenud men\u00fc\u00fcst saad valida j\u00e4rgmised finantsaruanded: Bilanss Kasumiaruanne Rahavoogude aruanne\u00a0 Saldoaruanne &nbsp; Bilanss &nbsp; Bilansi avamiseks mine\u00a0\u201cAruanded\u201d &gt; \u201cBilanss\u201d. Mittedetailne bilansi vaade on toodud j\u00e4rgmisel pildil. Kui paned linnukese \u201cN\u00e4ita k\u00f5iki\u201d ette, siis kuvatakse Sulle ka nullsaldodega read. &nbsp; Detailne bilansi vaade n\u00e4itab bilansiridasid kontode kaupa. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":3312,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[451],"tags":[23,33,616,617,89],"class_list":["post-8865","page","type-page","status-publish","hentry","category-aruandlus","tag-aruanded","tag-bilanss","tag-finants","tag-finantsaruanded","tag-kasumiaruanne"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/8865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=8865"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/8865\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/3312"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=8865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=8865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=8865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}