CAMPBRAIN | STANDARD REPORTS EXPLAINED

1 CAMPBRAIN | STANDARD REPORTS EXPLAINED November, 2015 Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | Table of Contents Part 1 | Financial REPORTS : In Depth ACF-001: Household Account Statement CCF-100: Revenue Details by Accounting Category (Accrual Basis) CCF-105: Revenue Details by Camp and Session (Accrual Basis) CCF-110: Revenue Details CCF-150: Charges with No Camp by Season CCF-200: Daily Deposit Journal by Payment Method CCF-205: Payment Summary by Accounting Category (Cash Basis) CCF-210: Payment Summary by Camp and Session (Cash Basis) CCF-250: Declined Payments CCF-260: Unallocated Payments CCF-300: Household Balances CCF-305: Household Balances (for calculating balances as at prior dates) CCF-310: Camper Balances by Session Financial REPORTS : Summary PART 2 | Registration REPORTS CCR-100: 5 Day Attendance Sheet CCR-110: Camper Check-in-Sheet CCR-200: Cabin List CCR-210: Camper Information by Cabin CCR-300.

2 Camper Printable Forms CCR-310: Camper Registration History CCR-320: Campers by Session Options CCR-340: Household Confirmation Letter CCR-350: Camper Profile CCR-360: Campers by Season (Site) CCR-400: Registration Summary Session Options CCR-410: Registration Summary Sessions Registration REPORTS : Summary PART 3 | Medical REPORTS CCM-100: Camper Food Allergies and Dietary Restrictions CCM-200: Camper Medication List CCM-300 Campers with EpiPens CCM-400: Medical Form Medical REPORTS : Summary Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | PART 4 | People REPORTS CCP-100: A5161 - Household Mailing Labels CCP-105: A5162 Household Mailing Labels CCP-110: A5260 Household Mailing Labels CCP-115: A5260 The XYZ Household Labels CCP-120: A5260 Primary and Secondary Household Labels CCP-150: A5161 Person Mailing Labels CCP-155: A5162 Person Mailing Labels CCP-160: A5260 Person Mailing Labels CCP-165: A5260 Person File Folder Labels CCP-180.

3 A5395 Name tags with Cabin CCP-200: Addresses and Emails for Exporting to Excel CCP-205: Birthday List CCP-210: Person Count by City and State CCP-215: List of Names with City and State CCP-230: Names CCP-300: Household Addresses and Emails for Exporting to Excel CCP-305: Household Directory CCP-310: Household and People Names CCP-400: Emergency Contact List People REPORTS : Summary PART 5 | Staff REPORTS CSR-100: Staff List CSR-200: Staff Positions by Period CSR-205: Alphabetical Staff Positions CSR-300: Staff Profile CSR-400: Staff Checklist CSR-405: Staff Season Yes No Fields Checklist CSR-500: Staff Certifications CSR-600: Staff Tshirts CSF-100: Staff Payroll Profile CSF-200: Staff Contract CSA-100: Staff Application Information CSA-200: Staff References (Excel) PART 6 | System REPORTS CCR-900: System: Online Printable Confirmation CCR-910: System: Original Form Submission CCM-900: System: Online Printable Medical Form CCF-900: System.

4 Household Account Statement Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | PART 1 : FINANCIAL REPORTS : IN DEPTH ACF-001: Household Account Statement Filters to use with this report : Accounts 1. Each camp will have a customized household account statement. It will list the charges of each camper and the household s payments for a given season. This is often referred to as an invoice or receipt. 2. You can run this report from the household account screen or from a camper charges screen by clicking on the invoice button.

5 3. The Household Account Statement should be run as a batch by using filters under the accounts tab; this will give you a complete picture of each household s account activity by season. Example of how to run the report : Please note: The above example pulls households with balances. By removing Season Account Balance you would get all invoices for every family in the given season. Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | CCF-100: Revenue Details by Accounting Category (Accrual Basis) Filters to use with this report : Charges 1.

6 This report is a summary of camper charges only, grouped by season and camp, and provides totals for each category. Since there are no payments included in this report , it is ideal for those doing accrual based accounting. 2. For this report to make sense you want to make sure that every charge you have configured in the Season Builder Step 4 Fees, has an accounting category assigned to it. Categories can be anything you want them to be. For example, they can group a specific selection of charges under one name or even General Ledger Codes.

7 You can even combine a specific name with a GL code as in: Pre Camp | 1-20-00-6555-00000. 3. If GL codes are important to your financial reporting, please talk to a member of our team about the best way to set them up. Example of how to run the report : Please note: You can only run this report with the charges filter. In the example above we are filtering for revenue as of June 30th. There are many charge filters to help you narrow your search. Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | CCF-105: Revenue Details by Camp and Session (Accrual Basis) Filters to use with this report : Charges 1.

8 This report is a summary of camper charges only, broken down to show a sub-total of all season, camp, session, session option and camp option level charges. 2. This report will follow the same filters as the CCF-100. If you run them for the same time frame ( with the same filters) they should give you the exact same totals. The obvious difference is that this report is summing up charges by camp, session, and session option whereas CCF-100 is giving you the sum of charges per accounting category. 3. One thing that you want to keep in mind is, any manually added charges should be properly assigned to a camp and/or session and/or session option should they belong to any of those.

9 There might be instances where a charge is just a season level charge and it does not belong to any camp. This is where our CCF-150: Charges with No Camp by Season report can help you. 4. REPORTS you could /should use with this report : CCF-150: Charges with No Camp by Season Example of how to run the report : Phone: 416-485-8885 | Toll Free: 1-866-485-8885 | CCF-110: Revenue Details Main filters to use with this report : Charges Additional filters you could use with this report : People | Registration 1.

10 The intent of this report is to give you an overview of your revenue per camper per selected season or overall for all seasons. It provides every charge date with a description and the accounting category it s assigned to. It also shows the amount, the tax and the total amount per charge. It groups all of those charges by person, and then it gives you a subtotal per person. 2. If you run this report and you select a certain charge session or charge camp and you notice that some charges are missing, that could be due to the fact that the charges have been added manually and a camp and/or session has not been assigned to the charge.