Company Statistics
Owner/manager only. Company Statistics is now a top-level parent sidebar navigation item (/admin/company-statistics). Unlike the Financial Dashboard and Accounting pages, which are scoped to a single month or year, Company Statistics reports on any date range you pick — useful for a quarter, a custom promo period, or comparing two arbitrary windows.
The Company Statistics Hub features 4 main tabs:
Account Stats
-
KPI tiles: Total Invoiced, Total Collected, Outstanding, and Profit for the selected range — the same figures and the same Profit formula as the Financial Dashboard and Accounting pages, see Accounting: how Profit is calculated.
-
Staff Performance (bar chart) — revenue and profit per staff member for the range, same attribution logic as the per-staff breakdown elsewhere (credited to whoever handled the case, not whoever issued the invoice).
-
Fee Category Breakdown (pie chart & data breakdown) — Visa Fees, Consulting Fees, Flight Revenue (with sub-metrics for Ticket Sale, Cost of Sale, and Net Flight Profit), Tour Revenue, and Other Fees, following the same calculation rules described in Accounting: fee breakdown. Includes:
- “View Other Fees Table” action button opening an in-page detail drawer (
<OtherFeesDetailDrawer />) displaying customer names, fee descriptions, amounts, and dates (with flight ticket prices and tour charges strictly excluded to avoid double-counting). - Detailed flight profitability metrics integrated into the Excel export.
- “View Other Fees Table” action button opening an in-page detail drawer (
-
Invoice Status Breakdown (pie chart) — count of invoices by status (unpaid, partial, paid, cancelled) created within the range.
Visa Stats Matrix
Multi-attribute breakdown by country, visa category, entry type, validity period, and sticker vs e-visa. Includes date quick range filters, a collapsible borderless grid layout, and Excel export.
Ticket Stats Matrix
Flight & Ticket breakdown by airline, route, passenger counts, and status.
Tour Stats Matrix
Tour operations breakdown by pacing, accommodation tier, guiders, and status.
Date range & Export
Pick a start and end date (end date defaults to today, start defaults to the first of the current month) and hit Apply. Every tile and chart on the page recomputes for exactly that window — the end date is inclusive.
The Export to Excel button downloads a spreadsheet built from exactly what’s on screen — a KPIs sheet, a Staff Performance sheet, and a Fee Breakdown sheet, or the matrix grid, depending on the active tab — for the currently selected date range. No separate export step or backend job; it’s generated instantly from the already-loaded data.