Use one row per opportunity
Keep the portfolio tracker small enough to review in a short meeting. Each row needs a stable opportunity ID, buyer, proposal owner, bid decision, current stage, and next action. Link to the response workspace instead of pasting every question into the tracker. Use the compliance matrix for question-level ownership and evidence.
The buyer deadline, internal review deadline, and planned upload are different dates. Store the buyer's time zone explicitly; a date without a time and zone is not a reliable submission instruction. Read the actual portal requirements before choosing an internal buffer.
Give each stage an exit condition
Agree these definitions before the team starts reporting progress. Stages describe work completed, not how optimistic the opportunity owner feels.
| Stage | Move forward when |
|---|---|
| Intake | Instructions, deadline, owner, and required files are recorded. |
| Qualification | An authorized owner records bid, conditional bid, or no bid. |
| Planning | Requirements, sources, contributors, and review dates are assigned. |
| Drafting | Required answers and attachments are ready for review. |
| Review | Material findings are resolved and required approvals are recorded. |
| Submission | The correct exported package is uploaded and a receipt is retained. |
| Outcome | The buyer's decision and useful feedback are recorded. |
Worked example: turn a vague status into an action
Illustrative example: a software proposal is marked '90% complete' two days before submission. All narrative answers exist, but the pricing schedule is unapproved and the export has not been checked. Calling this nearly finished hides the two tasks that can stop submission.
A useful entry reads: stage Review; blocker Pricing approval; next action Commercial lead approves Appendix B by the internal deadline; submission owner validates the final export afterward. If approval is late, escalate to the bid owner rather than silently moving the deadline.
Keep a separate field for the action owner. The proposal manager may own the opportunity without being authorized to approve price, legal exceptions, or delivery commitments.
Run the tracker as a short operating review
Filter first for overdue actions, unresolved blockers, and submissions approaching the internal review date. Ask what changed since the previous review and whether an amendment changes the scope or bid decision. Update the next action before moving to the next opportunity.
A tracker is not a substitute for access controls or an audit system. Keep sensitive pricing and customer documents in the approved workspace, and link only to locations the intended reviewers can access.
- Separate drafting status from approval status.
- Link the exact submitted version and retain the portal receipt.
- Record withdrawn and cancelled opportunities separately from lost bids.
- If reporting win rate, state the denominator: won divided by decided won plus lost opportunities. Do not include open bids.
Quick checklist
- Buyer deadline includes time and time zone
- Every active opportunity has one next action and an owner
- Review and upload dates are distinct
- Blockers and required approvals are visible
- Submitted version and receipt are retained
Put the guide to work
An editable portfolio tracker with a clearly marked example and a blank working row. Replace all bracketed values; no formulas or macros are included.
Download the RFP trackerNo signup required. Adapt the template to your own process.
Published by SavixRFP, the team behind the RFP response workspace. Examples are illustrative; adapt the worksheets to your buyer's instructions and your own approval process.
