Receivables Analysis in Power BI: From Debt Ageing to Collection

Receivables analysis in a Power BI report shows you every morning who owes you money, how long each debt is overdue and whether collection is improving. From that, you can decide whom to call first. The visualisation itself is not the hardest part. The real challenge is getting debt data from Rivilė or Finvalda to refresh on its own, without exporting to Excel. That is why a ready-built report package that connects directly to your accounting system saves the most time. Analitika360 offers Power BI packages of this kind to Rivilė and Finvalda users from €59 a month.

In brief

  • Receivables analysis answers four questions: how much money is tied up in debts, who is paying late, by how many days, and whether the situation is improving.
  • The foundation is the debt register, payments and sales invoices with payment terms. Rivilė provides these through its API.
  • The key metrics are ageing buckets (0–30, 31–60, 61–90, 90+ days), days sales outstanding and the share of overdue debt.
  • It is worth keeping supplier debts, supply delays and sales channels in the same model, because they all affect the same cash flow.
  • A ready-built Rivilė or Finvalda package removes the most error-prone task: preparing the data by hand.

Contents

What receivables analysis tells you

Receivables are amounts owed to you by customers for goods or services you have sold. Analysing them should help you make decisions, not just list who owes what. A good report answers these questions:

  1. How much money is tied up in debts right now, and how the total has changed since the start of the year.
  2. Which invoices are overdue and by how many days, broken down by customer, sales manager or department.
  3. What share of the debt is at risk, i.e. overdue by more than 60 or 90 days.
  4. Whether collection is improving: are customers paying faster than last quarter?
  5. Who pays late consistently, rather than just once.

For a restaurant chain, this usually means invoices for events, catering services and business clients. For a wholesaler or a construction company, it is the most important part of working capital. For an accountant, this report makes it possible to answer the managing director in a minute rather than after half a day in Excel.

What data you need from Rivilė or Finvalda

Debts do not appear in the accounts out of nowhere. The Rivilė GAMA guide explains that they arise when purchase and sales transactions are posted and when receivable or payable transactions are entered. If a payment deferral is specified, its days are added to the document date. This leads to a practical rule: if a document has no payment term, the report cannot calculate the days overdue correctly.

For Rivilė ERP users, the Power BI integration guide lists the datasets needed for debt analysis:

  • PAYABLE_RECEIVABLES_FLAT: the debt register, i.e. who owes whom and how much;
  • PAYMENTS: receipts and payments, showing when an invoice was paid;
  • SALES_INVOICE_DETAILED and PURCHASE_INVOICE_DETAILED: sales and purchase invoices with their line items;
  • CLIENT: the list of customers and suppliers with their groups.

The same guide states that Power BI connects to Rivilė through a REST API request with a key and a date range, and recommends incremental refresh and a star schema. We have described how this works in practice in our articles on connecting the Rivilė API to Power BI and connecting the Finvalda API to Power BI.

Metrics and visuals in the report

A good receivables report has only a few elements, but each one answers a specific question.

MetricWhat it showsSuitable visual
Total debtHow much money is tied up with customersCard showing the change since the start of the year
Ageing bucketsHow debts are distributed: current, 1–30, 31–60, 61–90, 90+ daysStacked column chart
Share of overdue debtWhat proportion of debt is already past its due datePercentage card with trend
Days sales outstanding (DSO)How many days it takes on average to collect cashLine chart by month
Customer rankingWhich customers owe the most and for the longestTable with conditional formatting
Customer × days overdueWhere the risk is concentratedHeat map with drill-down to invoice level

Days sales outstanding is a classic turnover ratio, also used in Lithuanian financial analysis research. It is calculated by dividing average receivables by sales for the period and multiplying by the number of days in the period. For example, if average receivables over a quarter were €120,000 and sales reached €360,000, then DSO = 120,000 / 360,000 × 90 = 30 days. If your standard payment term is 14 days, customers are paying, on average, twice as late as agreed.

A common mistake is to include invoices that are not yet due in the 1–30 day bucket. Keep current debts in a separate bucket, otherwise overdue debt will look worse than it really is.

How to build receivables analysis: five steps

  1. Get payment terms in order in your accounting system. Every sales document must have a payment term. Without one, Power BI will calculate days overdue from the document date. Only the accounting team can carry out this step.
  2. Connect the data directly, without Excel in the middle. A weekly manual export means the report is always out of date and depends on a single person. Analitika360 packages connect to Rivilė and Finvalda, and the reports refresh without any extra work from users.
  3. Build a star schema. Debt and payment facts are linked to customer, date and department dimensions. Dimensions are the tables you filter by. The most common mistake is a single large flat table in which amounts are duplicated. We cover this in more detail in our star schema guide.
  4. Calculate days overdue against today’s date. Days overdue must be counted from the due date to today. If they are fixed at the time of refresh, the report is wrong by the very next day. For large volumes of data, use incremental refresh.
  5. Create views for different users. The managing director needs the total and the trend, a sales manager needs a list of their own customers, and the accountant needs invoice-level detail. In the ready-built Rivilė and Finvalda packages, debt metrics already sit alongside revenue, costs and profit.

Supplier debts, supply delays and sales channels

Receivables analysis shows only half of the cash flow. The other half is payables analysis: how much you have to pay yourself, and when. When both sides are in a single model, you can see whether customer payments will cover upcoming payments to suppliers. In financial analysis, the supplier, customer, their groups and country are used as dimensions, and you can drill down from a total to an individual transaction. This principle is also described in Microsoft’s documentation. We explain how to link this to forecasting in our article on cash flow analysis.

