What was billed, less what it cost.
A custom, macro-free Excel workbook for a consulting team. It matches activity to cost by period and engagement ID, reports the margin, then lists every record it leaves out.
From the fictional October sample: $1,400 billed, less $800 cost, leaves a margin of $600.
Billed $1,400
Margin · October sample $600
Cost $800
What the workbook does
Matched on two keys. Period and engagement ID. An activity row and a cost row meet only when both agree.
Margin, stated plainly. Billed, cost, margin, margin rate and matched hours for the reporting month. October’s $600 is 42.86% of the $1,400 billed.
Exceptions, never hidden. A row without its counterpart is left out of the totals and listed in an exception log, with the reason beside it.
Three sample pages
One fictional report, followed from October’s matched rows to the November refresh. Swipe, drag, or focus the row and use the arrow keys.
October client report $600
Two engagements match across both exports: $1,400 billed and $800 cost. See why two rows were excluded.
Matched October rows ID Billed Cost Hours E01 $600 $350 5 E02 $800 $450 7 Total $1,400 $800 12
Margin is $1,400 − $800 = $600, or 42.86% of billed.
Open full size Download image
October exception log Two excluded
Each record left out of the October totals, with the reason. E03 is activity without cost; E04 is cost without activity.
E03 · Activity only. $200 billed and two hours are excluded. No cost row matches the period and engagement ID.
E04 · Cost only. $120 in costs is excluded. No activity row matches that key.
Open full size Download image
November refresh $400
The same workbook after both exports are replaced. $1,000 billed, $600 cost, and every row matches.
Matched November rows ID Billed Cost Hours E01 $750 $400 6 E02 $250 $200 3 Total $1,000 $600 9
Margin is $1,000 − $600 = $400, or 40.00% of billed. No rows excluded.
Open full size Download image
Advanced Excel portfolio
Inside a year of consulting work.
Follow nine fictional engagements across twelve months. Investigate three held records, repair a missing cost and test the price change that clears a 54% margin target.
Take the workbook tour See all selected work
Files Opens in desktop Excel. All sample data is fictional.
Scope and price
$2,000
USD, fixed price, one custom workbook.
You send Two approved, de-identified exports that share a period and an engagement ID. Each export can contain up to 200 data rows.
You receive One macro-free Excel workbook. It reports billed, cost, margin, margin rate and matched hours, with visible exceptions.
Refresh Clear and paste both files, then choose the reporting month.
Also included One handoff guide and one scoped correction.
Outside this package Extra data sources, live dashboards and general cleanup.
Describe one recurring report and the two exports behind it. Share column names or synthetic examples and keep client data private.