Manual · Engineering
Manual14 min read

Analytics & Reports

Every dashboard and report, the Export Center, scheduled reports, the KPI Explorer and forecasting.

ForExecutiveFinanceSalesOperations
Read firstCH 00Orientation — how the system thinks
RelatedReferenceMonth-end close, start to finish

Everything here is read-only

Rule

Reports never post

No dashboard or report posts a journal entry. Financial reports read only POSTED journals.

Analytics dashboards

The Analytics chip nav switches between dashboards. Headline metrics by dashboard:

DashboardRolesHeadline metrics
ExecutiveCEOEBITDA, net profit margin, revenue growth, new customers; a 12-month forecast panel; Strategic Risks covering receivables, inventory, pending approvals, expense ratio and customer concentration
FinanceCEO, CFOCurrent and quick ratio, DSO, DPO; budget vs actual; expense category trends; cash-flow forecast; a financial health score out of 100
SalesCEO, SALES_MANAGERPipeline value, win rate, revenue vs target, active opportunities; pipeline by stage; win/loss; revenue targets; sales-team ranking; lost opportunities; customer cohort
FleetCEO, COO, USERAverage cost per trip, total fuel spend, maintenance and lifetime fleet cost; cost, fuel and maintenance trends; vehicle lifecycle; trip-profitability heatmap
OperationsCEO, COOSLA attainment (trip ≤ 3 days), active routes, drivers and a health score; route efficiency; bottlenecks; driver productivity
WarehouseCEO, CFO, COONet throughput, inventory turnover, warehouse count and pick/pack efficiency; throughput, space utilisation, stock aging and turnover trend
ProcurementCEO, CFOTotal vendors, average PO cycle in days, total spend and top vendor share; PO cycle time; spend by vendor; vendor performance; concentration
CustomersCEO, SALES_MANAGERTop customers, total revenue, top customer, average revenue per customer; revenue trend; top five
ForecastingCEO, CFOAverage forecast revenue and expenses, projected net cash flow; revenue, expense and cash-flow forecasts
KPI ExplorerCEO, CFO, COOCompare up to two KPIs side by side

Known limitation

Dashboards use fixed windows

There are no per-page date filters. Dashboards are built to answer 'how are we doing right now' — use Reports when you need a specific date range.

The report catalogue

CategoryMenuReports
Fleet OperationsFleet ReportsTrip Profitability · Fuel Consumption per Vehicle · Driver Performance Scorecard · Fleet Utilisation Rate
Sales & ReceivablesSales ReportsSales by Customer/Month · Invoice Aging
Inventory & WarehouseInventory ReportsStock Levels by Warehouse · Inventory Valuation · Slow-Moving Items
Financial StatementsFinancial ReportsTrial Balance · General Ledger · Profit & Loss · Balance Sheet · Cash Flow Statement
Fixed AssetsAsset ReportsDepreciation Schedule · Asset Register
Purchases & PayablesProcurement ReportsVendor Spend Analysis · Payables Aging
Driver SettlementsSettlement ReportsDriver Settlement Summary
Port & ContainersPort & Container ReportsContainer Profitability · Demurrage Exposure · Demurrage Invoiced vs Collected
IntercompanyLanding page onlyInterco Reconciliation
  • Invoice Aging buckets outstanding invoices into Not Due, 1–30, 31–60, 61–90 and 90+ days.
  • Inventory Valuation is on-hand × weighted-average cost, approximated from PO line costs, with a total row.
  • The Balance Sheet adds a Current Period Earnings equity line so Assets = Liabilities + Equity.
  • The Cash Flow Statement groups cash-account (1000, 1010) movements into operating, investing and financing.
  • Container Profitability ranks the worst-profit containers first.

Generating and exporting a report

  1. 01

    Open the report

    From the Reports landing page or a category page. A preview sheet shows the first 50 rows.

  2. 02

    Choose a format

    Excel, PDF or CSV. Files are named {reportId}-{from}-{to}.

  3. 03

    Track it

    Exports are rate-limited and every export is logged in the Export Center.

Watch

Report visibility is filtered by role at the interface, not in the export action

The report cards you see are filtered by your role, but the export action itself is workspace-scoped. Assign roles carefully.

Scheduled Reports

Create a schedule with the report, format (Excel or PDF), a cron expression such as 0 8 * * * for daily at 08:00, comma-separated recipient emails and an enabled switch. Row actions are Run Now, Edit and Delete.

Note

Delivery is by Telegram chat

Due schedules are checked hourly and the generated report is delivered to the mapped Telegram chats. If no chats are mapped, the run completes without sending.

Scheduled ReportsReports → Scheduled Reports

Export Center

  • A summary shows total exports, successful exports and success rate.
  • The table lists the latest 30 exports with report, format, status and message, size, user, date and a download action.
  • Download re-runs the report on demand — it does not fetch a stored file. Error rows cannot be downloaded.
Export CenterReports → Export Center

KPI Explorer and Forecasting

KPI Explorer lets you search and select up to two KPIs — Net Profit, Net Profit Margin, Revenue Growth, Customer Growth, Total Spend and Outstanding Receivables — and compare them with a 90-day sparkline and a CSV download.

Forecasting projects monthly revenue, expenses and net cash flow using a simple moving average over a three-month window, with net cash flow applying the last three months' average inflow and outflow cumulatively. Prediction bounds appear as a shaded band over a six-month horizon.

KPI ExplorerAnalytics → KPI Explorer
ForecastingAnalytics → Forecasting

Note

Budgets feed budget-vs-actual

Budgets & Targets (Finance → Budgets & Targets) feeds the Finance budget-vs-actual panel and the Sales revenue targets, prorating multi-month budgets per month. With no budgets set, those panels fall back to the previous average plus 10%.

Currency notes

  • Reports and analytics convert to the workspace base currency.
  • Invoice and payables aging multiply by the applied rate.
  • Trip expenses are already stored in base currency.
  • Intercompany Reconciliation shows each transaction's native amount and currency with no conversion.

Troubleshooting

MessageFix
from must be YYYY-MM-DD / to must be YYYY-MM-DDProvide a valid range
from must be before or equal to toCorrect the range
Unknown report: {id}Reopen from the Reports page
Rate limit exceeded. Try again in N seconds.Wait, then retry
No data available for this report.Widen the range or check the source data
Failed to load previewRetry
No reports match your searchClear the search
No organization context available.Sign in again
No export historyExport a report
No scheduled reportsCreate one

Cheat sheet

Executive overview
Analytics → Executive
Finance ratios and forecast
Analytics → Finance
A financial statement
Reports → Financial Reports
Outstanding cash
Reports → Sales Reports → Invoice Aging, or Procurement Reports → Payables Aging
Fleet and settlement reporting
Reports → Fleet Reports, Settlement Reports
Port and demurrage
Reports → Port & Container Reports
Download Excel, PDF or CSV
Any report → Excel / PDF / CSV
See past exports
Reports → Export Center

Rule

The rule that never changes

Reports are read-only; they never post to the ledger.