AR Aging Overview

Introduction

The Accounts Receivable (AR) Aging by Invoice report helps you review the outstanding amounts that are yet to be paid (i.e. are due) by your customers.

ar aging report.png

Rules for calculating the report

  • Invoiced amounts "age" based on the Due Date of the respective Invoice. For example, if the due date of an invoice passed yesterday, that invoice amount will be included in the 1-30 Days aging bucket.
  • Invoices with status “Paid” are excluded from the total due amounts, as payment for them was received in full.
  • Invoices with status “Partially Paid” are included in the total due amounts, but the partially paid amount (both from payments and allocations) is subtracted from the total due amount.
  • Invoices with status “Awaiting Payment” are considered NOT paid and their invoice amount is included (in full) in the total due amount.
  • TAX, deposits, and processing fees are INCLUDED in the total due amount.
  • This report lists every entity that you have a direct commercial relationship with. It can show Companies, Company Members (if they have personal fees/memberships), and/or Individual Members.

Aging Buckets

  • Pending - the total amount due from Invoices that are NOT overdue yet. That means that their due date still hasn't passed and they are currently in status "Pending"
  • 1-30 Days - the total amount due from invoices that are overdue for more than a day, but NOT overdue for more than 30 days.
  • 31-60 Days - the total amount due from invoices that are overdue for more than 30 days, but NOT overdue for more than 60 days.
  • 61-90 Days - the total amount due from invoices that are overdue for more than 60 days, but NOT overdue for more than 90 days.
  • 90+ Days - the total amount due from invoices that are overdue for more than 90 days.

Overview Tab

Invoice Due Amounts, Split by Aging Bucket and Customer Total

The first visualization shows you the total amount due in each aging bucket, along with the count of customers that contribute to each respective amount.

inv by ab.png

Customers, Sorted by Due Amounts

The second visualization shows you an exhaustive list of all customers with due amounts, sorted by the highest amount from top to bottom.

customers ranked by due amount.png

Additional options such as filtering, expanded views, and data export are available as well. Click here to learn more.
Was this article helpful?
0 out of 0 found this helpful
Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.