Follow

Camper Transaction Summary

The Camper transaction summary reports on the total amount of charges, discounts, payments, credits, refunds, and reversals per transaction category.

All transactions are also reconciled together to provide a snapshot of how much payment your camp still needs to collect (per transaction category and also overall).

First, navigate to the Financial Dashboard by clicking the Financial link in the top navigation bar.

Next, go "Camper reports" and select "Camper transaction summary."

Filters

  1. Select an enrollment year
  2. Filter transactions by the month they were created in CampSite
    • For example, if 2020 is selected as the year, and the month of January is checkmarked, the report will generate any transactions created during the month of January of any year, that are applying towards the 2020 enrollment year.
  3. Filter transactions by a specific timeframe when they were created
    • Leave the date range blank to report on all transactions from the selected enrollment year/months
  4. Click Run Report to generate your results

Note: If you filter by month or date range, the report results will only include 'Reversals' that occurred during the months/date range selected. For example, if charges were created in January then reversed in March, and only January is selected in your report filters, the reversal of those charges will not be accounted for in your transaction totals since they occurred outside of the report filters.

Totals by Category

Each row of the report results will present the transaction totals per transaction category. See the column headers for each transaction type.

The "total" column on the far right represents the grand total of all transactions for that particular category.

For example, in the screenshot above, the After School category has a grand total of $1635, because $1645 in charges have been posted but only $10 in payments have been collected. A total of $1635 indicates that the camp still needs to collect $1635 in payments for the current charges that have been posted for the After School category.

The School Break category, on the other hand, shows a total of $0.00, to indicate that all charges have been paid for this category. This is calculated by taking the $2400 total charges and subtracting the $50 in discounts, for an adjusted total charges of $2350. With $2350 in received payments, all charges have thus been paid. That said, when all current charges have been paid, the total will equal zero.

A positive total represents how much your camp still needs to be paid.

A negative total indicates that your camp received too much payment (because the total amount of payments you've collected is higher than the amount that you've charged families to pay).

Totals by Transaction Type

Each column of the report results will present the transaction totals of that particular type of transaction. Refer to each row for the total per transaction category.

The very bottom row of the report results represents the grand total amount posted for that particular type of transaction.

For example, in the screenshot above, the Charges column shows that $1,645 in charges have been posted for the After School category; $0 for Cancellation fee; $2,400 for School Break; $68,270 for Summer Camp, and $1,565 for Tuition.

Then, the very bottom cell of the Charges column indicates that a grand total of $73,880 in charges have been posted.

  • Please note: The "Reversals" column reflects reversals of all transaction types summed together.

Grand Total

The bottom right cell of the report will calculate the grand total of all transactions.

For example, in the screenshot above, the grand total of all transactions is $70,192.28. This number represents the sum of all transaction category totals, as well as the sum of all transaction type totals.

A positive total represents how much your camp still needs to be paid.

A negative total indicates that your camp received too much payment (because the total amount of payments you've collected is higher than the amount that you've charged families to pay).

As such, the above screenshot indicates that the camp still needs to collect an overall amount of $70,192.28 in payments for the current charges that have been posted.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk