AR Aging by Transaction Report

Introduction

The Accounts Receivable (AR) Aging by Transaction report helps you review the transactions that have been already delivered but are yet to be paid (i.e. are due) by your customers. 

Important Notes

Rules for calculating the report

• This report shows unpaid transactions (Membership and one-off fees) with a delivery date equal to or less than today.
• Membership fee transactions age based on:
  • (1) the start date of the membership (in the first month the membership is activated)
  • OR
  • (2) the first day of the billing cycle of the respective Company/Member (when the membership recurs for the 2nd time or more)
• One-off fee transactions age based on the start date of the fee.
• Membership and One-off fee transactions that are part of Invoices with status “Paid” are NOT included in the report.
• Membership and One-off fee transactions that are part of Invoices with status “Partially Paid” and “Awaiting Payment” are considered NOT paid and are included in the report in their full amount.
• TAX is excluded from the total amount of each transaction
• Deposits and processing fees will appear as line items in this report
• A negative amount will appear as a line item in this report if:
  • a fee/membership was credited (i.e. a Credit Note was issued for it)
  • you’ve created a fee with a negative value in the first place
• Manually created line items in invoices will appear in this report.
• 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

The total due amounts are broken down into the following (aging) buckets:

• 1-30 Days - the amount due from Membership and One-off fee transactions whose start date passed more than a day ago, but NOT more than 30 days ago.

• 31-60 Days - the amount due from Membership and One-off fee transactions whose start date passed more than 30 days ago, but NOT more than 60 days ago.

• 61-90 Days - the amount due from Membership and One-off fee transactions whose start date passed more than 60 days ago, but NOT more than 90 days ago.

• 90+ Days - the amount due from Membership and One-off fee transactions whose start date passed more than 90 days ago.

AR Aging by Transaction Report

The report shows a detailed list of Transactions with the amounts (per transaction) that are still due for each customer.