Commission Desk

Guides

For bookkeepers: commission statements for your clients

If you keep the books for a business with a few commissioned reps, the monthly commission run often lands with you: an export from the client, a spreadsheet, and questions from reps afterwards.

What Commission Desk does in that job

  • Takes the client's export of closed deals as a CSV file with four columns: deal, rep, date, amount.
  • Applies each rep's rate, and an optional higher rate above a monthly threshold.
  • Shows every deal with the commission it earned, so the figure can be traced.
  • Issues each rep's statement as a private read-only page that does not change after it is issued.
  • Keeps a change log of every correction.

What it does not do

  • It does not pay anyone or post to payroll or the ledger. You enter the totals where you enter them today.
  • It does not handle splits, clawbacks, draws, bonuses or quotas over several months.
  • It does not connect to a CRM or an accounting package. An export from QuickBooks is reshaped into the four columns first; a guide on this site shows how.
  • One account holds one business's reps. There is no multi-client view.

Checking it against your own figures

The sample page takes a whole team's month (up to 10 reps and 200 deals) without an account and stores nothing; a free account holds 3 reps and 150 deals. Compare the statements with your spreadsheet line by line. Each deal's commission is rounded to the nearest cent and the total is the sum of the lines; if your sheet rounds the total instead, expect differences of a few cents and no more.

Data

Statements contain names and pay. They are stored in the account, shown only to its signed-in members and to holders of a statement's link and access code, and deleted with the account.

Sales commission calculatorTry it with sample dataSee pricingCreate a free account

More guides