Construction AR Aging Reports: 30/60/90/120 Day Guide | Projul

If you have ever finished a job, sent the invoice, and then waited… and waited… you already know the pain of slow-paying customers. In construction, that pain hits harder than most industries because your overhead does not stop just because a client drags their feet. Materials suppliers want their money. Your crew expects paychecks on Friday. And your next project needs funding whether the last one has paid out or not.

That is where accounts receivable aging reports come in. They are not glamorous. Nobody got into contracting because they love spreadsheets. But an aging report is one of the most useful tools you can have in your back office, and ignoring it is one of the fastest ways to run a profitable company straight into a cash crisis.

This guide breaks down everything contractors need to know about AR aging reports: what the aging buckets mean, how to use the data to collect faster, and how to connect your aging numbers to the bigger picture of cash flow health.

What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a simple document that lists every unpaid invoice your company is owed, grouped by how long each invoice has been outstanding. Think of it as a snapshot of who owes you money and how late they are.

Most aging reports organize invoices into time-based columns called “buckets”:

• Current (0 to 30 days): Invoices that are still within normal payment terms. Nothing to worry about yet.
• 31 to 60 days: Starting to get stale. These need attention before they become a real problem.
• 61 to 90 days: Red flag territory. The longer an invoice sits here, the harder it gets to collect.
• 91 to 120 days: Serious concern. You are now looking at potential bad debt.
• 120+ days: Critical. Collection rates drop dramatically past this point.

A typical report will show you the customer name, invoice number, invoice date, amount due, and which aging bucket it falls into. Most will also show a total for each bucket so you can see at a glance how much of your receivables are current versus overdue.

Here is why this matters for construction specifically: your invoices tend to be large. A single unpaid invoice for $47,000 sitting at 90 days is not the same as a $200 phone bill going late. When construction invoices age, the dollar impact on your business is massive.

Understanding the 30/60/90/120 Day Aging Buckets

Each aging bucket tells you something different about the state of that receivable, and each one calls for a different response.

Current (0 to 30 Days)

This is healthy territory. The invoice has been sent and is within the payment window you agreed on. If you set net-30 payment terms, these invoices are not late yet. Your job here is simply to make sure the invoice was received and there are no disputes brewing. A quick confirmation email or call a few days after sending can prevent surprises later.

31 to 60 Days

Now you are past due. For most contractors, this is where the first follow-up call should happen if it has not already. The tone is still friendly and professional. Maybe the invoice got lost in someone’s inbox. Maybe the GC is waiting on the owner to release funds. Whatever the reason, you need to find out now, not later.

At this stage, about 90% of invoices are still collectible if you take action. The key word there is “if.” Contractors who shrug off 45-day-old invoices and say “they will pay eventually” are the same ones scrambling to make payroll two months later.

61 to 90 Days

This bucket is where things get serious. Industry data shows that the probability of collecting an invoice drops significantly once it passes 60 days. At this point you should:

• Send a formal past-due notice in writing
• Call the customer directly (not just email)
• Document every communication
• Consider withholding additional work until the balance is resolved

If you are dealing with a general contractor who has not paid a subcontractor invoice at 90 days, it is also time to review your lien rights and make sure you have not missed any filing deadlines.

91 to 120+ Days

Once an invoice crosses 90 days, you are staring at potential bad debt. Collection agencies typically recover only a fraction of the original amount at this stage, and the cost of legal action may or may not be worth it depending on the invoice size.

At 120+ days, many accounting standards suggest you should start considering a write-off or at least set up an allowance for doubtful accounts. That does not mean you stop trying to collect. It means you stop counting that money as a reliable asset on your balance sheet.

The lesson across all these buckets is simple: time kills collectibility. Every week that passes without action reduces your chances of getting paid in full.

How to Use Aging Reports to Prioritize Collections

Having an aging report is one thing. Actually using it to drive your collection efforts is another. Here is a practical approach that works for construction companies of all sizes.

