Skip to content
English
  • There are no suggestions because the search field is empty.

Reports : Aging Report

Article Contents: This article explains how to use the Aging Report to track unpaid member balances by how long they’ve been outstanding (e.g., 1–30 days, 31–60 days, and beyond). You’ll learn how to filter the report by date range and member, choose whether aging is based on Transaction Date or Statement Date, and correct balances so the report reflects what is truly owed.

Step by Step:

Step 1: Click on the Reports module. Then on the left hand of the screen, click on the Aging Report button.

 
 

Step 2: In this report, 1-30, 31-60, 61-90, 91-120, greater than 120 columns are there, in which membership amount gets deducted from the first-month balance amount when we do membership payment for this member.

 
 
Step 3: You can also use the filters along the top of the report for a date range, specific members, and then by Transaction or Statement Date.
 




Transaction or Statement date: The Aging Report can calculate how old a balance is based on either the Transaction Date (when the charge was posted) or the Statement Date (when the charge was billed on a statement). Use Transaction Date if members are expected to pay as charges occur, and use Statement Date if you bill on a statement cycle so aging matches when members were actually billed and when late fees should apply.





Step 4: If you would like to edit/remove and entry, please navigate to the members profile. Then, select the Membership tab > Ledger tab. If the intention is to zero out the balance for the account, you'll want to perform a credit ledger adjustment and then enter in the amount. Next, you'll enter in a description, select the proper chart of account and be sure to check the box to Consider payment against previous invoice and then click on Ok. Once you perform the adjustment to bring the balance to zero, it'll remove the amount owed on the aging report. 




Example Scenario:
Your controller runs the Aging Report at month-end to identify members with balances over 60 days past due. They filter by a date range and select Statement Date so the aging matches the club’s monthly billing cycle. One member shows an old balance that should have been corrected, so the staff member opens the member’s Membership > Ledger and completes a Credit Ledger Adjustment with “Consider payment against previous invoice” checked. After the correction, the balance is cleared and the Aging Report updates accordingly.