{"id":11316,"date":"2026-09-24T09:28:43","date_gmt":"2026-09-24T07:28:43","guid":{"rendered":"https:\/\/powerbi.pl\/?p=11316"},"modified":"2026-09-10T09:40:14","modified_gmt":"2026-09-10T07:40:14","slug":"power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","status":"publish","type":"post","link":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","title":{"rendered":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk"},"content":{"rendered":"<h2>A Shared View of Receivables for Finance and Sales<\/h2>\n<p>In many organizations, accounting tracks outstanding balances, sales representatives know the arrangements made with customers, and management receives an aggregated summary. This information does not always come together in one place, so identifying the reason for a late payment requires exchanging messages and comparing spreadsheets. Microsoft Power BI allows teams to combine data from ERP, accounting, and CRM systems with payments applied to invoices. A report can bring together the outstanding amount, payment due date, account manager, and case status. After selecting a customer, users can move from the total balance to individual invoices and payment history. Using <a href=\"https:\/\/powerbi.pl\/en\/areas-of-implementation\/power-bi-in-finance\">Power BI in finance<\/a> this way reduces report preparation time and makes it easier to agree on next steps.<\/p>\n<p>The overview page should show total receivables, the overdue amount, its share of the outstanding balance, and payments expected over the coming weeks. The same report can support filtering by company, currency, region, or sales representative. Finance can then analyze the entire portfolio, while account managers receive the details they need for customer conversations. Each team\u2019s data access should reflect its responsibilities.<\/p>\n<h2>DSO in Power BI: When Do Sales Turn into Cash?<\/h2>\n<p>Days Sales Outstanding, or DSO, expresses the level of receivables in days of sales and helps assess how quickly credit sales convert into cash. One calculation method divides average trade receivables by credit sales for the period and multiplies the result by the number of days. With average receivables of PLN 1.2 million and credit sales of PLN 2.4 million over 90 days, DSO is 45 days. This is a simplified example that assumes the amounts are calculated on a comparable basis, including consistent treatment of VAT. In Power BI, teams can create an agreed-upon DSO measure and track it by month, customer segment, and business unit. The result responds to the selected filters, eliminating the need to prepare separate summaries for each department.<\/p>\n<p>The greatest value comes from comparing DSO with payment terms and overdue balances. An increase may reflect late customer payments, but it can also result from longer terms offered in new contracts or seasonal changes in sales. The report helps determine whether the deterioration affects the entire company or a single segment. Alongside DSO, it is useful to show the actual time to payment and days past due for settled invoices. This helps managers distinguish the effects of sales policy from problems collecting payments under agreed terms. DSO is not a simple average of invoice payment delays and should not be interpreted in isolation.<\/p>\n<h2>Overdue Invoices: From Outstanding Balances to Action Priorities<\/h2>\n<p>An accounts receivable aging report shows how long individual amounts have remained unpaid past their due dates. In Microsoft Power BI, balances can be divided into amounts not yet due and aging buckets such as 1\u201330, 31\u201360, 61\u201390, and more than 90 days past due. A chart shows the composition of the portfolio, while selecting a bucket narrows the list of customers and invoices requiring attention. The analysis should use the remaining outstanding balance after partial payments and adjustments. Aging should be calculated as of a selected reporting date, allowing users to compare the current position with previous periods. Reconstructing historical balances requires retaining payment application data or periodic balance snapshots.<\/p>\n<p>A practical worklist can include:<\/p>\n<ul>\n<li>Customer name, invoice number, and remaining amount due.<\/li>\n<li>Payment due date and days past due.<\/li>\n<li>The person responsible for follow-up.<\/li>\n<li>Complaint or dispute status.<\/li>\n<li>The promised payment date and whether that commitment was met.<\/li>\n<\/ul>\n<p>This view helps distinguish an overlooked payment from an invoice withheld because of a complaint. It also makes it easier to prioritize follow-up based on the amount, age of the debt, and customer history. The team receives a specific list of cases rather than simply being told that overdue receivables have increased. Recording customer contacts and sending reminders remain the responsibility of an operational system or a separately integrated workflow.<\/p>\n<h2>Customer Risk: Which Overdue Balances Could Threaten the Business?<\/h2>\n<p>Two companies with the same level of overdue receivables may face very different situations. In one, overdue balances are spread across many customers; in the other, most of the balance belongs to a single customer. Power BI can show how much of the receivables portfolio is concentrated among the largest debtors and how their payment behavior is changing. A report can compare increasing payment delays with credit limit utilization, missed payment commitments, and new orders. If the company has data from a business credit reporting agency or trade credit insurer, that information can also be incorporated. The result is a view that supports exposure assessment rather than merely ranking the largest invoices.<\/p>\n<p>Agreed-upon rules can flag customers that require review before additional credit is extended. A color or risk category helps set priorities, but it does not automatically establish that a customer is insolvent. Payment behavior should also be considered alongside margins and the cost to serve. A high-revenue customer may tie up significant capital and require expensive financing. Combining receivables with <a href=\"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-customer-and-product-profitability-analysis-how-to-identify-hidden-losses-in-your-business\">customer and product profitability analysis<\/a> provides a more complete basis for discussing commercial terms.<\/p>\n<h2>Cash Receipts Forecasting: How Can You Identify a Cash Shortfall Earlier?<\/h2>\n<p>The due date on an invoice specifies when a customer should pay, but it does not always indicate when the money will actually arrive. In Microsoft Power BI, teams can compare receipts scheduled according to contractual due dates with a forecast based on payment history and current arrangements. A customer that typically pays ten days late should not be treated the same as one that consistently pays on time. Disputed invoices, installment payments, and receivables with uncertain collectibility require separate treatment. The forecast should be updated as new information becomes available, and its accuracy should be assessed against actual receipts. Power BI displays and recalculates this model, but its assumptions must be designed in advance.<\/p>\n<p>Only by combining projected receipts with available cash and planned outflows can a company assess the risk of a cash shortfall. The report can show opening cash, inflows, outflows, and projected closing cash week by week. Including supplier obligations, payroll, and other payments reveals periods when inflows are insufficient to cover requirements. For management, this view is more useful than the total receivables balance alone. It also complements <a href=\"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-executives-10-kpis-that-truly-support-strategic-decision-making\">metrics that support strategic decisions<\/a> by showing how much time is available to respond.<\/p>\n<h2>Scenario Analysis: What Happens If a Customer Pays Late?<\/h2>\n<p>Microsoft Power BI lets teams build an analysis where users adjust assumptions and immediately see the effect on projected cash. They can test a delay in a large payment, a partial payment, or a shift in receipts from a selected customer segment. Suppose a company starts the week with PLN 300,000, expects PLN 500,000 in receipts, and plans PLN 650,000 in outflows. In the base case, closing cash is PLN 150,000. Moving a customer payment of PLN 250,000 to the following week changes the result to a PLN 100,000 shortfall. This simplified example shows why a positive base-case cash forecast is not enough to assess liquidity resilience.<\/p>\n<p>Such a report gives finance time to review funding sources and agree on possible actions. Teams can also compare base, downside, and upside scenarios using consistent calculation rules. Daily balances are useful alongside weekly balances when major payments fall due before expected receipts. The simulation helps assess the plan\u2019s sensitivity to changing assumptions, but it does not guarantee a future cash position.<\/p>\n<h2>How Do You Implement Power BI for Accounts Receivable Management?<\/h2>\n<p>Start with the decisions the report should support: selecting customers for follow-up, reviewing credit limits, or planning liquidity. Next, agree on the DSO calculation method, aging buckets, and cash receipts forecasting rules. Payments must be correctly applied to invoices, adjustments must be accounted for, and currencies must be converted according to agreed rules. A <a href=\"https:\/\/powerbi.pl\/en\/blog\/blog-en\/how-to-design-a-data-model-in-power-bi-for-fast-scalable-and-reliable-reports\">well-designed data model<\/a> helps prevent double-counting balances and keeps analyses consistent. Before sharing the report, reconcile its figures with accounting records, and display the data\u2019s as-of date. Users can then tell whether the latest payment has already been included.<\/p>\n<p>At EBIS, we help plan <a href=\"https:\/\/powerbi.pl\/en\/offer\/power-bi-implementations\">Power BI implementations<\/a> that connect accounts receivable data with the information finance, sales, and management need. Contact us to develop reporting that makes it easier to monitor receivables and respond earlier to liquidity risks.<\/p>\n<div id=\"gtx-trans\" style=\"position: absolute; left: 1px; top: 1630.88px;\">\n<div class=\"gtx-trans-icon\"><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Growing sales do not always mean more money in the bank. A company can fulfill new orders and report a profit while waiting increasingly longer to get paid. When payroll, taxes, and supplier payments come due before customer payments arrive, the business needs analysis that goes beyond a list of unpaid invoices. Power BI for accounts receivable management combines sales data, account balances, and customer payment behavior. This enables finance and sales teams to collaborate on a shared report, identify issues earlier, and determine which actions are most critical for maintaining liquidity.<\/p>\n","protected":false},"author":2,"featured_media":11311,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[29],"tags":[557,556],"class_list":["post-11316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-en","tag-power-bi-for-accounts-receivable-management","tag-power-bi-w-zarzadzaniu-naleznosciami"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner<\/title>\n<meta name=\"description\" content=\"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner\" \/>\n<meta property=\"og:description\" content=\"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\" \/>\n<meta property=\"og:site_name\" content=\"EBIS - Microsoft Power BI Partner\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-24T07:28:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ma\u0142gorzata Dadok-Grabska\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ma\u0142gorzata Dadok-Grabska\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\"},\"author\":{\"name\":\"Ma\u0142gorzata Dadok-Grabska\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#\\\/schema\\\/person\\\/0f852d864de2411bda6ff9991846aa20\"},\"headline\":\"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk\",\"datePublished\":\"2026-09-24T07:28:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\"},\"wordCount\":1381,\"publisher\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Power-BI-w-zarzadzaniu-naleznosciami.png\",\"keywords\":[\"Power BI for Accounts Receivable Management\",\"Power BI w zarz\u0105dzaniu nale\u017cno\u015bciami\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\",\"url\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\",\"name\":\"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Power-BI-w-zarzadzaniu-naleznosciami.png\",\"datePublished\":\"2026-09-24T07:28:43+00:00\",\"description\":\"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage\",\"url\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Power-BI-w-zarzadzaniu-naleznosciami.png\",\"contentUrl\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Power-BI-w-zarzadzaniu-naleznosciami.png\",\"width\":900,\"height\":600,\"caption\":\"Power BI w zarz\u0105dzaniu nale\u017cno\u015bciami.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/blog-en\\\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/home-page\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#website\",\"url\":\"https:\\\/\\\/powerbi.pl\\\/en\",\"name\":\"EBIS - Microsoft Power BI Partner\",\"description\":\"us\u0142ugi analityczne\",\"publisher\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#organization\"},\"alternateName\":\"Microsoft Power BI\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/powerbi.pl\\\/en?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#organization\",\"name\":\"EBIS\",\"alternateName\":\"EBIS\",\"url\":\"https:\\\/\\\/powerbi.pl\\\/en\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/favicon-ebis.png\",\"contentUrl\":\"https:\\\/\\\/powerbi.pl\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/favicon-ebis.png\",\"width\":512,\"height\":512,\"caption\":\"EBIS\"},\"image\":{\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ebis-business-intelligence\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/powerbi.pl\\\/en#\\\/schema\\\/person\\\/0f852d864de2411bda6ff9991846aa20\",\"name\":\"Ma\u0142gorzata Dadok-Grabska\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g\",\"caption\":\"Ma\u0142gorzata Dadok-Grabska\"},\"url\":\"https:\\\/\\\/powerbi.pl\\\/en\\\/blog\\\/author\\\/malgorzatadg\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner","description":"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and","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:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","og_locale":"en_US","og_type":"article","og_title":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner","og_description":"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and","og_url":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","og_site_name":"EBIS - Microsoft Power BI Partner","article_published_time":"2026-09-24T07:28:43+00:00","og_image":[{"width":900,"height":600,"url":"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png","type":"image\/png"}],"author":"Ma\u0142gorzata Dadok-Grabska","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ma\u0142gorzata Dadok-Grabska","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#article","isPartOf":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk"},"author":{"name":"Ma\u0142gorzata Dadok-Grabska","@id":"https:\/\/powerbi.pl\/en#\/schema\/person\/0f852d864de2411bda6ff9991846aa20"},"headline":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk","datePublished":"2026-09-24T07:28:43+00:00","mainEntityOfPage":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk"},"wordCount":1381,"publisher":{"@id":"https:\/\/powerbi.pl\/en#organization"},"image":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage"},"thumbnailUrl":"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png","keywords":["Power BI for Accounts Receivable Management","Power BI w zarz\u0105dzaniu nale\u017cno\u015bciami"],"articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","url":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk","name":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk | EBIS - Microsoft Power BI Partner","isPartOf":{"@id":"https:\/\/powerbi.pl\/en#website"},"primaryImageOfPage":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage"},"image":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage"},"thumbnailUrl":"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png","datePublished":"2026-09-24T07:28:43+00:00","description":"Power BI for Accounts Receivable Management - Microsoft Power BI allows teams to build an analysis in which users adjust assumptions and","breadcrumb":{"@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#primaryimage","url":"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png","contentUrl":"https:\/\/powerbi.pl\/wp-content\/uploads\/2026\/09\/Power-BI-w-zarzadzaniu-naleznosciami.png","width":900,"height":600,"caption":"Power BI w zarz\u0105dzaniu nale\u017cno\u015bciami."},{"@type":"BreadcrumbList","@id":"https:\/\/powerbi.pl\/en\/blog\/blog-en\/power-bi-for-accounts-receivable-management-how-to-analyze-dso-overdue-invoices-and-liquidity-risk#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/powerbi.pl\/en\/home-page"},{"@type":"ListItem","position":2,"name":"Power BI for Accounts Receivable Management: How to Analyze DSO, Overdue Invoices, and Liquidity Risk"}]},{"@type":"WebSite","@id":"https:\/\/powerbi.pl\/en#website","url":"https:\/\/powerbi.pl\/en","name":"EBIS - Microsoft Power BI Partner","description":"us\u0142ugi analityczne","publisher":{"@id":"https:\/\/powerbi.pl\/en#organization"},"alternateName":"Microsoft Power BI","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/powerbi.pl\/en?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/powerbi.pl\/en#organization","name":"EBIS","alternateName":"EBIS","url":"https:\/\/powerbi.pl\/en","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/powerbi.pl\/en#\/schema\/logo\/image\/","url":"https:\/\/powerbi.pl\/wp-content\/uploads\/2025\/12\/favicon-ebis.png","contentUrl":"https:\/\/powerbi.pl\/wp-content\/uploads\/2025\/12\/favicon-ebis.png","width":512,"height":512,"caption":"EBIS"},"image":{"@id":"https:\/\/powerbi.pl\/en#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/ebis-business-intelligence\/"]},{"@type":"Person","@id":"https:\/\/powerbi.pl\/en#\/schema\/person\/0f852d864de2411bda6ff9991846aa20","name":"Ma\u0142gorzata Dadok-Grabska","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed5c3428270dd07207a7ff9b14e8e35984ed1601651e6daa7f1fb281f041b1df?s=96&d=mm&r=g","caption":"Ma\u0142gorzata Dadok-Grabska"},"url":"https:\/\/powerbi.pl\/en\/blog\/author\/malgorzatadg"}]}},"_links":{"self":[{"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/posts\/11316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/comments?post=11316"}],"version-history":[{"count":1,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/posts\/11316\/revisions"}],"predecessor-version":[{"id":11317,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/posts\/11316\/revisions\/11317"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/media\/11311"}],"wp:attachment":[{"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/media?parent=11316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/categories?post=11316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powerbi.pl\/en\/wp-json\/wp\/v2\/tags?post=11316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}