{"id":2404,"date":"2024-06-03T13:39:21","date_gmt":"2024-06-03T13:39:21","guid":{"rendered":"https:\/\/live-portfellow-com.vserver.zonevs.eu\/?post_type=docs&#038;p=2404"},"modified":"2025-02-05T08:56:22","modified_gmt":"2025-02-05T08:56:22","password":"","slug":"lhv-tehingute-ja-kontode-csv-importimine","status":"publish","type":"docs","link":"https:\/\/www2.portfellow.com\/et\/help\/lhv-tehingute-ja-kontode-csv-importimine\/","title":{"rendered":"LHV tehingute ja kontode import CSV-failist"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">LHV andmete struktuuri t\u00f5ttu tuleb sealt importida tehingute v\u00e4ljav\u00f5te ja konto v\u00e4ljav\u00f5te eraldi.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"424\" src=\"https:\/\/portfellow.com\/wp-content\/uploads\/2024\/06\/Screenshot-2025-02-05-at-09.51.07.png\" alt=\"\" class=\"wp-image-4303\" srcset=\"\" sizes=\"(max-width: 1024px) 100vw, 1024px\" data-srcset=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Esmalt alusta tehingute v\u00e4ljav\u00f5tte importimisega.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-toc-title\">LHV tehingute v\u00e4ljav\u00f5tte importimine<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Logi sisse oma LHV kontole<\/li>\n\n\n\n<li class=\"translation-block\">Vali men\u00fc\u00fcst \u201cTehingute v\u00e4ljav\u00f5te\u201d<\/li>\n\n\n\n<li class=\"translation-block\">Vali konto, periood ning kas \u201cv\u00e4\u00e4rtpaberid\u201d v\u00f5i \u201ckr\u00fcptovarad\u201d<\/li>\n\n\n\n<li>Vajuta \u201cSaada p\u00e4ring\u201d <strong>&#8220;Submit Query&#8221;<\/strong>.<\/li>\n\n\n\n<li class=\"translation-block\">Vajuta lehe \u00fcla osas \u201cCSV\u201d ikoonile<\/li>\n\n\n\n<li class=\"translation-block\">Lae loodud fail Portfellowsse \u00fcles<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph translation-block\">Kui tehingud importitud, siis j\u00e4rgmisena asu konto v\u00e4ljav\u00f5tte importimise juurde. Konto v\u00e4ljav\u00f5tte importimisel kustuta \u00e4ra ostu ja m\u00fc\u00fcgi tehingud (kuna need said juba Tehingute importimisel sisestatud)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"7-toc-title\">LHV konto v\u00e4ljav\u00f5tte importimine<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">Logi sisse oma LHV kontole<\/li>\n\n\n\n<li class=\"translation-block\">Vali men\u00fc\u00fcst \u201cKonto v\u00e4ljav\u00f5te\u201d ning vali konto ja periood<\/li>\n\n\n\n<li class=\"translation-block\">Vajuta \u00fcleval asuvat \u201cSalvesta\u201d nuppu ning vali \u201cCSV\u201d<\/li>\n\n\n\n<li class=\"translation-block\">Lae loodud fail Portfellowsse \u00fcles<\/li>\n<\/ul>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Due to the structure of LHV data, the transaction statement and account statement must be imported separately. Start by importing the transaction statement first. Importing LHV Transaction Statement Once the transactions have been imported, proceed with importing the account statement.When importing the account statement, remove purchase and sale transactions, as these have already been recorded [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2414,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"doc_category":[23],"doc_tag":[],"class_list":["post-2404","docs","type-docs","status-publish","has-post-thumbnail","hentry","doc_category-getting-started"],"aioseo_notices":[],"year_month":"2026-06","word_count":145,"total_views":"2695","reactions":{"happy":"0","normal":"0","sad":"1"},"author_info":{"name":"Portfellow","author_nicename":"admin","author_url":"https:\/\/www2.portfellow.com\/et\/author\/admin\/"},"doc_category_info":[{"term_name":"Getting started","term_url":"https:\/\/www2.portfellow.com\/et\/help-category\/getting-started\/"}],"doc_tag_info":[],"jetpack_sharing_enabled":true,"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/comments?post=2404"}],"version-history":[{"count":5,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2404\/revisions"}],"predecessor-version":[{"id":4330,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/docs\/2404\/revisions\/4330"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/media\/2414"}],"wp:attachment":[{"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/media?parent=2404"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/doc_category?post=2404"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www2.portfellow.com\/et\/wp-json\/wp\/v2\/doc_tag?post=2404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}