An MIS dashboard where every number opens its own lineage

KPI cards

Revenue, margins, EBITDA, cash, debtor and creditor days — each with its movement on last month and a twelve-month trend.

Revenue and profit, year to date

Revenue, gross profit and profit after tax by month across the financial year.

From revenue to profit

A bridge from revenue through each cost head to the result for the month.

Costs by month

Direct costs, employee cost and other operating expenses, stacked, month by month.

Working capital

Receivables, inventory, payables, debtor and creditor days at the month end.

Ageing

Receivables and payables by age bucket, when the bills reports are loaded alongside the trial balance.

Most MIS dashboards are charts drawn from a spreadsheet that was itself built by hand, so the dashboard is two steps removed from the books and nobody can say where a figure came from when a director asks. Here the dashboard, the workbook and the commentary are three views of one computed set of figures. Every number carries its lineage, and the chat beside the dashboard answers “why did that move?” from the same figures — every number in its answer computed, never generated.

The dashboard is added once to a company and refreshed each month you add; see what you get each month and the credit packs.