How to Run and Export the A/R Aging Report in NetSuite

The A/R aging report is the one document every collections conversation starts from, and in NetSuite it is buried exactly three menu levels deep. If your team runs on NetSuite and your collections process runs on a spreadsheet, the bridge between the two is this report: who owes you, how much, and how late. This guide walks through running both versions of the report, reading every column, exporting it cleanly to Excel or CSV, and avoiding the three quirks that most often make an exported aging report disagree with your general ledger. It is part of a series; the QuickBooks version of this guide and the Xero version cover the same workflow in those systems.

To run the A/R aging report in NetSuite, go to Reports > Customer/Receivables > A/R Aging, then choose Summary or Detail. To export it, click the Excel, CSV, PDF, or Word icon in the report footer. You need the Export Lists permission to export, and the report loads with a progress bar you can cancel.

What Is the A/R Aging Report in NetSuite?

NetSuite’s A/R aging report lists every unpaid invoice and statement charge in accounts receivable, grouped by how long each amount has been outstanding. It is the standard input for prioritizing collections: the older the bucket, the lower the odds you ever collect, so the report tells you where the risk is concentrating before your cash flow feels it.

Summary or Detail: which one do you want?

NetSuite ships two versions. The A/R Aging Summary groups unpaid invoices and statement charges by customer and billing period, one line per customer, which is the version you hand a controller for a quick read on exposure. The A/R Aging Detail itemizes every open transaction under each customer or project, then sums by period, which is the version a collections workflow actually needs, because you chase invoices, not customers-in-aggregate. Per NetSuite’s own documentation, the Detail report shows transactions based on the date they are closed rather than the date they are applied, and that includes credit memos.

How Do You Run the A/R Aging Report in NetSuite?

The menu path

Go to Reports > Customer/Receivables > A/R Aging > Detail, or > Summary for the rolled-up version. A message appears while the report loads, with a status bar in the footer showing progress. On large ledgers this can take a while; you can click Cancel Report next to the status bar if you picked the wrong one.

Reading the columns on the Detail report

The Detail report gives you, per line: Customer (the legal name of the customer or project holding the open balance; entries grouped under No Customer/Project are journal entries), Transaction Type (invoice, customer credit, payment, and so on), Date (when the transaction was entered), No. (the transaction number), P.O. No. (the purchase order reference, which your customer’s AP team will ask for), Due Date, Age (days past due), and Amount Due, itemized per transaction and summed per customer.

The columns your collections process will actually use

For working the report, three columns matter most: Age tells you which conversation to have, Amount Due tells you which conversation to have first, and P.O. No. is the detail that gets your invoice located inside the customer’s AP system in one email instead of three. If your export will feed any downstream tool, add the Internal ID as a results column before exporting; NetSuite keeps the relational link to the underlying record that way, so the row can be traced back programmatically.

How Do You Export the Report to Excel, CSV, or PDF?

The export icons live in the footer

Open the report, then look at the report footer: NetSuite shows an icon for each available format, Microsoft Excel, PDF, CSV, and Microsoft Word. Click the one you need and the file downloads. If your administrator has enabled Tableau Workbook Export and granted you that permission, a Tableau icon appears too.

The permission that trips people up

Exporting requires the Export Lists permission on your role. If the icons are missing or the export fails, that permission, not the report, is almost always the reason, and it is a one-minute fix for your administrator under export permissions in NetSuite’s documentation.

Which format should you pick?

Whichever you choose, remember the export is a snapshot: the moment a payment posts, your file is stale, which is an argument for exporting on a schedule rather than on memory.

Scheduling the report instead of remembering it

NetSuite can email and schedule reports, so the aging report can arrive in your inbox, or your collections tool’s inbox, every morning without anyone running it. If your collections process consumes a daily file, scheduling plus CSV is the combination that removes the human bottleneck.

Why Might the Report Disagree With Your Ledger?

Three documented quirks cause most of the confusion.

Journal entries that cancel out

Debit and credit journal entries against identical accounts for the same entity value do not impact the general ledger, and NetSuite therefore leaves them out of the A/R Aging Detail report. If someone has been fixing balances with paired journal entries, the aging report and a transaction search will not tell the same story.

Consolidated customer hierarchies

