Use NetSuite A/R Aging Detail for collections

Run A/R Aging Detail when you need to see the transactions behind a customer’s aging balance. Record the report cutoff and scope before export, then check each invoice against payments and credits posted since that date.
Upload a case

Key facts

Use Detail for invoice-level work and Summary for account-level prioritization.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.