This report is only available to firms on Aiwyn Practice.
What the profitability report contains.
Compares what the firm billed against what the work cost, using submitted WIP — so you can see whether the hours and expenses logged are turning into profitable revenue.
All figures on this report are based on submitted WIP. Draft entries are not included.
The date filter applies to all tiles, the chart and the tables using the WIP logged date—the date the work was logged. This includes Total Billed: billed amounts count in the month the work was logged, not the month it was invoiced.
Tabs
| Tab | What it shows |
|---|---|
| Profitability KPIs | Firm-wide profitability tiles and the monthly trend chart |
| Profitability Insights | Profitability broken out in detail |
Profitability KPIs
KPI tiles
| KPI | Definition |
|---|---|
| Profitability | Total Billed divided by Total Cost, expressed as a percentage |
| Total Billed | Total amount billed against submitted WIP |
| Total Cost | Total cost of submitted WIP, calculated as units × the cost rate stamped at the time of entry. Includes both time WIP (hours × cost rate) and expense WIP (quantity × unit cost) |
| Total Hours | Total hours logged on submitted time entries. Filtered to time WIP only — expense entries do not have hours |
| WIP Value | Total dollar value of submitted WIP, calculated as hours × billing rate |
Charts
| Chart | Type | What it shows |
|---|---|---|
| Profitability by Monthly WIP Logged Date | Line | Monthly trend of Total Billed ÷ Total Cost. Recent months may look lower because of the natural lag between when work is logged and when it is invoiced |
Profitability Insights
Profitability is broken out by client, employee, service line, project, client partner, project partner, and office.
Tables and columns
| Table | Columns |
|---|---|
| Profitability by Client | Client Name, Client Status, Client Number, Client Group Name, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Employee | Employee Name, Employee Role, Employee Status, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Service Line | Service Line Name, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Project | Job Name, Job ID, Job Status, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Client Partner | Client Partner Name, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Project Partner | Project Partner Name, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
| Profitability by Office | Office Name, Total Billed Amount, Total Cost Amount, Total Hours, Profitability Percentage, WIP Value Amount |
Related
- Report reference
- Employee performance report reference
- Billing performance report reference
- Aiwyn KPI glossary