{"id":4718,"date":"2024-03-26T12:36:24","date_gmt":"2024-03-26T10:36:24","guid":{"rendered":"https:\/\/support.venice.be\/nl\/?p=4718"},"modified":"2024-04-04T14:08:16","modified_gmt":"2024-04-04T12:08:16","slug":"de-fiscale-balans-exporteren-naar-een-extern-werkblad-vb-excel","status":"publish","type":"post","link":"https:\/\/support.venice.be\/nl\/index.php\/de-fiscale-balans-exporteren-naar-een-extern-werkblad-vb-excel\/","title":{"rendered":"De fiscale balans exporteren naar een extern werkblad (vb. Excel)"},"content":{"rendered":"\n<p>We krijgen op regelmatige basis de vraag of het mogelijk is om de fiscale balans te exporteren naar Excel of een ander werkbladprogramma.<\/p>\n<p>Om aan deze vraag tegemoet te komen, hebben we een aangepaste lay-out gemaakt op basis van de fiscale balans.<\/p>\n<p>U kan de aangepaste lay-out <a href=\"https:\/\/support.venice.be\/servicepacks\/KBases\/FisclB9.clf\">hier<\/a> downloaden. Vervolgens kopieert u het bestand onder de map \\Main\\clf onder het basispad van Venice.<\/p>\n<h2>Hoe maken we het extern werkblad aan?<\/h2>\n<p>We kiezen <em>Rapporten boekhouding &#8211; Balansen &#8211; Fiscale balans<\/em>.<\/p>\n<p>We kiezen&nbsp;<em>Afdrukken naar bestand&nbsp;<\/em>en selecteren de variant <em>Export Excel (9)<\/em><\/p>\n<p><a href=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4719\" src=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal1.png\" alt=\"\" width=\"512\" height=\"253\" srcset=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal1.png 512w, https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal1-300x148.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a><\/p>\n<p>Vervolgens klikken we op de knop&nbsp;<em>Opzoeken<\/em>. We selecteren de map waar we het bestand wensen aan te maken. Als type bestand kiezen we <em>Alle bestanden<\/em> en we geven als extensie van ons bestand <em>.csv&nbsp;<\/em>op.<\/p>\n\n\n\n<p><a href=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4720\" src=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal2.png\" alt=\"\" width=\"926\" height=\"116\" srcset=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal2.png 926w, https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal2-300x38.png 300w, https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal2-768x96.png 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/a><\/p>\n\n\n\n<p>Vervolgens klikken we op de knop\u00a0<em>Opties<\/em> en geven volgende specificaties op:<\/p>\n<p><a href=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4721\" src=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal3.png\" alt=\"\" width=\"427\" height=\"410\" srcset=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal3.png 427w, https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal3-300x288.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>We krijgen dan als resultaat een bestand dat er als volgt uitziet:<\/p>\n<p><a href=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4722\" src=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal4.png\" alt=\"\" width=\"496\" height=\"478\" srcset=\"https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal4.png 496w, https:\/\/support.venice.be\/nl\/wp-content\/uploads\/2024\/03\/KB-Fiscbal4-300x289.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We krijgen op regelmatige basis de vraag of het mogelijk is om de fiscale balans te exporteren naar Excel of een ander werkbladprogramma. Om aan deze vraag tegemoet te komen, hebben we een aangepaste lay-out gemaakt op basis van de &hellip; <a href=\"https:\/\/support.venice.be\/nl\/index.php\/de-fiscale-balans-exporteren-naar-een-extern-werkblad-vb-excel\/\">Lees verder <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[6,48],"tags":[552,395],"class_list":["post-4718","post","type-post","status-publish","format-standard","hentry","category-boekhouding","category-tip","tag-exporteren-naar-excel","tag-fiscale-balans"],"acf":[],"_links":{"self":[{"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/posts\/4718","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/comments?post=4718"}],"version-history":[{"count":4,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/posts\/4718\/revisions"}],"predecessor-version":[{"id":4728,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/posts\/4718\/revisions\/4728"}],"wp:attachment":[{"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/media?parent=4718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/categories?post=4718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.venice.be\/nl\/index.php\/wp-json\/wp\/v2\/tags?post=4718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}