Supply delay analysis requires two dates: the promised delivery date and the actual one. The difference in days, calculated by supplier, shows how often delays occur and how long they last. This data often sits in a logistics system or an Excel spreadsheet. Analitika360 integrates such sources into the same Power BI model as the accounting data.

Sales channel analysis compares revenue, margin and collection speed by channel: online shop, wholesale, events. A channel where sales are growing but DSO is lengthening may be less profitable than its turnover suggests. If channel information is held in a CRM system, CRM and Power BI integration will help.

How to read the results and what to do next

  • The 90+ day bucket is growing: review these customers’ credit terms and add them to a priority reminder list.
  • DSO is lengthening even though there is little overdue debt: you have most likely granted payment terms that are too long. The fix is commercial, not a matter of debt collection.
  • A single customer accounts for a large share of debt: this is concentration risk, which the managing director needs to see separately.
  • You pay suppliers faster than you collect from customers: you are financing working capital yourself, so it is worth negotiating terms.

It is worth knowing what the law allows. Under the Law on the Prevention of Late Payments in Commercial Transactions, a creditor who has become entitled to interest may, without separate notice, claim €40 as compensation for recovery costs. The law also regulates payment terms between businesses. For a specific contract or dispute, consult a lawyer.

Ready-built debt report packages for Rivilė and Finvalda

Analitika360 sells ready-built Power BI report packages that show revenue, costs, profit, the balance sheet, sales, inventory and debts in real time. The reports refresh automatically. Rivilė Basic and Finvalda Basic cost €59 a month, while Rivilė PRO and Finvalda PRO cost €89 a month.

Analitika360

If you need to link logistics, CRM or SharePoint data, or create reports tailored to your company’s processes, bespoke projects cost €70 an hour. You can compare all plans on the business analytics pricing page. An example aimed at accountants can be found in our article on Rivilė debt reports.

Our view

Debt reports do not solve problems on their own. Problems get solved when someone sees the report in time and takes action. That is why our first priority is making sure data from Rivilė or Finvalda arrives by itself, so nobody has to be reminded to refresh it.

We always assess receivables alongside revenue, profit and supplier debts. A standalone debt table tells you who is paying late. A combined model shows what that delay means for cash flow and which decision needs to be made today.

Our ready-built packages are designed so that the accountant, finance director or owner has this picture from day one. Time can then go into decisions rather than into preparing reports.

Analitika360

FAQ

Do you need a developer for receivables analysis in Power BI?

If you build the model yourself, you will need to know how to connect to an API, how to model data and how to write DAX formulas. A ready-built Rivilė or Finvalda package has this work done already: you see the metrics, and refreshes happen automatically.

Do you need a developer for receivables analysis in Power BI?

Which ageing buckets suit most companies?

The most common are current debts, 1–30, 31–60, 61–90 and more than 90 days. If your payment terms are short, for example 7 days, the first bucket can be split more finely.

Debt ageing buckets by days overdue

Can you see receivables and payables in a single report?

Yes, and it is recommended. Rivilė provides a combined debt register, so both sides fit into a single model, with the impact on cash flow visible alongside.

Can sales managers view the Power BI report too?

Yes. The report can be shared with your team, and each user can be given the view they need. Sharing reports requires Microsoft licences, which Analitika360 can also provide.

Sources

Customer debt analysis, Rivilė GAMA guide For analytics, reporting and data export, Rivilė ERP guide Financial insights, Microsoft Learn Turnover ratios, Mykolas Romeris University Law on the Prevention of Late Payments in Commercial Transactions, e-seimas

Further reading

Want reports like these for your own business?

Analitika360 builds Power BI reports from the data already in your accounting system — Rivilė, Finvalda or R-Keeper. They refresh automatically, from €59 a month.

Pricing and plans
Analitika360 client stories

Data that helps you decide

See how companies like yours put Analitika360 reports to work in Power BI.

“
We took the standard R-Keeper report package and they tailored it to us on top of that. It all just works.
TB
Tomas B.restaurant owner
“
Twenty ready-made reports — we didn't have to work out what to ask for. Our Finvalda data is finally something you can look at. Recommended.
IM
Ingrida M.accountant
“
What we liked was that Analitika360 already had a 20-report package for Rivilė users — we didn't have to work out our requirements from scratch. We were up and running quickly, and later they adapted several reports to the specifics of our production. It saved us both time and money.
MK
Marius K.finance director
“
We are a group of companies running Rivilė, and consolidated reporting was always a headache. Analitika360 started from the standard 20-report package and then fitted it to our group structure — we now see everything in one Power BI model, and it refreshes itself.
GJ
Giedrė Jankauskaitėfinancial accountant
“
We run six restaurants on R-Keeper and had long been looking for a way to compare results across sites. The standard 20-report package covered most of what we needed, and reports specific to our group were added later.
AŠ
Andrius Š.director of a restaurant group
“
We came to them on a recommendation, and the ready-made 20-report standard for Finvalda users was a pleasant surprise straight away. Management now gets a clear financial picture every Monday, and I no longer spend days exporting data into Excel.
RP
Rasa Petrauskienėhead of accounting
“
We use Rivilė, but we never had time to build reports from scratch. The 20-report package was exactly what we needed — we had it running within a week.
VP
Vaidas P.retail chain manager
“
We have four cafés on R-Keeper and for a long time we ran them on gut feel. The Analitika360 reports showed us things we had simply never noticed. We now decide on the numbers rather than on guesswork.
LK
Laura Kazlauskienėfinance director of a café group