Q1 2026 — Account Profitability Report

Combined Revenue

Q1 budgets — 5 accounts

Combined Cost

Hours × $185/hr

Net Loss

Across bottom 5

Avg Margin

Cost vs. revenue

Revenue = project budgets (monthly retainers × active months). Cost = hours × $185/hr. Ranked by margin — worst performers first. Click any row to expand.

Bottom 5 Accounts

Rank 1 — Most Unprofitable

Client A

-$27,828

-206% margin

Revenue

$13,500

Actual Cost

$41,328

Net Loss

-$27,828

Hours

223.4 hrs

Budget Type

Monthly retainer

Budget consumption — 306%$41,328 / $13,500

Rank 2 — Largest Dollar Loss

Client B

-$57,167

-127% margin

Revenue

$45,000

Actual Cost

$102,167

Net Loss

-$57,167

Hours

552.3 hrs

Budget Type

Monthly retainer

Budget consumption — 227%$102,167 / $45,000

Rank 3

Client C

-$42,330

-118% margin

Revenue

$36,000

Actual Cost

$78,330

Net Loss

-$42,330

Hours

423.4 hrs

Budget Type

Monthly retainer

Budget consumption — 218%$78,330 / $36,000

Rank 4

Client D

-$28,307

-108% margin

Revenue

$26,250

Actual Cost

$54,557

Net Loss

-$28,307

Hours

294.9 hrs

Budget Type

Monthly retainer (2 mo.)

Budget consumption — 208%$54,557 / $26,250

Rank 5

Client E

-$26,959

-60% margin

Revenue

$45,000

Actual Cost

$71,959

Net Loss

-$26,959

Hours

389.0 hrs

Budget Type

Monthly retainer

Budget consumption — 160%$71,959 / $45,000

Summary Table

Account	Revenue	Cost	Net 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 data available for Client A and Client B — the two worst performers by margin.

Client A — Task Breakdown

Q1 Budget: $13,500 · Actual: $41,328 · Overrun: -$27,828 · Margin: -206%

306% consumed

Email Implementation

+$13,374 overrun · 78.4 hrs · 1,189%

$1,125 budgeted$14,499 actual

Paid Media Implementation

+$5,260 overrun · 34.5 hrs · 468%

$1,125 budgeted$6,385 actual

Email Strategy

+$3,867 overrun · 27.0 hrs · 344%

$1,125 budgeted$4,992 actual

Account Management

+$6,890 overrun · 67.7 hrs · 123%

$5,625 budgeted$12,515 actual

Content Design

-$877 under · 13.5 hrs · -26%

$3,375 budgeted$2,498 actual

Paid Media Strategy

-$687 under · 2.4 hrs · -61%

$1,125 budgeted$438 actual

Task	Budget	Cost	Overrun	%	Hrs	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: $102,167 · Overrun: -$57,167 · Margin: -127%

227% consumed

Marketing Strategy

+$33,754 overrun · 231.1 hrs · 375%

$9,000 budgeted$42,754 actual

Account Management

+$12,156 overrun · 102.2 hrs · 180%

$6,750 budgeted$18,906 actual

Content Design

+$7,448 overrun · 58.5 hrs · 221%

$3,375 budgeted$10,823 actual

Email Implementation

+$7,199 overrun · 63.2 hrs · 160%

$4,500 budgeted$11,699 actual

Project Management

+$867 overrun · 29.0 hrs · 19%

$4,500 budgeted$5,367 actual

Website Publication

+$1,474 unbudgeted · 8.0 hrs

No budget allocated$1,474 actual

Paid Media Implementation

-$732 under · 20.4 hrs · -16%

$4,500 budgeted$3,768 actual

Content Development

-$5,715 under · 36.0 hrs · -46%

$12,375 budgeted$6,660 actual

Task	Budget	Cost	Overrun	%	Hrs	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

Service lines aggregated from task-level data across Client A and Client B. Ranked by total overrun — highest first.

Service Line Overages — Client A + Client B

Marketing / Strategy

+$33,754

Budget

$9,000

Actual

$42,754

Hours

231.1 hrs

% Over

375%

$9,000 budget375% consumed

Client B

Email Services

+$24,440

Budget

$6,750

Actual

$31,190

Hours

231.9 hrs

% Over

362%

$6,750 budget362% consumed

Client AClient B

Account Management

+$19,046

Budget

$12,375

Actual

$31,421

Hours

169.9 hrs

% Over

154%

$12,375 budget154% consumed

Client AClient B

Paid Media

+$3,841

Budget

$6,750

Actual

$10,591

Hours

60.5 hrs

% Over

57%

$6,750 budget157% consumed

Client AClient B

Content

+$856

Budget

$19,125

Actual

$19,981

Hours

131.0 hrs

% Over

$19,125 budget104% consumed

Client AClient B

Project Management

+$867

Budget

$4,500

Actual

$5,367

Hours

29.0 hrs

% Over

19%

$4,500 budget119% consumed

Client B

Service Line Summary

Service Line	Budget	Cost	Overrun	%	Hours	Accounts
Marketing / Strategy	$9,000	$42,754	+$33,754	375%	231.1	Client B
Email Services	$6,750	$31,190	+$24,440	362%	231.9	A, B
Account Management	$12,375	$31,421	+$19,046	154%	169.9	A, B
Paid Media	$6,750	$10,591	+$3,841	57%	60.5	A, B
Content	$19,125	$19,981	+$856	4%	131.0	A, B
Project Management	$4,500	$5,367	+$867	19%	29.0	Client B
Total	$58,500	$141,304	+$82,804	—	853.4

Q1 2026Account Profitability

Q1 2026
Account Profitability