{"id":6673,"date":"2024-09-05T16:05:39","date_gmt":"2024-09-05T16:05:39","guid":{"rendered":"https:\/\/techhub.saworks.io\/?post_type=docs&#038;p=6673"},"modified":"2025-08-13T16:55:38","modified_gmt":"2025-08-13T16:55:38","slug":"7-reports-rapports-comptables","status":"publish","type":"docs","link":"https:\/\/techhub.saworks.io\/fr\/docs\/comptabilite\/specification-comptable-possible\/7-reports-rapports-comptables\/","title":{"rendered":"7. Reports (Rapports comptables)"},"content":{"rendered":"\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><strong>Les trois rapports comptables de base :<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Balance Sheet (Bilan)<\/strong><br>\u2192 Montre les&nbsp;<strong>actifs<\/strong>,&nbsp;<strong>passifs<\/strong>&nbsp;et&nbsp;<strong>capitaux propres<\/strong>&nbsp;\u00e0 un moment donn\u00e9.<br><strong>Formule :<\/strong><br>Assets=Liabilities+EquityAssets=Liabilities+Equity<\/li>\n\n\n\n<li><strong>Profit and Loss Statement (Compte de R\u00e9sultat)<\/strong><br>\u2192 R\u00e9sume les&nbsp;<strong>revenus<\/strong>,&nbsp;<strong>d\u00e9penses<\/strong>,&nbsp;<strong>profits<\/strong>&nbsp;ou&nbsp;<strong>pertes<\/strong>&nbsp;sur une p\u00e9riode donn\u00e9e.<\/li>\n\n\n\n<li><strong>Trial Balance (Balance de V\u00e9rification)<\/strong><br>\u2192 Liste tous les comptes avec leurs soldes&nbsp;<strong>d\u00e9bit<\/strong>&nbsp;et&nbsp;<strong>cr\u00e9dit<\/strong>&nbsp;pour v\u00e9rifier que les \u00e9critures sont \u00e9quilibr\u00e9es.<\/li>\n<\/ol>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Contexte des r\u00e8gles comptables :<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>R\u00e8gles d\u2019or de la comptabilit\u00e9 :<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Compte r\u00e9el :<\/strong><br>\u27a4&nbsp;<strong>D\u00e9biter<\/strong>&nbsp;ce qui entre,&nbsp;<strong>cr\u00e9diter<\/strong>&nbsp;ce qui sort.<\/li>\n\n\n\n<li><strong>Compte personnel :<\/strong><br>\u27a4&nbsp;<strong>D\u00e9biter<\/strong>&nbsp;celui qui re\u00e7oit,&nbsp;<strong>cr\u00e9diter<\/strong>&nbsp;celui qui donne.<\/li>\n\n\n\n<li><strong>Compte nominal :<\/strong><br>\u27a4&nbsp;<strong>D\u00e9biter<\/strong>&nbsp;toutes les&nbsp;<strong>d\u00e9penses et pertes<\/strong>,&nbsp;<strong>cr\u00e9diter<\/strong>&nbsp;tous les&nbsp;<strong>revenus et gains<\/strong>.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Effets des op\u00e9rations sur les comptes :<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Type de compte<\/th><th>D\u00e9bit (\u2191)<\/th><th>Cr\u00e9dit (\u2193)<\/th><\/tr><\/thead><tbody><tr><td><strong>Actif<\/strong><\/td><td>Augmentation<\/td><td>Diminution<\/td><\/tr><tr><td><strong>Passif<\/strong><\/td><td>Diminution<\/td><td>Augmentation<\/td><\/tr><tr><td><strong>Capitaux propres<\/strong><\/td><td>Diminution<\/td><td>Augmentation<\/td><\/tr><tr><td><strong>Revenu<\/strong><\/td><td>Diminution<\/td><td>Augmentation<\/td><\/tr><tr><td><strong>D\u00e9pense<\/strong><\/td><td>Augmentation<\/td><td>Diminution<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"903\" height=\"659\" data-src=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/balance-sheet.png\" alt=\"\" class=\"wp-image-6674 lazyload\" data-srcset=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/balance-sheet.png 903w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/balance-sheet-300x219.png 300w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/balance-sheet-768x560.png 768w\" data-sizes=\"(max-width: 903px) 100vw, 903px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 903px; --smush-placeholder-aspect-ratio: 903\/659;\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">7.1&nbsp;<strong>Bilan Comptable<\/strong><br><\/h2>\n\n\n\n<p>Un bilan comptable pr\u00e9sente une synth\u00e8se des actifs, capitaux propres et passifs d&rsquo;une organisation ou d&rsquo;un individu \u00e0 un moment pr\u00e9cis.<\/p>\n\n\n\n<p><strong>Formule fondamentale :<\/strong><br><strong>Actif = Passif + Capitaux propres<\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7.1.1 Requ\u00eate Exemple<\/strong><\/h3>\n\n\n\n<p>La requ\u00eate ci-dessous concerne les&nbsp;<strong>actifs<\/strong>. Les requ\u00eates pour les&nbsp;<strong>passifs<\/strong>&nbsp;et les&nbsp;<strong>capitaux propres<\/strong>&nbsp;sont similaires, mais la formule de calcul du solde est diff\u00e9rente (voir la section 6 pour les r\u00e8gles : pour les passifs et capitaux propres, le solde = cr\u00e9dit &#8211; d\u00e9bit).<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#24292e;--cbp-line-number-width:calc(2 * 0.6 * .75rem);line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#f2f2f2;color:#2f363c\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#24292e;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT debits.glcode AS 'glcode', debits.name AS 'name',\n       (IFNULL(debits.debitamount, 0) - IFNULL(credits.creditamount, 0)) AS 'balance'\nFROM\n  (SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount'\n   FROM acc_journal_entry, acc_coa\n   WHERE acc_coa.id = acc_journal_entry.coa_id\n     AND acc_journal_entry.type = 'DEBIT'\n     AND acc_coa.category IN ('ASSET')\n   GROUP BY name\n   ORDER BY glcode) debits\nLEFT OUTER JOIN\n  (SELECT acc_coa.gl_code, name, SUM(amount) AS 'creditamount'\n   FROM acc_journal_entry, acc_coa\n   WHERE acc_coa.id = acc_journal_entry.coa_id\n     AND acc_journal_entry.type = 'CREDIT'\n     AND acc_coa.category IN ('ASSET')\n   GROUP BY name) credits\nON debits.name = credits.name\n\nUNION\n\nSELECT credits.glcode AS 'glcode', credits.name AS 'name', \n       (IFNULL(debits.debitamount, 0) - IFNULL(credits.creditamount, 0)) AS 'balance'\nFROM\n  (SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount'\n   FROM acc_journal_entry, acc_coa\n   WHERE acc_coa.id = acc_journal_entry.coa_id\n     AND acc_journal_entry.type = 'DEBIT'\n     AND acc_coa.category IN ('ASSET')\n   GROUP BY name\n   ORDER BY glcode) debits\nRIGHT OUTER JOIN\n  (SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'creditamount'\n   FROM acc_journal_entry, acc_coa\n   WHERE acc_coa.id = acc_journal_entry.coa_id\n     AND acc_journal_entry.type = 'CREDIT'\n     AND acc_coa.category IN ('ASSET')\n   GROUP BY name\n   ORDER BY glcode) credits\nON debits.name = credits.name;\n<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-light\" style=\"background-color: #fff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">       (<\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">)) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;balance&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  (<\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">LEFT OUTER JOIN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  (<\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">UNION<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">, <\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">       (<\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">)) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;balance&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  (<\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">RIGHT OUTER JOIN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  (<\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">     <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">   <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\">;<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7.2 Compte de R\u00e9sultat (Income Statement)<\/strong><\/h3>\n\n\n\n<p>Le&nbsp;<strong>Compte de R\u00e9sultat<\/strong>&nbsp;est un \u00e9tat financier d\u2019une entreprise qui montre comment les&nbsp;<strong>revenus<\/strong>&nbsp;(argent re\u00e7u de la vente de produits et services avant d\u00e9duction des charges) sont transform\u00e9s en&nbsp;<strong>r\u00e9sultat net<\/strong>&nbsp;(le b\u00e9n\u00e9fice apr\u00e8s d\u00e9duction de toutes les charges et revenus).<\/p>\n\n\n\n<p>Il affiche les&nbsp;<strong>revenus reconnus<\/strong>&nbsp;sur une p\u00e9riode donn\u00e9e, ainsi que les&nbsp;<strong>co\u00fbts et d\u00e9penses<\/strong>&nbsp;associ\u00e9s \u00e0 ces revenus.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Formule :<br>Resultat&nbsp;Net=Revenus&nbsp;Totaux\u2212D\u00e9penses&nbsp;TotalesR\u00e9sultat&nbsp;Net=Revenus&nbsp;Totaux\u2212De\u02capenses&nbsp;Totales<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"581\" data-src=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/income-statement.png\" alt=\"\" class=\"wp-image-6676 lazyload\" data-srcset=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/income-statement.png 900w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/income-statement-300x194.png 300w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/income-statement-768x496.png 768w\" data-sizes=\"(max-width: 900px) 100vw, 900px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 900px; --smush-placeholder-aspect-ratio: 900\/581;\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7.2.1 Requ\u00eate Exemple \u2013 Revenus<\/strong><\/h3>\n\n\n\n<p>La requ\u00eate ci-dessous concerne les&nbsp;<strong>revenus<\/strong>. La requ\u00eate pour les&nbsp;<strong>d\u00e9penses<\/strong>&nbsp;serait similaire, sauf pour le calcul du solde (voir les r\u00e8gles dans la section 6).<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#24292e;--cbp-line-number-width:calc(2 * 0.6 * .75rem);line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#f2f2f2;color:#2f363c\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#24292e;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT *\nFROM (\n  SELECT debits.glcode AS 'glcode', debits.name AS 'name',\n         (IFNULL(credits.creditamount, 0) - IFNULL(debits.debitamount, 0)) AS 'balance'\n  FROM (\n    SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'DEBIT'\n      AND acc_coa.category IN ('INCOME')\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) debits\n  LEFT OUTER JOIN (\n    SELECT acc_coa.gl_code, name, SUM(amount) AS 'creditamount'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'CREDIT'\n      AND acc_coa.category IN ('INCOME')\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n  ) credits\n  ON debits.name = credits.name\n\n  UNION\n\n  SELECT credits.glcode AS 'glcode', credits.name AS 'name',\n         (IFNULL(credits.creditamount, 0) - IFNULL(debits.debitamount, 0)) AS 'balance'\n  FROM (\n    SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'DEBIT'\n      AND acc_coa.category IN ('INCOME')\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) debits\n  RIGHT OUTER JOIN (\n    SELECT acc_coa.gl_code, name, SUM(amount) AS 'creditamount'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'CREDIT'\n      AND acc_coa.category IN ('INCOME')\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) credits\n  ON debits.name = credits.name\n) AS fullouterjoinresult\nORDER BY glcode;\n<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-light\" style=\"background-color: #fff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         (<\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">)) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;balance&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">LEFT OUTER JOIN<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">UNION<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         (<\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">)) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;balance&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">RIGHT OUTER JOIN<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">category<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IN<\/span><span style=\"color: #24292E\"> (<\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> fullouterjoinresult<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode;<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7.3 Balance de V\u00e9rification (Trial Balance)<\/strong><\/h3>\n\n\n\n<p>La&nbsp;<strong>balance de v\u00e9rification<\/strong>&nbsp;est une liste de tous les comptes du&nbsp;<strong>grand livre g\u00e9n\u00e9ral<\/strong>&nbsp;(qu\u2019ils soient de nature&nbsp;<strong>capital<\/strong>&nbsp;ou&nbsp;<strong>revenu<\/strong>) d\u2019une entreprise.<\/p>\n\n\n\n<p>Cette liste contient :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le&nbsp;<strong>nom du compte<\/strong>&nbsp;du grand livre nominal.<\/li>\n\n\n\n<li>La&nbsp;<strong>valeur<\/strong>&nbsp;de ce compte.<\/li>\n<\/ul>\n\n\n\n<p>Chaque compte aura soit :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Une&nbsp;<strong>valeur de solde d\u00e9biteur<\/strong>&nbsp;\u2192 affich\u00e9e dans la&nbsp;<strong>colonne d\u00e9bit<\/strong>.<\/li>\n\n\n\n<li>Une&nbsp;<strong>valeur de solde cr\u00e9diteur<\/strong>&nbsp;\u2192 affich\u00e9e dans la&nbsp;<strong>colonne cr\u00e9dit<\/strong>.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"908\" height=\"433\" data-src=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/trial-balance.png\" alt=\"\" class=\"wp-image-6678 lazyload\" data-srcset=\"https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/trial-balance.png 908w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/trial-balance-300x143.png 300w, https:\/\/techhub.saworks.io\/wp-content\/uploads\/2025\/08\/trial-balance-768x366.png 768w\" data-sizes=\"(max-width: 908px) 100vw, 908px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 908px; --smush-placeholder-aspect-ratio: 908\/433;\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7.3.1 Requ\u00eate Exemple \u2013 Balance de V\u00e9rification<\/strong><\/h3>\n\n\n\n<p>Il s&rsquo;agit de la requ\u00eate compl\u00e8te pour g\u00e9n\u00e9rer le rapport de&nbsp;<strong>balance de v\u00e9rification<\/strong>&nbsp;:<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#24292e;--cbp-line-number-width:calc(2 * 0.6 * .75rem);line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#f2f2f2;color:#2f363c\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#24292e;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT *\nFROM (\n  SELECT debits.glcode AS 'glcode', debits.name AS 'name',\n         IF(debits.type = 'ASSET' OR debits.type = 'EXPENSES',\n            IFNULL(debits.debitamount, 0) - IFNULL(credits.creditamount, 0), '') AS 'debit',\n         IF(debits.type = 'INCOME' OR debits.type = 'EQUITY' OR debits.type = 'LIABILITIES',\n            IFNULL(credits.creditamount, 0) - IFNULL(debits.debitamount, 0), '') AS 'credit'\n  FROM (\n    SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount', acc_coa.type AS 'type'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'DEBIT'\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) debits\n  LEFT OUTER JOIN (\n    SELECT acc_coa.gl_code, name, SUM(amount) AS 'creditamount', acc_coa.type AS 'type'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'CREDIT'\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) credits\n  ON debits.name = credits.name\n\n  UNION\n\n  SELECT credits.glcode AS 'glcode', credits.name AS 'name',\n         IF(credits.type = 'ASSET' OR credits.type = 'EXPENSES',\n            IFNULL(debits.debitamount, 0) - IFNULL(credits.creditamount, 0), '') AS 'debit',\n         IF(credits.type = 'INCOME' OR credits.type = 'EQUITY' OR credits.type = 'LIABILITIES',\n            IFNULL(credits.creditamount, 0) - IFNULL(debits.debitamount, 0), '') AS 'credit'\n  FROM (\n    SELECT acc_coa.gl_code AS 'glcode', name, SUM(amount) AS 'debitamount', acc_coa.type AS 'type'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'DEBIT'\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) debits\n  RIGHT OUTER JOIN (\n    SELECT acc_coa.gl_code, name, SUM(amount) AS 'creditamount', acc_coa.type AS 'type'\n    FROM acc_journal_entry, acc_coa\n    WHERE acc_coa.id = acc_journal_entry.coa_id\n      AND acc_journal_entry.type = 'CREDIT'\n      AND acc_journal_entry.entry_date BETWEEN '2012-11-01' AND '2012-11-31'\n    GROUP BY name\n    ORDER BY glcode\n  ) credits\n  ON debits.name = credits.name\n) AS fullouterjoinresult\nORDER BY glcode;\n<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-light\" style=\"background-color: #fff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         <\/span><span style=\"color: #D73A49\">IF<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;EXPENSES&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">            <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">), <\/span><span style=\"color: #032F62\">&#39;&#39;<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debit&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         <\/span><span style=\"color: #D73A49\">IF<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;EQUITY&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;LIABILITIES&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">            <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">), <\/span><span style=\"color: #032F62\">&#39;&#39;<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;credit&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;type&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">LEFT OUTER JOIN<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;type&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">UNION<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">glcode<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;name&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         <\/span><span style=\"color: #D73A49\">IF<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;ASSET&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;EXPENSES&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">            <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">), <\/span><span style=\"color: #032F62\">&#39;&#39;<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debit&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">         <\/span><span style=\"color: #D73A49\">IF<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;INCOME&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;EQUITY&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">OR<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;LIABILITIES&#39;<\/span><span style=\"color: #24292E\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">            <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">creditamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">-<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">IFNULL<\/span><span style=\"color: #24292E\">(<\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">debitamount<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">0<\/span><span style=\"color: #24292E\">), <\/span><span style=\"color: #032F62\">&#39;&#39;<\/span><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;credit&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;glcode&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;debitamount&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;type&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;DEBIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) debits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">RIGHT OUTER JOIN<\/span><span style=\"color: #24292E\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">SELECT<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">gl_code<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #D73A49\">name<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">SUM<\/span><span style=\"color: #24292E\">(amount) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;creditamount&#39;<\/span><span style=\"color: #24292E\">, <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;type&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">FROM<\/span><span style=\"color: #24292E\"> acc_journal_entry, acc_coa<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">WHERE<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_coa<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">id<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">coa_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">type<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;CREDIT&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">      <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">acc_journal_entry<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">entry_date<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">BETWEEN<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-01&#39;<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">AND<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #032F62\">&#39;2012-11-31&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">GROUP BY<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">    <\/span><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  ) credits<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">  <\/span><span style=\"color: #D73A49\">ON<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">debits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #D73A49\">=<\/span><span style=\"color: #24292E\"> <\/span><span style=\"color: #005CC5\">credits<\/span><span style=\"color: #24292E\">.<\/span><span style=\"color: #005CC5\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #24292E\">) <\/span><span style=\"color: #D73A49\">AS<\/span><span style=\"color: #24292E\"> fullouterjoinresult<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D73A49\">ORDER BY<\/span><span style=\"color: #24292E\"> glcode;<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Cette requ\u00eate permet de g\u00e9n\u00e9rer une&nbsp;<strong>balance de v\u00e9rification compl\u00e8te<\/strong>, en distinguant les&nbsp;<strong>soldes d\u00e9biteurs<\/strong>&nbsp;(pour les comptes d\u2019actif et de d\u00e9penses) et les&nbsp;<strong>soldes cr\u00e9diteurs<\/strong>&nbsp;(pour les comptes de revenus, capitaux propres et passifs), selon les r\u00e8gles comptables.<\/p>\n\n\n\n<p>Souhaites-tu que je t\u2019aide \u00e0 adapter cette requ\u00eate \u00e0 une autre p\u00e9riode ou \u00e0 un autre type de rapport ?<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Les trois rapports comptables de base : Contexte des r\u00e8gles comptables : R\u00e8gles d\u2019or de la comptabilit\u00e9 : Effets des op\u00e9rations sur les [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6631,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"doc_badge":[],"class_list":["post-6673","docs","type-docs","status-publish","hentry"],"author_avatar":"https:\/\/secure.gravatar.com\/avatar\/6a70e7c73db9f245e650948d09d74f61?s=96&d=mm&r=g","author_name":"Annick N'dri","_links":{"self":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6673"}],"collection":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/comments?post=6673"}],"version-history":[{"count":0,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6673\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6631"}],"wp:attachment":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/media?parent=6673"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/doc_tag?post=6673"},{"taxonomy":"doc_badge","embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/doc_badge?post=6673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}