Blog · Board and management reporting · Investment banking
An investment banking dashboard separates recognized fees from expected deal fees by sector team. Work a fee-ledger reconciliation, a mandate pipeline, and a delayed-close scenario that changes the forward view without changing reported revenue.
An investment banking dashboard compares recognized fees and open deal opportunities by sector team, with mandates and pitches shown separately. It should explain whether a weaker quarter reflects fewer earned fees, a change in product mix, or expected transactions moving into a later period.
This is a management view for a US investment bank's finance and coverage teams. It covers advisory and capital-raising business. FINRA's description of investment banking activities includes debt and equity offerings as well as mergers, acquisitions, and restructuring transactions; those activities define the commercial scope here.
Keep the layout compact enough for a sector head to connect the current quarter with the forward book.
| Panel | Question it answers | Source file | Required distinction |
|---|---|---|---|
| Recognized fees | Where did reported revenue move? | Closed-period fee ledger | Advisory versus underwriting |
| Open opportunities | What could contribute in the next period? | Dated opportunity export | Mandated versus pitched |
| Close-date movement | Which expected fees moved out? | Comparable opportunity snapshots | Timing change versus lost business |
| Coverage ownership | Who owns the client follow-up? | Approved client coverage list | Lead responsibility versus revenue credit |
The existing investment banking coverage KPI list defines the broader measure set. This dashboard arranges the fee and pipeline measures into a review that finance and sector heads can reconcile.
The fee file needs a transaction reference, posting period, product, sector team, and recognized amount in USD. Use finance's approved revenue classification. Include corrections and reversals under the same rules as the close pack, and retain a mapping for rows without an assigned sector.
The opportunity file needs a stable opportunity reference, sector owner, product, stage, expected bank fee, expected close date, and snapshot date. Use expected fees attributable to this bank, after the agreed fee split. A client's transaction value belongs in a separate field.
Recognized fees and expected fees answer different questions. For example, Goldman Sachs' 2024 Form 10-K describes recognizing advisory fees when the related services are completed under the assignment terms, and underwriting fees upon completion of the underlying transaction. Your bank's finance team owns the accounting treatment; a commercial stage label cannot replace it.
Consider an illustrative US advisory and capital-markets firm. The ledger summary below covers Q2 and Q3 2026, using the same sector allocation rules. Q3 runs from July through September. All amounts are recognized fees, including any ledger adjustments already posted for the period.
| Sector team | Q2 fees (USD) | Q3 advisory fees (USD) | Q3 underwriting fees (USD) | Q3 total fees (USD) | Change (USD) |
|---|---|---|---|---|---|
| Technology | 1,200,000 | 500,000 | 300,000 | 800,000 | −400,000 |
| Industrials | 700,000 | 400,000 | 500,000 | 900,000 | 200,000 |
| Healthcare | 600,000 | 500,000 | 0 | 500,000 | −100,000 |
| Total | 2,500,000 | 1,400,000 | 800,000 | 2,200,000 | −300,000 |
Recognized fee change = Current-period recognized fees − Comparable-period recognized fees
Fee change percentage = Recognized fee change / Comparable-period recognized fees
The firm earned $2,200,000, down $300,000 from $2,500,000: −300,000 / 2,500,000 = −12.0%. Technology's $400,000 decline and Healthcare's $100,000 decline were partly offset by Industrials' $200,000 increase.
Two checks prove this summary. Product totals must agree with sector totals: 1,400,000 advisory + 800,000 underwriting = 2,200,000. Sector changes must also bridge the periods: 2,500,000 − 400,000 + 200,000 − 100,000 = 2,200,000. Finally, the recognized total must tie to the approved investment banking revenue accounts in the close pack.
For a deeper explanation of earned-fee movements, use investment banking revenue analysis. Keep cost and profitability questions in the separate investment banking cost analysis, rather than treating fee growth as a margin result.
The opportunity export at September 30, 2026 contains these open transactions with expected Q4 closes. For this example only, management assigns a planning weight of 75% to a mandate and 25% to a pitch. These are stated assumptions, not measured completion probabilities or industry benchmarks.
| Opportunity | Sector | Stage | Expected fee (USD) | Planning weight | Weighted fee (USD) |
|---|---|---|---|---|---|
| T-01 | Technology | Mandated | 1,000,000 | 75% | 750,000 |
| T-02 | Technology | Pitched | 600,000 | 25% | 150,000 |
| I-01 | Industrials | Mandated | 800,000 | 75% | 600,000 |
| H-01 | Healthcare | Mandated | 500,000 | 75% | 375,000 |
| H-02 | Healthcare | Pitched | 400,000 | 25% | 100,000 |
| Total | 3,300,000 | 1,975,000 |
Weighted expected fee = Expected bank fee × Stated planning weight
Mandated expected fees total 1,000,000 + 800,000 + 500,000 = $2,300,000. Pitched fees total 600,000 + 400,000 = $1,000,000. The stage totals reconcile to $3,300,000, while the weighted total is 750,000 + 150,000 + 600,000 + 375,000 + 100,000 = $1,975,000.
Technology contributes $900,000 of the weighted book, Industrials $600,000, and Healthcare $475,000. This lets the coverage head ask about specific transactions rather than reading the total as an assured revenue figure. Do not add weighted pipeline to recognized fees and call the result current-quarter revenue.
Now change only T-01's expected close date from Q4 2026 to Q1 2027. Its fee, stage, and planning weight stay the same. The transaction remains open, but it leaves the Q4 dashboard window.
| Q4 measure | Original snapshot (USD) | Date-change scenario (USD) | Change (USD) |
|---|---|---|---|
| Mandated expected fees | 2,300,000 | 1,300,000 | −1,000,000 |
| Pitched expected fees | 1,000,000 | 1,000,000 | 0 |
| Total expected fees | 3,300,000 | 2,300,000 | −1,000,000 |
| Weighted expected fees | 1,975,000 | 1,225,000 | −750,000 |
| Recognized Q3 fees | 2,200,000 | 2,200,000 | 0 |
The weighted Q4 view falls by 750,000 / 1,975,000 = 38.0%, rounded to one decimal place. That is a timing change in the forward view. It is neither a recognized revenue reversal nor a lost mandate. The coverage owner should explain the changed expected date; finance should leave the closed Q3 ledger untouched unless an accounting correction is required.
Bring a fee-ledger export and dated opportunity files with sector ownership, stage, expected fees, and expected close dates. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the movements with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See Covirage for investment banking for the supporting industry context.
Include recognized fees against the comparable period, expected fees by mandate stage and close period, and the sector team responsible for each item. Add fee attribution and reconciliation checks so managers can distinguish commercial activity from booked revenue and duplicated credit.
No. Weighted pipeline multiplies expected bank fees by stated planning assumptions. Recognized revenue comes from finance's accounting records. A mandate can move between expected close periods without changing reported revenue, and a planning weight is not a guarantee of collection or completion.
Use the bank's expected fee as the pipeline amount. Transaction value measures the size of the client's transaction and can differ greatly from the bank's economics. If deal value is displayed, label it separately and keep it out of fee totals.