{"id":21879,"date":"2024-07-18T11:00:09","date_gmt":"2024-07-18T11:00:09","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%aa%d9%82%d8%b1%d9%8a%d8%b1-%d8%a3%d8%b9%d9%85%d8%a7%d8%b1-%d8%af%d9%8a%d9%88%d9%86-%d8%a7%d9%84%d8%b9%d9%85%d9%84%d8%a7%d8%a1\/"},"modified":"2024-12-23T09:29:09","modified_gmt":"2024-12-23T09:29:09","slug":"aged-debtors-report","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/","title":{"rendered":"Clients Aged Debtors Report"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1734876096988{margin-left: 200px !important;}&#8221;]The Client Debt Aging Report divides client debts based on the period of delay in the payment of amounts due on their due dates. It is typically divided as follows:<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Debts overdue for 30 days.<\/li>\n<li aria-level=\"1\">Debts overdue between 30 and 60 days.<\/li>\n<li aria-level=\"1\">Debts overdue between 60 and 90 days.<\/li>\n<li aria-level=\"1\">Debts overdue for more than 90 days.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">Through the system, you can automatically generate the Client Debt Aging Report without spending time or effort. We will review how to generate it in this guide.<\/p>\n<p>[\/vc_column_text][vc_custom_heading text=&#8221;What is the Client Debtor Aging Report?&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1734876223795{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1734876822457{margin-left: 200px !important;}&#8221;]The client debt aging report is a report that provides detailed information about the amounts due from clients, categorized by specific periods. This report helps track overdue debts based on payment priority and assists in evaluating how well the company is progressing in collecting these dues. It also enables the company to improve cash flows and increase liquidity.[\/vc_column_text][vc_custom_heading text=&#8221;Importance of the Client Debtor Aging Report&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1734876851443{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1734938196478{margin-left: 200px !important;}&#8221;]The Customer Debtor Aging Report helps manage your financial relationships with clients and frees you from chasing large numbers of invoices and clients. It consolidates, analyzes, and categorizes the information you need to collect your money without delay. The significance of the Customers Debtor Aging Report lies in the following points:<\/p>\n<h3>Cash Flow Management<\/h3>\n<p>The most challenging moment for any business is facing a lack of liquidity and being unable to meet financial obligations on time. Your ability to liquidate current assets quickly and easily is one of the most important factors affecting your cash flow. One of the easiest ways to ensure the smooth liquidation of assets is for customers to pay their invoices promptly, which is the benefit of the Customer Debt Aging Report.<\/p>\n<h3>Filtering Customers by Payment Compliance<\/h3>\n<p>You should regularly generate the Client Debt Aging Report to continuously monitor overdue invoices. This helps you categorize your clients based on their payment behavior. You can then prioritize nurturing relationships with customers who pay on time, offering them deals and encouraging their continued business while taking appropriate actions with customers who are habitually late, possibly even stopping dealings with some altogether.<\/p>\n<h3>Evaluating Sales Team Performance<\/h3>\n<p>Closing a sale does not mean payment has been completed. What truly matters is that you collect your money, and it may be best to delegate this task to your sales employees. The Customer Debt Aging Report helps you identify which sales employees follow up with customers until payment is made, based on how invoices are classified by the sales employee, depending on whether the customer is late or compliant with payment.<\/p>\n<h3>More Accurate Financial Statement Projections<\/h3>\n<p>Financial statements reflect the numbers achieved at the end of the reporting period. If customers are late with payments, the financial period will close without clearing those accounts, which may lead to surprises as you expect a larger amount to be collected based on the invoice due dates. Therefore, the Customer Debt Aging Report gives you a forward-looking perspective, allowing you to anticipate continued delays in collecting some of your debts.<\/p>\n<h3>Improving Your Payment Strategies and Methods<\/h3>\n<p>By tracking patterns of late payments from customers, you may identify issues that are more related to your business than to the customers themselves. Perhaps the payment options available to your customers are limited, or maybe you lack a system for regular follow-ups or forget to send reminders. Thus, you should take your payment policies and mechanisms into account when analyzing why some customers delay payment.[\/vc_column_text][vc_custom_heading text=&#8221;How can the System Help You Generate the Customer Debt Aging Report?&#8221; font_container=&#8221;tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2&#8243; use_theme_fonts=&#8221;yes&#8221; css=&#8221;.vc_custom_1734938242415{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1734946069365{margin-left: 200px !important;}&#8221;]The software provides a variety of easy-to-generate reports to help you understand your company&#8217;s financial situation. There are two reports related to customer debt aging:<\/p>\n<h3><b>Aged Debtor (Invoices):<\/b><\/h3>\n<p>This report directly concerns customer invoices. It calculates the time that has passed since the due date of each invoice, and these amounts are recorded in the adjacent fields next to the customer&#8217;s name in the report based on the time that has passed since the due date for each client.<\/p>\n<p>&nbsp;<\/p>\n<p><b>For Example:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Client &#8220;<strong>Michael<\/strong>&#8221; has:<\/span><\/p>\n<p>An invoice overdue for more than 90 days with an amount of 40,713.20 L.E.<\/p>\n<p>Another invoice overdue for more than 120 days with an amount of 122,139.60 L.E.<\/p>\n<p>&nbsp;<\/p>\n<p>This will be reflected in the aging report, with each invoice amount recorded in a separate column under the client&#8217;s name, both appearing in the same row.<\/p>\n<p>&nbsp;<\/p>\n<h3>Aged Debtor (Ledger):<\/h3>\n<p>This report relates to the debts that the customer owes you, regardless of the source, based on the balances in the customer&#8217;s general ledger account for the reporting period. These debts may be the result of invoices or other financial transactions.<\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25569 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-1024x512.png\" alt=\"\" width=\"640\" height=\"320\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-768x384.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor.png 1199w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><b>For Example:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Client &#8220;<strong>Michael<\/strong>&#8221; has:<\/span><\/p>\n<p>She has an invoice due within the period of (1 &#8211; 30 days) for an amount of 20,356.60 L.E,<br \/>\nand another invoice due within the period of (31 &#8211; 60 days) for an amount of 356.60 L.E.<\/p>\n<p>This will be reflected by recording the amount of each invoice in a separate column in the Aged Debtor Report (Invoices), with both appearing in the same row under the customer\u2019s name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25571 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-1024x512.png\" alt=\"\" width=\"640\" height=\"320\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-768x384.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger.png 1199w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3><\/h3>\n<h3><b>Steps to Generate the Aged Debtor Report<\/b><\/h3>\n<p>Click on &#8220;<strong>Clients Reports<\/strong>&#8221; from the &#8220;<strong>Reports<\/strong>&#8221; dropdown in the main menu, then click on either &#8220;<strong>Aged Debtor (Invoices)<\/strong>&#8221; or &#8220;<strong>Aged Debtor (Ledger)<\/strong>&#8221; depending on the type of Client Debt Aging Report you wish to generate.<\/p>\n<p><a href=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25573 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-1024x449.png\" alt=\"\" width=\"640\" height=\"281\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-1024x449.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-300x132.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-768x337.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports.png 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Adjust the report settings as desired, then click the &#8220;<strong>Show Report&#8221;<\/strong> button.<\/p>\n<p>You can also print the report by clicking the &#8220;<strong>Print<\/strong>&#8221; button or download it to your device by clicking &#8220;<strong>Export Options.<\/strong>&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25575 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-filters-1024x335.png\" alt=\"\" width=\"640\" height=\"209\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-filters-1024x335.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-filters-300x98.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-filters-768x251.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-reports-filters.png 1140w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>The <strong>Aged Debtor Report (Invoices)<\/strong> will appear as follows:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25577 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Invoices-1024x512.png\" alt=\"\" width=\"640\" height=\"320\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Invoices-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Invoices-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Invoices-768x384.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Invoices.png 1199w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>The <strong>Aged Debtor Report (Ledger)<\/strong> will appear as follows:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25579 size-large\" src=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-display-1024x512.png\" alt=\"\" width=\"640\" height=\"320\" srcset=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-display-1024x512.png 1024w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-display-300x150.png 300w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-display-768x384.png 768w, https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-Ledger-display.png 1198w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[6953],"tags":[7864,7865,7867,7866,7868,7869,4082,5737],"class_list":["post-21879","user_manual","type-user_manual","status-publish","hentry","category-clients-reports","tag-aged-debtor","tag-aged-debtor-report","tag-clients-reports","tag-customer-aged-debtor-report","tag-debit-aging","tag-debit-aging-report","tag-reports","tag-5737"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Clients Aged Debtors 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\/user_manual\/aged-debtors-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Clients Aged Debtors Report - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1734876096988{margin-left: 200px !important;}&#8221;]The Client Debt Aging Report divides client debts based on the period of delay in the payment of amounts due on their due dates. It is typically divided as follows: Debts overdue for 30 days. Debts overdue between 30 and 60 days. Debts overdue between 60 and 90 days. Debts overdue for [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-23T09:29:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-1024x512.png\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"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\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor.png\",\"width\":1199,\"height\":600},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/\",\"name\":\"Clients Aged Debtors Report - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#primaryimage\"},\"datePublished\":\"2024-07-18T11:00:09+00:00\",\"dateModified\":\"2024-12-23T09:29:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Clients Aged Debtors Report\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Clients Aged Debtors 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\/user_manual\/aged-debtors-report\/","og_locale":"en_US","og_type":"article","og_title":"Clients Aged Debtors Report - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=&#8221;.vc_custom_1734876096988{margin-left: 200px !important;}&#8221;]The Client Debt Aging Report divides client debts based on the period of delay in the payment of amounts due on their due dates. It is typically divided as follows: Debts overdue for 30 days. Debts overdue between 30 and 60 days. Debts overdue between 60 and 90 days. Debts overdue for [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2024-12-23T09:29:09+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor-1024x512.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","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":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/aged-debtor.png","width":1199,"height":600},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/","name":"Clients Aged Debtors Report - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#primaryimage"},"datePublished":"2024-07-18T11:00:09+00:00","dateModified":"2024-12-23T09:29:09+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/aged-debtors-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Clients Aged Debtors Report"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/21879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/user_manual"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":4,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/21879\/revisions"}],"predecessor-version":[{"id":25581,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/21879\/revisions\/25581"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=21879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=21879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=21879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}