Bookkeeper / Accounting

Write a commission or spiff calculation memo

  • Est. time saved20 min per pay period
  • Works withCopilot · ChatGPT · Gemini
  • GroupRun the Shop
  • Ref.WO-0002
Never paste: Bank or card numbers, account logins, employee pay rates and SSNs, customer addresses or phone numbers, tax IDs, or financing applications.

When to use it

When explaining how commissions or spiffs were calculated for a pay period.

The prompt

Copy this, then replace everything in [brackets].

Write a clear memo explaining commission/spiff calculations.
Plan rules: [% of sold/collected, spiffs per membership, clawbacks for recalls/cancellations]
This period: [use tech initials and job totals only]

Explain the rules in plain English, show one worked example, and list any adjustments with reasons. I'll verify all math in payroll.

Before / after

Before: Techs arguing about their check every two weeks.

After (example output):

Rule: 5% of collected revenue on sold repairs + $25 per membership. Example (MR): $8,400 collected x 5% = $420 + 3 memberships x $25 = $75. Adjustment: -$40 clawback, job 4402 refunded.

Tips

  • Keep names and pay rates out of the AI. Use initials and totals.
  • Paste totals and categories, not raw bank exports with account numbers.
  • The AI drafts and organizes. Your accountant or CPA signs off on anything tax-related.
  • Review every draft before you send it. You’re accountable for what goes out.