What "Manual Commission Tracking" Looks Like at a Web Agency
Manual commission tracking at a web agency is not always a spreadsheet. Sometimes it is a spreadsheet. Sometimes it is a CRM with a free-text "commission" field that someone manually updates. Sometimes it is a WhatsApp message at the end of each week summarising closes. Sometimes it is a mental ledger the agency owner keeps and reconciles at month end. All of these are manual tracking — and all of them share the same structural problem: the running commission total is not visible to both parties simultaneously in real time.
The agency owner's tracking and the SDR's tracking start from the same point on day 1 and diverge predictably throughout the month. Not because either party is dishonest. Because they are each logging events from their own perspective with their own definition of what counts, at their own cadence, without a shared authoritative record forcing alignment.
Shadow Accounting — The Signal That Manual Tracking Has Failed
Shadow accounting is not a dishonesty signal — it is a trust signal. An SDR who keeps their own parallel record is not trying to claim more commission than they earned. They are protecting themselves in a system where they have no independent way to verify the calculation. The shadow accounting emerges because the system does not give them a shared authoritative record to reference — so they build their own.
How to know if your SDR is shadow accounting: Ask them, unprompted, what their current commission total is for this month. If the figure they state matches your running total exactly — and they cite the same source — your tracking is aligned. If they hesitate, produce a different figure, or reference a separate record, shadow accounting is already happening. The solution is not to tell them to stop keeping their own record. The solution is to give them a shared real-time record that makes maintaining a separate one unnecessary.
The 4 Failure Modes of Manual Commission Tracking
Manual commission tracking fails through four specific mechanisms. Understanding which mode is driving a specific dispute determines which system fix prevents it from recurring.
How the Two Records Diverge Through the Month
The divergence between the agency owner's commission record and the SDR's parallel record does not happen all at once — it compounds gradually through the month, with each unresolved discrepancy making the next one harder to detect and resolve.
Days 1–7
Days 8–14
Days 15–21
Days 22–30
What a Commission Tracker for Web Agencies Must Do — 5 Non-Negotiable Requirements
Generic commission tracker software — built for staffing agencies, affiliate programmes, or enterprise sales floors — addresses the wrong version of the problem. A web agency commission tracker needs to solve the divergence problem at its root: the absence of a shared real-time record that both parties trust.
Shared real-time close count — same number visible to both parties at all times
The verified close count per SDR must be visible to both the agency owner and the SDR in real time — updating the moment a close is approved, accessible from any device, showing the same figure to both parties simultaneously. Both parties referencing the same live number eliminates the input data divergence failure mode entirely.
Verification gate that holds commission until owner approval
Every close must enter a Pending Verification state before being counted or calculated. Commission does not fire until the agency owner explicitly approves the close with the verified invoiced amount. This creates the single authoritative moment at which both parties have agreed the close is real and the deal value is confirmed.
Dual timestamp — close date and verification date both recorded permanently
Every close must record both the date the SDR logged it and the date the owner verified it. Commission plan specifies which date determines month attribution. Both timestamps are visible to both parties. Month attribution is a fact derived from timestamps — not a decision the owner makes at month end.
Automated tier calculation on verified invoiced value
Commission must calculate automatically the moment the owner enters the invoiced amount and approves the close — applying the correct tier rate from the configured structure without manual lookup or arithmetic. The SDR sees the commission figure update on their leaderboard within seconds of the owner's approval.
Rejection logging with permanent written reason — notified to SDR immediately
Every rejected close must log a permanent written reason entered by the owner at the time of rejection, with immediate notification to the SDR. The SDR does not discover excluded closes at month end — they are informed at the moment of rejection with the specific reason.
Manual Tracking vs Automated Commission Tracker — Side by Side
| Tracking Dimension | ✗ Manual Tracking (Spreadsheet / Memory) | ✓ Automated Commission Tracker |
|---|---|---|
| Close count visibility | Agency owner sees their record. SDR sees their parallel record. Neither sees the other's in real time. | Both parties see the same verified close count on the shared leaderboard, updating in real time. |
| Deal value input | SDR logs quoted price. Owner may use a different figure at month end. Discrepancy discovered at statement. | Owner enters invoiced amount at verification. Both parties see the verified figure at the same moment. |
| Commission calculation timing | Calculated at month end from memory and separate records. Errors discovered after payment. | Fires automatically on each approved close. SDR sees their running total update in real time. |
| Month attribution | Determined by the owner at month end based on their record. SDR may have different understanding. | Derived from timestamped close date and verification date. Applies the rule written in the commission plan. Objective. |
| Rejected close communication | SDR discovers missing commission at month end. Cannot identify which close is absent or why. | SDR notified at moment of rejection with permanent written reason. Dispute isolated to specific close immediately. |
| Shadow accounting risk | High — SDR has no real-time visibility, so maintaining a parallel record is the only way to track earnings. | None — both parties see the same record. Maintaining a separate tracker is redundant. |
| Month-end statement | First time many figures are shared. High dispute probability because one or both parties are seeing new information. | Confirmation of what both parties have been watching all month. Zero new information. Zero dispute probability. |
Why general commission tracker software does not solve the web agency problem: Konquest is built for staffing — split placements, contract extensions, and placement fees. Qobra and Canidium are built for enterprise sales floors with Salesforce integrations and RevOps teams. Affiliate tracking software handles clicks and conversions, not owner-verified website project closes. Web agency commission tracking has one unique requirement that none of these platforms address: the verification gate — the specific workflow where a live person (the agency owner) reviews and approves each close before commission fires, using the actual invoiced amount rather than any self-reported figure. The verification gate is what creates the shared authoritative record. Without it, every other tracking feature is built on unverified data.
- Verification gate — every close holds in Pending until owner approves with verified invoiced amount
- Real-time leaderboard — both parties see the same verified close count and commission total throughout the month
- Dual timestamp — close date and verification date recorded permanently, month attribution from timestamped rule
- Automated tier calculator — fires on owner-approved invoiced amount, correct rate applied without manual lookup
- Rejection logging — permanent written reason, immediate SDR notification, isolated dispute instead of month-end mystery
- Monthly statement from verified record — confirmation of shared record both parties watched all month
Frequently Asked Questions
What is a commission tracker and why do web agency teams need one?
A commission tracker is a system that records verified closes, calculates commission automatically, and makes the running total visible to both the agency owner and the SDR in real time. Web agency teams need one because manual commission tracking — spreadsheets, notes, or memory — produces four specific failure modes: input data divergence (counting different events), deal value drift (quoted vs invoiced discrepancy), timing gaps (month attribution misalignment), and delayed visibility (month-end surprises). Any one of these failure modes produces commission disputes. A commission tracker that includes a verification gate, real-time shared visibility, and automatic calculation eliminates all four.
What is shadow accounting in commission tracking?
Shadow accounting occurs when an SDR begins maintaining their own parallel commission record because they cannot trust the agency's tracking system to reflect what they believe they have earned. It is a symptom of tracking failure — not dishonesty. An SDR who shadow accounts is protecting themselves in a system where they have no independent way to verify the running total. The solution is a shared real-time tracker that makes both parties' records identical — so maintaining a separate parallel record becomes unnecessary and irrelevant.
Why does spreadsheet commission tracking cause disputes?
Spreadsheet commission tracking causes disputes through four specific mechanisms: (1) both parties update their records from different sources and arrive at different close counts; (2) the SDR logs quoted price while the owner invoices a different amount, creating a deal value discrepancy; (3) closes logged at month end may be reviewed in the next month, creating timing attribution disputes; (4) the SDR has no real-time visibility into the running total, so any discrepancy is discovered at month end when reconstructing the entire month requires hours. A commission tracker with a verification gate and shared real-time visibility eliminates all four mechanisms.
Why doesn't general commission tracker software solve the web agency problem?
General commission tracker software (Konquest for staffing, Qobra/Canidium for enterprise sales floors, affiliate trackers for clicks) does not include the verification gate workflow specific to web agency cold calling — where a live agency owner reviews each close, enters the actual invoiced amount, and approves before commission fires. Without this gate, every tracking feature is built on unverified data. The verification gate is the foundational requirement that makes the tracker's running total a shared authoritative record rather than an aggregation of self-reported figures.
One Commission Record. Both Parties See It. All Month.
Verification gate. Real-time shared leaderboard. Automated calculation. Dual timestamps. Rejection reasons at time of rejection. The commission tracker that makes shadow accounting irrelevant because both parties are always looking at the same number.
Start Free Trial →