These reports can be found on the "All Reports" page under the "Financial" tab.
⚖️ Cash Basis & Accrual GL
Click the arrow to learn more
Click the arrow to learn more
📋 What
Provides a detailed breakdown of all transactions by GL Code within a selected date range and location. Displays both cash basis and accrual basis totals side-by-side, helping you easily spot any differences.
🔑 Key features
Filter by specific GL codes to focus your view
See totals for cash, check, credit card, gift card, and other payment types
Difference column highlights any mismatch between cash and accrual totals
Displays product details grouped under each GL code for easy reference
Shows resident vs. non-resident pricing breakdowns (where applicable)
Products not assigned to a GL code are clearly labeled
Grand total shown at the bottom across all selected codes
Gift card transactions are excluded from grand totals to ensure accuracy
✅ When to use it
Perfect for financial audits, reconciliations, or reviewing program revenue across different payment methods and accounting methods.
💡 Pro Tip
Toggle between Cash Basis and Accrual Basis views to better align with your accounting method. Accrual shows income when earned, while Cash shows income when received — helping ensure accurate financial reporting for audits, taxes, and internal reviews!
🏫 Cash Basis by Class
Click the arrow to learn more
Click the arrow to learn more
📋 What
Provides a detailed financial breakdown for each class within a selected date range and location. Displays both accrual basis and cash basis amounts for easy comparison.
🔑 Key features
Filter by season, GL code, and location to refine results
Shows cash, check, credit card, and other payment types
Difference column highlights any mismatch between cash and accrual totals
Displays class details along with customer name and email for participant tracking
Organized by class name for a clear view of financial performance across programs
Grand totals calculated for a full financial snapshot
✅ When to use it
Ideal for tracking class revenue, reconciling payments, and monitoring enrollment-based financials.
💡 Pro Tip
Use this report to break down cash collections by class and GL Code for a specific date range. It's a great tool for reconciling deposits and making sure each class’s revenue is properly accounted for — especially during busy seasons!
🧑💼 Cash Basis by Customer
Click the arrow to learn more
Click the arrow to learn more
📋 What
Lists all financial transactions by customer name within a selected time period and location. Displays both accrual basis and cash basis totals per customer.
🔑 Key features
Filter by GL code, customer tags, or specific customer ID
Show Invoice Details option to display full, itemized invoice breakdowns
Includes important customer info like name and email for easy reference
Organizes transactions by customer, making it easy to track individual purchase history
Shows cash, check, credit card, and other payment types
Grand totals help summarize overall customer financial activity
✅ When to use it
Perfect for tracking customer payments, resolving billing questions, and reviewing detailed transaction histories for individual clients.
💡 Pro Tip
Use this report to track exactly which customers made payments within a specific date range. It’s especially helpful for troubleshooting billing questions, handling refunds, or verifying deposits tied to individual accounts!
📊 Category Sales
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Category Sales report provides a revenue or sales breakdown of all products grouped by their assigned categories and subcategories. It helps compare the performance of different types of products—like merchandise, rentals, or concessions—over a selected time period. You can run it by revenue (what’s been invoiced) or by sales (what has actually been collected).
🔑 Key features
Filter by:
Location(s)
Date Range and Time
Employee(s)
Program(s)
Optional display toggles:
Show sales instead of revenue (switch to show what has been collected)
Include Inactive Facilities
Include Team/Employee Credits
Displays results grouped by:
Category
Subcategory
Product
Clickable [Transactions] links to view full product-level detail in the Product Sales Report
Each row shows:
Product Name
UPC Code
Units Sold
Revenue or Sales Total by Location
Grand Totals at the bottom
✅ When to use it
Use this report to track how different product categories perform over time, especially for inventory forecasting, seasonal performance analysis, or sales comparisons. It's great for concessions, pro shop sales, rental tracking, and retail audits.
💡 Pro Tip
If you want to evaluate revenue over time, run the report with the “Show sales instead of Revenue” box unchecked to see what has been invoiced. To see only what's been paid, check the box to switch to a collected sales view. For more granular insight on a product category, click the [Transactions] link next to any item to jump directly into the Product Sales report. This is helpful when reconciling category totals with actual sales activity. Use CSV export if you plan to compare multiple time frames or share the breakdown by category with finance or inventory teams.
💳 Customer Credit
Click the arrow to learn more
Click the arrow to learn more
📋 What
Tracks customer credits that were transferred from one invoice to another. Helps clearly follow how credits were originally issued, where they were applied, and any notes added during the credit movement process.
🔑 Key features
Select a date range to view all credit usage within that period
See original credit invoice notes and the staff member who applied the credit
Optional columns let you toggle notes and show created by information for even deeper tracking
Quick access to linked invoices to verify credit source and application
Useful for resolving customer balance questions or investigating credit history
✅ When to use it
Ideal when researching account credits, validating transfers, answering customer inquiries, or auditing financial records.
💡 Pro Tip
Use the filters to narrow down by location or date range to quickly identify where outstanding credits exist. This helps with reaching out to customers for refunds, credit usage, or reconciliation before season closeouts!
🧭 Cross-Location Transactions
Formerly called "Intercompany report"
Click the arrow to learn more
Click the arrow to learn more
📋 What
This is a report that tracks payments collected at a location different from where the program or service actually takes place.
🔑 Key features
Identifies when staff process payments at the wrong location without adjusting their working location
Highlights customers who have a primary location on their profile but participate across multiple locations
Shows payment routing based on merchant accounts tied to transaction processing locations, not invoiced locations
Includes invoice details if the "Show Invoices" option is enabled for easier review
✅ When to use it
Helpful for catching and correcting cross-location payments to ensure accurate financial reporting and reconciliation across all your facilities.
💡 Pro Tips
Use this report regularly if you manage multiple merchant accounts or have staff working across sites — it’ll help you catch small mistakes before they turn into bigger accounting headaches!
🗓️ Dated Customer Account Credit
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Dated Customer Account Credit report provides a summary of all customer accounts that currently have a credit balance on file. In addition to listing the total credit available per customer, it shows the most recent activity for each account—such as the latest invoice or payment date—so you can identify inactive accounts with outstanding credits.
🔑 Key features
Filter by Latest Activity Date to return only customers who have not had activity since the specified date
Displays for each customer:
Customer Name (clickable to view the customer profile)
Latest Activity – the date of the most recent invoice or payment
Credit Balance – total unspent credit remaining on the account
Columns are sortable to help you easily rank by most credit or longest inactivity
Exportable to CSV or PDF for accounting use, audits, or customer outreach
✅ When to use it
Use this report when reviewing unused customer credit, especially for accounts with no recent activity. It's ideal for accounting audits, year-end reconciliation, preparing refund lists, or triggering outreach campaigns to re-engage inactive customers with credit on file.
💡 Pro Tips
Sort by Credit to prioritize large balances or by Latest Activity to find the longest inactive customers. You can leave the Latest Activity Date blank to view all customers with credit regardless of last action. Exporting to CSV makes it easy to create follow-up workflows or organize data for refunds and notifications.
🧾 Discount Report
Click the arrow to learn more
Click the arrow to learn more
📣 Want to learn how to set up and manage discounts?
Check out our Help Center article below to learn how to create, apply, and track discount codes in your system:
📋 What
The Discount Report displays all transactions where a discount was applied or reversed during a selected date range. You can search for all discount activity or narrow results by a specific discount code. This report helps track how discounts are being used across products, customers, and staff.
🔑 Key features
Filter by:
Specific Discount Code (or leave blank to show all)
Predefined Date Ranges or Custom Start/End Date and Time
Displays:
Date and Time of Transaction
Discount Amount
Invoice # (clickable)
Discount Code
Product Name
Customer Name
Employee who applied the discount
Results can be:
Exported to CSV or PDF
Sorted by column (e.g., Date, Discount, Employee)
✅ When to use it
Use this report to monitor how and when discounts are applied, ensure compliance with pricing policies, identify high-usage discounts, and reconcile discount activity with revenue or promotional goals. It’s especially helpful for financial audits, seasonal promotions, or staff oversight.
💡 Pro Tips
Use the Discount Code filter to track specific promotions like “Black Friday” or “Sibling Discount.” If you're auditing a particular program or product category, export the results and group them by product to see where discounts are most commonly applied. Combine with the Product Sales report to compare discount volume against total revenue for better margin analysis.
🗓️ Event Invoices
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Event Invoices report provides a transaction-level view of invoiced rental events. It includes event details such as customer, date, time, location, and financials (invoiced amount, amount paid, and balance due). It’s a helpful tool for auditing rental revenue and verifying that all events have been properly invoiced.
🔑 Key features
Filter by:
Date & Time Range
Location
Event Type
Customer (by name or Customer ID)
Optional: Hide Invoiced Rentals to view only uninvoiced events
Each row displays:
Event Type
Event Name (clickable to view full event details)
Day and Date
Start/End Time
Location and Resource
Invoiced Amount, Paid, and Balance
Export results to CSV or PDF for financial reporting or operational review.
✅ When to use it
Use this report to track which events have been invoiced and paid for, identify outstanding balances, or validate rental billing history. Ideal for finance, rentals, and operations staff needing a clear record of event-based revenue.
💡 Pro Tips
If you're auditing missed invoices, filter by date range and select "Hide Invoiced Rentals" to quickly spot unpaid or missed bookings. Clicking the event name opens the full event details so you can manually invoice directly if needed. Use the customer search field when following up with a specific group or organization about their account balance.
💼 Expense Tracking P&L
Click the arrow to learn more
Click the arrow to learn more
📣 Want to learn how to add and track expenses?
Check out our Help Center article below to learn how to use the roster-level expense tracking tool to monitor costs and profits:
📋 What
The Expense Tracking P&L Report helps you evaluate the financial performance of rosters by calculating revenue, expenses, gross profit, and profit margins. The data is grouped by season, level, and roster, and can include detailed breakdowns by expense type.
🔑 Key features
Filter by:
Location(s)
Season(s)
Level(s)
Roster(s)
Program(s)
Expense Type(s)
Start and End Date (required for data to generate)
Optional display toggles:
✅ Show Expense Type Column
✅ Show Expense Summary Tab
Each row displays:
Season, Level, and Roster
Revenue (from customer payments)
Expenses (entered through the Roster page)
Gross Profit and Profit Margin
Optional: Breakdown by Expense Type
Two tabs:
Expense Report (shows line-by-line data by roster)
Expense Summary (shows totals by season or level)
Exportable to CSV or PDF for financial reporting or internal use.
✅ When to use it
Use this report to track net profitability for individual rosters or full seasons. Ideal for operations or finance teams managing budgets for camps, classes, or team-based programs. Use it during mid-season reviews or end-of-season wrap-ups to identify which programs were profitable or over budget.
💡 Pro Tips
Always set your Start and End Dates to capture the full transaction range—these are required to pull accurate revenue and expense data. If you're reviewing performance by cost category (like equipment or coaching), enable Show Expense Type Column. Switch to the Expense Summary tab for a cleaner high-level snapshot of season-wide performance. Use CSV export for custom spreadsheet analysis or budget planning.
🎯 Free Trials Conversion Report
Click the arrow to learn more
Click the arrow to learn more
📣 Want to learn how to interpret your Free Trials data?
Check out our Help Center article below to explore how to track conversions from trial to paid registration and improve your programs:
📋 What
The Free Trials Conversion Report helps you evaluate how effectively your free trial classes convert into paid enrollments. It provides detailed stats at the season, level, and class/camp level, including total trials, attendance, conversions, and calculated conversion and attendance rates.
🔑 Key features
Filter by:
Location(s)
Season(s)
Level(s)
Classes/Camps
Free Trial Date Range (Min/Max)
Registration Date Range (Min/Max)
Display options:
Show or hide columns: Customer Details, Class/Camp, Level, Season, or Location
Results display:
Total # of Free Trials
Attendance Count
Conversions (number of paid registrations)
Total Rate = Conversions ÷ Total Trials
Att Rate = Conversions ÷ Attended Trials
Report includes rollups at:
Season Level
Level (e.g., Big Feet 5–6)
Individual Class/Camp
Exportable as CSV or PDF for deeper analysis or presentation.
✅ When to use it
Use this report to analyze the effectiveness of your free trial programs, evaluate instructor/class performance, and improve your conversion strategy. It’s essential for program managers, marketers, and enrollment teams seeking to increase retention from trials to paid registrations.
💡 Pro Tips
If you're running multiple trial types or testing seasonal marketing, use the Season and Date filters to isolate specific campaigns. Hide columns you don’t need to simplify exports. Pay close attention to classes with high attendance but low conversion—those may need follow-up, training, or adjusted messaging. Export results and share them with marketing teams to identify top-converting programs and plan future promotions.
📒 General Ledger (GL Report)
Click the arrow to learn more
Click the arrow to learn more
📣 Want to learn more about the GL Report?
Check out our Help Center article below to learn how to access and what this report can do.
If you're using the Split GL Code feature, be sure to run the separate General Ledger – Split GL Codes report instead.
📋 What
The General Ledger (GL) Report provides a detailed breakdown of revenue by GL Code across programs and locations. It shows all invoiced amounts during a selected date range and can be used to export financial data into accounting software. It also links directly to product setup pages and underlying transactions for auditing.
🔑 Key features
Filter by:
Location(s)
Program(s)
Predefined or Custom Date Range
Format Type for export (QuickBooks, Great Plains, Sage Intacct, etc.)
Optional format toggles:
Show Product Details
Include Team/Employee Credits
Show Inactive Facilities
Show Only Normal Team Invoiced Amounts
Displays:
Account (GL Code) and Description
Associated Program
Quantity
Total Debits and Credits
Clickable links to:
View underlying transactions
Open product setup page
Exportable as CSV or PDF for financial review, reconciliation, or import into third-party accounting platforms.
✅ When to use it
Use this report to prepare monthly financial summaries, reconcile accounting ledgers, and validate revenue attribution by GL Code. Ideal for finance staff, accountants, or bookkeepers preparing general ledger entries or financial packages.
💡 Pro Tips
Use the Format Type dropdown to match your accounting platform for smooth data transfers. If you want a deeper look into what’s driving each line, click the product link to access setup details or click the credit amount to open individual transactions. For program-specific views, filter by Program and export only what’s relevant. Enable Product Details for a more granular breakdown when needed for audit or planning.
🔄 Invoice Reversal
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Invoice Reversal Report displays details about invoice reversals, including original and reversed invoice numbers, amounts, associated line items, refund activity, and the employee who processed the reversal. It is primarily used for auditing and identifying potential issues such as over-reversals or unusual staff behavior.
🔑 Key features
Filter by location and date range to narrow the scope of the report.
Option to display only reversals greater than the original amount.
Shows detailed fields including:
Original and reversed invoice numbers
Invoice line item descriptions
Original billed amount
Reversed amount
Any refunds issued
Associated employee and customer
Exportable to CSV or PDF formats for audit logs or further analysis.
✅ When to use it
Use this report to audit staff invoice reversals for accuracy or potential misconduct, especially if you need to flag unusual patterns or suspicious activity. It’s helpful for identifying cases where more was reversed than originally billed, which may indicate errors or abuse. This report also supports investigation into billing discrepancies and helps ensure reconciliation records are accurate. Additionally, it allows you to confirm whether reversals were properly followed by refunds or left incomplete.
💡 Pro Tips
For easier identification of issues, use the “Only show reversals over original amount” option to filter the report to just the cases that may indicate errors or suspicious behavior. If you’re auditing specific staff activity, sorting the report by the Employee column can help you quickly isolate who processed which reversals. Keep in mind that reversed amounts appear as negative values, reflecting the amount that was removed from the original invoice.
🚫📅 Invoices Without Events
Click the arrow to learn more
Click the arrow to learn more
📋 What
This report lists all invoices that are not tied to a specific event, helping you identify standalone sales such as memberships, surcharges, or merchandise. These invoices are typically generated without linking to a class, camp, or session and may require special tracking for reconciliation, auditing, or follow-up.
🔑 Key features
Filter by:
Location
Date Range (limited to a 31-day window)
Product Type
Displays for each invoice:
Location
Invoice Number (clickable to view details)
Customer Name
Invoice Date and Time
Amount
GL Code and GL Code Description
Exportable as CSV or PDF for analysis or record keeping
✅ When to use it
Use this report when auditing revenue tied to product sales or fees that aren’t tied to scheduled events. It’s especially helpful during reconciliation or tax review periods, or when investigating unusual billing activity such as one-off memberships, facility fees, or administrative charges.
💡 Pro Tips
The report will only return results within a 31-day range, so break your search into monthly chunks for longer audits. Use the Product Type filter to isolate specific categories, such as “Memberships” which will have no events associated to it. If you’re reviewing GL accuracy, this report can help identify which non-event charges are contributing to revenue by GL Code.
📬 Open Invoices
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Open Invoices Report displays a list of all open invoices with an outstanding balance or remaining credit within a selected date range. These are transactions that have not been fully paid, canceled, or voided. This report helps staff monitor which invoices are still active and may require follow-up.
🔑 Key features
Filter by:
Location (required)
Start and End Date (required)
Optional checkboxes:
Show only generic customers: Restrict results to invoices assigned to the "Generic Customer"
Exclude Team Invoices: Remove invoices created for team registrations
Displays for each invoice:
Facility
Invoice ID (clickable to view invoice)
Date of creation
Current Balance (positive or negative)
Includes a running Total Balance at the bottom of the report.
Export options: CSV and PDF
✅ When to use it
Use this report to track unpaid or underpaid invoices for customers, camps, teams, or rentals. It’s ideal for front desk teams or billing staff conducting collections, audits, or cleanup of outstanding balances. Great for identifying which transactions require follow-up or potential write-off.
💡 Pro Tips
Enable Show Only Generic Customers to find quick-sale or kiosk transactions assigned without a specific customer. Use the Exclude Team Invoices option when you want to focus only on individual account billing. Run this report monthly to reconcile accounts receivable and follow up on aged balances. Export the list and sort by balance to prioritize the highest-value open invoices.
🧾 Payment Batch Report
Formerly called "ACH/Credit Card Batch Report"
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Payment Batch Report provides a list of payment batches processed through your credit card and ACH payment providers. It displays the batch ID, total batch amount, the time of the first and last transactions within the batch, and which provider processed the payments.
This report consolidates what used to be two separate reports (ACH Batch and Credit Card Batch) into one easy-to-use view.
🔑 Key features
Select a location to view batch activity for a specific site.
Filter by specific payment providers if you use multiple processors.
Choose which type of payments you want to see (ACH, Credit Card, or Both).
View first and last transaction times for each batch to help with reconciliation.
Export the report to CSV or PDF for easy accounting and record keeping.
Option to display inactive payment providers for historical searches.
✅ When to use it
Use the Payment Batch Report when reconciling bank deposits with payment batches from providers such as CardConnect or GoCardless. It’s helpful when investigating discrepancies between the payments recorded in your system and the actual deposits received. This report is also valuable for reviewing the timing of batches when finalizing end-of-day or end-of-month financials. Even if a payment provider is no longer active, you can still run historical reports to maintain a complete financial audit trail.
💡 Pro Tips
If you have ACH enabled, the "Record Type" dropdown lets you easily toggle between credit card batches, ACH batches, or view both together for a full picture. You may notice some batch IDs display as "N/A"—this is typical for ACH providers like GoCardless, which don’t batch transactions the same way as credit card processors. If the batch amount doesn’t align perfectly with your deposit, it’s worth checking if multiple batches were grouped into a single deposit. And for deeper financial analysis, always export to CSV so you can sort by batch, provider, or transaction time, or use pivot tables to organize your insights.
💸 Refund Report
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Refund Report provides a detailed view of all refunds processed within a selected date range. It lists customer names, refund dates, refund amounts, payment types (cash, check, or credit), payment notes, and customer addresses.
You can filter the report based on refund type and location.
🔑 Key features
Filter by location to focus on refunds from a specific site.
Select the refund types you want to display: cash, check, or credit card refunds.
View the original payment type associated with each refund.
See any refund notes added on the invoice to explain the refund reason.
Export the data to CSV or PDF for easy tracking and financial reconciliation.
Search for specific customers within the report using the search bar.
✅ When to use it
Use this report to review all refunds issued during a specific billing period and verify refund amounts and payment methods for accounting reconciliation. It’s also valuable when investigating refund-related notes added to invoices, which can be helpful for customer service follow-up or audit trails. Additionally, the report can serve as a historical record of refund activity for internal reporting or submission to external auditors.
💡 Pro Tips
For a complete view of refund activity, make sure to check all three refund types—Cash, Check, and Credit—when generating the report. The Payment Note column is especially useful for quickly identifying the reason behind each refund without needing to open individual invoices. If you're managing refunds across multiple locations, filtering one location at a time will provide a cleaner, more organized report. Exporting to CSV is ideal when you want to sort, group, or calculate totals by payment type, customer, or reason code.
🏠 Resident Pricing
Click the arrow to learn more
Click the arrow to learn more
Important: This report is only available if GIS Mapping is enabled and properly set up in your Company Settings.
Want to learn more about Residential Pricing?
📋 What
The Resident Pricing Report displays how much residents have saved compared to non-resident pricing across all products.
You can select a specific past date range to view detailed invoice data, including individual product discounts and a grand total of all resident savings.
🔑 Key features
Filter by location to view resident savings for a specific site.
Select any date range to view historical or recent savings.
See individual invoices tied to each product.
View the discount quantity and discount total for each product.
See a grand total at the bottom of the report summarizing all resident discounts.
Export the report to CSV or PDF for easy sharing or further analysis.
✅ When to use it
Use this report to review how much residents are saving over time compared to non-resident pricing. It’s ideal for analyzing the financial impact of your discount strategy and evaluating how those resident savings contribute to accessibility goals or funding requirements. This report also serves as strong supporting documentation for grant reports, city council presentations, or internal audits. Additionally, it allows you to verify that resident discounts are being properly applied across programs.
💡 Pro Tips
Be sure to select the Show Invoice Details option if you want invoice numbers to appear alongside each product entry. The search bar is especially helpful for quickly locating specific products or invoices within a long list. For more advanced analysis or visualizations of resident versus non-resident savings, export the data and work with it in Excel or other reporting tools.
🏕️ Sales by Camp
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Sales by Camp report displays sales of camp products at a selected location, based on the invoice date.
🔑 Key features
Filter by Location and Camp Season(s): Choose one or multiple camp seasons to view sales specific to different programs.
Set a Date Range: Focus the report on a custom time window to track seasonal or session-based performance.
Camp-Level Totals: Different sessions of the same camp are grouped together and subtotaled at the Level line for easier tracking.
Detailed Financials: See billed amounts, discounts applied, and the total due for each camp session and level.
Export Options: Download your report results as CSV or PDF for easy review, sharing, or analysis.
✅ When to use it
Use this report to review total sales and participation for each camp season and camp level. It’s helpful for identifying which camps are performing best in terms of both revenue and enrollment. You can also track how discounts are applied across different camp sessions to evaluate pricing strategies, and analyze financial trends by session and level to support planning and forecasting for future seasons.
💡 Pro Tips
If you're overseeing multiple facilities, the Group by Location option will help you keep the data clearly separated and easier to interpret. Expanding the Level rows will allow you to review detailed performance metrics for each individual camp session. To include past or canceled camps in your reporting, enable the Include Inactive Camps option. When you need more flexibility for filtering or deeper analysis, export the data to a CSV and work with it in Excel or Google Sheets.
📚 Sales by Class
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Sales by Class report displays sales of class registration types at a selected location, based on the invoice date.
🔑 Key features
Filter by Location and Class Season(s): Choose one or more seasons to view sales for specific programs.
Set a Date Range: Focus your report on a custom time period to review seasonal or session-based performance.
Class-Level Totals: Different sessions of the same class are grouped together and subtotaled at the Level line for easy tracking.
Detailed Financials: See billed amounts, discounts given, and the total due for each class session and level.
Export Options: Download results as CSV or PDF for easier sharing or further analysis.
✅ When to use it
Use this report to review total sales and participation for each class season and level. It helps you identify which classes or levels are generating the most revenue and lets you monitor how discounts are applied across different sessions and programs. This is especially useful for analyzing financial performance at both the class and session level, supporting more accurate reporting and future program planning.
💡 Pro Tips
If you're managing multiple facilities, use the Group by Location option to keep your data organized and easier to read. You can expand the Level sections to view performance for individual class sessions when you need more detail. Enable the Include Inactive Classes filter to pull in historical or canceled sessions for more comprehensive reporting. For advanced analysis, export the data to CSV and work with it in tools like Excel or Google Sheets.
🧑💼 Sales by Employee
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Sales by Employee report displays all transactions processed by employees during a selected date range. It organizes payments by employee and provides full visibility into each transaction’s details—including the associated invoice, customer, payment type, and transaction amount. This is especially helpful for sales tracking, payroll commissions, or auditing employee activity.
🔑 Key features
Filter by:
Location
Start and End Date
Displays for each employee:
Payment ID (used for auditing, matches what appears in the Employee Audit Log)
Invoice ID (clickable to view invoice details)
Customer Name and ID
Payment Type (e.g., Visa, MasterCard, Cash)
Authorization Code
Date and Time of Payment
Transaction Amount
Summary section totals sales by payment type per employee
A final Grand Total row appears at the bottom of the report for all employees
Exportable as CSV or PDF for financial tracking, staff accountability, or reporting
✅ When to use it
Use this report to monitor employee sales activity, track performance-based pay, or verify transaction history. It’s ideal for daily reconciliations, shift audits, and commission-based evaluations across your front desk or sales team.
💡 Pro Tips
Use the Payment ID to cross-reference transactions in the Employee Audit Log for deeper investigation. Running the report for shorter time frames (e.g., daily or weekly) can help with shift-level performance reviews. If your facility uses multiple payment types, the totals by type section is helpful for reconciling by card or cash drawer.
⏱️ Sales by Per Session
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Sales by Per Session report tracks sales activity for programs based on the actual event dates rather than invoice dates. It’s designed for programs like drop-in activities or camps where each session occurs on a specific day. The report displays the number of customers, total revenue, discounts given, net sales, and pass usage for each event date.
🔑 Key features
Filter by location, season, event date range, day of the week, event start and end times, and more.
Additional options to show pass usage, purchase orders, day of the week, and event time.
Organized by Location → Season → Level → Group → Event Date for clear, drill-down reporting.
Provides a detailed view of:
Number of customers per session
Total revenue generated
Discounts applied
Net sales after discounts
Passes used for sessions (if applicable)
Exportable to CSV or PDF formats for external analysis.
✅ When to use it
Use this report when you need to analyze revenue based on when events actually occur, rather than when invoices are paid. It’s especially useful for tracking daily attendance and evaluating financial performance for seasonal programs like camps or drop-ins. You can also use it to review how discounts and pass usage affect sales totals across specific dates, and to manage staffing or operational needs based on real-time attendance trends.
💡 Pro Tips
Set both an event date range and specific start/end times to focus your report on the exact sessions you want to review. If you're looking for patterns in attendance or revenue, enable the "Show Day of Week" option to spot high-traffic days more easily. Keep in mind that Sales by Per Session differs from Sales by Camp—this report tracks revenue based on event dates, while Sales by Camp is tied to payment dates. For deeper insight or filtering by session, export your report to Excel and sort by date or revenue totals.
🏅 Sales by Team
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Sales by Team report displays detailed invoice and payment activity for teams within a selected season and time frame. It includes amounts billed, payments received, employee or other credits, discounts, scholarships, and the final balance due for each team.
🔑 Key features
Filter by location, season, and date range to customize the report view.
Choose to display normal teams, individual teams, and inactive teams.
See a breakdown of:
Total amount billed
Payments received
Credits (such as employee discounts or account credits)
Additional discounts and scholarships
Final balance due after all adjustments
Group results by location and view season or team-level details.
Export the report to CSV or PDF for easier sharing or record keeping.
✅ When to use it
Use this report when you need to track outstanding balances for teams during or after a season, review payment activity to ensure billing accuracy, and monitor how much was credited through employee benefits or other promotions. It’s also helpful for analyzing the total billed versus payments collected for a specific league or individual teams, making it a valuable tool for financial oversight and seasonal reconciliation.
💡 Pro Tips
Make sure to set both a start and end date to narrow down the transaction activity you want to review. Enabling the “Show Season Detail” and “Show Credit Detail” options can help you gain more granular insight into invoice adjustments and credit usage. Keep an eye on the Due column to quickly spot teams with remaining balances after discounts, credits, or partial payments. If you need to filter or analyze the data further, exporting the report to CSV will allow for easier manipulation in Excel.
💲 Sales Report
Also known as the Daily Sales & Receipts Report
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Daily Sales & Receipts Report tracks all payments made during a specified time period. It includes details such as payment type, refunds/reversals, and credits given. This report provides a payment method breakdown and itemized transaction list, making it ideal for daily reconciliation or accounting exports.
🔑 Key features
Filter by:
Location(s)
Predefined or Custom Date & Time Range
Dollar Range (min/max)
Payment Type (e.g., Cash, Check, Credit Card)
Payment Provider
Employee(s)
Options include:
Include Refunds/Reversals
Include Team/Employee Credits
Separate by Credit Card Type
Show Payment Notes
Show Tax-Exempt Sales Only
Show Credit Card Transaction IDs
Results display:
Payment breakdown by method (Cash, Check, Credit Card, etc.)
Reversal totals (e.g., Credit Card Reversal)
Grand Total and Credit Card Total
Line-item detail: Date, Amount, Type, Invoice (clickable), Customer, Employee, and Location
Export Options: CSV or PDF
Print Options: 4AM Drop or Standard Print
✅ When to use it
Use this report daily to reconcile what was paid versus what was deposited. It's especially helpful for finance teams managing cash drawers, monitoring online vs. in-person payments, or verifying refunds. This is your go-to end-of-day financial check-in tool.
💡 Pro Tips
Online transactions will appear under the employee name “dash.” Use the Separate by Credit Card Type option to get totals by card brand (Visa, Mastercard, etc.). If your organization tracks tax-exempt sales, enable the Show Tax-Exempt Sales Only filter for compliance or audit review. Export to CSV and group by employee to track register activity for shift closings.
🧮 Sales Tax
Click the arrow to learn more
Click the arrow to learn more
Each product needs to have a GL Code, Program Name and Tax Rate assigned to it in order to appear on the report.
The sales tax report is a calculation on total sales. It doesn't take into account penny rounding, complete allocations, or tax exempt customers. Refer to the Cash Basis & Accrual to account for this detail.
📋 What
The Sales Tax report provides a detailed breakdown of sales and tax activity across various tax categories. It’s designed to help staff prepare sales tax returns by showing the total number of taxable transactions, total sales amounts, and the exact tax applied per product or service. The report can be filtered and grouped by multiple dimensions for precise reporting.
🔑 Key features
Filter by:
Location
GL Code
Program
Tax Type
Date Range (Start and End Dates)
Displays for each product:
GL Code and Description
Product Name
Program Name
Quantity Sold
Sales Amount and Tax Collected per applicable tax category (e.g., State/Municipal Tax, Party/Service Fees)
Organized by tax type columns, each with its own Sales and Tax total
Final Total column summarizes overall sales and tax amounts per product
Bottom of the report includes:
Total per Tax Category
Grand Total for All GL Codes (combined Sales and Tax)
Exportable as CSV or PDF for tax filing, finance team review, or auditor requests
✅ When to use it
Use this report when preparing sales tax returns, reconciling tax collected by type, or analyzing how much tax was charged for specific product categories. It’s ideal for accounting, finance, or compliance teams needing to report monthly, quarterly, or annual sales tax details.
💡 Pro Tips
Filter by specific GL Codes or Programs to isolate particular services, like concessions or party rentals. Use the Tax Type filter to drill into one specific surcharge or jurisdiction. Scroll to the bottom of the report for a quick snapshot of total revenue and taxes across all included categories. Export to CSV when you need to submit detailed totals for reporting or when working with an external accountant or tax preparer.
📆 Scheduled Payments
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Scheduled Payments Report displays all scheduled and processed payments within a selected date range. It includes payment results—such as success, failure, or skipped—and lets you filter by customer, result code, and payment type. This report helps track the status of recurring or scheduled payments tied to open invoices.
🔑 Key features
Filter by:
Location
Date Range or Predefined Date Range
Display Payment Type: Scheduled, Processed, or Both
Specific Customer Name or ID
Processed Payment Result Code:
Success
Failed
Bad Payment Information
No Payment Information
Other
Results include:
Payment Date and Amount
Customer (clickable to profile)
Phone and Email
Invoice Number (clickable)
Result Code (e.g., SUCCESS, FAIL, OTHER)
Result Message for more detail (e.g., “Not sufficient funds”)
Type: Scheduled vs. Processed
Exportable to CSV or PDF for reconciliation or follow-up.
✅ When to use it
Use this report to review payment activity tied to recurring billing or autopay setups. It’s especially helpful for membership teams, billing staff, or financial administrators following up on failed or skipped charges. You can monitor which scheduled payments succeeded or failed and why—making this a vital tool for reducing outstanding balances.
💡 Pro Tips
Use the “Result Code” filter to quickly isolate failed payments or bad payment info for follow-up. If a customer’s invoice shows a result message like “Skipping invoice because it has a zero balance,” that indicates the system auto-suppressed the payment. Export failed transactions to CSV to share with your billing team or set reminders for retrying payments.
🧾 Tax Deductible Payments
Formerly called "Child Care Statement"
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Tax Deductible Payments report (formerly called the "Child Care Statement") shows payments made toward products marked as tax deductible. It displays invoiced customers, customer IDs, emails, participant details (including siblings if applicable), payment dates, invoice numbers, tax ID (if set up), program names, products, and total allocated amounts.
🛠️ Initial Setup (required before running the report)
To ensure products appear correctly as tax deductible:
Go to Products via the global search.
Find and open the product (e.g., camp fees, program tuition).
Toggle the Tax Deductible option ON.
(Optional) Add your Company Tax ID under Company Settings → Locations so it shows on reports if desired.
Without this setup, payments toward those products won't be flagged or pulled into the report.
🔑 Key features
Filter by start and end date to capture payments made within a specific timeframe.
Search by invoiced customer or participant to find all relevant transactions.
Select specific programs or include all eligible tax-deductible programs.
Option to display the Tax ID if configured in the Location Company Settings section and if "Show Tax Info" is enabled.
Ability to show invoiced customer email for easier family tax records.
View details for multiple participants (siblings) under the same parent account.
Export results to CSV or PDF for sharing or saving records.
✅ When to use it
Use this report when families request a breakdown of their tax-deductible payments for personal or tax filing purposes. It's especially useful for camps, childcare, and other programs where payments may qualify for tax credits or deductions.
💡 Pro Tips
Be sure to enable the "Show Tax Info" option in the report settings if you want the organization's Tax ID to appear—this must also be configured in the location’s company settings. If a parent has paid for multiple siblings, including their name in the report can help families easily track all applicable payments in one place. Keep in mind that if no products have been marked as tax-deductible, the report will return no results, so it's important to complete the product setup first. When families request documentation for tax filing, export the report to generate an official statement for their records.
📋 Team Summary Report
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Team Summary Report provides a high-level overview of team activity, including financials and scheduled games, within a specific date range. It summarizes how many games were scheduled during the full season versus how many occurred during the selected time window, along with billed revenue and league details.
🔑 Key features
Filter by Location and Date Range to see which games and financials fall within your reporting window.
Displays sortable columns for:
Facility, Season, and League
Season Start/End Dates
GL Code (general ledger mapping)
Billed Amount
Total Scheduled Games
Games Played During Date Range (e.g., Dec–2024)
Exportable to CSV or PDF for reporting or reconciliation
Easy to scan and compare game counts and billing performance across leagues
✅ When to use it
Use this report to review how active each league or program has been during a specific period, especially during mid-season or month-end reporting. It’s ideal for finance teams, program directors, or facility managers tracking revenue by league or verifying game fulfillment during a season.
💡 Pro Tips
Use the date range filter to zero in on activity within a particular month or week and compare it to the full season’s expectations. This is especially helpful for seeing if games are on track to finish or if weather or cancellations have caused delays. If your organization uses GL Codes for accounting, this report provides a clean summary of totals billed per program. Export the report to CSV to sort and total data across multiple programs or seasons for budget prep or board review.
🏆 Top Sales by Employee
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Top Sales by Employee report ranks staff members by their total sales over a defined date range. It visually displays the top 10 sellers in a horizontal bar chart and distinguishes between employee-driven transactions and automated ones (like online or scheduled payments). This report is ideal for tracking sales performance or evaluating team contributions.
🔑 Key features
Filter by:
Start Date and End Date (Month and Year)
Optional checkbox to exclude online registrations (from users like
dash
orarenabot
)
Displays:
A ranked horizontal bar chart of the top 10 employees by total sales
Employee legend with color-coded indicators
dash = Online transactions
arenabot = Scheduled payments or automated billing
Named users = In-person or admin-processed sales
Use the “Exclude Online Registrations” option to filter out transactions not completed directly by a staff member.
✅ When to use it
Use this report when evaluating staff performance, managing incentives, or identifying high-performing team members in sales roles. It’s also helpful for comparing front desk activity, tracking seasonal sales spikes by employee, or monitoring how much online vs. in-person business your team is handling.
💡 Pro Tips
Use the “Exclude Online Registrations” checkbox to get a clearer view of employee-driven sales. The legend helps you spot whether high totals are due to actual employees or automated accounts. For better historical analysis, run this report quarterly or annually and compare team trends over time.
🔍 Transaction Search
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Transaction Search report allows you to look up individual credit card transactions by entering a unique ID—such as the Transaction ID, PNRef (payment network reference), or Order ID. It’s designed to help staff quickly locate specific payments for verification, refund processing, or reconciliation purposes.
🔑 Key features
Search by:
Transaction ID
PNRef
Order ID
Results display:
Invoice ID (clickable to view full invoice)
Transaction ID
Transaction Date and Time
Payment Type (e.g., Credit)
Last 4 digits of the credit card used
Amount paid
Employee who processed the transaction
This tool is often used by finance staff or customer service teams when resolving payment disputes or verifying a card payment’s status.
✅ When to use it
Use this report anytime you need to confirm the details of a credit card transaction. It’s especially useful when a customer provides a transaction reference from their credit card statement, or when you need to verify a refund, reversal, or completed charge.
💡 Pro Tips
You don’t need a full invoice or customer name to find a transaction—just the transaction ID provided by your processor. Use this tool to troubleshoot payment issues, locate disputed charges, or verify that a refund was correctly issued. If you’re dealing with large volumes of transactions, store reference IDs temporarily in case customers call with questions.
📊 Transaction Summary Report
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Transaction Summary Report provides a high-level breakdown of all financial transactions that occurred within a selected date range. It groups data by payment type (cash, check, credit card) and highlights any staff-applied or employee-specific credits. This report is designed to summarize volume and totals across payment channels.
🔑 Key features
Filter by:
Start and End Date & Time
Predefined Ranges (monthly, quarterly, etc.)
View:
Number of transactions per payment type
Amount processed per payment method (cash, check, credit card)
Employee credit totals
Optional credit totals (manually added credits)
Each row shows:
Payment Type (e.g., Credit (Cash), Credit (Check), Employee Credit)
Number of transactions
Total amount processed
✅ When to use it
Use this report to review financial activity over a set period and reconcile transaction counts and amounts by payment method. It’s especially useful for accounting teams doing monthly closeouts or reconciling end-of-day reports, as well as for identifying staff-applied credits.
💡 Pro Tips
Use this report alongside your Daily Sales Report or GL Report to verify transaction volumes match your deposit totals. Pay attention to “Employee Credit” and “Optional Credit” rows—these represent non-standard payments that may need additional validation. Run it monthly to build consistent financial snapshots for internal tracking or audits.
📆 Unearned Revenue - Booking Event
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue – Booking Events report displays earned and unearned revenue for rental or booking-based events, broken down by month for each booking. It uses accrual accounting logic, recognizing revenue as events occur rather than when payment is collected. This report helps you understand how contract revenue is spread over time, with visibility into each month’s financial activity.
🔑 Key features
Filter by:
Location
As Of Date to determine the financial snapshot point
Optional checkboxes:
Show Other Months to include all months for long-term or multi-month bookings
Show GL Details to display associated GL codes for each line item
Displays for each booking:
Booking Name (clickable to view booking)
Number of Events Total and per Month
Month and GL Code
Unearned Revenue Opening, Invoiced, Total Revenue
Earned Revenue for the selected month
Unearned Revenue Closing balance
Highlighted rows indicate the As Of Month, helping you pinpoint your reporting window
Subtotals are grouped per booking and summarized by location
Exportable as CSV or PDF for reconciliation, deferred revenue schedules, or audit prep
✅ When to use it
Use this report when analyzing revenue recognition for rental contracts, especially those that span multiple months. It’s ideal for month-end close, audit support, or forecasting how revenue is earned across future bookings. It also helps verify how much of your booked revenue is still unearned and will be recognized in the coming periods.
💡 Pro Tips
Enable Show Other Months to get the full story behind recurring or long-term bookings—this is critical for multi-month field rentals or recurring space contracts. Use the highlighted row to quickly locate data tied to your selected As Of Date. Export the report to CSV for combining data across locations or to build custom deferred revenue projections.
🎒 Unearned Revenue - Camp
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue – Camp report provides a month-by-month revenue breakdown for each camp session, highlighting how billed amounts transition into earned and unearned revenue. It is built for accrual accounting and offers insight into how camp revenue is recognized over time rather than all at once.
The report displays key financial indicators per session, such as billed amount, unit price, discounts, and session-level earned and unearned revenue, all tied to the assigned product and GL code. When "Show Other Months" is selected, the report expands to include a fuller picture of the season’s activity across time—including opening balances, monthly earned revenue, and closing unearned revenue.
🔑 Key features
Filter by Location, Camp Season, and As Of Date
Displays:
Session name, Product name, and GL Code
Unit Price, Billed amount, Discount, and Net Billed
Monthly revenue earned based on participation
Opening Unearned Revenue, Total Invoiced, Earned, and Closing Unearned Revenue
A season total line aggregates all session-level data for easy comparison
Grey highlighting indicates the "As Of Month", helping you visually anchor the current reporting period
Toggle Show Other Months to view full-season revenue distribution and track how pre-paid revenue is earned across future months
Exportable to CSV or PDF for financial reporting, reconciliation, or board reporting
✅ When to use it
Use this report when closing out monthly books, preparing financial statements, or analyzing how much camp revenue remains to be earned. It's especially useful for finance and accounting teams that follow accrual-based revenue recognition for multi-session programs.
💡 Pro Tips
Enable Show Other Months to access a complete view of how revenue flows across the entire season—this is key when reconciling deferred income. Use the total season line for high-level performance tracking and budget comparison. Grey-shaded rows help you quickly locate data for the selected As Of Month, and you can export to CSV to pivot or calculate across months and sessions as needed.
🏫 Unearned Revenue - Class
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue – Class report tracks unearned and earned revenue for classes over time. This report adheres to accrual accounting principles—revenue is considered "earned" only when a class occurs, not when payment is received. It breaks down unearned revenue by class level and product for the selected season and reporting month.
🔑 Key features
Displays class revenue based on held sessions, not just payments received.
Shows invoiced totals, earned revenue, and unearned revenue closing balances.
Organizes data by location, season, level, product, and GL Code.
Highlights the current reporting month in grey for easy reference.
The “Show Other Months” option lets you view the entire season’s monthly breakdown.
Aggregates totals for each level, season, and product used in that level.
✅ When to use it
Use this report when you want to see how much revenue has been earned versus how much remains unearned for scheduled classes during a season. It's especially helpful for finance teams performing month-end close, tracking deferred revenue, or ensuring proper revenue recognition over time. You can run this across all locations and filter by specific class seasons.
💡 Pro Tips
Turn on the "Show Other Months" option to display the full revenue distribution over the entire season, not just the "As Of Date" month. This gives you a clearer understanding of how income is spreading out across time. If you're reviewing season closeouts, verify that the unearned revenue closing balance is $0.00 by the end of the last month in the season—this indicates all classes have been held and revenue has been fully earned.
✅ Example with “Show Other Months” On
⬜ Example with “Show Other Months” Off
📊 Unearned Revenue Summary - Class
Formerly called "Class Unearned Revenue Summary (visual)"
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue Summary – Class report (previously "Class Unearned Revenue Summary (visual)") presents earned, unearned, and invoiced class revenue in a visual, bar graph format. This report helps quickly compare financial distribution by either location or season based on selected class seasons and “as of” date.
🔑 Key features
Displays visual summaries of class revenue broken into earned, unearned, and invoiced amounts.
Includes two tabs:
By Location: Compares revenue breakdown per location.
By Season: Compares revenue breakdown per class season.
Color-coded bar graphs make it easy to identify discrepancies or trends.
Useful for quick financial snapshots and performance tracking by location or season.
✅ When to use it
Use this report when you need a high-level visual summary of your class-based revenue metrics. It's especially helpful for quickly comparing financial progress across facilities or program seasons, understanding how much revenue has been recognized (earned) vs. deferred (unearned), and making informed decisions based on those insights. This is ideal for directors, finance teams, or regional managers reviewing multiple class seasons or facilities at once.
💡 Pro Tips
Use the As of Date to capture revenue values at a specific point in time, such as the end of a month or financial quarter. Switching between the By Location and By Season tabs gives you different context—ideal for operational decision-making or multi-program financial comparisons. If the bar spacing feels tight, hovering over each segment reveals exact values for earned, unearned, and invoiced amounts. For a deeper dive, pair this summary report with the detailed Unearned Revenue – Class report to get session-level breakdowns by product, level, and season.
🏢 By Location Tab Example
📆 By Season Tab Example
🥳 Unearned Revenue - Event & Rental
Click the arrow to learn more
Click the arrow to learn more
📋 What
This report provides a detailed breakdown of revenue that has been invoiced but not yet earned as of a selected date. It groups transactions by GL Code and shows customer names, event details, invoice dates, and total unearned revenue associated with events or rentals that are scheduled in the future.
🔑 Key features
Filter by location, event type, GL code, and an “As Of” date to define the reporting scope.
Toggle “Show Event Details” to include or exclude specific customer names, event descriptions, invoice numbers, and event dates.
Displays:
GL Code and description
Customer and event information
Invoice numbers and dates
Event dates associated with unearned amounts
Total amount of unearned revenue per GL Code
Automatically calculates a GL total per code and a grand total at the bottom.
Exportable to CSV or PDF.
✅ When to use it
Use this report when you need to track and report on revenue that has been billed for future events but not yet recognized. It's especially helpful for finance and accounting teams during month-end closeouts, audits, or when following revenue recognition standards for deferred income.
💡 Pro Tips
To get a clear picture of future obligations, use the “As Of” date to freeze the report at a specific point in time—great for accounting snapshots. If you want to see granular activity, enable the “Show Event Details” checkbox to include the full breakdown of individual events, customers, and invoice dates. You can also limit the report to specific event types or GL codes for targeted analysis.
📇 Unearned Revenue - Membership
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue – Membership report provides a comprehensive, multi-tab view of total, earned, and unearned revenue for all membership types across the last 12 months. It aligns with accrual accounting principles, where revenue is earned over time rather than at the point of sale. This report consolidates all membership products into one report, making it ideal for financial oversight and audit preparation.
🔑 Key features
Filter by Location and choose an As Of Date to define the trailing 12-month view.
Include Inactive Memberships option lets you display data for discontinued or currently inactive membership products.
The report is divided into four tabs for flexible review:
All Data – Shows total, earned, and unearned revenue in one combined view for each membership product and GL Code.
Membership Revenue – Displays total revenue per month, broken down by membership product.
Earned Membership – Shows monthly revenue that has been recognized (earned) for each membership type.
Unearned Membership – Displays deferred revenue that has not yet been earned, reflecting future service periods.
Each table includes:
Membership Name
GL Code
Monthly revenue data for the previous 12 months
A Total column that sums the revenue across the full period
Interactive functionality:
Clicking a membership name in the “Membership Revenue” or “Unearned Membership” tab opens the Unearned Revenue – Membership – Month Detail report.
Clicking an earned amount in the “Earned Membership” tab opens the Earned Revenue – Membership – Customer Detail report.
Export options include CSV and PDF for use in audits, financial statements, or internal planning.
✅ When to use it
Use this report during month-end or year-end close, for revenue recognition tracking, or when performing internal or external financial audits. It’s also a great tool for forecasting and analyzing how different membership types are contributing to recognized and deferred revenue streams over time.
💡 Pro Tips
Set the As Of Date to the last day of your reporting month for a complete trailing-year picture. Use the All Data tab for a high-level financial snapshot, and then drill into the Earned or Unearned tabs for deeper investigation. If you're validating deferred revenue, the Unearned Membership tab is especially helpful when comparing accrual balances. Use the Membership Revenue tab for a cash-based view of when membership sales were invoiced.
📊 All Data Tab Example
📈 Membership Revenue Tab Example
💰 Earned Membership Tab Example
⏳ Unearned Membership Tab Example
📅 Unearned Revenue - Membership - Month Detail
Formerly called "Details Unearned Revenue - Membership"
Click the arrow to learn more
Click the arrow to learn more
📋 What
This report provides a monthly, accrual-based breakdown of total, earned, and unearned revenue for a specific membership product over the trailing 12-month period. It reflects when revenue is actually recognized—not just when it was collected—making it a powerful tool for finance teams using accrual accounting principles.
🔑 Key features
Filter by Location, Membership Product, and an As Of Date (Month and Year) to control the trailing 12-month window.
Revenue is grouped by month and displayed across three tables:
Monthly Revenue by Period – shows actual revenue activity per calendar month
Unearned Revenue Table – shows revenue still deferred for future months
Earned Revenue Table – shows revenue recognized for each month
Each row represents a month in the trailing year from the selected "As Of" month.
Monthly buckets display breakdowns by GL code where applicable.
A Total column summarizes the accumulated revenue for each category across the year.
Export options include CSV and PDF formats for reporting or auditing purposes.
✅ When to use it
This report is best used by finance and accounting teams during month-end close, revenue recognition, and budget forecasting. It provides full transparency into how membership fees are spread over time, helping teams align revenue with service delivery periods.
💡 Pro Tips
Always ensure your “As Of” month/year reflects the end of the period you want to analyze—this controls the trailing 12-month display. Use this report to reconcile monthly revenue or audit deferred income. If you're reporting across multiple locations or membership types, generate separate versions by adjusting the Product filter.
💰 Earned Revenue - Membership - Customer Detail
Formerly called "Unearned Memberships Detail"
Click the arrow to learn more
Click the arrow to learn more
📋 What
This report provides a customer-level breakdown of earned revenue for a selected membership product over the past 12 months, as of a specific date. It lists every customer whose membership includes the "As Of" date, along with purchase history and monthly earned amounts, following accrual-based revenue recognition.
🔑 Key features
Filter by Location, Product, and As Of Month/Year to set the 12-month reporting window.
Displays the following for each qualifying customer:
Invoice ID (clickable for quick reference)
Customer Name
Purchase Date – the original start date of the membership (may be years prior if renewed)
Expiration Date – the current end date of their active membership
Price – the total cost of the membership
Earned – the amount of revenue earned up through the selected "As Of" month
Earned Per Month – the monthly accrual amount based on the total price
Exportable to CSV or PDF for reconciliation, audit support, or customer inquiries.
✅ When to use it
This report is ideal for finance teams looking to validate earned revenue at the customer level or for auditors needing to trace revenue recognition back to individual memberships. It's also helpful when researching renewal patterns, especially when purchase dates are several years in the past.
💡 Pro Tips
Use the As Of Month/Year filter to analyze a specific month-end for revenue tracking. If you're reviewing older, renewed memberships, the Purchase Date may appear several years prior—this reflects the original sale, not necessarily the most recent renewal. Export to CSV when comparing historical trends or running reconciliations across multiple customers.
🧢 Unearned Revenue - Team
Click the arrow to learn more
Click the arrow to learn more
📋 What
The Unearned Revenue – Team report provides a detailed, accrual-based view of team revenue for league-based programs. Instead of reporting revenue when payments are received, this report reflects revenue as it is earned over time, specifically when games are held. It breaks down the financial activity for each team by month, product, and league level, with the option to view the full revenue timeline for the entire season.
🔑 Key features
Filter by:
Location
Team Season
As of Date
Optional checkbox:
Show Other Months to display the full season’s monthly activity, including historical and future values
Displays per team level:
GL Code, Product Name, and Level Name
Month and Number of Games
Billed Amount, Payments (PMTS), Credits, Discounts, and Net Billed
Unearned Revenue Opening, Invoiced, Total Revenue
Earned Revenue and Unearned Revenue Closing
The report also includes season totals at the top of each section
Grey shading highlights the “As of” month, helping you easily identify where you are in the season
Exportable to CSV or PDF for financial tracking or reconciliation
✅ When to use it
Use this report for accrual-based financial tracking, especially when closing out revenue each month, reconciling general ledger entries, or preparing financial reports for leagues. It’s also useful when analyzing the timing of earned revenue vs. billed or collected payments, helping teams understand financial flow across a sports season.
💡 Pro Tips
Enable Show Other Months to get a complete view of the full season’s monthly revenue distribution. The season total line gives a clear snapshot of league performance, while individual rows offer insight into team-level billing and earned progress. To understand how much revenue is left to recognize, use the formula:
Remaining Games × Unit Price = Unearned Revenue, and subtract this from Total Revenue to track earned amounts.