What an aging report is
Accounts receivable is the money customers owe you for work you have already invoiced. An aging report takes that total and breaks it down by how long each invoice has been outstanding. Instead of a single figure telling you that clients owe you €14,600, it tells you how much of that is recent and almost certainly fine, and how much has been sitting unpaid for months. That distinction is what makes it useful. A business with €14,600 outstanding, all of it less than two weeks old, is in a very different position from one with the same total where half is over 90 days late. The aging report is the quickest way to see which of those businesses you are running, and where to spend your time chasing.
The standard buckets
Most aging reports group unpaid invoices into columns. Current means not yet due, still within the payment terms you agreed. Then come invoices 1 to 30 days past due, 31 to 60 days, 61 to 90 days, and over 90 days. Some tools count from the invoice date instead of the due date, so check which one your report uses: an invoice sent on net 30 terms will look 25 days old by invoice date while still being current by due date. Each row is usually a client, with their total split across the columns, and a total row at the bottom. You can read it in two directions. Across a row, you see how one client pays. Down a column, you see how much of your money is stuck at each stage.
A worked example
Imagine a small studio with four clients owing a total of €14,600. Client A owes €4,800, all current. Client B owes €3,200, of which €1,600 is current and €1,600 is 1 to 30 days late. Client C owes €2,400, all 31 to 60 days late. Client D owes €4,200: €1,200 in the 61 to 90 column and €3,000 over 90 days. Reading down, €6,400 is current, €1,600 is slightly late, €2,400 is getting stale, and €4,200 is seriously overdue. Reading across, A and B are healthy, C needs a direct conversation this week, and D is a real problem. Almost 30 percent of what this studio is owed is more than 60 days late, and nearly all of it comes from one client. That is the kind of insight a single total hides.
What each bucket is telling you
Current invoices need nothing beyond keeping an eye on them. The 1 to 30 days column is usually admin: an invoice that got lost in an inbox or is waiting for approval. A polite reminder fixes most of these. The 31 to 60 days column is a warning. Something is in the way, whether a cash problem at the client, a dispute about the work, or simply that you are low on their list. Pick up the phone or send a direct message asking when payment is scheduled. From 61 to 90 days, the chance of getting paid starts to drop, and you should consider pausing further work until the account is settled. Over 90 days, you need a firm plan: a final notice, a payment plan, or steps toward collection. Our guide on following up on overdue invoices has wording for each stage.
Look at clients, not just totals
The totals tell you how much is at risk. The rows tell you who is causing it. Look for patterns across several months rather than a single report. A client who always lands in the 1 to 30 days column is a slow payer with a predictable habit, and you can plan around it or tighten their terms. A client who was always current and suddenly shows up in the 31 to 60 column may be having trouble, and an early, friendly conversation is worth more than a stern email later. Also watch concentration: if one client accounts for most of your overdue balance, as in the example above, your cash flow depends heavily on one company's accounts payable team. Adjusting payment terms or asking for deposits on new work can reduce that exposure.
Two numbers worth tracking
Two simple figures turn the aging report into a trend you can follow. The first is the share of receivables more than 60 days overdue. In the example it is €4,200 out of €14,600, roughly 29 percent. Track it monthly; for most small service businesses you want it low and stable. The second is days sales outstanding, which estimates how long it takes on average to get paid. A simple version is accounts receivable divided by revenue over a period, multiplied by the number of days in that period. If you are owed €14,600 and billed €21,900 over the last 90 days, that is 14,600 divided by 21,900 times 90, about 60 days. If your standard terms are 30 days, clients are taking roughly twice as long as agreed.
When to write off an invoice
Sometimes an invoice will not be paid: the client has gone out of business, disappeared, or the cost of collecting is more than the amount owed. At that point it is better to recognise the loss than to leave it in your receivables, where it makes your books look healthier than they are. How you record it depends on your accounting method. On accrual basis, you already counted the invoice as income, so writing it off reduces your profit. On cash basis, you never counted it, so there is usually nothing to reverse for income tax. Some VAT systems let you reclaim VAT you paid over on an invoice that was never settled, subject to conditions. Rules differ by country, so check with your tax office or accountant before writing off a large amount.
Make it a weekly five-minute habit
An aging report is only useful if you look at it. Once a week, open it and work from right to left: deal with the oldest balances first, then the 31 to 60 column, then send reminders for anything just past due. Once a month, as part of your month-end close, note the total owed and the share over 60 days so you can see the trend. The weekly look takes five minutes and stops small delays from becoming large ones. The monthly note tells you whether your terms, reminders and client mix are working. Most freelancers who say they have a cash flow problem actually have a receivables problem, and this habit is the most direct fix.
An aging report that builds itself
You should not have to build an aging report in a spreadsheet. In Kelvo Books, every invoice you send is tracked from the moment it goes out, and the accounts receivable aging report groups everything you are owed by client and by how late it is, updated live. Automatic payment reminders on Pro chase late invoices for you on a schedule you set, the public invoice page lets clients view and pay without hunting through email, and credit notes keep balances correct when something changes. The free plan includes 10 invoices a month, unlimited clients and expenses, and the P&L. Pro at €7 a month adds unlimited invoices, reminders and recurring billing. Start at books.kelvo.app and see exactly who owes you what.