Skip to Content
Ranlanka CRM documentation — pre-release, subject to change.
FeaturesCompany Statistics

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) — Visa Fees, Consulting Fees, Flight Revenue, Tour Revenue, and Other Fees, the same breakdown described in Accounting: fee breakdown. Includes a “View Other Fees Table” action button opening an in-page detail drawer (<OtherFeesDetailDrawer />) displaying:

    • Customer Name & Invoice #
    • Other Fee Name (e.g. Courier Fee, Insurance, Photo Charge, Fast-Track)
    • Value (LKR)
    • Invoice Date & Service Type
    • Full-text search filter, period totals, and pagination.

  • 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.

Last updated on
AccountingReminders