Symphony — Opportunity Tracking

The situation today

Sales pipelines break at the seams.

Your pipeline workbook lives in a shared drive. Reps update it on Monday mornings. Sometimes two people edit at once and someone's work gets overwritten. Forecasts change from week to week — but nobody remembers why. Leadership gets a snapshot at each meeting, but no story about how that snapshot came together.

You've tried real-time co-authoring. Reps hate it: they don't want half-formed forecasts visible to the whole team. So they turn it off and go back to emailing each other individual copies. Version drift starts on day one.

How Symphony fits

Two ways to structure your pipeline.

Symphony gives sales teams two proven approaches. Pick the one that matches how your team already works — you don't need to reorganize around the tool.

Option 1

A worksheet per rep

Each rep gets their own worksheet inside the shared pipeline workbook. They update opportunities privately throughout the week. When Monday's forecast meeting arrives, they Submit — and only then does leadership see the update.

Best for:Teams where reps own distinct territories, accounts, or verticals.

Complete privacy — no teammate sees drafts
Each rep controls when to publish updates
Leadership sees the consolidated pipeline after Refresh

Option 2

One worksheet, rep by row

All reps share a single pipeline worksheet. Each rep owns their rows — the deals assigned by name, territory, or account. They update their rows privately, then Submit when ready. Leadership Refreshes to see the whole pipeline.

Best for:Smaller teams that want the entire pipeline visible at a glance.

Every rep sees the whole pipeline as context
Row ownership keeps updates clean
Simpler to set up — one worksheet, one workbook

Both approaches give you a full transaction history, diff-any-two-weeks comparison, and reasons attached to every update.

A typical workflow

From workbook setup to Monday review.

Sales leader creates a pipeline workbook.

One workbook per team. One worksheet per rep. Add columns for opportunity name, account, stage, amount, close date, and confidence.

Invite each rep to their worksheet.

Reps open the pipeline in their own Excel. They see only their worksheet — plus a read-only view of the team totals.

Reps update opportunities privately.

Throughout the week, reps update stages, amounts, close dates. No teammate sees the changes. No manager pings.

Before Monday, they Submit.

Each rep Submits with a short reason: "Q4 push added two new deals," or "Enterprise deal slipped to Q1." Reasons attach to the transaction.

Sales leadership Refreshes.

The Monday meeting starts with a clean, consolidated pipeline. Discussion focuses on the changes — with reasons visible in-line.

Diff for QBRs and forecast reviews.

At month-end or quarter-end, compare any two Submit points. See how the forecast evolved. Understand which deals moved and why.

Benefits at play here

Why this works for sales teams.

Every Symphony benefit lands somewhere in this workflow. These four do the heaviest lifting for opportunity tracking specifically.

Benefit 02

Work privately and Sync-By-Choice.

Benefit 03

Understand what, when, why, and who changed the information.

Benefit 01

Smooth and harmonious conversations with trusted teams.

Benefit 06

Assemble purposeful workbooks, conduct multiple private conversations per worksheet.

See all benefits →

In practice

See how a sales team put this to work.

Case Study 5 min read

How a sales team and management worked together to meet their numbers.

One leader's playbook for moving from spreadsheet chaos to a clean weekly forecast, without switching CRMs.

Read the case study →

Every opportunity, every rep, every update — captured cleanly.