Automated commonsku Monthly Commission Report
On the first run of each month, WebRun opens commonsku, pulls all orders invoiced in the previous month, calculates gross commission for each sales rep at your configured rate, and posts a summary digest to Slack while logging the full breakdown to a Google Sheet for payroll review.
How do I automatically calculate and report sales commission for my promo reps each month?
WebRun opens commonsku on the first Monday of each month, pulls every order invoiced in the previous month, and calculates each sales rep's total sales and gross commission at your configured rates. It posts a per-rep summary to Slack and logs the full order-level breakdown to a Google Sheet so payroll review takes minutes, not hours.
- Monthly commission calculations are ready for payroll review every first Monday
- Unassigned orders are flagged automatically before they affect a rep's commission
- Google Sheets provides a permanent order-level audit trail for every commission period
Built for promotional products distributors · promo business owners · sales managers · payroll administrators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.commonsku.comin a real browser with your saved login - no setup, no API keys. -
1
commonsku - pull invoiced orders and assign to sales reps
commonsku.com
WebRun opens commonsku to pull invoiced orders and assign to sales reps. - Open commonsku and filter orders to those invoiced in the previous calendar month
- Read the order total, gross margin, assigned sales rep, and commission rate for each order
- Group orders by sales rep and sum total sales and calculated commission for each
- Capture any orders without an assigned rep and flag them for review
Done when Every invoiced order from last month is grouped by rep with total sales and commission calculated.
-
2
Slack - post commission summary digest
slack.com
WebRun opens Slack to post commission summary digest. - Post a commission summary digest to your owner or finance Slack channel
- List each rep's total invoiced sales, commission rate, and gross commission earned
- Include a total line for the full team and flag any unassigned orders
Done when Last month's commission summary is posted to Slack.
-
3
Google Sheets - log full commission breakdown for payroll review
google.com
WebRun opens Google Sheets to log full commission breakdown for payroll review. - Write the full order-level commission breakdown to a monthly tab in the commission tracking Sheet
- Include order number, client, order total, margin, rep, and commission for each row
- Add a summary row at the top of each tab with per-rep totals
Done when Full commission breakdown is logged in Google Sheets ready for payroll review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it process payroll or pay out commissions automatically?
No. WebRun generates the commission summary and logs it for your review. All payroll decisions and payments are made by you after reviewing the report.
How does it know each rep's commission rate?
You configure the commission rate for each rep when setting up the workflow. WebRun applies those rates to the invoiced order totals or margins it reads from commonsku.
What if an order is assigned to the wrong rep?
The report reflects the rep assignment as recorded in commonsku. If an order is unassigned or misassigned, it is flagged in the Slack summary for you to correct before finalizing payroll.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.