# Accounts receivable aging: how to set buckets and act on each

https://krokul.com/en/blog/ar-aging-buckets/ · Krokul Team · Updated 2026-10-31

A finance manager with forty open invoices needs to know which ones to call about today. This guide shows how to sort receivables into aging buckets by days past due and what to do with each bucket.

**Short answer.** To set accounts receivable aging buckets, group every unpaid invoice by days past its due date: not yet due, up to 7 days, 8–30 days and over 30 days. Count each invoice in its own bucket, total each bucket, and give every bucket one action and one owner, from a reminder to a payment plan.

## When you need accounts receivable aging

Accounts receivable aging is the first step of collections, described in the guide on [getting B2B invoices paid on time](https://krokul.com/en/blog/topics/getting-paid/). It turns a long list of open invoices into a few totals, each with its own next step.

- The list of unpaid invoices is long and nobody agrees which ones to chase first.
- The total owed looks acceptable, yet cash arrives later than planned.
- A client has several open invoices of different ages and the calls mix them up.
- The owner asks how much of the debt is older than a month.
- Collection calls happen when someone remembers, with no fixed order.

- **Accounts receivable aging** — Accounts receivable aging is a report that sorts unpaid invoices into buckets by the number of days they are past their due date.
- **Aging bucket** — An aging bucket is a range of days past due, for example 8–30 days, that holds the total of all invoices falling inside it.
- **Days past due** — Days past due is the number of days between an invoice’s due date and today, counted only after the due date has passed.

## How to set accounts receivable aging buckets in six steps

Setting aging buckets means choosing day ranges once, then sorting every open invoice into them on a fixed schedule. The steps run in this order, and a spreadsheet is enough to follow them.

### 1. List every open invoice with its due date

Take each invoice that has been issued and not fully paid. Write down the client, the invoice number, the due date and the amount still unpaid.

Use the unpaid amount and ignore the original total. An invoice paid in part sits in the list with the remainder only.

### 2. Count the days past due

Subtract the due date from today’s date. An invoice due today is still on time, and an invoice due yesterday is one day past due.

Count from the due date, never from the invoice date. A 30-day invoice that is 20 days old is not yet due, and the clock for a late payment starts only after day 30.

### 3. Choose the bucket boundaries

Four buckets suit most B2B companies with terms of 15 to 30 days: not yet due, up to 7 days, 8–30 days and over 30 days. The first late bucket holds forgotten invoices, the second holds clients with cash pressure, and the last holds disputes and low priority.

Companies with 45 or 60 day terms often split the last bucket into 31–60, 61–90 and over 90 days. Write the boundaries down and keep them fixed, so this month’s totals compare with last month’s.

### 4. Put each invoice into its own bucket

Sort invoices one by one, never by client. A client with a fresh invoice and a three-month-old invoice appears in two buckets, and the old invoice is the one that needs the call.

Sorting by client puts the whole balance into the oldest bucket and overstates the old debt.

### 5. Total each bucket and its share of receivables

Add up the unpaid amounts in each bucket, then divide each total by the sum of all buckets. The shares show where the money waits, and a growing share in the last bucket is the earliest warning of a collection problem.

Keep all amounts in one currency. Convert each invoice at its own rate once and keep that value, so a rate change does not move the totals.

> **Tip.** Run the report on the same weekday every week, so each bucket changes only because invoices were paid or aged.

### 6. Give each bucket one action and one owner

Write the next step for every bucket and the person who takes it. A bucket without an action is a report, and a bucket without an owner is a wish.

The table in the next section holds a starting set of actions.

## What to do with each aging bucket

Each bucket calls for a different conversation, because the cause of the delay changes with its age. Move from a reminder in the first bucket to the contract signer in the last one.

Aging buckets, typical cause and the action for each:

| Bucket | Typical cause | Action | Owner |
|---|---|---|---|
| Not yet due | Invoice is within its term | Reminder three days before the due date | Account owner |
| Up to 7 days | Lost invoice, approval delay | Resend the invoice and ask who approves it | Account owner |
| 8–30 days | Cash pressure on the client side | Call, agree a date and record the promise | Account owner |
| Over 30 days | Dispute or low priority | Escalate to the contract signer and agree a payment plan | Head of finance |

The date that comes out of the 8–30 call is the most valuable output of the whole routine. The guide on [recording a promise to pay](https://krokul.com/en/blog/promise-to-pay/) explains how to store it and what to do when it slips.

## How to calculate aging buckets on an example

The example uses five open invoices and a report date of 30 November. Each invoice lands in one bucket according to its own due date.

Example: five open invoices sorted into aging buckets on 30 November:

| Invoice | Client | Unpaid amount | Due date | Days past due | Bucket |
|---|---|---|---|---|---|
| INV-210 | Client D | £6,300 | 10 Dec | 0 | Not yet due |
| INV-201 | Client A | £4,200 | 28 Nov | 2 | Up to 7 days |
| INV-188 | Client B | £7,500 | 20 Nov | 10 | 8–30 days |
| INV-192 | Client A | £2,000 | 12 Nov | 18 | 8–30 days |
| INV-175 | Client C | £3,000 | 25 Oct | 36 | Over 30 days |

Example: bucket totals and share of receivables:

| Bucket | Total | Share |
|---|---|---|
| Not yet due | £6,300 | 27.4% |
| Up to 7 days | £4,200 | 18.3% |
| 8–30 days | £9,500 | 41.3% |
| Over 30 days | £3,000 | 13.0% |
| All receivables | £23,000 | 100% |

Bucket total = sum of the unpaid amounts of the invoices inside it. Share = bucket total ÷ all receivables × 100, so £9,500 ÷ £23,000 gives 41.3%. Client A appears in two buckets, with £4,200 in the first late bucket and £2,000 in the second, and the call about INV-192 comes before the call about INV-201. Late invoices make up 72.6% of the receivables, which tells the owner that most of the money outstanding is already waiting past its date.

## Which aging report mistakes distort the picture

- Counting days from the invoice date. A fresh invoice then looks late, so count from the due date.
- Placing a whole client into the oldest bucket. Sort every invoice separately and the debt in each bucket stays true.
- Changing the boundaries every month. Fix them once and totals compare month to month.
- Adding amounts in different currencies. Convert each invoice at its own rate, then total.
- Reading the report without an owner for each bucket. Name one person per bucket before the first review.

## A weekly aging review checklist

Copy the list into your weekly routine. The full routine, day by day, is in the guide on [chasing late invoice payments](https://krokul.com/en/blog/chase-late-invoice-payments/).

- Update the list of open invoices and their unpaid amounts.
- Recalculate days past due for every invoice.
- Sort each invoice into its bucket and total the buckets.
- Compare each total with last week and write down what moved.
- Call the clients in the 8–30 bucket and record each promised date.
- Escalate the over-30 invoices to the contract signer.
- Check the promises that fell due this week.

## How Krokul builds aging buckets automatically

Krokul CRM is a B2B CRM for contract-based companies: deals, projects and profit per client in one system, implemented by integration partners. Its Debtors screen sorts every open invoice into the four buckets above without a spreadsheet.

Debt is the issued invoices minus the payments applied to them. Four tiles at the top show the totals for not yet due, up to 7 days, 8–30 days and over 30 days, and each invoice counts in its own bucket. An invoice due today still counts as not yet due, and amounts are totalled in the company’s base currency at the rate frozen on the invoice.

The tiles total the clients in the list, so with Overdue only on, clients without an overdue invoice appear neither in the list nor in the totals. A click on a tile filters the list to the clients who owe money in that bucket, and a second click removes the filter. The Overdue only switch is on by default, so the morning list starts with late invoices, and the Overdue column counts days from the client’s oldest due date. The list sorts by debt, oldest due date or days overdue.

![Debtors screen with four aging tiles from not yet due to over 30 days and a table of clients with debt and days overdue](https://krokul.com/img/en/blog/debtors-aging-buckets.webp)

From a row, record a payment promise or create a task for the account owner, and use the filters for broken promises, promises due today and late clients with no promise. The page on [how Krokul handles payments and receivables](https://krokul.com/en/solutions/payments/) shows this screen next to bank statement matching, partial payments and payment promises.

## Frequently asked questions

### How many aging buckets should I use?

Use four buckets for payment terms up to 30 days, and add 31–60, 61–90 and over 90 day buckets for terms of 45 days or more. More buckets add detail only when each one has its own action.

### Should aging count from the invoice date or the due date?

Count from the due date. Aging from the invoice date mixes payment terms with lateness, so a client on 60-day terms looks overdue after 30 days.

### How often should I refresh the aging report?

Refresh it once a week at a fixed time, and glance at the new overdue invoices each morning in between. A weekly rhythm makes bucket totals comparable from one week to the next.

### Where does a partly paid invoice go?

Put the unpaid remainder in the bucket for the invoice’s due date. The paid part is already collected and does not count in any bucket.

### When should I write off an invoice in the last bucket?

Decide on a write-off with your accountant, after the contract signer has been contacted and a payment plan has failed. A write-off follows the accounting rules and tax law of your country, so confirm them before the decision.

---

App: https://app.krokul.com/ · API: https://app.krokul.com/api/v1/docs
