Darwin Cloud

How to Add the "datePaid" Column to the AR Aging Report

Updated on

Overview

The datePaid column has been added to the AR Aging report and A/R Aging Level 3 Raw Data report. When enabled, it displays the payment date associated with each invoice or balance directly in the report output.

Benefits

  • View payment dates without searching payment records separately.
  • Simplify account reconciliation and auditing.
  • Reduce manual lookup efforts for accounting teams.
  • Improve reporting transparency and accuracy.

Steps to View the datePaid Column in the A/R Aging Report

  1. Navigate to Reports > All Reports > Accounting > A/R Aging.
  2. Open the A/R Aging report.
  3. Enter the required report filters.
  4. In the Column Settings section, select datePaid from the available columns.
  5. Click Preview to generate the report.
  6. Review the datePaid column:
    • Paid invoices display the payment date.
    • Unpaid or open invoices display a blank value.
  7. Export the report if needed. The datePaid column will be included in the export when selected.