AR Aging

Introduction

The Accounts Receivable (AR) Aging report is one the latest additions to our Reports Tab.
It gives you an easy way to review the outstanding payments of a client, versus their deposits and credit with you. 

By Invoice

mceclip0.png

There are a few columns in this report, and you can find a description of what each of them displays below:

  1. Name - This column contains the names of members and companies. They are listed in one or more groups based on their location.
  2. Status - This column shows the current status of the member.
  3. Deposit Held - This column shows the total of the refundable fees which have been collected and have not been refunded.
  4. Pending - This column holds the total amount of unpaid invoices that have not reached their overdue date yet.
  5. 1-30 Days - This column shows the amount that is overdue for 30 or fewer days. 
  6. 31-60 Days - This column shows the amount that is overdue for a period of 31 to 60 days.
  7. 61-90 Days - This column shows the amount that is overdue for a period of 61 to 90 days.
  8. Over 90 Days - This column holds the amount in invoices that are more than 90 days overdue.
  9. Total Overdue - This column represents the total amount of overdue payments from the 4 previous columns.
  10. Unallocated Amounts - This column represents the total sum of all credit notes and overpayments issued to the member.

The Totals rows of each column are also separated by Location for better visibility of the report.

On the top of the page, there is a drop-down menu that can be used to apply some filters to this report. The two options are:

  • "Without Overdue Amounts"  - If you select Without Overdue Amounts, you will have a list of all the people that only have Deposits and/or Unallocated Amounts
  • "With Overdue Amounts" - If you select With Overdue Amounts, it will only show members that have overdue invoices.
    With both selected or deselected, the system will show you a complete list of members that qualify for this report.

By Transaction

Unlike the "By invoices" section this gives you a complete breakdown for each customer of all their one-offs and memberships that have been recorded.

mceclip1.png

Each membership and one-off is presented on a separate row and is treated as separate transactions.

In the top part of this section you can search for customers using their names.

Note: The transactions list includes all transactions up to, but not including today's date.
Example: If today's the 2nd, then you won't see one-offs and memberships from the same day, but only from the previous 1st and back. 

Here are the columns that available for this part of the report:

  1. Member - This column contains the names of members and companies.
    Note: There's no grouping by location so you can use the global location filter in the center of every page for that purpose.
  2. Status - This column shows the current status of the member.
  3. Name - This column shows the name of the membership/one-off.
    Note: If an invoice has a manually added line item it will not be present as a transaction.
  4. Start Date -  The start date of the membership or the date of the fee.
  5. Invoiced - The invoice in which the item is included.
  6. Billing Account - The account with which the fee/membership is associated.
  7. Total Amount - The total cost of the item, including taxes.
  8. 1-30 Days - This column shows the amount that is overdue for 30 or fewer days. 
  9. 31-60 Days - This column shows the amount that is overdue for a period of 31 to 60 days.
  10. 61-90 Days - This column shows the amount that is overdue for a period of 61 to 90 days.
  11. Over 90 Days - This column holds the amount in invoices that are more than 90 days overdue.
  12. Deposit Held - This column shows the total of the refundable fees which have been collected and have not been refunded.
  13. Unallocated Amounts - This column represents the total sum of all credit notes and overpayments issued to the member.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.