Kangarootime offers a robust number of reports that are available in either CSV and/or PDF. Below you'll find 3 tables that review all Kangarotime exports available within the K2 site, including the name of each report, the format in which you can download the export, filters, column headers, and some information about what the report will display, and can be used for.
Table of Contents
Attendance
|
Name of Report |
Format |
Data Supplied |
Information |
|
Attendance Totals Per Week
|
CSV |
Report Headers: Center Name, Charged (Care Type), Type, Days of the week, Totals for Charged Attendance, Actual Attendance, Absences, Approved Capacity, and Space Available
Filter by Center(s) and Date - the date you select will provide you with weekly data for the week the day you chose falls in. |
This report is designed to display booked vs actual attendance information related to a center along with the capacity of the center to determine staffing requirements - all defined by care type. |
|
Child Check In |
CSV |
Report Headers: Center, Child Name, Class, Account Name, Date, Time of check-in, Time of check-out, Contact Name Check-In, Contact Name Check out, Contact IDs, Class ID
Filter by Center, Class, Start and End Date |
This report tracks child check-in and check-out times along with who checked the child in and checked the child out. The report displays the child chain of custody and can be helpful to keep track of subsidy attendance. |
|
Child Miscellaneous |
CSV |
Report Headers: Child Name, Child DOB, Class Name, Grade, Number of Attended Sessions, Number of Standard Absent Days, Number of Holiday Absent Days, Number of Additional Absent Days, Total Absent Days, Number of Casual Sessions
Filter by Center, Class, Start Date, End Date
|
This report tracks attended sessions and sessions that were not attended and marked as absent. The Child Miscellaneous report can be used to track subsidy children to ensure they are attending enough to remain eligible to continue being sponsored by the subsidizing agency. |
|
Child Sign in Form |
|
Report Headers: Form includes blank fields for: Date, Center Name,
Child Name, Class, Time In, Signature, Time Out, Signature, Absent check box, Notes
This report is similar to the Class Attendance Roster, but it produces blank fields rather than populating expected attendance data. |
The Child Sign in Form is a printable, blank sign-in sheet designed for downtime or offsite location attendance tracking.
This report can be printed at the beginning of each week to be prepared in case of any power or internet outages that would prevent you from using Kangarootime products to track attendance. |
|
Child Tracking |
|
Report Headers: Center, Date, Child name, time, and space location, action by
Filter by Center, Start Date, End Date, with an additional option to filter by Space OR Child OR Neither |
This report can be used to track the chain of custody throughout the day by tracking the movements a child has made from space to space. This report displays space and class data which can be very useful for contact tracing. |
|
Class Attendance Roster |
|
Report Headers: Center, Class, Child Name, DOB and Age with week schedule to indicate manually check in check out and absent
Filter by Center, Date (most likely current or future), and Class
This report is similar to the Child Sign In Form, but contains expected attendance data. |
This report produces a printable weekly class roster to check in, check out or mark absent a child, which includes the child's name and date of birth.
Within each day, white fields indicate the child is expected to attend, and gray fields indicate that the child is not expected to attend.
This report can be printed at the beginning of each week to be prepared in case of any power or internet outages that would prevent you from using Kangarootime products to track attendance. |
|
Employee Timesheet |
|
Report Headers: This report is broken up by Scheduled, Actual, and Adjusted times, by Date and Employee.
Filter by Center, Employee(s), Start Date, and End date |
This report presents employees' clock in and out times to ensure consistency for hourly employees. This report also gives the employee an opportunity to sign off on their hours at the bottom of each weekly page. |
|
Name to Face |
CSV/PDF |
Report Headers: Center, Class, Space, Staff Name, Date, Time, Child Name, and Account
Filter by Center, Class, Start Date, End Date. |
This report syncs with the Point of Care App Name to Face feature, to report a child's location at the time the Name to Face action was done, the time the Name to face action was done, and the staff member who completed the Name to Face action.
Oftentimes, businesses require staff to perform the Name to Face action to ensure all children in the custody of a teacher remain in that teacher's custody (ex. moving from one space to another or hourly roll call). |
|
Name to Face Form Weekly |
|
Report Headers: Class, Date, Weekly Attendance Schedule, Child Name, DOB, Age and Space
Filter by Center, Date, and Class
|
The Name to Face Form (Weekly) report is a printable weekly class attendance schedule with child’s name, space assigned with an open checkbox to manually mark. |
|
Quarter Hour Check In |
PDF
|
Class attendance count by quarter hour
Filter by Center, Date |
This report displays the variance of check in's for every 15 minutes. The color indicates if the variance of check in went up or down during that 15 minute increment, and the number displays the count of children checked in. Example: If 2 kids are checked in at 10 AM and then 0 kids are checked in at 10:15, you would see a green 2 at 10, then a red 0 for 10:15. |
Families
| Name of Report | Format | Data Supplied | Information |
|
Account Contact Information |
CSV |
Report Headers: Center, First Name, Last Name, Email Address, Primary Phone Number, Child Associated, Contract Class, Primary (Y/N), Relationship, Pick Up Permission (Y/N), Payments Permission (Y/N)
Filter by Center(s) with the status of Active and/or Inactive |
This report is a child-level report to verify contact information and contact permissions. The report concisely displays contact info vital to the center such as phone number and email address while also showing whether contacts have permission to pick up/drop off and whether the contact has permission to pay the bill. |
|
Child Contracts |
CSV |
Report Headers: Contract ID, Class Name, Center ID, Center Name, Child ID, Child First Name, Child Last Name, Child DOB, Account GUID, Account Name, Contract Start Date, Contract End Date, Active, Center External ID, Account ID< Primary Fee Name, Contract Type
Filter by Center(s) and Date |
This report should be used to make sure all children are enrolled correctly (contract end dates, fees, contract type, etc.) or to simply review child enrollment data by Center.
We advise that this report be used close to the end of a school term, summer term, etc. for our Before and After School customers to make sure contracts have end dates so Kangarootime ceases to bill at the end of the term. |
| Child Health & Wellness |
CSV/PDF |
Report Headers: Report Headers: Center Name, Center ID, Class, Date, Child ID, Child Name, Child Age, Category, Condition Type, Condition Name, Symptoms/Reactions, Care Instructions, Expiration Date, Review Date
Filter by Center, Class, Condition, Start Date, End Date, Format |
This report is a great printout via PDF or CSV to display medical conditions, allergies, and restrictions by class. Oftentimes, centers prefer to keep a paper copy of this information within each classroom but this information can also be accessed via Point of Care |
|
Contact Details (Emergency & Primaries) |
CSV/PDF |
Report Headers: Center Name, Class, Child - Last Name, Child - First Name, Emergency Contact - First Name, Emergency Contact - Email, Emergency Contact - Primary Phone, Emergency Contact - Relationship, Emergency Contact - Home Phone, Emergency Contact - Work Phone, Emergency Contact - Mobile Phone, Emergency Contact - Apt, Emergency Contact - City, Emergency Contact - State, Emergency Contact - Postal Code, Primary Contact - First Name, Primary Contact - Last Name, Primary Contact - Email, Primary Contact - Primary Phone, Primary Contact - Relationship, Primary Contact - Home Phone, Primary Contact - Work Phone, Primary Contact - Mobile Phone
Filter by Center(s), Format, and Class |
This is a more comprehensive contacts report that specifically indicates emergency contacts and primary contacts within separate columns. This report will create as many columns as necessary to capture all Emergency Contacts and Primary Contacts, so this report is more lengthy than the Account Contact Information report. |
| Edits to Contract |
PDF |
Report Headers: Date of Change, Action, Modified, Previous Data, New Data, Employee who made the change
Filter by Center or Account, Start Date, End Date |
With this report you can view all modifications made to a child's contract, and which employee made the modifications. This report is great for accountability if an error is found so you can show employees mistakes that were made when editing contracts and how they should proceed in the future. |
| Email Address |
CSV |
Report Headers: Account Name, Contact Name, Email Address, Contact Type, Account Status
Filters by Center(s), Account Status, Primary and/or Non-Primary |
This report provides an account-level view of email addresses associated with accounts and contact names. You can use this report to create email blasts in third-party communication software like Constant Contact. |
| Ended Contracts |
CSV |
Report Headers: Center Name, Account GUID, Account Name, Account ID, Child First Name, Child Last Name, Class Name, Exit Reason, Starts, Ends |
This report exports ended contract data within a date range and exit reason. You can use this report to see which children are leaving your center(s) and why they left OR how many contract changes are taking place. |
|
Meal Tracking Report |
|
Report Headers: This report is broken apart into 2 sections:
Center Operating & Enrollment Data - Unspecified Enrollment, Free Enrollment, Reduced Enrollment, Paid Enrollment, Total Enrollment, Number of Operating Days, Total Monthly Attendance
Meal Count Data - Type, Breakfast, AM Snack, Lunch, PM Snack - and this data is broken down by Unspecified, Free, Reduced, Paid, Total Meals, Avg. Dailly Participation
Filter by Center(s), Month
|
This report provides a summary of student attendance counts for comparison to the counts of students receiving meals that are free, reduced, or paid. This gives you the ability to quickly report on the data you need if you participated in the Child and Adult Care Food Program (CACFP).
This data is refreshed nightly so it will not show real-time data, you'll see the day before's data. Also, this report provides data based on the current meal type settings and thus is not meant for historical purposes, so we recommend keeping these reports saved if you would like to retain that historical data. |
|
New Contracts |
CSV |
Report Headers: Center Name, Account ID, Account GUID, Account Name, Child Name, Class Enrolled, Frequency, Days per Week, Start Date
Filter by Center(s), Date |
This report lists new contracts started from the specified date.
|
Finance
|
Name of Report
|
Format |
Data Supplied
|
Information
|
| ADP Weekly Payroll |
CSV
|
Report Headers: Co Code, Batch ID, File #, Reg Hours, O/T Hours, Hours 4 Code, Hours 4 Amount, Temp Dept, Temp Rate, Workweek. Filter by Center(s), Start Date, End Date |
ADP report for centers working with ADP Vantage/K2 integration. Please contact your Implementation Specialist or your Customer Service Manager if you are interested in using this report.
|
|
Account Balances
|
CSV/PDF
|
Report Headers: Center, Balance Date, Account ID, Account Name, Account GUID, Balance, Active/Inactive
Filter by Center(s), Format, Account Status Active and/or Inactive
|
This report exports each account balance as of the date you pull the report.
Example: Two days after payments are due, you can pull this report to find accounts that have fallen behind on their payments. You can also couple this report once you've reviewed Kangarootime's AR reporting dashboards to identify missed payments. |
|
Attendance Cost (by session)
|
CSV
|
Report Headers: Date, Center Code, Class, Account GUID< Child ID, Child Last Name, Child First Name, Sign In Time (First), Sign Out Time (Last), Child DOB< Age of Child, Fee ID, Fee Name, Fee Value, Absent, Session Hours, Account ID, External ID, Booking Origin.
Booking Origin - This column will include the following values: Default (contractually enrolled children), ADHOC (session added via the Attendance Menu), and KT Connect (session booked via KT Connect drop in feature)
Filter by Center(s), Start, End Date, Format |
This report displays the cost of individual child sessions making it a great way to tell who is enrolled vs. who dropped in either manually or via KT Connect via the Booking Origin column.
Keep in mind, that only children enrolled on session fees or dropped in via session fees will appear on this report, meaning flat rate contracted children will be excluded.
|
|
Billing Summary
|
|
Report Headers: Center, Date Range, and Total amounts
Information is broken down by class, transactions, discounts, subsidies, and payment methods based on enrollment counts.
Filter by Center(s), Start and End Date
|
This report provides a summary of the fees, transactions, discounts, subsidies, and payment methods utilized within the timeframe selected. This report can be used for auditing billing and to gauge future enrollments. The inclusion of payment methods is also useful to see exactly how families are paying for care.
Keep in mind, custom transactions will not appear on this report however we recommend using this report in conjunction with our transaction reports to get a better picture of cash flow. |
|
Class Occupancy Totals
|
CSV
|
Report Headers: Center Name, Class Name, Week Beginning, Capacity Per Day, Monday - Friday Count (One column per day), Monday - Friday Utilization (One column per day), Weekly Class Count, Weekly Class Utilization,
Filter by Center(s), Class, Start and End Date, Toggle to exclude/include classes without attendance |
This report exports a center’s occupancy totals by individual weekdays within a week, broken down by child count and utilization percentage. You can use this report to see which classes are performing well or underperforming with enrollment to make staffing decisions or decisions regarding what programs are offered in the future. |
|
Contract Fee Detailed Overview
|
|
Report Headers: Totals Contract Fees broken down by Type, Description, Child Name, Weekly, Biweekly, and Monthly Amounts
Filter by Center(s) and Date |
This report exports contract fees by individual child enrollment contract(s) per billing period (Weekly, Bi-Weekly, Monthly, Quarterly), including Totals. This report can be used to see how much you can expect from tuition, by fee and billing period on an account level.
|
|
Contract Fee Overview
|
|
Report Headers: Totals - Type, Fees, Credits, Total, Avg/Account
Weekly/Bi-weekly/Monthly: Description, Count, Amount
Filter by Center(s) and Date |
This report is a high-level overview of fees and their corresponding counts indicating the number of contracts assigned to that fee and the total dollar amount. You can use this report to review aggregate counts and dollar amounts by fee per billing period.
|
|
Deposits Held
|
CSV |
Report Headers: Center GUID, Center ID, Center Name, Account GUID, Account ID, Account Name, Child GUID, Child Name, Amount, Last Attendance
Filter by Center(s) |
This report lists currently maintained deposits on a child level. You can use this report to easily keep track of held deposits by account.
|
|
Disbursements (Monthly)
|
CSV
|
Report Headers: Center ID, Center Name, Disbursement ID, Disbursement Created, Disbursement Processed, Disbursement Status, Disbursement Amount, Disbursement Returned, ACH Fees, ACH Transactions, Credit Card Fees, Credit Card Transactions, Refunds, Returns, Remainder, Other
Filter by Center(s) and Month
|
This report compiles all bank disbursements within a month for the chosen centers into unique rows per day within the month.
|
|
Royalty
|
|
Report Headers: Centers, expected gross income, collected gross income, income subject to royalties, discounts, enrollment information, and hourly staff information
Filter by Center(s), Start Date, End Date, Subsidy Payments
|
This report should only be used by clients with a franchise business model. The export displays the health of the businesses with regard to staffing and costs.
|
|
Transaction Totals Per Month (by transaction type)
|
CSV
|
Report Headers: Center Name, Date, Transaction Type, Fee, Discounts, Early/Late, Subsidy, Credits, Debits, Payments, Totals, External ID with a totals row on the bottom of the report
Filter by Center(s), Start Month, End Month with toggles to take into consideration Period Accounting and to include liabilities (i.e. deposits, which are a transaction type that do not contribute to revenue)
|
This report provides a view of transaction totals per month, sorted by Transaction Type. This report can be used to compare how much money is being brought in vs. lost potential revenue + payments by month or a series of months.
|
|
Transaction Totals Per Week (by transaction type)
|
CSV
|
Report Headers: Center Name, Date, Transaction Type, Fee, Discounts, Early/Late, Subsidy, Credits, Debits, Payments, Totals, External ID
Filter by Center(s), Start Date, End Date with toggles to take into consideration Period Accounting and to include liabilities (i.e. deposits, which are a transaction type that do not contribute to revenue)
|
This report provides a view of transaction totals per week, sorted by Transaction Type. This report can be used to compare how much money is being brought in vs. lost potential revenue + payments by week/start date to end date.
|
|
Transaction totals per month
|
CSV
|
Report Headers: Center Name, Date, Fee, Discounts, Early/Late, Subsidy, Credits, Debits, Payments, Totals, External ID with a totals row.
Filter by Center(s), Start Month, End Month and Period Accounting
|
This report provides a high-level vantage point of transaction totals per month, consolidating all transactions into totals for Fees, Discounts, Early/Late fees, Subsidies, Credits, Debits, and Payments. While not as granular as the transaction type totals reports, you can use this report to gain a more general perspective on revenue vs. revenue lost.
|
|
Transaction totals per week
|
CSV
|
Report Headers: Center Name, Date, Fee, Discounts, Early/Late, Subsidy, Credits, Debits, Payments, Totals, External ID with a totals row.
Filter by Center(s), Start Date, End Date and Period Accounting
|
This report provides a high-level vantage point of transaction totals per week, consolidating all transactions into totals for Fees, Discounts, Early/Late fees, Subsidies, Credits, Debits, and Payments. While not as granular as the transaction type totals reports, you can use this report to gain a more general perspective on revenue vs. revenue lost.
|
|
Weekly Payroll
|
CSV |
Report Headers: Start of Week, End of Week, Center Name, Staff Last Name, Staff First Name, Employment Status, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Position, Training (hrs), Holiday (hrs), Total Worked (hrs), Paid Time Off (hrs), Unpaid Time Off (hrs), Total Paid (hrs)
Filter by Center(s), Start Date, End Date |
The Hourly Payroll report displays worked hours, training hours, holiday hours, paid and unpaid time off hours with totals for paid and unpaid hours by employee per week. This report can be utilized to keep track of and review your weekly payroll. |