Use NetSuite A/R Aging Detail for collections
Key facts
Use Detail for invoice-level work and Summary for account-level prioritization.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Run the detailed report
Go to Reports › Customer/Receivables › A/R Aging › Detail. Oracle describes the report as unpaid invoices and statement charges grouped by customer and aging period. Set the cutoff for the purpose: today’s work list and last month’s finance reconciliation need different reporting dates. Set the report’s As of date. The report uses the transaction’s close date rather than its application date to determine which transactions appear. Reconcile historical credits and payments against their source transactions before comparing totals.
Separate genuine arrears from exceptions
For each invoice you intend to chase, retain the customer, invoice number, due date, open balance and currency. Check for unapplied cash, an unresolved dispute or a credit processed after the cutoff. Keep a separate exception queue for those items so they reach the person who can resolve them.
Record an accountable next step
For each remaining balance, add a follow-up owner, action and date. If a parent pays for its subsidiaries, check which entity owes each invoice. Oracle notes that subcustomer balances can appear separately under Consolidated Payments. Use the accounts receivable guide to plan the broader follow-up process.


.webp)