Watch a (2:34) video tutorial on the Revenue Reconciliation Reports
Jackrabbit's Revenue Reconciliation reports are an indispensable tool when you have multiple Locations in your database!
You can find these reports in the Reports menu. Go to Reports > Transactions/Financials >Who Has Paid > Revenue Reconciliation Reports.
- Reconcile revenue between where payments were received and where revenue was earned.
- Analyze revenue by Family or by Location using four report options: Reconciliation Summary, Location Summary, Revenue by Location, and Revenue by Family.
When you have a single Location in your database, the only report option available is the Revenue by Family; the other three options relate to multiple Location revenue reconciliation.
Using the following example we'll step through each of the four report options:
- An organization has two Locations, Concord (CCD) and Davidson (DVD). The physical locations are very close to each other and many families have students taking classes at both.
- Each Location is managed by a different business partner and revenue is routed to separate bank accounts based on the Location of the family making the payment.
- The ConcordFamily has a student taking one class at the Davidson Location ($75); they made a payment of $75 for the October tuition and it was deposited into the Concord bank account.
- The DavidsonFamily has a student taking one class at the Davidson Location ($75) and one class at the Concord ($50); they made a payment of $125 for the October tuition and it was deposited into the Davidson bank account.
- The Paid Fees Detail report for all Locations reflects both payments and total revenue of $200.
reconciliation summary The Reconciliation Summary report does the math to suggest the amounts that need to be transferred between the two bank accounts so that each partner receives the amount of revenue that was earned at their Location.
The ConcordFamily made a payment of $75 and it was deposited into the Concord bank account but their payment was actually for fees for the class taken in Davidson, therefore, Concord owes Davidson $75.
The DavidsonFamily made a payment of $125 and it was deposited into the Davidson bank account but $50 of that payment was actually for fees for the class taken in Concord, therefore, Davidson owes Concord $50.
The net effect is that Concord owes Davidson $25.
To drill down into the details further, the Location Summary is used.
location summary The Location Summary report lists, by Location, the total payments received and the fees they were applied to.
The Difference will net to zero.
Revenue by Location
revenue by location The Revenue by Location report lists every payment received and every fee that had a payment applied to it, for each Location. This report can be used to confirm the results of the Location Summary and the Reconciliation Summary.
Revenue by Family
revenue by family The Revenue by Family report lists every payment made and the fees the payment is linked to, for each family.