What NetSuite's documentation says
- NetSuite's A/P Aging Summary (Reports > Vendors/Payables > A/P Aging) shows what is owed to vendors by period, and A/P Aging Detail lists individual bills per vendor with days past due and open balances. Source 1 (opens in a new tab)
- The Aging Reports Use accounting preference sets the basis: Due Date ages bills by their due date, Transaction Date by the date of the bill. Source 2 (opens in a new tab)
Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.
What the aging report shows
The A/P Aging Summary (Reports > Vendors/Payables > A/P Aging) shows what is owed to vendors by period. The A/P Aging Detail lists individual bills per vendor with days past due and open balances. Use the summary for the shape of the payable and the detail for the bills you need to touch. If a total looks wrong, go to the detail before you call the vendor.
The Aging Reports Use accounting preference sets the basis. Due Date ages bills by their due date. Transaction Date ages bills by the date of the bill. Both are useful, but they answer different questions. Due Date tells you what is late now. Transaction Date tells you how old the bill is. Pick the basis your team reviews against vendor statements and note it on the review.
The export carries the supplier invoice number as Reference No. That matters more than it sounds. Vendor statements use the supplier's invoice number, not your internal bill number. When you export the A/P Aging Detail and the Reference No. column is there, you can match line by line. Without it, AP clerks end up matching by vendor name and amount, which is where re-keyed numbers slip through.
Reading credits and debit balances
An aging report is a list of open balances, not a list of correct balances. A credit that was entered but never applied can sit on the vendor record while the bill it should offset stays open. The total may look fine at the vendor level and still be wrong at the bill level. Read the detail, not just the summary, when a vendor has both bills and credits open.
A debit balance needs a plain explanation. It can mean you paid more than the open bills support, or that a credit was posted without being matched. It can also come from the same supplier set up twice: one vendor record holds the bills, another holds the payment or credit. In NetSuite, check the vendor record and the open items before you treat the balance as real money owed. If the records do not explain it, ask the supplier for a statement and work from that.
Take a vendor with a bill carrying Reference No. INV-1043 and a credit sitting open. If the credit was meant for that bill, apply it or ask why it wasn't applied. If the credit belongs to another bill, match it there. Don't let an open credit age while you keep paying new bills. That is how a clean vendor balance hides a recovery item.
Using aging to spot overpayments
Most duplicate payments start as small keying differences. A bill comes in as INV-1043 and gets entered again as 1043. The vendor is the same, the bill lines look the same, and the only visible difference is the reference format. If both bills sit open, the A/P Aging Detail will show two open items for the same vendor. Hold the second one and check payment history before it goes into a run.
Other overpayments come from the same supplier set up twice, from paying a statement as well as the invoices on it, from a payment run that was sent twice, and from credits that were never applied. None of these look dramatic in the aging summary. They show up as balances that don't reconcile to the vendor statement, or as a vendor with more open bills than the buying history supports.
Use a simple match on vendor, amount and a date window. Export the A/P Aging Detail with Reference No. and compare it to the latest vendor statement. For each vendor, look for the same invoice number in two formats, the same amount close together, and payments that don't map to a bill. Then check paid bills too, because the aging only shows what is still open. A duplicate that was paid on both bills will not sit in the aging detail waiting for you.
When you find a likely overpayment, ask the supplier for a credit or a refund and send the backup: bill numbers, payment references and the statement lines. Keep the ask specific. A supplier can act on 'please credit invoice INV-1043, we paid it twice' faster than on a general balance query. Log the credit or refund against the vendor record so the next aging run tells the truth.
A monthly routine
Run the A/P Aging Summary and the A/P Aging Detail at the same point in your close. Check the Aging Reports Use preference first. If it is set to Due Date, the buckets follow due dates. If it is set to Transaction Date, they follow bill dates. Don't switch mid-review. Pick the basis that matches your vendor statement review and stay with it.
Export the detail with Reference No. and sort by vendor. Work the vendors with the largest balances first, then the ones with credits, debit balances or old open items. Match each vendor to the latest statement. Mark the bills that agree, the bills that are missing from the statement, and the statement lines that are missing from your records. Those lists are your work queue.
Look for the usual patterns before you pay anything new. Same invoice number in two formats, same supplier on two vendor records, a statement paid as well as the bills, a payment run sent again, a credit left unapplied. If a bill was voided or reversed, check NetSuite's own help for how that transaction should appear, rather than guessing from the aging line.
Finish with a short cleanup list: apply open credits, ask suppliers for missing credits or refunds, merge or fix duplicate vendor records in your ERP, and note any bill that needs a second review before the next payment run. Then rerun the aging detail. The point is not a perfect report. It is a report you can explain line by line.
To review paid bills outside NetSuite, export them: Export paid bills from NetSuite. The supplier's invoice number is in the Reference No. column.
Questions
How do I run the AP aging report in NetSuite?
Go to Reports > Vendors/Payables > A/P Aging. Run the A/P Aging Summary for balances by period, or the A/P Aging Detail for individual bills with days past due and open balances. Check the Aging Reports Use preference first so you know whether bills age by due date or by transaction date.
What is the difference between A/P Aging Summary and A/P Aging Detail?
The summary shows what is owed to vendors by period. The detail lists individual bills per vendor with days past due and open balances. Use the summary for totals and the detail for bill level work.
Where is the supplier invoice number in the AP aging export?
The supplier invoice number appears in the export as Reference No. Use that column to match bills to vendor statements and to catch re-keyed numbers such as INV-1043 and 1043.
How do I spot duplicate payments in the AP aging?
Use the A/P Aging Detail and look for the same vendor with two open bills that carry the same invoice number in different formats, like INV-1043 and 1043. Check the same amount within a date window, and compare the open items to the vendor statement. Then check paid bills too, because a duplicate that was paid on both bills will not appear as open.
Updated Nov 11, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.