{"id":1910,"date":"2016-10-21T09:35:36","date_gmt":"2016-10-21T06:35:36","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1910"},"modified":"2016-10-21T09:35:45","modified_gmt":"2016-10-21T06:35:45","slug":"mikro-yazilim-banka-excel-aktarimlari","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-yazilim-banka-excel-aktarimlari\/","title":{"rendered":"Mikro Yaz\u0131l\u0131m &#8211; Banka Excel Aktar\u0131mlar\u0131"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Bankalar\u0131n sizlere g\u00f6ndermi\u015f oldu\u011fu excel hesap \u00f6zetlerini sistemdeki ticari evraklara aktar\u0131m anlat\u0131lmaktad\u0131r.<\/p>\n<ul>\n<li>\u0130\u015flem Kodlar\u0131 tan\u0131mlar\u0131 (073698)<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.ozgurguler.net\/blog\/mikro-yazilim-banka-excel-aktarimlari\/banka-aktar-1\/\" rel=\"attachment wp-att-1911\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1911\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-1.png\" alt=\"banka-aktar-1\" width=\"371\" height=\"86\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-1.png 371w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-1-300x70.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-1-250x58.png 250w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/a><\/p>\n<p>Bu men\u00fc arac\u0131l\u0131\u011f\u0131 ile Bankaya \u00f6zel excel i\u00e7erisinde bulunan i\u015flem kodlar\u0131n\u0131z\u0131 sisteme tan\u0131mlamal\u0131s\u0131n\u0131z. (Her banka i\u00e7in ayr\u0131 tan\u0131mlanmas\u0131 gerekecektir.)<\/p>\n<p>\u00d6rnek tan\u0131mlama a\u015fa\u011f\u0131da resimde belirtiyorum. \u0130\u015faretli Alanlar Excel ile e\u015fit olma zorunlulu\u011fu bulunmaktad\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1912\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2.png\" alt=\"banka-aktar-2\" width=\"1337\" height=\"267\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2.png 1337w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2-300x60.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2-768x153.png 768w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2-1024x204.png 1024w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-2-250x50.png 250w\" sizes=\"auto, (max-width: 1337px) 100vw, 1337px\" \/><\/p>\n<p>Excel de i\u015flem kodlar\u0131 bulunan resim.<\/p>\n<p><a href=\"http:\/\/www.ozgurguler.net\/blog\/mikro-yazilim-banka-excel-aktarimlari\/banka-aktar-3\/\" rel=\"attachment wp-att-1913\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1913 size-full\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136.png\" width=\"1077\" height=\"398\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136.png 1077w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136-300x111.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136-768x284.png 768w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136-1024x378.png 1024w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-3-e1477031697136-250x92.png 250w\" sizes=\"auto, (max-width: 1077px) 100vw, 1077px\" \/><\/a><\/p>\n<p>Bu tan\u0131mlamalar yap\u0131lmas\u0131 akabinde 2. Ad\u0131ma ge\u00e7ilebilir.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Banka Hesap \u00f6zeti aktar\u0131m\u0131 (073979)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1914\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-4.png\" alt=\"banka-aktar-4\" width=\"531\" height=\"69\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-4.png 531w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-4-300x39.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-4-250x32.png 250w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>Resimde i\u015faretledi\u011fim alanlara dikkat ederek aktar\u0131m yap\u0131lacak banka hesab\u0131 ve g\u00f6ndermi\u015f oldu\u011fu excel se\u00e7imi yap\u0131l\u0131r. Tarih kriterleri girilir.<\/p>\n<p><strong>Sol altta i\u015faretlemi\u015f oldu\u011fum Excel import parametreleri b\u00f6l\u00fcm\u00fc a\u00e7\u0131larak a\u015fa\u011f\u0131da resimlerle e\u015fle\u015ftirme yapaca\u011f\u0131m \u015fekilde excel tan\u0131mlar\u0131 yap\u0131lmal\u0131d\u0131r. (Her banka Excel\u2019i i\u00e7in ayr\u0131 tan\u0131m yapmal\u0131s\u0131n\u0131z)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1915\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-5.png\" alt=\"banka-aktar-5\" width=\"908\" height=\"555\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-5.png 908w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-5-300x183.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-5-768x469.png 768w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-5-250x153.png 250w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1916\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-6.png\" alt=\"banka-aktar-6\" width=\"625\" height=\"452\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-6.png 625w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-6-300x217.png 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-6-242x175.png 242w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>E\u015fleme Alanlar\u0131n\u0131n yanlar\u0131na numaral\u0131 olarak not d\u00fc\u015ft\u00fcm ilgili excelde nerelere bakarak bu bilgileri bulaca\u011f\u0131n\u0131z\u0131 a\u015fa\u011f\u0131daki resimde g\u00f6rebilirsiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1917\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7.jpg\" alt=\"banka-aktar-7\" width=\"1164\" height=\"390\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7.jpg 1164w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7-300x101.jpg 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7-768x257.jpg 768w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7-1024x343.jpg 1024w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-7-250x84.jpg 250w\" sizes=\"auto, (max-width: 1164px) 100vw, 1164px\" \/><\/p>\n<p>E\u015fleme alanlar\u0131 ile do\u011fru bilgiler tan\u0131mlar yap\u0131lmas\u0131 akabinde F2 tu\u015fu veya ekran\u0131n sa\u011f alt\u0131nda yer alan <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1918\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-8.png\" alt=\"banka-aktar-8\" width=\"50\" height=\"61\" \/>\u00a0i\u015fareti ile aktar\u0131m ba\u015flatabilirsiniz.<\/p>\n<p>Exceldeki bilgiler <strong>verdi\u011finiz tarih aral\u0131\u011f\u0131nda mevcut ise<\/strong> kar\u015f\u0131n\u0131za aktar\u0131m yap\u0131lacak i\u015flemler ve<\/p>\n<p>sistemde <strong>yap\u0131labilen otomatik e\u015flemeler gelecek eksik bilgileri el ile doldurman\u0131z akabinde<\/strong> sisteme fi\u015fleri kay\u0131t edebileceksiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1919\" src=\"http:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9.jpg\" alt=\"banka-aktar-9\" width=\"1117\" height=\"565\" srcset=\"https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9.jpg 1117w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9-300x152.jpg 300w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9-768x388.jpg 768w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9-1024x518.jpg 1024w, https:\/\/www.ozgurguler.net\/blog\/wp-content\/uploads\/2016\/10\/Banka-Aktar-9-250x126.jpg 250w\" sizes=\"auto, (max-width: 1117px) 100vw, 1117px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Bankalar\u0131n sizlere g\u00f6ndermi\u015f oldu\u011fu excel hesap \u00f6zetlerini sistemdeki ticari evraklara aktar\u0131m anlat\u0131lmaktad\u0131r. \u0130\u015flem Kodlar\u0131 tan\u0131mlar\u0131 (073698) Bu men\u00fc arac\u0131l\u0131\u011f\u0131 ile Bankaya \u00f6zel excel i\u00e7erisinde bulunan i\u015flem kodlar\u0131n\u0131z\u0131 sisteme tan\u0131mlamal\u0131s\u0131n\u0131z. (Her banka i\u00e7in ayr\u0131 tan\u0131mlanmas\u0131 gerekecektir.) \u00d6rnek tan\u0131mlama a\u015fa\u011f\u0131da resimde belirtiyorum. \u0130\u015faretli Alanlar Excel ile e\u015fit olma zorunlulu\u011fu bulunmaktad\u0131r. Excel de i\u015flem kodlar\u0131 bulunan resim. [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1584,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,9],"tags":[],"class_list":["post-1910","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel","category-mikro-yazilimevi"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1910"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1910\/revisions"}],"predecessor-version":[{"id":1921,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1910\/revisions\/1921"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1584"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}