P&L Dashboard

Data sources & logic

Source: a Cloudflare Worker endpoint (not raw SQL) that pre-classifies Pohoda accounting ledger entries per selected company and date range.

Fields returned: date, companyName, plType (Revenue / Expenses), plCategory (e.g. Revenue, Gross expenses (COGS), Other income, Other expenses), amount, text (transaction description).

Logic: gross margin = plType='Revenue' & plCategory='Revenue' minus plCategory='Gross expenses (COGS)'. Other income/expenses are added separately below the margin line. Daily revenue vs. expense chart sums amount per day by plType.

Loading…
Contribution margin
GMV
—
COGs
—
GM
—
GM %
—
Transport
—
GM 2
—
GM 2 %
—
Bottom line
Overhead
—
Other income
—
Other expenses
—
Net income
—

Revenue vs Expenses — by day

Revenue Expenses

Expenses by category

Margin per customer

Customer ↕ GMV ↓#8593; COGs ↕ GM ↕ GM % ↕ Margin

Margin per contract

Contract ID ↕ Contract name ↕ Customer ↕ GMV ↓#8593; COGs ↕ GM ↕ GM % ↕ Margin

Transactions

Date Customer Type Category Description Amount CZK