{"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 “ALPHA-CHARLY”, le point au 15 avril"},"content":{"rendered":"

Le projet arrive en phase de test.<\/p>\n

Pour m\u00e9moire, le projet ALPHA CHARLY a pour objet la r\u00e9alisation d’un logiciel d’audit des comptes consolid\u00e9s \u00e0 partir d’une extraction de donn\u00e9es du logiciel de consolidation ETAFI CONSO.<\/p>\n

\"Analyse<\/a>

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)<\/p><\/div>\n

J’ai pour le moment abandonn\u00e9 l’id\u00e9e de programmer cette application sous DELPHI. J’ai pr\u00e9f\u00e9r\u00e9 l’\u00e9crire en VBA. J’ai effectu\u00e9 ce choix essentiellement pour r\u00e9utiliser une partie du code-source d’un autre de mes projets, M\/ATAC<\/a>, dont l’objectif est semblable : analyser des donn\u00e9es comptables.<\/p>\n

\"Reconstitution<\/a>

Reconstitution du bilan individuel d’une filiale tel que repris dans les comptes consolid\u00e9s<\/p><\/div>\n

Le programme d’analyse produit des feuilles de travail exploitables sur les principaux th\u00e8mes d’audit du commissaire aux comptes : reconstitution et analyse des \u00e9tats financiers consolid\u00e9s, analyse du p\u00e9rim\u00e8tre de consolidation (pourcentages d’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…<\/p>\n

Le param\u00e9trage reste \u00e0 affiner (pr\u00e9sentation des feuilles) mais je vais pouvoir traiter la saison d’audit des comptes consolid\u00e9s avec un outil en grande partie op\u00e9rationnel.<\/p>\n

Pour en savoir plus : aller sur la page du projet<\/a><\/p>\n

Retrouvez tous les articles sur l’audit des comptes consolid\u00e9s<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Le projet arrive en phase de test. Pour m\u00e9moire, le projet ALPHA CHARLY a pour objet la r\u00e9alisation d’un logiciel d’audit des comptes consolid\u00e9s \u00e0 partir d’une extraction de donn\u00e9es du logiciel de consolidation ETAFI CONSO. J’ai pour le moment abandonn\u00e9 l’id\u00e9e de programmer cette application sous DELPHI. J’ai pr\u00e9f\u00e9r\u00e9 l’\u00e9crire en VBA. J’ai effectu\u00e9 …<\/p>\n

Continue reading ‘Audit des comptes consolid\u00e9s : Projet “ALPHA-CHARLY”, le point au 15 avril’ »<\/a><\/p>\n","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,"jetpack_seo_schema_type":"","ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ayudawp_aiss_exclude":false,"_ayudawp_aiss_exclude_summary":false,"_ayudawp_aiss_summary":"","_ayudawp_aiss_summary_provider":"","_ayudawp_aiss_summary_hash":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false,"_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}]}}