Analyze revenue and collections
The Revenue & collections analysis wizard compares invoiced revenue and collected amounts over a period to link sales and cash flow. It covers sales tickets with at least one revenue line; aggregated amounts are limited to the chosen date range.
Important: invoicing and collections may not follow the same calendar. Correct date framing is essential to interpret gaps.
Open the wizard
- From the dashboard, click Revenue & collections analysis.
- Set a start date and end date.
- Click Refresh to reload data.
“Revenue & collections” view
This view shows in parallel:
- a chart of Revenue for the period;
- a chart of Collections for the period;
- reconciliation panels.
The Revenue details menu breaks down the revenue pie chart by accounting Nature or Activity category.
Invoiced (incl. VAT) and collected amounts may not fall on the same dates; complement with exports for precise accounting — see Export data for accounting.
Reading the reconciliation panels
The reconciliation panels explain, line by line, where the gap between revenue and collected amounts for the period comes from. Hover over a line to see its explanation, and click the small list button to the left of a line to View entry details.
Revenue collections analysis
This waterfall chart breaks down the period’s ticket revenue by when it was collected:
- Before the period: revenue already collected before the start date (deposits, online payments at booking…).
- During the period: revenue collected during the period.
- After the period: revenue collected after the end date.
- Amount due: what has not been collected yet on the period’s revenue tickets. It is not extra revenue, it is the part of revenue still to be received.
Next come Revenue on tickets, Revenue outside tickets and Total revenue.
Collections for the period
This panel details everything collected during the period:
- (1) Revenue collections during the period: payments for the period’s revenue tickets, received during the period.
- (4) Collections on tickets outside the period: payments received during the period for tickets from another period (for example a deposit for next month’s activity). They are not part of the period’s revenue.
- (4b) Other non-ticket cash flows: money in or out during the period without a ticket (cash movements, fees, etc.). A negative amount means a net outflow.
- Total collected for the period: the sum of these three lines. This is the figure to reconcile with your cash tracking.
A check line below the panels recalls both equations: ticket revenue equals (1) + before + after + amount due, and the period’s collections equal (1) + (4) + (4b).
“Breakdown by resource” view
Choose Breakdown by resource for a table with two values per column: Invoiced (revenue incl. VAT) and Collected.
- Rows are resources (instructors, guides…); a No resource row groups the rest.
- Columns depend on Column grouping: by sales ticket, by activity name, by activity’s first category, or by month (line start date).
Collections by resource: limitations
For collections, the tool allocates pro rata based on each resource’s share of revenue (incl. VAT) in the column — this is not payment-by-payment traceability. With tickets spanning multiple activities or multiple resources, displayed allocation may be approximate.
Best practices:
- Start with grouping by sales ticket for a careful reading of collections.
- Use the table CSV to check or archive amounts.
- For legal or contractual value, cross-check with detailed accounting exports.
For detail on limitations: Why are collections by resource approximate?.
Common issues
- Revenue / collections gap: widen or shift the date range depending on your goal (invoiced revenue vs cash collected).
- Inconsistent amounts per resource: check grouping and see the FAQ above.
- “Amount due” although everything seems paid: click the line’s list button to see the tickets involved. A payment recorded on an invoice or on another ticket does not show on the original ticket.