Sort by Dollar Amount Within Each Bucket

Not all overdue invoices deserve the same level of effort. A $2,500 invoice at 45 days is less urgent than a $85,000 invoice at 35 days, even though the smaller one is technically more overdue. Sort each bucket by dollar amount and focus your energy on the biggest balances first.

Work the 31 to 60 Day Bucket Hardest

This is your sweet spot for collections. Invoices in this range are overdue enough to justify a direct phone call but not so old that the customer has mentally written them off. Your recovery rate here is still high, and a little persistence goes a long way.

Create a Weekly Collection Routine

Pick a day each week (Monday morning works well for most contractors) and review the full aging report. Make your calls, send your follow-up emails, and update notes on each account. Consistency matters more than intensity. Five follow-ups spread over five weeks will outperform one angry phone call at 90 days.

Flag Repeat Offenders

If the same customer keeps showing up in your 60+ day buckets, that is a pattern, not a coincidence. Consider adjusting their payment terms, requiring deposits on future work, or raising the conversation with their project manager. Your accounts receivable process should include a policy for dealing with chronically late payers.

Connect Collections to Project Decisions

Your aging report should feed into your project planning. If a developer owes you $120,000 at 75 days and wants you to start another $200,000 job, that is critical information. Do not silo your accounting data away from your operations team. Everyone who makes decisions about which work to take on should have visibility into outstanding receivables.

Automating AR Tracking to Save Time and Catch Problems Early

Manual AR tracking with spreadsheets works when you have five invoices outstanding. It breaks down fast when you are running 15 projects with progress billing, retention holdbacks, and multiple pay applications per job.

Why Spreadsheets Fall Short

The biggest problem with spreadsheet-based aging reports is that they are only as current as the last time someone updated them. If your bookkeeper updates the AR spreadsheet on Friday afternoon, by Wednesday you are looking at stale data. Invoices that came in over the weekend are not reflected. Payments that cleared on Monday are still showing as outstanding.

In construction, where a single day can make the difference between filing a lien on time or missing the deadline, stale data is dangerous.

What Automated AR Tracking Looks Like

Modern construction management software connects your invoicing, payment tracking, and reporting into one system. When you send an invoice through the platform, it automatically starts the aging clock. When a payment comes in, the system updates the balance and aging in real time.

This means your aging report is always current. You do not have to ask someone to “run the numbers” before your Monday morning meeting. You pull up the report and the data is live.

Automated systems can also send payment reminders on a schedule you set. Maybe you want a friendly reminder at 7 days before due date, another at the due date, and a past-due notice at day 35. Set it once and the system handles it without anyone having to remember.

Connecting AR to Your Bigger Financial Picture

The real power of automated tracking shows up when your AR data connects to other parts of your business. When your aging report talks to your cash flow forecast, you can see exactly how overdue invoices are going to impact your ability to fund upcoming projects. When it connects to your job costing, you can see profitability by customer, factoring in how long they take to pay.

Contractors across the country trust Projul to run their businesses. Read their reviews.

A customer who pays $100,000 at 120 days is less profitable than one who pays $90,000 at 15 days, once you factor in the carrying cost and the cash flow disruption. Your AR aging data makes that visible.

Reducing DSO: Practical Steps for Construction Companies

DSO, or Days Sales Outstanding, is the average number of days it takes your company to collect payment after sending an invoice. It is arguably the single most important metric tied to your aging report.

Here is how to calculate it:

DSO = (Total Accounts Receivable / Total Credit Sales) x Number of Days

For example, if you have $450,000 in receivables and did $1,800,000 in credit sales over the last 90 days:

DSO = ($450,000 / $1,800,000) x 90 = 22.5 days

A DSO of 22.5 days is excellent for construction. The industry average tends to hover between 60 and 90 days, depending on the trade and project type. Commercial work typically has longer DSO than residential because of the layers of payment applications and approval processes involved.

How to Lower Your DSO

