{"id":12786,"date":"2025-07-26T17:55:48","date_gmt":"2025-07-26T15:55:48","guid":{"rendered":"https:\/\/www.auditsi.eu\/?page_id=12786"},"modified":"2026-08-30T20:19:22","modified_gmt":"2026-08-30T18:19:22","slug":"outil-en-ligne-generation-dune-balance-generale-en-ligne-a-partir-dun-fec","status":"publish","type":"page","link":"https:\/\/www.auditsi.eu\/?page_id=12786","title":{"rendered":"Analyse de FEC en ligne avec ANA-FEC2"},"content":{"rendered":"<p style=\"text-align: justify;\">Analyser vos FEC en ligne, gratuitement, en illimit\u00e9, sans inscription et en toute confidentialit\u00e9 ! L&#8217;essayer c&#8217;est l&#8217;adopter !<\/p>\n<p><strong>S\u00e9lectionner un FEC<\/strong> puis :<\/p>\n<ul>\n<li>Cliquer sur <strong>G\u00e9n\u00e9rer la balance Excel<\/strong> pour t\u00e9l\u00e9charger la balance ; au besoin saisir des crit\u00e8res de filtre (compte, libell\u00e9 compte ou \u00e9critures, mois) avant de cliquer sur le bouton<\/li>\n<li>ou saisir un num\u00e9ro de compte avant de cliquer sur <strong>Exporter \u00e9critures comprenant Compte<\/strong> pour obtenir une extraction Excel de toutes les \u00e9critures comptables qui contiennent le compte d\u00e9sign\u00e9<\/li>\n<li>ou soumettre le FEC \u00e0 la <strong>loi de Benford (fraudes et erreurs)<\/strong> (le cas \u00e9ch\u00e9ant : filtre sur num\u00e9ro de compte, code journal et mois) ; plus d&#8217;infos sur la <a href=\"https:\/\/www.auditsi.eu\/?p=4199\">loi de Benford<\/a><\/li>\n<li>ou calculer le taux de TVA de chaque \u00e9criture comptable \u00e0 l&#8217;aide de la fonction <strong>Analyse de la TVA<\/strong> (le cas \u00e9ch\u00e9ant : filtre sur code journal et mois)<\/li>\n<li>ou analyser les <a href=\"https:\/\/www.auditsi.eu\/?p=9118\"><strong>sch\u00e9mas d&#8217;\u00e9critures comptables<\/strong><\/a> (le cas \u00e9ch\u00e9ant : filtre sur code journal et mois)<\/li>\n<li>ou Ex\u00e9cuter une requ\u00eate SQL<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Confidentialit\u00e9<\/strong> : toutes les donn\u00e9es restent sur le poste de l&#8217;utilisateur (aucune donn\u00e9e n&#8217;est transf\u00e9r\u00e9e sur le serveur) et les calculs sont effectu\u00e9s en local.<\/p>\n    <div id=\"fec-container\">\n        <style>\n            #fec-container{--fec-blue:#1769aa;--fec-border:#d7dee8;--fec-soft:#f5f8fb;--fec-text:#223043;color:var(--fec-text)}\n            #fec-container *{box-sizing:border-box}.fec-upload-card{padding:22px;border:2px dashed #9db4ca;border-radius:12px;background:linear-gradient(135deg,#f7fbff,#fff)}\n            .fec-upload-card h2{margin:0 0 6px}.fec-upload-card>p{margin:4px 0 14px;color:#586779}.fec-file-input{display:block;width:100%;max-width:620px;padding:11px;border:1px solid var(--fec-border);border-radius:7px;background:#fff}\n            .fec-status{display:none;margin-top:13px;padding:10px 13px;border-radius:7px;font-weight:600}.fec-status.is-info{display:block;background:#eaf3fb;color:#185985}.fec-status.is-ok{display:block;background:#e8f6ed;color:#176b3a}.fec-status.is-warn{display:block;background:#fff4d9;color:#805500}.fec-status.is-error{display:block;background:#fdeceb;color:#a62920}\n            .fec-tabs{display:flex;gap:8px;margin:22px 0 0;border-bottom:1px solid var(--fec-border)}.fec-tab{padding:11px 16px;border:1px solid transparent;border-bottom:0;border-radius:8px 8px 0 0;background:transparent;cursor:pointer;font-weight:700;color:#516174}.fec-tab.is-active{background:#fff;border-color:var(--fec-border);color:var(--fec-blue);margin-bottom:-1px}.fec-tab:disabled{opacity:.45;cursor:not-allowed}\n            .fec-panel{display:none;padding:20px 0}.fec-panel.is-active{display:block}.fec-empty-state{padding:28px;text-align:center;border:1px solid var(--fec-border);border-radius:10px;background:var(--fec-soft);color:#647386}\n            .fec-kpi-wrap{margin-top:18px;overflow-x:auto}.fec-kpi-table{width:100%;max-width:860px;border-collapse:separate;border-spacing:0;border:1px solid var(--fec-border);border-radius:10px;overflow:hidden;background:#fff}.fec-kpi-table caption{padding:0 0 10px;text-align:left;font-size:18px;font-weight:700;color:#183b5b}.fec-kpi-table th,.fec-kpi-table td{padding:9px 14px;border-bottom:1px solid #e4e9ef}.fec-kpi-table th[scope=\"row\"]{width:68%;text-align:left;font-weight:600}.fec-kpi-table td{text-align:right;white-space:nowrap;font-variant-numeric:tabular-nums}.fec-kpi-table .fec-kpi-head th{background:#183b5b;color:#fff;text-align:left}.fec-kpi-table .fec-kpi-head th:last-child{text-align:right}.fec-kpi-table .fec-kpi-group th{padding:8px 14px;background:#edf3f8;color:#183b5b;text-align:left;font-size:13px;text-transform:uppercase;letter-spacing:.035em}.fec-kpi-table tr:last-child th,.fec-kpi-table tr:last-child td{border-bottom:0}.fec-kpi-negative{color:#b42318;font-weight:700}.fec-kpi-balanced{color:#17733b;font-weight:700}\n            .fec-validation-wrap{overflow-x:auto}.fec-validation-table{width:100%;max-width:720px;border-collapse:separate;border-spacing:0;border:1px solid var(--fec-border);border-radius:10px;overflow:hidden;background:#fff}.fec-validation-table caption{padding:0 0 10px;text-align:left;font-size:18px;font-weight:700;color:#183b5b}.fec-validation-table th,.fec-validation-table td{padding:10px 14px;border-bottom:1px solid #e4e9ef}.fec-validation-table thead th{background:#183b5b;color:#fff;text-align:left}.fec-validation-table thead th:not(:first-child),.fec-validation-table td{text-align:right}.fec-validation-table td{font-variant-numeric:tabular-nums}.fec-validation-table tbody tr:last-child th,.fec-validation-table tbody tr:last-child td{border-bottom:0}.fec-validation-table .fec-validation-ok{color:#17733b;font-weight:700}.fec-validation-table .fec-validation-ko{color:#b42318;font-weight:700}.fec-validation-note{margin:10px 0;color:#647386;font-size:13px}\n            .fec-filter-grid{display:grid;grid-template-columns:repeat(2,minmax(220px,1fr));gap:12px 18px;padding:16px;border:1px solid var(--fec-border);border-radius:9px;background:var(--fec-soft)}.fec-filter-grid label{display:flex;flex-direction:column;gap:5px;font-weight:600}.fec-filter-grid input{width:100%;padding:9px;border:1px solid #aeb8c5;border-radius:6px;background:#fff}.fec-filter-actions{display:flex;align-items:end}.fec-filter-actions button{padding:9px 12px}\n            .fec-active-filters{min-height:24px;margin:9px 0;color:#586779;font-size:13px}.fec-action-grid{display:grid;grid-template-columns:repeat(2,minmax(240px,1fr));gap:12px}.fec-action-card{display:flex;flex-direction:column;align-items:flex-start;gap:5px;min-height:104px;padding:15px;border:1px solid var(--fec-border);border-radius:9px;background:#fff;text-align:left;cursor:pointer}.fec-action-card:hover:not(:disabled){border-color:#76a8d1;box-shadow:0 3px 12px rgba(36,79,118,.12)}.fec-action-card:disabled{opacity:.48;cursor:not-allowed}.fec-action-card strong{font-size:15px;color:#183b5b}.fec-action-card span{font-size:13px;color:#637286}\n            #balance-table-section{overflow:auto;max-height:600px}#balance-table-section table{border-collapse:collapse;width:100%}#balance-table-section th{position:sticky;top:0;background:#edf3f8}#balance-table-section th,#balance-table-section td{padding:7px;border:1px solid #dce2e8}\n            @media(max-width:760px){.fec-filter-grid,.fec-action-grid{grid-template-columns:1fr}.fec-tabs{overflow:auto}.fec-tab{white-space:nowrap}.fec-kpi-table th,.fec-kpi-table td,.fec-validation-table th,.fec-validation-table td{padding:8px 9px}.fec-kpi-table th[scope=\"row\"]{width:62%}}\n        <\/style>\n        <div class=\"fec-upload-card\">\n            <h2>Analyser un fichier FEC<\/h2>\n            <p>S\u00e9lectionnez un fichier <code>.txt<\/code> ou <code>.csv<\/code>. Les donn\u00e9es comptables sont trait\u00e9es localement dans votre navigateur.<\/p>\n            <input class=\"fec-file-input\" type=\"file\" id=\"fecFile\" accept=\".txt,.csv\" \/>\n            <div id=\"fec-global-status\" class=\"fec-status\" role=\"status\" aria-live=\"polite\"><\/div>\n            <p id=\"fec-counter\" style=\"font-weight:bold;margin-top:1em\"><\/p>\n        <\/div>\n\n        <nav id=\"fec-tabs\" class=\"fec-tabs\" aria-label=\"Espaces ANA-FEC2\">\n            <button type=\"button\" class=\"fec-tab is-active\" data-fec-panel=\"dashboard\">Tableau de bord<\/button>\n            <button type=\"button\" class=\"fec-tab\" data-fec-panel=\"treatments\" disabled>Traitements<\/button>\n            <button type=\"button\" class=\"fec-tab\" data-fec-panel=\"validation\" disabled>Dates validation<\/button>\n            <button type=\"button\" class=\"fec-tab\" data-fec-panel=\"sql\" disabled>Extraction SQL<\/button>\n        <\/nav>\n\n        <section id=\"fec-panel-dashboard\" class=\"fec-panel is-active\">\n            <div id=\"fec-dashboard-empty\" class=\"fec-empty-state\">Chargez un FEC pour afficher son tableau de bord et acc\u00e9der aux traitements.<\/div>\n            <div id=\"synthese-fec-section\"><\/div>\n            <div id=\"balance-table-section\"><\/div>\n            <div id=\"synthese-balance-section\"><\/div>\n        <\/section>\n\n        <section id=\"fec-panel-treatments\" class=\"fec-panel\">\n            <div id=\"filters-section\"><\/div>\n            <div id=\"benford-chart-container\" style=\"margin-top:30px;display:none\">\n                <h3>Graphique de Benford<\/h3>\n                <canvas id=\"benfordChart\" width=\"700\" height=\"400\"><\/canvas>\n            <\/div>\n        <\/section>\n\n        <section id=\"fec-panel-validation\" class=\"fec-panel\">\n            <div id=\"fec-validation-empty\" class=\"fec-empty-state\">Chargez un FEC pour analyser les dates de validation.<\/div>\n            <div id=\"fec-validation-summary\"><\/div>\n        <\/section>\n\n        <section id=\"fec-panel-sql\" class=\"fec-panel\">\n            <div class=\"fec-empty-state\">Chargez un FEC pour utiliser l\u2019extraction SQL.<\/div>\n        <\/section>\n    <\/div>\n    \n<p style=\"text-align: justify;\">Pr\u00e9sentation et <strong>manuel utilisateur<\/strong> : <a href=\"https:\/\/www.auditsi.eu\/?p=12803\">cliquer ici<\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?page_id=11211\">d\u00e9couvrir les autres outils en ligne<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Analyser vos FEC en ligne, gratuitement, en illimit\u00e9, sans inscription et en toute confidentialit\u00e9 ! L&#8217;essayer c&#8217;est l&#8217;adopter ! S\u00e9lectionner un FEC puis : Cliquer sur G\u00e9n\u00e9rer la balance Excel pour t\u00e9l\u00e9charger la balance ; au besoin saisir des crit\u00e8res de filtre (compte, libell\u00e9 compte ou \u00e9critures, mois) avant de cliquer sur le bouton ou &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?page_id=12786\" class=\"more-link\">Continue reading &lsquo;Analyse de FEC en ligne avec ANA-FEC2&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","ngg_post_thumbnail":0,"_ayudawp_aiss_exclude":false,"_ayudawp_aiss_exclude_summary":false,"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-12786","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/pages\/12786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/page"}],"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=12786"}],"version-history":[{"count":24,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/pages\/12786\/revisions"}],"predecessor-version":[{"id":12985,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/pages\/12786\/revisions\/12985"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}