Compute figures such as balances, totals, or commissions.

Calculate Q2 sales commissions for the account reps so payroll can process them by Thursday. Use the closed-won sheet and apply the tiered commission schedule, flag contracts with partial payments this quarter, and sum commissions per rep in a single payout column. Recheck that the formula references the commission schedule sheet and that no rows are excluded by filters.

Before I send commissions to payroll, make approval easy for sales ops. Show each rep’s gross sales, deductions, and final payable in that order, surface any contract overpayments or manual adjustments, and put a column that links to the original closed-won row. Highlight anything that reduces pay compared with last quarter so the reviewer can spot anomalies fast.

I ran commissions for April–June and noticed two senior reps’ totals are $1,200 and $3,400 lower than last quarter despite similar sales. I’m the Account Manager, payroll waits Thursday, and I suspect either a changed tier threshold or omitted closed-won rows, but I don’t know which. What diagnosis should I run first and the fastest formula or check to isolate the discrepancy before payroll cut-off?

Every quarter we find commission mistakes after payroll posts and have to process corrections—costing us time and trust with reps. I handle commission runs and want to stop this. Which two habits should I change in the commission process—one to prevent calculation errors and one to make approval reliable—so we avoid post-payroll corrections?