Invoice immediately. Every day between finishing work and sending the invoice is a day added to your DSO. If your crew finishes on Friday, the invoice should go out Friday, not the following Wednesday.

Make it easy to pay. Accept credit cards, ACH transfers, and online payments. The fewer obstacles between your customer and their bank, the faster money moves. Yes, credit card processing fees eat into margin. But getting paid in 5 days instead of 45 days is often worth the 2-3% fee.

Bill more frequently. Instead of one big invoice at project completion, use progress billing tied to milestones. Smaller, more frequent invoices are easier for customers to approve and pay. They also reduce your exposure if something goes sideways on the project. Check out how progress payment applications can help you stay ahead.

Tighten your payment terms. If you are currently at net-60, consider moving to net-30 with a 2% early payment discount. Many customers will take the discount, and those who do not are at least anchored to a shorter timeline.

Pre-qualify your customers. Before you sign a contract, do some basic homework. Check references. Look at their payment history with other subs. Pull a credit report on larger jobs. The best time to avoid a 120-day receivable is before you start the work.

Follow up before invoices are due. A quick “just confirming you received invoice #4523” call at day 15 catches problems early. Maybe there is a line item dispute. Maybe the invoice went to the wrong person. Better to find out at day 15 than day 45.

Connecting AR Aging to Cash Flow Health

Your aging report is not just a collections tool. It is a window into the financial health of your entire operation.

The Cash Flow Connection

Every dollar sitting in your aging report is a dollar you cannot spend. It cannot buy materials for the next job. It cannot cover the insurance premium due next week. It cannot fund the new truck your crew needs. When your aging report shows heavy balances in the 60+ day columns, your cash flow is under pressure whether your profit and loss statement looks good or not.

This is the trap that kills construction companies. You can be profitable on paper and still run out of cash. The P&L says you made $200,000 last quarter. But if $180,000 of that is sitting in accounts receivable at 75 days, your bank account tells a very different story.

Using Aging Data for Cash Flow Forecasting

A smart forecasting process starts with your aging report. Look at each bucket and assign a realistic collection probability:

• Current: 95 to 98% likely to collect
• 31 to 60 days: 85 to 90% likely
• 61 to 90 days: 70 to 80% likely
• 91 to 120 days: 50 to 60% likely
• 120+ days: 25 to 40% likely

Multiply each bucket total by its probability and that gives you a more realistic picture of incoming cash than just looking at the raw receivables number. Use those adjusted numbers in your cash flow forecast and you will make better decisions about when to take on new work, when to tap your credit line, and when to hold off on equipment purchases.

Warning Signs in Your Aging Report

Watch for these patterns that signal trouble:

Growing 60+ day balances month over month. If the tail end of your aging report keeps getting fatter, your collection process has a leak somewhere.

One customer dominating your receivables. If 40% of your outstanding AR is from a single client, you have concentration risk. If that client goes sideways, so does your cash flow.

Retention balances that never get billed. Retention holdbacks are normal in construction, but they should eventually convert to invoices and then to cash. If you have retention sitting unbilled for months after project completion, you are leaving money on the table.

DSO trending upward. Track your DSO monthly. A steady climb over three to six months means something systemic is changing, maybe your customer mix is shifting, maybe your billing process has slowed down, or maybe the market is tightening and customers are stretching payments.

Building a Healthier AR Position

The contractors who maintain healthy cash flow are not just good at building things. They are good at the boring stuff: invoicing on time, following up consistently, tracking their numbers weekly, and making collection calls before things get awkward.

Start with your aging report. Review it every week. Act on what it tells you. Connect it to your cash flow forecast so you can see around corners. And build a collection process that your team follows without fail, not just when cash gets tight.

Your AR aging report will not make collections fun. But it will make them manageable, predictable, and far less stressful than getting blindsided by a cash crunch you did not see coming.

Ready to see how Projul can work for your crew? Schedule a free demo and we will walk you through it.

The work you do deserves to get paid for. An aging report is how you make sure it does.