Aged Accounts on the Executive Dashboard

The Aged Accounts section of the Executive Dashboard provides a breakdown of all of the unpaid fees owed to you by your families divided into time buckets for 0-30, 31-60, 61-90, and >90 days. Fees begin to age from their transaction date. 

Use this information to assist you with your Accounts Receivable collection efforts. See Aged Accounts Summary Report for more information.

  • The totals in the aging columns represent the total of unpaid fees on a family's account. This may or may not be the actual balance owing on the family's account depending on whether or not they have any unapplied credits. The sum of all unpaid fees on an account less any unapplied credits will equal the family balance. 
  • The Total column is the sum of all of the aging columns.
  • The Balance (incl. Credits) column is the sum of all of your family account balances and includes fees with a date in the future AND unapplied credits.


It is important to note that improper linking of fees and payments will affect these aging totals. If a fee has been paid but a payment has not been linked to it, it will be included in the Aged Account totals because Jackrabbit still sees the fee as unpaid. See Fee Linking Explained for more information.

To give a quick visual of the overall 'health' of your accounts, customize the time bucket columns to color code them (green, yellow, red) by clicking the Settings link.  Note: The 0 - 30 column is not able to be color coded as these amounts are considered current.

Example
 

  • 31-60 days column - If the sum of all aged fees in this group is $10,000 or less the box will be shaded green. If that total is between $10,000 - $15,000 the column will change to yellow. When the total of all aged fees in this group exceeds $15,000 the column will be shaded red.
  • 61-90 days column - If the sum of all aged fees in this group is $2,000 or less the box will be shaded green. If that total is between $2,000 - $4,000 the column will change to yellow. When the total of all aged fees in this group exceeds $4,000 the column will be shaded red.
  • >90 days column - If the sum of all aged fees in this group is $0 the box will be shaded green. If that total is between $0 - $500 the column will change to yellow. When the total of all aged fees in this group exceeds $500 the column will be shaded red.