We’ve gathered some of the most useful collection reports to help boost your Jackrabbit IQ. These reports help you figure out, ‘Who owes me money?’
There are three ways to look at this: outstanding fees (Aged Accounts Detail), outstanding accounts (Aged Accounts Summary), and family balances as of a certain date (Family Balance.) Of course, all three have many options for finding just the fees or families you need.
Aged Accounts Detail – This lists each fee on its own line and can be subtotaled by family and Location. This a traditional ‘past due’ report.
Aged Accounts Summary – Get here easily from the Executive Dashboard and use this for your accounts receivable collection efforts.
Option 1: From the dashboard click either one of the aging options (0-31, 31-60, etc) or Total to get a quick count of all families who have outstanding fees with you. This adds all of the unpaid fees for accounts with a balance greater than $1. Note: Fees with a Date in the future are not included because they are not past due.
Option 2: Click ‘Balance’ from the Aged Accounts area of the dashboard. This adds the balances for all accounts, except Store accounts, and will include Fees with a Date in the future as well as future Payments (including unapplied credits.)
If running for Option 2 you can also include families whose balance is zero, but who may have unlinked fees and payments. To do this, check the box beside ‘Show families with zero balance’ on the results page.
Family Balance – A quick snapshot of what family balances are (or were) on a certain date. This will include everyone in Option 1 & 2 above, as well as accounts with zero dollar balances and no unlinked fees or payments accounts. Think of it as a fly-on-the-wall report, if you were to pull Statements for each family at a point in time what would it look like as of that date?
See more on Financial Reports in the Help Center.
Also check out: Top Reports