Understanding the Itemized Report

The Itemized Report gives you a detailed, line-item-level view of every transaction. You'll find it in the admin panel under Reports > Itemized.

Unlike the Revenue Report (which shows one row per order), the Itemized Report shows one row per line item. If a customer bought three different items in a single order, that order appears as three separate rows — one for each item with its own price, discount, tax, and fee breakdown.

When to Use the Itemized Report

The Itemized Report is best for:

Auditing specific charges — verifying that the correct price, discount, or tax was applied to an individual item
Filtering by product type — viewing only court bookings, memberships, coaching lessons, or a specific product category
Reconciling line-item details — checking per-unit pricing and quantities for product sales

For a higher-level overview of daily sales and payment methods, use the Revenue Report instead.

Financial Summary

The Itemized Report shares the same financial summary section as the Revenue Report, displayed at the top of the page. This includes the Sales Breakdown, Tax Summary, OpenCourt Fees, and Payment Method Breakdown for the selected date range.

For a detailed explanation of each metric, see the Understanding the Revenue Report article.

Table Columns

Each row represents a single line item within an order:

	ColumnWhat it means
Order ID	The unique order identifier. Multiple rows can share the same Order ID when an order contains multiple items.
Transaction Time	When the order was placed.
Customer / Email	The customer who made the purchase.
Line Item	Description of the item — product name, court booking, coaching lesson, membership, etc.
Category	The product category, if applicable.
Price	The per-unit price before any discounts.
Qty	Quantity purchased. For products (merchandise, food, etc.), this is the actual quantity ordered. For court bookings, lessons, memberships, event fees, and other non-product items, this is always 1.
Extended Price	Price multiplied by Qty — the full amount before discounts.
Discount / Adjustment	The discount applied to this line item from promo codes or manual adjustments. Shown as a negative number when a discount was applied.
Taxable Base	The amount subject to tax: Extended Price plus the Discount (which is negative when a discount exists).
Sales Tax	Tax charged on this line item.
OpenCourt Service Fee	Platform fee on this line item.
Total Charged	The final amount charged to the customer for this line item: Taxable Base + Sales Tax + Service Fee.
Stripe	Link to view the payment in your Stripe dashboard.

Filtering

The Itemized Report supports filtering by product type and category, in addition to the date range filter. Use the filter to narrow down to specific types of transactions:

POS products
Court bookings
Player fees
Daily fees
Memberships
Equipment rentals
Coaching lessons
Custom items
Specific product categories

This is useful when you need to review transactions for a particular part of your business — for example, viewing only coaching lesson charges for the month, or filtering to a specific product category to check pricing.

How Refunds Appear in the Table

When a full refund is issued, each refunded line item gets its own refund row directly below the original item, with "(Refunded)" appended to the description and negative amounts.

Important note about partial refunds: Partial refunds may not always appear as individual line item rows in the Itemized Report. This is because a partial refund is sometimes issued as a flat dollar amount rather than being tied to specific items, and the system cannot always determine which line items the refund applies to. When this happens, the refund is still reflected in the financial summary at the top of the page (which calculates from payment-level data), but it may not appear as a line item row in the table below.

If you need the most complete picture of refund activity, use the Revenue Report — it shows all refunds as separate order-level rows regardless of how the refund was attributed.

Exporting Data

Click the Export button to download the currently filtered data as a CSV file. The export includes all visible columns and respects your current filters, so you can export just the subset of transactions you need.