{"id":6005,"date":"2018-08-01T17:06:08","date_gmt":"2018-08-01T14:06:08","guid":{"rendered":"http:\/\/support.simplbooks.lt\/en\/?post_type=ht_kb&#038;p=6005"},"modified":"2018-08-01T17:07:17","modified_gmt":"2018-08-01T14:07:17","slug":"importing-bank-transactions-in-xml-or-csv-format","status":"publish","type":"ht_kb","link":"https:\/\/support.simplbooks.lt\/en\/vartotojo-vadovai\/importing-bank-transactions-in-xml-or-csv-format\/","title":{"rendered":"Importing bank transactions in XML or CSV format"},"content":{"rendered":"<p>For the purposes of importing bank transactions (CSV) the import templates in SimplBooks are preconfigured. Adding an import template. In order to import XML format transactions it is not necessary to configure import templates \u2013 in that case the EU wide ISO format will be used.<\/p>\n<p>To perform a bank import you will first need a transaction extract file for the corresponding period in CSV or XML format.<\/p>\n<div class=\"su-note\"  style=\"border-color:#9bd98e;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#b5f3a8;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">We recommend using XML format, if possible, since this includes more information on transactions.<\/div><\/div>\n<p>Example: SEB Pank<br \/>\n<strong>1.<\/strong>\u00a0Log in<br \/>\n<strong>2.<\/strong>\u00a0Click on \u201cSettlements\u201d and then select &#8220;Statement\u201d under \u201cOverview\u201d<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/05-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6021\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/05-1.png\" alt=\"\" width=\"838\" height=\"390\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1.png 838w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1-300x140.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1-768x357.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1-50x23.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1-600x279.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/05-1-320x149.png 320w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/a><\/p>\n<p><strong>3.<\/strong>\u00a0Select \u201cExport statement\u201d<br \/>\n<strong>4.\u00a0<\/strong>Select period<br \/>\n<strong>5.<\/strong>\u00a0Select format (ISO statement)<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6022\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/06.png\" alt=\"\" width=\"578\" height=\"281\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/06.png 578w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/06-300x146.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/06-50x24.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/06-320x156.png 320w\" sizes=\"auto, (max-width: 578px) 100vw, 578px\" \/><\/a><\/p>\n<p>Click on <strong>\u201cExport\u201d<\/strong> and save the file to your computer. Now the file is available and we move to SimplBooks.<\/p>\n<p>Bank import can be performed from the menu selection, either<strong> Transactions -&gt; Receipts<\/strong> or <strong>Transactions -&gt; Payments<\/strong>.<\/p>\n<p><strong>1.<\/strong>\u00a0In the given example we perform it under \u201cReceipts\u201d.<br \/>\n<strong>2.\u00a0<\/strong>Click on the import button<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/07-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6024\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/07-1.png\" alt=\"\" width=\"1280\" height=\"420\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1.png 1280w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-300x98.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-768x252.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-1024x336.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-50x16.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-920x302.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-600x197.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/07-1-320x105.png 320w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<p><strong>3.<\/strong>\u00a0Select the CSV or XML file saved on your computer from the bank<br \/>\n<strong>4.<\/strong>\u00a0Select the suitable file type<br \/>\n<strong>5.\u00a0<\/strong>Select the import template for the corresponding bank\u00a0(this step is not necessary in the case of an XML file, but is necessary with a CSV file)<br \/>\n<strong>6.<\/strong>\u00a0Click on the\u00a0<strong>\u201cImport\u201d\u00a0<\/strong>button<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6025\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/08.png\" alt=\"\" width=\"921\" height=\"426\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08.png 921w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-300x139.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-768x355.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-50x23.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-920x426.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-600x278.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/08-320x148.png 320w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/a><\/p>\n<p><strong>When importing, operations will appear in three states:<\/strong><\/p>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron spoiler-green su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>SUITABLE ROWS (click here):<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Suitable rows<\/strong> \u2013 the program is able to bind these payments and receipts itself; in order <strong>to save<\/strong>, you will need to click on<strong> \u201cSave ordered rows\u201d<\/strong>. Ordered rows can be save one at a time, by clicking on the disk icon. In case some rows cannot be saved, click on the rubbish bin icon.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/09-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6034\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/09-1.png\" alt=\"\" width=\"1287\" height=\"344\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1.png 1287w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-300x80.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-768x205.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-1024x274.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-50x13.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-920x246.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-600x160.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/09-1-320x86.png 320w\" sizes=\"auto, (max-width: 1287px) 100vw, 1287px\" \/><\/a><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron spoiler-red su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>FAULTY ROWS (click here)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Faulty<\/strong> \u2013 the correct connection to the initial document must be found for these or they must be reflected as a main ledger entry.<br \/>\nIf the receipt or payment has been made by another client, then changing the client name will be sufficient. In the lower box suitable as yet unbound\/unpaid invoices can be selected.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6035\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/10.png\" alt=\"\" width=\"1266\" height=\"258\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10.png 1266w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-300x61.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-768x157.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-1024x209.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-50x10.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-920x187.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-600x122.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/10-320x65.png 320w\" sizes=\"auto, (max-width: 1266px) 100vw, 1266px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6036\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/11.png\" alt=\"\" width=\"911\" height=\"293\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11.png 911w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11-300x96.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11-768x247.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11-50x16.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11-600x193.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/11-320x103.png 320w\" sizes=\"auto, (max-width: 911px) 100vw, 911px\" \/><\/a><\/p>\n<p>Data corrected, click on the disk icon <strong>\u201cSave\u201d<\/strong>.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron spoiler-red su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>DUPLICATES (click here)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Duplicates<\/strong> \u2013 these transactions have already been reflected in your environment. Duplicates can be deleted, if you click on &#8220;Delete all duplicates&#8221; or one by one, clicking on the rubbish bin icon at the end of the row.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6038\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/12.png\" alt=\"\" width=\"1275\" height=\"342\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12.png 1275w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-300x80.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-768x206.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-1024x275.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-50x13.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-920x247.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-600x161.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/12-320x86.png 320w\" sizes=\"auto, (max-width: 1275px) 100vw, 1275px\" \/><\/a><\/p>\n<\/div><\/div>\n<p><strong>Bank transactions<\/strong> can be <strong>saved<\/strong> in the SimplBooks environment as a:<br \/>\n\u2013 Payment\/Receipt<br \/>\n\u2013 Financial transaction<br \/>\n\u2013 Payment of wages<br \/>\n\u2013 Payroll taxes<\/p>\n<p>In order to save a bank transaction as a <strong>financial transaction<\/strong> select <strong>&#8220;Financial transaction\u201d<\/strong> (1) from the drop-down menu (denoted by the triangle in the header) and thereafter select <strong>transaction type (<\/strong>2) from the <strong>&#8220;Transaction type&#8221;<\/strong> drop-down menu. Make sure that the<strong> financial account<\/strong> (3) is designated correctly. If the data is correct, click on the disk icon \u201cSave\u201d.<\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6041\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/13.png\" alt=\"\" width=\"1282\" height=\"215\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13.png 1282w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-300x50.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-768x129.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-1024x172.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-50x8.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-920x154.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-600x101.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/13-320x54.png 320w\" sizes=\"auto, (max-width: 1282px) 100vw, 1282px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6042\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/14.png\" alt=\"\" width=\"1284\" height=\"301\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14.png 1284w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-300x70.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-768x180.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-1024x240.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-50x12.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-920x216.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-600x141.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/14-320x75.png 320w\" sizes=\"auto, (max-width: 1284px) 100vw, 1284px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6043\" src=\"http:\/\/support.simplbooks.lt\/ee\/wp-content\/uploads\/2018\/08\/15.png\" alt=\"\" width=\"1277\" height=\"297\" srcset=\"https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15.png 1277w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-300x70.png 300w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-768x179.png 768w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-1024x238.png 1024w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-50x12.png 50w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-920x214.png 920w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-600x140.png 600w, https:\/\/support.simplbooks.lt\/lt\/wp-content\/uploads\/2018\/08\/15-320x74.png 320w\" sizes=\"auto, (max-width: 1277px) 100vw, 1277px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":332,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht_kb_category":[174],"ht_kb_tag":[],"class_list":["post-6005","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-operations-faq"],"_links":{"self":[{"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb\/6005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/users\/332"}],"replies":[{"embeddable":true,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/comments?post=6005"}],"version-history":[{"count":15,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb\/6005\/revisions"}],"predecessor-version":[{"id":6046,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb\/6005\/revisions\/6046"}],"wp:attachment":[{"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/media?parent=6005"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb_category?post=6005"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.simplbooks.lt\/en\/wp-json\/wp\/v2\/ht_kb_tag?post=6005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}