CSV Template

Commission trackingwithout the spreadsheet.

Track sales rep commissions and payouts with a simple form and download a clean CSV ready for your compensation management and accounting systems.

Simple commission formAccounting-ready CSVTry it free

Sales Rep Commission & Payout Tracking

Try the template with up to 3 commission records

What You'll Collect

Sales Rep Name

String
*Required

The person's name for identification and communication.

Sales Rep Email

Email
*RequiredUnique

Email address for contact, communication, and account recovery.

Commission Period

String
*Required

Free text, exported as the “commission_period” column.

Total Sales

Number
*Required

Validated as a number. Thousands separators like 1,200 are accepted.

Commission Rate (%)

Number

Validated as a number. Thousands separators like 1,200 are accepted.

Commission Amount

Number
*Required

Price or financial amount for transaction records.

Bonus

Number

Validated as a number. Thousands separators like 1,200 are accepted.

Total Payout

Number
*Required

Validated as a number. Thousands separators like 1,200 are accepted.

Payout Status

Enum

Choose one of: Pending, Processed, Paid, Disputed.

Payout Date

Date

A date, validated before download.

Payment Method

Enum

Choose one of: Direct Deposit, Check, Wire Transfer, PayPal.

Notes

String

Detailed description or notes about this record.

Need more than three records?

Track up to a thousand commission records instead.

The free template is limited to three rows so you can try the workflow. Create your own Import Builder form when you need to track larger sales teams or more periods.

Create your own form

Up to 1,000 rows

Track larger sales teams and multiple commission periods without passing spreadsheets around.

Custom fields

Add any commission, bonus, or payout information relevant to your compensation.

Validation

Help your team provide complete and consistent commission data.

Reusable forms

Use the same form for every commission cycle and payout period.

How it works

From commission details to accounting-ready CSV in three steps.

01

Collect

Give your team a simple form to enter commission and payout information.

02

Complete

Keep the information structured and make it easier to avoid missing or inconsistent data.

03

Download

Download the completed CSV and use it with your accounting or payroll system.

Why use a form?

Tracking commissions is harder than paying them out.

Sending a spreadsheet and asking your team to fill in commission information can lead to missing fields, inconsistent values, calculation errors, and unnecessary back-and-forth.

A structured form gives your team a clearer way to provide the information your accounting and payroll systems need.

Missing information

Required commission fields are easier to communicate before the CSV is created.

Inconsistent values

Use structured fields and predefined options where appropriate.

Spreadsheet back-and-forth

Collect commission information directly through a simple browser form.

Sales Rep Commission & Payout Tracking Template

A simple way to manage sales commission and payout tracking

Use this template to collect sales rep commission information such as rep names, total sales, commission rates, commission amounts, bonuses, payout status, payout dates, and payment methods.

Instead of sending your accounting team a spreadsheet and asking them to work out which columns to complete, give them a simple form built around the information your payroll and accounting systems need.

When they're finished, download the CSV and use it with your payroll processing, accounting software, or compensation management system.

If you need different fields, additional validation or more than a few rows, create your own Import Builder form and configure it for your workflow.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by any payroll processing or accounting software provider.