{"id":32246,"date":"2023-07-04T09:55:09","date_gmt":"2023-07-04T09:55:09","guid":{"rendered":"https:\/\/www.erplybooks.com\/?page_id=32246"},"modified":"2026-08-26T13:20:31","modified_gmt":"2026-08-26T13:20:31","slug":"saldode-umardamine-kahe-komakohani","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/saldode-umardamine-kahe-komakohani\/","title":{"rendered":"Saldode \u00fcmardamine kahe komakohani"},"content":{"rendered":"<h1>Saldode \u00fcmardamine kahe komakohani<\/h1>\n<p>&nbsp;<\/p>\n<p>Kui Sul ilmevad sendierinevused aruannetes<span style=\"font-weight: 400;\">, n\u00e4iteks erinevad bilansis aktiva ja passiva \u00fche sendi v\u00f5rra, siis v\u00f5ib see tulla \u00fcmarduse komakohtade arvust algsaldodes.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Algsaldode numbrid peaksid olema sisestatud kahe komakohaga, et tulevikus ei tekiks \u00fcmardusvahesid. Kui Sul on rohkem komakohti, siis tuleks need korrigeerida. V<\/span><span style=\"font-weight: 400;\">aikimisi tehakse kanded nii mitme komakohaga kui kanne tekib. N\u00e4iteks kui arve rea summa on 10.5722, siis kande reale l\u00e4hebki 10.5722, aga mitte 10.57. Seega v\u00f5ib tekkida \u00fcmardusvahe, kui bilanssi kokku pannakse, sest bilansi elemendid \u00fcmardatakse kahe komakohani.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Algsaldode kontrollimiseks mine <b>\u201cS\u00e4tted\u201d &gt; \u201cAlgandmed\u201d &gt; \u201cSisesta algsaldod\u201d <\/b>ja valige algsaldode kuup\u00e4ev.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">J\u00e4rgnevas n\u00e4ites on k\u00f5ik algsaldod n\u00e4ha kahe komakohaga.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/09\/algsaldod.png\" alt=\"Sendierinevused aruannetes\" width=\"400\" height=\"200\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Kui teed topelt hiirekl\u00f5psu valitud saldo peal, n\u00e4ed, et saldo tegelik number v\u00f5ib olla \u00fcmardatud kolme v\u00f5i enama komakohani.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/09\/alsaldod-2.png\" alt=\"Sendierinevused aruannetes\" width=\"400\" height=\"200\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Algsaldod saad parandada kahe komakohani kohe <strong>&#8220;Saldo&#8221;<\/strong> tulbas ja seej\u00e4rel salvestada. Selle jaoks pead k\u00f5ik numbrid \u00fcle kontrollima. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Lihtsam viis on kahe komakohani \u00fcmardada aga Excelis. Selleks toimi j\u00e4rgnevalt:<\/span><\/p>\n<ul>\n<li style=\"text-align: justify;\">ERPLY Booksi algsaldode lehel vajuta klahvikombinatsioone <b>Ctrl+E, Ctrl+A ja Ctrl+C<\/b>.<\/li>\n<li style=\"text-align: justify;\">Kleebi andmed Excelisse <b>Ctrl+V<\/b>. Kasuta numbrite \u00fcmardamiseks funktsiooni <b>=ROUND(A2, 2)<\/b>, kus A2 on lahter ja 2 on komakohtade arv.<\/li>\n<li style=\"text-align: justify;\">Kleebi muudetud andmed uuesti ERPLY Booksi algsaldode lehele. Aktiveeri andmed Excelis, vajuta\u00a0<b>Ctrl+C.<\/b><\/li>\n<li style=\"text-align: justify;\">ERPLY Booksi algsaldode lehel tehke \u00fcks hiirekl\u00f5ps esimesel lahtril, et see muutub siniseks, ja vajuta\u00a0<b>Ctrl+V<\/b>.<\/li>\n<li style=\"text-align: justify;\">Vajuta\u00a0<b>\u201cSalvesta\u201d<\/b> nuppu.<\/li>\n<li>Seej\u00e4rel kuvatakse aktiva ja passiva numbrid. Veendu, et need oleksid v\u00f5rdsed.<\/li>\n<li>Kui k\u00f5ik valmis, siis avage \u00dcldised s\u00e4tted ja aktiveerige: <strong>\u00dcmarda kandeid automaatselt <\/strong>(<strong><span style=\"font-weight: 400;\">\u201cKomakohti \u00fcmardamisel &#8211; 2\u201d)<\/span><\/strong>\n<div><\/div>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39852\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/08\/Screenshot-2026-08-26-155002.png\" alt=\"\" width=\"864\" height=\"127\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Vajadusel saad teha seda ka saldode korrigeerimist aasta keske perioodi, mis on lukustatud. Sel juhul toimi samamoodi nagu eelnevalt kirjeldatud, kuid vali peale algsaldode avamist soovitud kuup\u00e4ev, mil tahad saldosid korrigeerida. Korrigeerimine tehakse selle kuup\u00e4evaga.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kui aruannetes on vahe suurem kui 1 sent, siis t\u00f5en\u00e4oliselt pole mingi kanne tasakaalus. Et seda kontrollida, ava\u00a0<b>\u201cRMP\u201d &gt; \u201cKanded\u201d<\/b>, vali periood ja vali\u00a0<b>\u201cMillised n\u00e4idata?\u201d<\/b> alt <b>\u201cKanne pole tasakaalus\u201d<\/b> ja Sulle v\u00e4ljastatakse mittetasakaalus kanded, mida saad korrigeerida. ERPLY Books ei luba vaikimisi mittetasakaalus kandeid, kuid algsaldode sisetamisega v\u00f5ib see siiski juhtuda.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/09\/kannepoletasakaalus.png\" alt=\"Sendierinevused aruannetes\" width=\"400\" height=\"200\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Et edaspidi oleks komakohti \u00fcmardamisel 2, mine <b>\u201cS\u00e4tted\u201d &gt; \u201c\u00dcldised s\u00e4tted\u201d<\/b> ja vali \u201cAktiveeri- Jah\u201d ja \u201cKomakohti \u00fcmardamisel &#8211; 2\u201d. <\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5098\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2020\/09\/umardaautomaatselt.png\" alt=\"Sendierinevused aruannetes\" width=\"500\" height=\"200\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Seej\u00e4rel vajuta\u00a0<b>\u201cSalvesta\u201d<\/b> nuppu.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saldode \u00fcmardamine kahe komakohani &nbsp; Kui Sul ilmevad sendierinevused aruannetes, n\u00e4iteks erinevad bilansis aktiva ja passiva \u00fche sendi v\u00f5rra, siis v\u00f5ib see tulla \u00fcmarduse komakohtade arvust algsaldodes. Algsaldode numbrid peaksid olema sisestatud kahe komakohaga, et tulevikus ei tekiks \u00fcmardusvahesid. Kui Sul on rohkem komakohti, siis tuleks need korrigeerida. Vaikimisi tehakse kanded nii mitme komakohaga kui [&hellip;]<\/p>\n","protected":false},"author":24,"featured_media":0,"parent":0,"menu_order":13,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[450],"tags":[533,534],"class_list":["post-32246","page","type-page","status-publish","hentry","category-seadistused","tag-algsaldo-2","tag-algsaldo-sisestamine-2"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/32246","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\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=32246"}],"version-history":[{"count":3,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/32246\/revisions"}],"predecessor-version":[{"id":39859,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/32246\/revisions\/39859"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=32246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=32246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=32246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}