Q1 2026 Profitability
— Bottom 5 Accounts
Combined Revenue
$165.8K
Q1 budgeted
Combined Cost
$348.3K
hours × $185
Net Loss
-$182.6K
across 5 accounts
Avg Margin
-110%
cost vs revenue
Revenue is based on project budgets (monthly retainers × active months). Cost is hours × $185/hr. Ranked by margin % ascending — worst performers first.
Ranked by Margin — Worst to Best
Rank 1 — Most Unprofitable
Client A
-206% margin
Rank 2
Client B
-127% margin
Rank 3
Client C
-118% margin
Rank 4
Client D
-108% margin
Rank 5
Client E
-60% margin
Summary Comparison
| Account | Revenue | Cost | Net Profit / Loss | Margin | Hours |
|---|---|---|---|---|---|
| Client A | $13,500 | $41,328 | -$27,828 | -206% | 223.4 |
| Client B | $45,000 | $102,167 | -$57,167 | -127% | 552.3 |
| Client C | $36,000 | $78,330 | -$42,330 | -118% | 423.4 |
| Client D | $26,250 | $54,557 | -$28,307 | -108% | 294.9 |
| Client E | $45,000 | $71,959 | -$26,959 | -60% | 389.0 |
| Total | $165,750 | $348,341 | -$182,591 | -110% | 1,883.0 |
Task-level analysis is available for Client A and Client B only — these are the two worst performers by margin. Tasks shown are those with active time logged in Q1 2026.
Client A — Task Breakdown
Q1 Budget: $13,500 · Actual Cost: $41,328 · Total Overrun: -$27,828 · -206% margin
Email Implementation
+$13,374 overrun · 78.4 hrs
Paid Media Implementation
+$5,260 overrun · 34.5 hrs
Email Strategy
+$3,867 overrun · 27.0 hrs
Account Management
+$6,890 overrun · 67.7 hrs
Content Design
-$877 under · 13.5 hrs
Paid Media Strategy
-$687 under · 2.4 hrs
| Task | Budget (Q1) | Actual Cost | Overrun / Under | % | Hours | Status |
|---|---|---|---|---|---|---|
| Email Implementation | $1,125 | $14,499 | +$13,374 | 1,189% | 78.4 | Critical |
| Paid Media Implementation | $1,125 | $6,385 | +$5,260 | 468% | 34.5 | Over |
| Email Strategy | $1,125 | $4,992 | +$3,867 | 344% | 27.0 | Over |
| Account Management | $5,625 | $12,515 | +$6,890 | 123% | 67.7 | Over |
| Content Design | $3,375 | $2,498 | -$877 | -26% | 13.5 | Under |
| Paid Media Strategy | $1,125 | $438 | -$687 | -61% | 2.4 | Under |
| Total | $13,500 | $41,328 | +$27,828 | -206% | 223.4 |
Client B — Task Breakdown
Q1 Budget: $45,000 · Actual Cost: $102,167 · Total Overrun: -$57,167 · -127% margin
Marketing Strategy
+$33,754 overrun · 231.1 hrs
Content Design
+$7,448 overrun · 58.5 hrs
Account Management
+$12,156 overrun · 102.2 hrs
Email Implementation
+$7,199 overrun · 63.2 hrs
Project Management
+$867 overrun · 29.0 hrs
Website Publication
+$1,474 (unbudgeted) · 8.0 hrs
Paid Media Implementation
-$732 under · 20.4 hrs
Content Development
-$5,715 under · 36.0 hrs
| Task | Budget (Q1) | Actual Cost | Overrun / Under | % | Hours | Status |
|---|---|---|---|---|---|---|
| Marketing Strategy | $9,000 | $42,754 | +$33,754 | 375% | 231.1 | Critical |
| Account Management | $6,750 | $18,906 | +$12,156 | 180% | 102.2 | Over |
| Email Implementation | $4,500 | $11,699 | +$7,199 | 160% | 63.2 | Over |
| Content Design | $3,375 | $10,823 | +$7,448 | 221% | 58.5 | Over |
| Project Management | $4,500 | $5,367 | +$867 | 19% | 29.0 | Watch |
| Website Publication | — | $1,474 | +$1,474 | Unbudgeted | 8.0 | Unbudgeted |
| Paid Media Implementation | $4,500 | $3,768 | -$732 | -16% | 20.4 | Under |
| Content Development | $12,375 | $6,660 | -$5,715 | -46% | 36.0 | Under |
| Total | $45,000 | $102,167 | +$57,167 | -127% | 552.3 |