{"id":4741,"date":"2014-04-15T13:44:23","date_gmt":"2014-04-15T11:44:23","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=4741"},"modified":"2014-04-19T09:39:47","modified_gmt":"2014-04-19T07:39:47","slug":"projet-alpha-charly-le-point-au-15-avril","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=4741","title":{"rendered":"Audit des comptes consolid\u00e9s : Projet &#8220;ALPHA-CHARLY&#8221;, le point au 15 avril"},"content":{"rendered":"<p style=\"text-align: justify;\">Le projet arrive en phase de test.<\/p>\n<p style=\"text-align: justify;\">Pour m\u00e9moire, le projet ALPHA CHARLY a pour objet la r\u00e9alisation d&#8217;un logiciel d&#8217;audit des comptes consolid\u00e9s \u00e0 partir d&#8217;une extraction de donn\u00e9es du logiciel de consolidation ETAFI CONSO.<\/p>\n<div id=\"attachment_4742\" style=\"width: 426px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2014\/04\/Contributions-au-CA.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4742\" class=\"size-full wp-image-4742\" alt=\"Analyse de la contribution des entit\u00e9s consolid\u00e9es au chiffre d'affaires et au r\u00e9sultat consolid\u00e9s (montant n\u00e9gatifs = soldes cr\u00e9diteurs)\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2014\/04\/Contributions-au-CA.png\" width=\"416\" height=\"661\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2014\/04\/Contributions-au-CA.png 416w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2014\/04\/Contributions-au-CA-188x300.png 188w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><p id=\"caption-attachment-4742\" class=\"wp-caption-text\">Analyse de la contribution des entit\u00e9s consolid\u00e9es au chiffre d&#8217;affaires et au r\u00e9sultat consolid\u00e9s (montant n\u00e9gatifs = soldes cr\u00e9diteurs)<\/p><\/div>\n<p style=\"text-align: justify;\">J&#8217;ai pour le moment abandonn\u00e9 l&#8217;id\u00e9e de programmer cette application sous DELPHI. J&#8217;ai pr\u00e9f\u00e9r\u00e9 l&#8217;\u00e9crire en VBA. J&#8217;ai effectu\u00e9 ce choix essentiellement pour r\u00e9utiliser une partie du code-source d&#8217;un autre de mes projets, <a title=\"Projet M\/ATAC\" href=\"http:\/\/www.auditsi.eu\/?page_id=4194\" target=\"_blank\">M\/ATAC<\/a>, dont l&#8217;objectif est semblable : analyser des donn\u00e9es comptables.<\/p>\n<div id=\"attachment_4759\" style=\"width: 480px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/01\/BILAN-INDIVIDUEL.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4759\" class=\"size-full wp-image-4759\" alt=\"Reconstitution du bilan individuel d'une filiale tel que repris dans les comptes consolid\u00e9s\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/01\/BILAN-INDIVIDUEL.png\" width=\"470\" height=\"518\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/01\/BILAN-INDIVIDUEL.png 470w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2013\/01\/BILAN-INDIVIDUEL-272x300.png 272w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/a><p id=\"caption-attachment-4759\" class=\"wp-caption-text\">Reconstitution du bilan individuel d&#8217;une filiale tel que repris dans les comptes consolid\u00e9s<\/p><\/div>\n<p style=\"text-align: justify;\">Le programme d&#8217;analyse produit des feuilles de travail exploitables sur les principaux th\u00e8mes d&#8217;audit du commissaire aux comptes : reconstitution et analyse des \u00e9tats financiers consolid\u00e9s, analyse du p\u00e9rim\u00e8tre de consolidation (pourcentages d&#8217;int\u00e9r\u00eats), tableaux de passage, contr\u00f4le de la reprise des comptes individuels, analyse des contributions de chaque entit\u00e9, analyse des imp\u00f4ts diff\u00e9r\u00e9s&#8230;<\/p>\n<p style=\"text-align: justify;\">Le param\u00e9trage reste \u00e0 affiner (pr\u00e9sentation des feuilles) mais je vais pouvoir traiter la saison d&#8217;audit des comptes consolid\u00e9s avec un outil en grande partie op\u00e9rationnel.<\/p>\n<p style=\"text-align: justify;\">Pour en savoir plus : <a title=\"Projet ALPHA CHARLY\" href=\"http:\/\/www.auditsi.eu\/?page_id=2745\" target=\"_blank\">aller sur la page du projet<\/a><\/p>\n<p style=\"text-align: justify;\"><em>Retrouvez tous les articles sur l&#8217;<a title=\"Articles sur : Audit des comptes consolid\u00e9s\" href=\"http:\/\/www.auditsi.eu\/?cat=324\">audit des comptes consolid\u00e9s<\/a><\/em><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Audit%20des%20comptes%20consolid%C3%A9s%20%3A%20Projet%20%22ALPHA-CHARLY%22%2C%20le%20point%20au%2015%20avril\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Le projet arrive en phase de test. Pour m\u00e9moire, le projet ALPHA CHARLY a pour objet la r\u00e9alisation d&#8217;un logiciel d&#8217;audit des comptes consolid\u00e9s \u00e0 partir d&#8217;une extraction de donn\u00e9es du logiciel de consolidation ETAFI CONSO. J&#8217;ai pour le moment abandonn\u00e9 l&#8217;id\u00e9e de programmer cette application sous DELPHI. J&#8217;ai pr\u00e9f\u00e9r\u00e9 l&#8217;\u00e9crire en VBA. J&#8217;ai effectu\u00e9 &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=4741\" class=\"more-link\">Continue reading &lsquo;Audit des comptes consolid\u00e9s : Projet &#8220;ALPHA-CHARLY&#8221;, le point au 15 avril&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Audit%20des%20comptes%20consolid%C3%A9s%20%3A%20Projet%20%22ALPHA-CHARLY%22%2C%20le%20point%20au%2015%20avril\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,7,324,49],"tags":[1355,1634,1645,991,1356,306,1357,666,531,995],"class_list":["post-4741","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-breves","category-comptes-consolides","category-logiciels-daudit","tag-alpha-charly","tag-audit-de-donnees","tag-comptes-consolides","tag-comptes-individuels","tag-contributions","tag-etafi-conso","tag-impots-differes","tag-perimetre-de-consolidation","tag-projets-informatiques","tag-tableau-de-passage"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4741"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4741\/revisions"}],"predecessor-version":[{"id":4762,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/4741\/revisions\/4762"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}