Billing cohorts, the best way to improve your cash collection

As a modern finance leader, you know how important it is to measure your company’s financial performance so that you can improve your financial position and better forecast future cash flows.

When it comes to analyzing your accounts receivable and improving your cash collection, the two most important KPIs to track are:

Why 180 days? Eventually, you’ll need to register a write-off in your accounting system when you know you won’t be able to get paid. From a general and practical standpoint, invoices still unpaid after more than 6 months are very likely to fall into this category.

These metrics are of course highly correlated: if you have a high percentage write-off, this negatively impacts your DSO because old invoices are still outstanding.

But they measure the impact on your business differently: having a high DSO means that you’re bankrolling your customers with essentially zero-interest loans, whereas a high percentage write-off means you are incurring a loss.

In this article, we want to share what we think is the most useful AR dashboard to monitor and walk you through a technique to measure your percentage write-off and ensure that it decreases over time: billing cohorts.

In essence, a billing cohort tracks groups of invoices that were issued in the same month.

The fundamental idea behind billing cohort analysis is to compare different billing cohorts with one another: for example, you may want to compare the percentage of invoices issued in May 2019 that were paid in under 30 days to those that were issued in September 2019 and that were paid within the same amount of time.

If you’ve been improving your collection efficiency, then the percentage of invoices paid in 30 days that were issued in September should be higher than those that were issued in May.

The best way to visualize this data is by using a 2 by 2 matrix:

Here, each row represents a different month of billing (a cohort), and each column represents the cumulative percentage of invoices that were paid within a certain time period. So here, for example, we can see that in December, we issued $31k in invoices and 89% of those were paid within 60 days of issuance.

Of course, you should adjust time buckets based on your business and your payment terms.

There are two ways to read a billing cohort:

Need help calculating your top A/R metrics? Have a look at our free spreadsheet.

The first thing you need to do is build the billing cohort matrix of your accounts receivable. We’ve got you covered with our free discover plan! Connect your ERP or billing tool in a few clicks and see your billing cohort matrix

Once done, look at your 180-day bucket. Even if it’s in the low single digits, this can add up to a significant amount of lost revenue (an accounts receivable cost estimator will help you understand exactly how much).

For example, did you know that at $10m revenue, a 0.5% write-off amounts to more than $4k lost every month?

Put differently, if you sell at a 20% margin each write-off will require you to sell 5x (revenue and cost incurred are both lost).

Once you understand the costs, measuring ROI is easy: in the above example reducing your write-offs from 0.5% to 0.3% equates to savings of $1,500 per month or $18k per year.

And the great news is that more often than not, simple process changes are sufficient to achieve those kinds of results.

In summary, every B2B company should be making use of billing cohorts to measure how efficient they are at cash collection, and how that efficiency is evolving over time. That’s the first step – from there you should implement tools that are more sophisticated than spreadsheets to keep track of your unpaid invoices and follow up on them in a systematic way.

At Upflow, we believe it’s all about automation! Our in-house A/R software can help you lower your DSO efficiently by automating your collection process and help you get paid faster. Try out our free Discover Plan by Upflow.