Detail Reports
4 terms in Sales Reports
Transaction Detail
#A line-level report providing granular information about individual sales transactions that feed into compensation calculations. Each row represents a single order or booking, displaying fields such as transaction ID, booking date, account name, product or SKU, revenue amount, crediting details, and resulting commission or bonus amounts. Transaction Detail reports serve multiple audiences: reps use them to verify they were paid correctly on every deal, managers use them to understand team production patterns, finance uses them for accrual reconciliation, and sales ops uses them to audit crediting accuracy. The report is the primary tool for resolving pay disputes — when a rep questions their commission, the first step is always pulling the Transaction Detail to verify that every eligible deal was captured, correctly credited, and accurately calculated.
A rep's monthly commission statement shows $8,400 in variable pay. They pull their Transaction Detail report and see 12 transactions: 10 match their CRM records, but two are missing — a $30K deal that closed on the 28th (likely missed the batch cutoff) and a $15K renewal they expected credit on. They escalate to Sales Ops with the Transaction Detail as evidence, and Ops confirms the $30K deal will be included in next month's adjustment and the $15K renewal was credited to the CSM per the plan's renewal crediting rules.
Section 11.2 — Statements and Reporting Participants will receive a monthly compensation statement within 10 business days of period close. The statement shall include a Transaction Detail report listing all credited transactions, commission calculations, and adjustments. Participants have 30 days from statement date to dispute any transaction. Disputes must reference specific Transaction IDs and be submitted in writing to Sales Operations.
Transaction Detail Report columns: Transaction ID, Booking Date, Account Name, Opportunity Name, Product Category, Gross Revenue, Net Revenue (after adjustments), Credited Rep, Credit %, Credited Amount, Measure, Rate Applied, Commission Earned, Payment Period. Filters: Date Range, Rep, Product, Account. Subtotals by product category, grand total with YTD running sum.
Calculation Detail
#A Calculation Detail report is the definitive transparency artifact in sales compensation. It decomposes every incentive payment into constituent parts: the creditable transaction, credit amount, rate table or formula applied, multipliers or accelerators in effect, and resulting payout per plan component. It traces from source transaction through crediting rules, attainment percentage, rate lookup, and final earning. This is the most critical report for dispute resolution because it lets reps see exactly how each dollar was computed. Organizations that fail to provide adequate calculation detail face higher dispute volumes and eroded trust in the compensation program.
Rep Sarah Chen's Q2 statement shows a $2,847 commission on Deal #4821. The report breaks this down: $189,800 credited revenue at 85% YTD attainment (Tier 2 rate of 1.5%), yielding $2,847.00. She sees the booking date, 100% direct credit split, and rate table version FY26-v2.
Section 8.1 — Calculation Transparency. The Company shall provide each Participant with a Calculation Detail statement no later than five (5) business days following each payment cycle, including: transaction identifier, date, credited amount, applicable quota component, attainment percentage, rate applied, and gross incentive earned.
Calculation Detail Report: columns for Rep Name, Period, Transaction ID, Booking Date, Credited Amount, Plan Component, Attainment %, Rate Applied, Gross Earning, Adjustments, Net Earning. Filterable by rep, period, and attainment tier. Drill-down to source records.
Payment Detail
#A Payment Detail report is the authoritative record of all compensation disbursements made to sales personnel during a given period. It captures payment date, gross amount, individual earning components (commissions, bonuses, SPIFs, draws, adjustments), tax withholdings, and net payment. In mature SPM organizations, this report integrates with payroll and serves as the reconciliation bridge between the incentive engine and general ledger. It must distinguish between regular-cycle payments, off-cycle corrections, advances, and recovery deductions. Common failures include missing line items after retroactive adjustments and timing mismatches between calculation and payroll funding dates.
Rep Marcus Johnson's March payment detail: Base Commission $4,125, New Business Bonus $1,500, Q1 SPIF $750, Draw Recovery -$800, Gross $5,575, Federal Tax -$1,226.50, State Tax -$390.25, Net Payment $3,958.25. Direct Deposit funded March 15.
Section 9.2 — Payment Documentation. Each payment shall include a detail statement itemizing earning components, deductions, draw recoveries, tax withholdings, and net disbursement. Participants shall receive details electronically no later than the payment date. Discrepancies must be reported within thirty (30) calendar days.
Payment Detail Report: columns for Rep Name, Payment Date, Earning Type, Gross Amount, Federal Tax, State Tax, Net Amount, Payment Method. Summary totals by earning type. Filterable by period and earning category. Exportable for payroll reconciliation.
Adjustment Detail
#An Adjustment Detail report documents every modification made to previously calculated or paid compensation, providing a complete audit trail of what changed, why, when, and who authorized the change. Adjustments arise from credit reassignments, retroactive quota changes, deal cancellations, data corrections, manual overrides, and dispute resolutions. Each record captures original value, adjusted value, delta, reason code, authorizing manager, and effective date. This report is critical for SOX compliance because auditors require evidence that every compensation modification follows documented approval workflows. Organizations lacking robust adjustment tracking often discover unauthorized changes during audits, creating compliance and financial risk.
Q1 shows 47 adjustments totaling -$28,400 net. Entry #A-0312: Rep Kim Park received a -$3,200 reversal after Acme Corp cancelled their $213K contract within the 90-day clawback window. Reason: CANCEL-90DAY. Approved by Director Lisa Tran, March 8.
Section 10.3 — Adjustment Documentation. All adjustments shall be documented including: original amount, adjusted amount, reason code, supporting documentation, approving authority, and effective date. Adjustments exceeding $5,000 require Director-level approval. Adjustments exceeding $25,000 require VP Sales Operations approval per Section 10.4.
Adjustment Detail Report: columns for Adjustment ID, Rep Name, Original Amount, Adjusted Amount, Net Change, Reason Code, Approver, Effective Period. Summary by reason code with trend chart. Filterable by period, reason code, and approval status.
Test Your Knowledge
0 of 4 correctWhich term does this describe?
A line-level report providing granular information about individual sales ______s that feed into compensation calculations. Each row represents a single order or booking, displaying fields such as ___…