Reports
Income, sales, and daily-total reports
#Before you begin
- Write down whether you are measuring payments, purchases, charges, or profitability.
- Select the date basis and location before comparing two reports.
- Use a known fictional sale containing one Sales Item, charge, payment, and—if applicable—inventory variant.
- Include a refund or void only in a separate controlled scenario after its processor and ledger effects are understood.
#Choose the report
| Question | Report to start with | Primary record |
|---|---|---|
| How much payment activity was recorded by day or method? | Daily Totals | Payments |
| What is the payment summary for a period? | Gross Income Summary | Payments |
| How much income is associated with classes? | Income By Class | Class-related financial records; verify the formula before publication |
| What was purchased? | Sales | Purchases |
| How do sales group by item or category? | Sales by Category | Purchases and Sales Item categories |
| What was sold without a registered client? | Sales to Not Registered Clients | Anonymous/front-desk purchases |
| What inventory was sold? | Inventory Sales | Purchases with inventory variants |
| How profitable is a class? | Class Profitability | Revenue and configured cost assumptions; currently Beta |
| How can I explore transaction-level revenue? | Revenue Explorer | Revenue transactions; currently Beta |
Important: Class Profitability and Revenue Explorer are labeled Beta. Use them for exploration, not as the sole basis for payroll, taxes, or a financial statement until their formulas have been approved and reconciled.
#Run Daily Totals or Gross Income Summary
- Open Reports > Daily Totals or Reports > Gross Income Summary.
- Enter Start Date and End Date.
- Choose the intended location and payment filters.
- Turn on details only when you need transaction-level evidence.
- Apply the filters.
- Compare one payment row or grouped total with Finance > Payments and the family ledger.
- Review the displayed total before generating a PDF.
Document whether the report includes refunded, voided, locally offset, unapplied, or out-of-season payments. A processor settlement can also differ because settlement timing and fees are external to the local payment record.
#Review sales
- Open Reports > Sales.
- Set the purchase date range.
- Narrow by Sales Item, category, location, status, or other available filters.
- Select the columns needed for the question.
- Apply the filters and review the purchase count and total.
- Open one linked purchase or account record.
- Confirm item, quantity or units, purchase status, amount, and date.
- Generate PDF or Excel only after the sample agrees with the source record.
The Sales report should not be expected to equal payment totals when purchases are unpaid, discounted, refunded, scheduled for later payment, or paid using credit from another date.
#Compare sales by category
Use Sales by Category when you need to group results rather than inspect every purchase.
- Select the same date range and locations used in the comparison report.
- Choose the detail, Sales Item, or category view.
- Apply matching purchase-status filters.
- Compare the grouped total with the detail view.
- Open a sample Sales Item and confirm its current category.
If an item's category changed after earlier sales, verify whether the report uses the current item category or a category captured with the original purchase before publishing a historical interpretation.
#Review anonymous or inventory sales
Sales to Not Registered Clients is for purchases that are not associated with an ordinary registered family. Review both its detail and grouped summary modes where available.
Inventory Sales adds item variant, location, and category context. Reconcile a sample with:
- the purchase record;
- the Sales Item and selected variant;
- inventory stock at the selling location; and
- the staff or Online Client cart result.
Do not adjust stock solely because a report total looks unexpected. First determine whether the discrepancy comes from purchase status, cancellation, return, manual stock adjustment, location, or date filters.
#Understand why totals differ
| Record | Common date | What it represents |
|---|---|---|
| Purchase | Purchase/checkout date | The item or package acquired and its lifecycle state. |
| Charge | Charge date | Amount added to the family ledger. |
| Payment | Payment date | Money or another payment record entered against the account. |
| Payment application | Application timing | How payment or credit was assigned to charges. |
| Processor settlement | External settlement date | Funds moved by the processor, potentially net of fees or delays. |
Two totals can both be correct while measuring different rows in this table.
#Confirm the result
Before distributing an income or sales report:
- record its name, date basis, locations, statuses, grouping, and payment filters;
- reconcile one known sale from purchase through charge, payment, and application;
- identify how discounts, credit, scheduled payments, refunds, and voids appear;
- compare the screen and export population; and
- label any Beta analysis clearly.
#Troubleshooting
#Sales do not equal payments
Confirm that you are not comparing purchase dates with payment dates. Review unpaid purchases, account credit, split or scheduled payments, zero-dollar items, discounts, refunds, and purchases outside the selected location.
#Daily Totals differ from a processor deposit
Compare time zone, payment type, settlement cutoff, pending/failed records, refunds, and processor fees. Use the processor portal or settlement report for external movement of funds.
#An item is in the wrong category
Open the Sales Item and confirm its current category, then determine whether historical reporting uses the current or purchase-time value. Do not rewrite item history before the reporting rule is known.
#A Beta report gives an unexpected profit or revenue value
Record the filters and one source class. Compare revenue records, instructor cost, room cost, overhead, fill rate, refunds, and purchase/payment timing. Escalate the sample without using the result as an approved accounting formula.