{"id":48472,"date":"2026-03-24T14:48:21","date_gmt":"2026-03-24T14:48:21","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/%d8%b9%d8%b1%d8%b6-%d8%aa%d9%82%d8%b1%d9%8a%d8%b1-%d8%a3%d8%b1%d8%b5%d8%af%d8%a9-%d8%a7%d9%84%d8%b9%d9%85%d9%84%d8%a7%d8%a1\/"},"modified":"2026-11-09T12:53:13","modified_gmt":"2026-11-09T12:53:13","slug":"clients-balance-report","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/","title":{"rendered":"Viewing the Clients Balance Report"},"content":{"rendered":"
\n

The Clients Balance report shows the financial position of each client during a specific period. It includes the balance before the start of the period, total sales, refunds, payments, and settlements, leading to the current closing balance. This report is used to review the balances owed by clients, track their account movements, and know the net debt or balance of each client in any period.<\/p>\n

\n

\ud83d\udec8<\/span><\/p>\n

Note:<\/strong> The report shows the balances in the account currency only, and it doesn\u2019t have an option to show the balances for each currency separately.<\/p>\n<\/div>\n

Steps to view the report<\/h2>\n
    \n
  1. Click Reports<\/strong>.<\/li>\n
  2. Click Clients Reports<\/strong>.<\/li>\n
  3. From the page, select Clients Balance<\/strong>.<\/li>\n
  4. You can apply a number of filters before viewing the report:\n
      \n
    • From Date \/ To Date:<\/strong> Select the period you want to view the client balance movements for.<\/li>\n
    • Client:<\/strong> Select one or more clients to view only their balance. You can search by name, email, or phone number.\n
        \n
      • If you don\u2019t select a specific client, the system shows the report for all clients.<\/li>\n<\/ul>\n<\/li>\n
      • Client Category:<\/strong> Filter the results to show only the clients of a specific category. You can search by name.\n
          \n
        • If you don\u2019t select a specific category, the system shows all categories.<\/li>\n<\/ul>\n<\/li>\n
        • Hide Zero Balance:<\/strong> Enable this option to hide clients with a zero balance and show only clients with balances.<\/li>\n
        • Show details:<\/strong> Enable this option to show the client\u2019s address, phone, and category details.<\/li>\n
        • Assigned Staff:<\/strong> Select one or more employees to view the clients linked to them. You can search by name, code, email, department, branch, or country.\n
            \n
          • If you don\u2019t select a specific employee, the system shows the report for all employees.<\/li>\n<\/ul>\n<\/li>\n
          • Follow Up Status:<\/strong> Filter the clients by the follow-up status assigned to them manually.\n
              \n
            • If you don\u2019t select a specific status, the system shows all clients regardless of their status.<\/li>\n<\/ul>\n<\/li>\n
            • Keywords:<\/strong> Type a word or phrase to search the clients\u2019 data and filter the results based on it.<\/li>\n
            • Journals Branch:<\/strong> Select one or more branches to view only the accounting entries linked to that branch.\n
                \n
              • If you don\u2019t select a specific branch, the system shows the report for all branches.<\/li>\n<\/ul>\n<\/li>\n
              • Hide Columns:<\/strong> You can hide any report column you don\u2019t need to show. The columns that can be hidden are: Code, Account No, Name, Client\u2019s Branch, Manual Status, Employee, Balance Before, Total Sales, Total Refund, Net Sales, Total Payments, Settlements, and Balance.<\/li>\n<\/ul>\n<\/li>\n
              • After you edit the filters, click Show Report<\/strong> to update the results, or click Reset<\/strong> to go back to the default settings.<\/li>\n
              • You can switch between Summary<\/strong> to show only the totals of each client, or Details<\/strong> to show the data of each transaction separately within the client\u2019s account.<\/li>\n
              • You can print the report from Print<\/strong> or export it from Export<\/strong> to:\n
                  \n
                • CSV<\/li>\n
                • Excel<\/li>\n
                • PDF<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

                  Report columns<\/h2>\n

                  The table shows a row for each client with a summary of their account movement during the selected period. The columns are as follows:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                  Column<\/th>\nDescription<\/th>\n<\/tr>\n
                  Code<\/strong><\/td>\nThe client\u2019s ID in the system, with a direct link to view the full client profile.<\/td>\n<\/tr>\n
                  Account No<\/strong><\/td>\nThe client\u2019s account number in the general ledger.<\/td>\n<\/tr>\n
                  Name<\/strong><\/td>\nThe client or company name as registered in the system, with a direct link to the client profile.<\/td>\n<\/tr>\n
                  Client\u2019s Branch<\/strong><\/td>\nThe branch the client belongs to.<\/td>\n<\/tr>\n
                  Manual Status<\/strong><\/td>\nThe client follow-up status that was assigned manually.<\/td>\n<\/tr>\n
                  Employee<\/strong><\/td>\nThe name of the employee responsible for or linked to the client.<\/td>\n<\/tr>\n
                  Balance Before<\/strong><\/td>\nThe client\u2019s accumulated balance before the start of the period selected in the filter. A negative value means the client has a credit balance.<\/td>\n<\/tr>\n
                  Total Sales<\/strong><\/td>\nThe total value of the sales invoices issued to the client during the selected period.<\/td>\n<\/tr>\n
                  Total Refund<\/strong><\/td>\nThe total value of the refund invoices issued to the client during the selected period.<\/td>\n<\/tr>\n
                  Net Sales<\/strong><\/td>\nThe difference between total sales and total refund. A negative value means the refunds exceeded the sales.<\/td>\n<\/tr>\n
                  Total Payments<\/strong><\/td>\nThe total amounts paid by the client during the selected period.<\/td>\n<\/tr>\n
                  Settlements<\/strong><\/td>\nThe value of any settlements or adjustment entries made on the client\u2019s account during the period.<\/td>\n<\/tr>\n
                  Balance<\/strong><\/td>\nThe client\u2019s current closing balance after calculating all movements. A positive value means an amount owed by the client, and a negative value means a credit balance in their favor.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                  At the bottom of the table, the Totals<\/strong> row adds up the values of all the financial columns for all clients over the whole period.<\/p>\n

                  FAQs<\/h2>\n

                  Can I view the Clients Balance report for each currency separately?<\/h3>\n

                  No, the Clients Balance<\/strong> report shows the balances in the account currency only, and it doesn\u2019t have a currency filter. Its filters are: From Date \/ To Date, Client, Client Category, Hide Zero Balance, Show details, Assigned Staff, Follow Up Status, Keywords, and Journals Branch.<\/p>\n

                  How do I hide clients with a zero balance?<\/h3>\n

                  Enable the Hide Zero Balance<\/strong> option before viewing the report, so only the existing balances appear.<\/p>\n

                  What does a negative value in the Balance column mean?<\/h3>\n

                  A negative value in the Balance<\/strong> column means a credit balance in the client\u2019s favor, while a positive value means an amount owed by the client.<\/p>\n<\/div>\n","protected":false},"author":17,"featured_media":0,"template":"","categories":[6953],"tags":[29562,21746,29548,29563,10598,4558,29557,29558,7867,29559,29560,20115,23209,24335,29561,4082,29552,29551,29564],"class_list":["post-48472","tutorial","type-tutorial","status-publish","hentry","category-clients-reports","tag-account-currency","tag-assigned-staff","tag-balance-before","tag-can-i-view-the-clients-balance-report-for-each-currency-separately","tag-client-balance-en","tag-client-category","tag-clients-balance","tag-clients-balance-report","tag-clients-reports","tag-debtors-balance","tag-follow-up-status","tag-hide-columns","tag-hide-zero-balance","tag-journals-branch","tag-net-sales","tag-reports","tag-settlements","tag-total-payments","tag-what-does-a-negative-value-in-the-balance-column-mean"],"yoast_head":"\nViewing the Clients Balance Report - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Viewing the Clients Balance Report - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"The Clients Balance report shows the financial position of each client during a specific period. It includes the balance before the start of the period, total sales, refunds, payments, and settlements, leading to the current closing balance. This report is used to review the balances owed by clients, track their account movements, and know the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-09T12:53:13+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/\",\"name\":\"Viewing the Clients Balance Report - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2026-03-24T14:48:21+00:00\",\"dateModified\":\"2026-11-09T12:53:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Viewing the Clients Balance Report\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Viewing the Clients Balance Report - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/","og_locale":"en_US","og_type":"article","og_title":"Viewing the Clients Balance Report - Daftra Knowledge Base","og_description":"The Clients Balance report shows the financial position of each client during a specific period. It includes the balance before the start of the period, total sales, refunds, payments, and settlements, leading to the current closing balance. This report is used to review the balances owed by clients, track their account movements, and know the […]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-11-09T12:53:13+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/","name":"Viewing the Clients Balance Report - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2026-03-24T14:48:21+00:00","dateModified":"2026-11-09T12:53:13+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/clients-balance-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Viewing the Clients Balance Report"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/48472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":5,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/48472\/revisions"}],"predecessor-version":[{"id":157776,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/48472\/revisions\/157776"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=48472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=48472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=48472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}