<img src="https://letcheck.b-cdn.net/3081/clxfqkgft0kzw4w9nel1dbwr0.jpeg" style="width: 100%; height: auto; cursor: pointer;" draggable="true"><h3 style="text-align: start" id="0c5c01df-0ee4-4000-93de-fb278acbc42e" data-toc-id="0c5c01df-0ee4-4000-93de-fb278acbc42e">Power BI Accounts Receivable Template</h3>The Power BI Accounts Receivable template from Accounting Insights&nbsp;is for finance and collections professionals that want to drive down average debtor days.Unlike conventional aged debtor reports, this Power BI Accounts Receivable template is highly interactive.&nbsp; Across just three report pages, the report provides the following insights:<ol><li>A top-level overview of debtors, KPIs and cash outlook for the month</li><li>A timeline of customer(s) balances and invoices falling due, with customer and invoice details</li><li>Trends of Debtor Days (DSO), Sales and Debtors for the last 3 months and 12 months</li></ol><h4 style="text-align: start" id="f616c5fe-35cd-4c7a-8de0-8b5f2966e3e2" data-toc-id="f616c5fe-35cd-4c7a-8de0-8b5f2966e3e2">Receivables overview page</h4>The Receivables Overview page (called “Receivables”) of the Power BI Accounts Receivable Template gives a company-wide overview of your debtors.<img src="https://letcheck.b-cdn.net/3081/clxfqi38o0lawd68zeuuz1rgg.png" style="width: 100%; height: auto; cursor: pointer;" draggable="true"><h4 style="text-align: start" id="698f8aa2-4d64-4e39-97dd-d16d490ffe0c" data-toc-id="698f8aa2-4d64-4e39-97dd-d16d490ffe0c">10 Accounts Receivable KPIs tracked by this page</h4>The Receivables Overview page of the Accounts Receivable Template for Power BI tracks the following 10 Accounts Receivable KPIs for the whole company and any selected customers:<ol><li>Aged Debt by Aged Period and by Week</li><li>Total outstanding (unreconciled) debt</li><li>Total Overdue Debt</li><li>Overdue ratio (overdue/outstanding) x 100%</li><li>Days Sales Outstanding (based on 52-weeks sales)</li><li>Weighted Average Debt Age</li><li>Weighted Average Due Days</li><li>Weighted Average Overdue Days</li><li>Receipts to date this month</li><li>Total receipts expected this month</li></ol><h4 style="text-align: start" id="05bb101f-a82f-44d4-bec9-5ee460ac6584" data-toc-id="05bb101f-a82f-44d4-bec9-5ee460ac6584">Collections Page (timeline of receivables due)</h4>The Collections page presents a more detailed picture of your Accounts Receivable, showing&nbsp; timeline of receivables falling due by customer, invoice and invoice item with the customer(s) balance history.<img src="https://letcheck.b-cdn.net/3081/clxfqi3c70m8wbh8z1bo29v4l.png" style="width: 100%; height: auto; cursor: pointer;" draggable="true"><h4 style="text-align: start" id="2fdea5ee-4625-4247-872b-3569217a5485" data-toc-id="2fdea5ee-4625-4247-872b-3569217a5485">Receivables Trends Page</h4>The trends page of the Accounts Receivable template shows the underlying trends of the receviables over the last 12 months and three months.&nbsp; Three trends are tracked:&nbsp;<ol><li>Days Sales Outstanding (aka “DSO” or “Debtor Days”), calculated on a 28-day basis (to match the trading patterns of the company).&nbsp; From the trends graph, you can see that there was a spike around 10 months ago, but the underlying trend has been down (an improvement).</li><li>28-Day Gross Sales Running Total.&nbsp; It is important to look at DSO trends and Debtor Balance trends in the context of sales that are being made.&nbsp; In other words, if you make no sales, then your debtors’ balance will reduce, but this is not usually a good thing.&nbsp; In this example, we have selected 28-days rolling sales as it matches the underlying sales patterns and collections patterns of the company, so reducing spurious “noise” from&nbsp;<a target="_blank" rel="noopener noreferrer nofollow" href="https://www.accountingweb.co.uk/tech/excel/the-abc-of-power-bi-d-is-for-date">sales patterns that are misaligned from the reporting patterns.</a></li><li>Customer balances.&nbsp; In this case we are showing all customer balances, including those with a credit balance since all customers in this dataset trade on credit.&nbsp;&nbsp;</li></ol><img src="https://letcheck.b-cdn.net/3081/clxfqi32d0ksj1h9ng0k55z9p.png" style="width: 100%; height: auto; cursor: pointer;" draggable="true">

Power BI Accounts Receivable Template to drive down debtor days

10 Accounts Receivable KPIs tracked by this page

Collections Page (timeline of receivables due)

Learn how to grow and scale your online course business using our online course platform. EzyCourse blog is designed to teach you how to create and sell online courses.

Power BI Accounts Receivable Template to drive down debtor days

Power BI Accounts Receivable Template to drive down debtor days

Related Posts

Sage 50 Accounts ODBC Excel connection

Power BI Profit and Loss Template