It's Thursday afternoon. Payroll runs tomorrow, five guys are counting on the deposit, and you honestly aren't sure the account can cover it. You think it can. You're pretty sure. But a handful of invoices are still open and you can't remember which ones, how big they are, or how long they've been sitting.
So you do what everybody does. You log into the bank, stare at the balance, and try to run the math in your head while a customer texts you about a Saturday start. The trouble is the balance only tells you what's there right now. It says nothing about what's stuck in somebody else's "I'll get to it" pile.
The fix isn't chasing harder or working the phones every night. It's seeing the whole picture on a schedule, before the squeeze lands. One short list every week: every unpaid invoice, how old each one is, and who to call first. That's an aging summary, and you can have it hit your inbox every Monday morning without you touching a thing.
What an aging report actually is
An aging report groups your open invoices by how long they've gone unpaid. Instead of one pile of "people owe me money," you get buckets: not due yet, 1 to 30 days late, 31 to 60, 61 to 90, and the ugly 90-plus column where money goes to die.
Each line shows the customer, the invoice number, the amount, and the age. Add it up and you know two things in about ten seconds: how much you're owed total, and how much of it is actually late. Those are very different numbers, and the gap between them is usually where the Thursday panic lives.
Most invoicing tools (QuickBooks, Jobber, Housecall Pro, Wave, whatever you run) already build this report. The catch is you have to remember to go pull it, and nobody does that on a good week, let alone during the spring rush. Automating it just means the report comes to you on a set day, every week, whether you remember or not.
Why the bank balance lies to you
Your balance mixes everything together. Money you've earned and collected, money you still owe out for materials, and a deposit from a job you haven't started all sit in the same number. It looks like cash. Some of it is already spoken for.
An aging summary pulls the receivables side out on its own. Say you're owed twelve grand across five invoices. If four of those are under 30 days, you'll likely see that cash soon and payroll's fine. If four of them are past 60 days, that's not money you can count on Friday, and you needed to know that on Monday, not at the ATM.
Seeing it early buys you moves. You can make two calls Monday instead of five panic calls Thursday. You can hold off ordering a special-order part. Worst case, you line up a short draw on a credit line calm and on your terms instead of scrambling. Early is cheap. Late costs you.
Set it up once, then leave it alone
- Open the report your software already has. Look for "A/R aging," "aging summary," or "open invoices" in the reports menu. If you bill on paper or in a spreadsheet, that works too, you'll just build a simple sheet with columns for customer, amount, and date billed.
- Pick the day and time it should land. Monday at 6 AM is a solid default. You read it with your coffee before the trucks roll, and you've got the whole week to act before Friday.
- Turn on the scheduled send. Most tools have an "email this report on a schedule" or "subscribe" button right on the report. Set it to weekly, point it at your inbox, done. No tech wizardry required.
- If your tool can't schedule it, bridge the gap. A simple automation (something like Zapier or Make, or a short setup we can wire up for you) can pull the open invoices every Monday and text or email you the list with the oldest ones on top.
- Flag anything over 45 days. You want the list to shout at you, not just sit there. Oldest and biggest at the top, a bold mark on anything that crossed the 45-day line since last week.
That's the whole build. Fifteen minutes if your software does the work, maybe an hour if we're bridging two tools. After that it runs on its own and you stop thinking about it until the email shows up.
Who to call first
A list of ten open invoices isn't much use if you don't know where to start. Rank it so the report tells you, instead of making you decide at 6 AM.
- Biggest and oldest first. A $6,000 invoice at 70 days is your Monday morning, not the $300 one from last week.
- Repeat customers get a softer touch. The property manager who feeds you eight jobs a year gets a friendly nudge. The one-time job that ghosted you gets firmer.
- Anything past 60 days gets a real phone call, not another emailed copy of the invoice. By 60 days the email clearly isn't working. A human voice does.
- Watch the pattern, not just the number. A customer who always pays on day 45 isn't a problem, that's just how they pay. A good customer suddenly sliding to 60 is a signal, call before it becomes a habit.
Where this stops helping
Be straight about what the report does and doesn't do. It shows you the money. It doesn't collect it. You or somebody on your crew still has to make the call, send the text, and have the slightly awkward conversation. No software gets that off your plate.
Garbage in, garbage out, too. If invoices go out late or not at all, the report just hands you a tidy picture of a mess. The aging summary is worth exactly as much as your billing habits are. If you're not invoicing the day the job closes, fix that first, the report second.
And it won't tell you why someone hasn't paid. Maybe they're short, maybe the invoice went to spam, maybe they're sitting on a complaint you never heard about. The list flags who to call. The call is where you find out what's really going on.
Worth doing this week
- Pull your aging report by hand once, today. Just look at it. The total-late number is usually a wake-up call on its own.
- Turn on a weekly scheduled send for Monday at 6 AM. If your tool supports it, this is a five-minute job.
- Sort it so the oldest and biggest sit at the top, and flag anything past 45 days.
- Make your first two calls this week on whatever's oldest. Don't wait for the system to be perfect.
- If your software won't schedule it, give us a shout at Mass AI Agency and we'll wire the weekly list up for you.
Do that and Thursday afternoon stops being a guessing game. You'll see the cash squeeze coming from Monday, with time to do something about it, instead of finding out at the bank with payroll due in the morning.