An accounts receivable aging report is one of the most-used reports in any NetSuite instance, and the accounts receivable (AR) data in it is only useful when the billing behind it is accurate and current. If invoices go out late, terms vary by customer or payments get recorded days after they arrive, your AR aging report tells a story that’s already out of date.
This guide covers what the report shows, how to run it in NetSuite, how to act on each aging bucket and how billing automation keeps the data reliable.
Key highlights
- An accounts receivable aging report groups unpaid invoices by how long they’ve been outstanding, which gives finance teams a clear view of collection risk, cash flow exposure and customer payment behavior.
- Running an AR aging report in NetSuite takes the right report settings and saved searches, and knowing where native reporting falls short tells you when to automate.
- Reading the report is half the job, because each aging bucket calls for a different action, from adjusting payment terms on current accounts to escalating collections on invoices past 60 days.
- ZoneBilling generates invoices on schedule with consistent terms inside NetSuite and ZonePayments collects payments automatically, so the aging report finance pulls downstream starts with accurate, current data.
What is an accounts receivable aging report?
An accounts receivable aging report is a breakdown of unpaid customer invoices grouped by how long they’ve been outstanding. The AR aging report shows how much money is tied up in overdue invoices, which customers are late and how long, on average, your customers take to pay.
Most reports group invoices into 30-day buckets.
- 0-30 days: Current invoices that aren’t overdue.
- 31-60 days: Slightly overdue invoices.
- 61-90 days: Moderately overdue invoices.
- 90+ days: Significantly overdue invoices that often need immediate action.
Let’s say a customer has three open invoices, one for $4,000 that’s 10 days old, one for $6,000 that’s 45 days old and one for $2,000 that’s 95 days old. The report puts $4,000 in the 0-30 bucket, $6,000 in the 31-60 bucket and $2,000 in the 90+ bucket, shows the $12,000 total and tells you at a glance that the oldest $2,000 needs a call.
Once you can see those buckets, you can decide where your collections effort goes first. The report also gives your finance team what it needs to adjust your collections process, such as when to send a reminder and when to pick up the phone.
Aging can be measured from the due date or the transaction date, and NetSuite lets you choose. An administrator sets this under Setup > Accounting > Preferences > Accounting Preferences, on the General subtab, in the Aging Reports Use field, so check the setting before you compare your report with anyone else’s numbers. The standard report shows what each customer owes for the current period, followed by overdue buckets for 1-30, 31-60, 61-90 and over 90 days.
What does an AR aging report look like?
An AR aging report lists each customer in a row, splits their unpaid balance across the aging buckets in columns and totals everything at the end. The example below shows invoice payment status for several fictitious companies. If you’re building an AR aging report template in a spreadsheet, start with these same elements and add due dates and payment terms for context.
What your AR aging report tells you about collections and cash flow
Your AR aging report tells you which customers are a collection risk, how your cash flow is trending, how to group customers for collections and where your credit policy needs to change.
- Spot high-risk accounts early. Customers who keep landing in the 61-90 and 90+ buckets are your credit risks. Treat any customer with a balance past 60 days two months in a row as high risk, then decide whether to tighten payment terms, lower the credit limit or move the account to active collections before the balance turns into bad debt.
- Read payment trends to forecast cash flow. A growing share of invoices in the 31-60 and 61-90 buckets means cash you expected this month is slipping into next month. Compare this month’s AR aging analysis with the last three months, and adjust your cash reserves or your collections plan when the older buckets keep growing. Track days sales outstanding (DSO) next to the buckets, because a rising DSO and an increasing 61-90 bucket usually point to the same problem.
- Segment customers for tailored collections. Not every late payer needs the same follow-up. Pull your accounts receivable report by customer and sort customers by payment history. Chronic late payers get a reminder before the due date and a call at day 31, while customers who occasionally slip may only need a check-in once an invoice crosses the due date.
- Adjust credit policy based on what the data shows. Review overdue accounts every month and negotiate new terms for customers who are frequently late, such as shorter terms, a deposit or a lower credit limit. For reliable payers, better terms can strengthen the relationship and cost you very little.
Whichever actions you adopt, write the trigger down. A rule such as “any balance past 60 days goes to the controller” removes the guesswork and keeps follow-up consistent across your AR team.
How to run an AR aging report in NetSuite
A NetSuite aging report takes four steps to run from the standard AR aging report, and a saved search covers what the standard report doesn’t.
Using native NetSuite saved searches and reports
You can run the standard NetSuite AR aging report in four steps.
- Go to Reports > Customer/Receivables > A/R Aging.
- Enter a new value in the Interval field in the report footer if you want different buckets. Use the double-arrow to change the Duration, then click Refresh.
- Go to Reports > Customer/Receivables > A/R Aging > Detail to see the invoices behind a customer's balance.
- Customize the Detail report to add the columns your team needs.
These steps give you the standard NetSuite AR view. Run it weekly for collections and at month end for close, and keep a copy of each month-end version so you can compare balances across periods. If you want results emailed on a schedule, build a saved search instead, because scheduled email is a saved search feature.
Customizing aging buckets and filters
Most teams keep the standard 30-day buckets, but NetSuite lets you change them.
- Change the interval: Enter a new value in the Interval field in the report footer, change the Duration if needed and click Refresh. Subscription businesses with high invoice volume often prefer narrower buckets, such as 0-15 and 16-30, so late payers show up sooner.
- Customize the detail view: The A/R Aging Detail report can be customized, so add the fields your team needs to compare how different parts of the business pay.
- Build a saved search: If you need buckets the standard report doesn’t offer, such as 91-120 and 120+, go to Reports > Saved Searches > All Saved Searches > New and choose Transaction. Add formula columns on the Results subtab that sort each open invoice into a bucket by days past due. Use internal field IDs in your formulas, as Oracle recommends, so results don’t change with a user’s language setting.
Where native NetSuite AR aging reports fall short
The standard report works for a monthly review, but it has four limits:
- Manual refresh: The report reflects your data when you run it, so it’s only as current as your last run.
- No trend analysis: Each run is a snapshot, so comparing aging month over month means exporting the data and rebuilding it in a spreadsheet.
- No automated follow-up: Nothing triggers a reminder when an invoice crosses 31 days.
- Limited visualization: You can add the Receivables key performance indicator (KPI) to a NetSuite dashboard for a quick total, but that’s a snapshot, not an accounts receivable dashboard that shows trends by customer or bucket.
How to read and act on each aging bucket
An accounts receivable aging report helps most when each bucket has a clear owner and a next step, and the table below gives you both.
What each aging bucket signals
Use this table as a starting point and adjust the actions to your own payment terms and customer mix.
Five actions to take when receivables age past 60 days
If a customer doesn’t pay their invoice past 60 days, consider the following steps:
- Send an escalation email from the controller. A note from the controller, rather than the AR clerk, tells the customer the balance has senior attention at your company.
- Call the customer’s AP team to confirm they received the invoice. Many balances in the 61-90 bucket turn out to be invoices that were never routed for approval on the customer’s side.
- Offer a structured payment plan for large balances. A plan with fixed dates and amounts gets you cash on a schedule and keeps the relationship intact.
- Place a credit hold on new orders in NetSuite. A hold stops the balance from growing while you resolve the open invoices.
- Set a write-off review threshold. For example, send every balance over 120 days to a monthly review with finance leadership, so old balances get a decision instead of sitting in the report.
AR aging data feeds your cash flow forecast directly. When receivables age, expected cash inflows drop, so a growing 61-90 bucket is an early signal that next month’s cash will land short. Track DSO next to the buckets to see the same trend in a single number.
How billing automation improves AR aging report accuracy
Billing automation improves an AR aging report by making sure the invoices feeding it go out on time, on the right terms and with payments recorded as they arrive. Three changes make the biggest difference to the data.
Invoices go out on schedule
Automated invoicing starts the aging clock when it should. With manual invoicing, invoices go out late and terms vary by customer, so your AR aging report shows invoices as overdue when the real problem is that they were sent late to begin with. Automation sends invoices on a set schedule with consistent terms, so the buckets compare cleanly across customers and an overdue invoice means the customer is late, not your team.
To see how much of your aging comes from billing delays, sort your 31-60 bucket by invoice date. Invoices that went out days after the service was delivered point to a delay on your side.
Payments post as they clear
Automated payment recording and cash application keeps paid invoices out of the aging buckets. When payments are entered by hand, a payment can sit unapplied for days while the invoice keeps aging in the report. Your team then chases a customer who already paid, which costs time and goodwill. When payments are recorded as they clear, the report only lists invoices that are really open.
Alerts and dashboards flag aging early
Automated alerts and dashboards show aging problems before the monthly review does. An alert can flag an invoice when it reaches a threshold, such as 31 days past due, so follow-up starts on time without anyone watching the report. Dashboards that update as invoices and payments change add the trend view the standard report lacks, such as which customers or buckets are growing over time.
How Zone automates accounts receivable aging for NetSuite teams
An AR aging report is only as useful as the invoice data behind it and the way your team sees it.
Zone’s AI-powered billing and reporting solutions run inside NetSuite, so invoices go out on schedule and aging data reaches your team in the dashboards and spreadsheets they already use.
- Generate invoices on schedule: ZoneBilling handles subscription, usage-based and one-time invoicing inside NetSuite, so the aging clock starts the day an invoice should go out instead of the day someone remembers to send it.
- Collect payments as customers pay: ZonePayments connects Stripe to NetSuite for automated AR collection, recording payments as they clear so paid invoices leave the aging buckets.
- Track aging trends in Power BI: ZoneReporting pulls NetSuite AR data into Power BI dashboards and automated aging reports, so you can see which customers and buckets are growing instead of rereading a static saved search.
- Work the aging data in Excel: Solution 7 brings NetSuite receivables data into Excel, so your team can slice aging by customer or segment in the spreadsheet they already use.