With the Consolidated Payments feature enabled, the report shows the un-consolidated balance for each subcustomer, totaled up the customer-subcustomer hierarchy. Read the hierarchy totals, not just the leaf rows, or a parent’s true exposure will be scattered across ten lines.

Credit memos in the detail

Because the Detail report includes credit memos and shows transactions on their closed date, an open credit sitting on the account reduces what the customer owes but appears as its own line. Netting these correctly matters when you load the export into any tool that emails customers about balances; chasing an amount the customer’s credits already cover is the fastest way to lose credibility.

How Do You Customize the Aging Report Before Exporting?

The stock report is close to right for most teams, but two customizations pay for themselves immediately.

Add the columns your process needs

Use Customize on the report to add columns before you export, rather than re-assembling context in the spreadsheet afterward. The three additions worth making almost everywhere: Internal ID, so downstream systems can trace each row back to the NetSuite record; the customer’s email and phone from the entity record, so the person working the list is never alt-tabbing to find contact details; and Currency, the moment you have subsidiaries or customers billing outside your base currency, because a mixed-currency Amount Due column sorted naively will mis-rank your priorities.

Set the aging buckets to match your terms

NetSuite’s default aging periods assume standard 30-day rhythm. If your book runs on net 60, a 1-to-30 bucket is noise: nothing in it is even late in a way your customer recognizes. Align the interval and the number of periods to your dominant terms, so the first bucket means “just past due” and the last one means “genuinely at risk”. The report options also let you choose whether aging runs from due date or transaction date; for collections use due date, since age-from-invoice-date quietly overstates lateness for any customer on longer terms, and that mismatch is how a polite reminder turns into an awkward apology.

What Should Happen After the Export?

An aging report nobody acts on is a spreadsheet, not a process. The export earns its keep when it drives the next touch on every overdue account.

From snapshot to worklist

Sort the export by Age within Amount Due, set a floor so your team is not spending an hour recovering a $12 balance, and decide the touch for each band: a reminder at 1 to 30, a call at 31 to 60, an escalation conversation past 60. Track the result in your A/R KPIs, and watch DSO respond over ninety days rather than a week.

Or feed it to an agent that works the list

This daily CSV is exactly what Abivo ingests. Kate, Abivo’s AI agent, takes the exported aging report, works every overdue account by email, text, and phone, and escalates to your team only when a customer disputes, negotiates, or needs judgment. Your NetSuite stays the system of record; the follow-up simply stops depending on anyone’s afternoon. Get started at https://abivocollections.com/sign-up/get-started

Curious what this sounds like in practice? Here’s a 98-second sample call: https://abivocollections.com/#live-demo

Practical Takeaways

Run Detail for collections and Summary for management. The path is Reports > Customer/Receivables > A/R Aging. Export from the footer icons, CSV for systems, Excel for humans, PDF for snapshots, and add Internal ID before exporting if anything downstream needs to trace rows. Missing export icons means the Export Lists permission is missing. Trust the hierarchy totals under Consolidated Payments, remember paired journal entries never appear, and net open credit memos before anyone emails a customer about a balance. Then schedule the report daily so the process stops depending on memory.

FAQ

Where is the A/R aging report in NetSuite?

Reports > Customer/Receivables > A/R Aging, then Summary or Detail. The report loads with a progress bar and can be canceled mid-load.

How do I export a NetSuite report to Excel or CSV?

Open the report and click the Excel or CSV icon in the report footer. Your role needs the Export Lists permission; without it the export options are unavailable.

What is the difference between A/R Aging Summary and Detail in NetSuite?

Summary shows one rolled-up line per customer by billing period. Detail itemizes every open invoice, credit memo, and statement charge under each customer or project, including transaction number, P.O. number, due date, and days past due.

Why do totals on the aging report differ from a transaction search?

The most common causes: paired debit and credit journal entries on the same account and entity are excluded from the report, subcustomer balances display un-consolidated under Consolidated Payments, and credit memos appear as their own lines on their closed date.

Can NetSuite send the A/R aging report automatically?

Yes. NetSuite reports can be emailed on a schedule, so the aging report can arrive daily or weekly without anyone running it. Pair a scheduled send with the CSV format and the report becomes a reliable feed for whatever works the list next, a person or a platform.