Dealership Commission Payroll: Getting Draws and Guarantees Out of the Spreadsheet

It’s the second business day of the month. Two commission sheets still haven’t come back from the sales desk. The controller can’t close the financial statement until the sales payroll is done. And somebody’s 90-day guarantee ended last Tuesday, but the pay plan never got changed. For a lot of rooftops, that’s what dealership commission payroll looks like: a workbook with one tab per salesperson, a pile of sign-offs, and a supplemental run keyed in by hand.

The math usually isn’t the problem. Most controllers can work out a tiered commission in their sleep. The handoff is the problem. Every number that leaves the spreadsheet has to be typed into payroll again, on a deadline, often by one person who also handles accounting for a second store.

This post walks through where the monthly commission run tends to break, and what changes when commissions, draws and guarantees run inside payroll instead of next to it. If you want a refresher on how the pay plans themselves are built, start with our guide to how commission-based pay works for auto sales staff. This one is about the process.

Why Commission Pay Still Lives in a Spreadsheet

Blame the pay plans. A single salesperson might get a semi-monthly draw, a percentage of front-end gross that climbs by tier, unit bonuses, spiffs, and separate lines for Commission (New) and Commission (Used). Plenty of DMS setups can’t turn that into a commission statement that follows every rule. So the office manager or controller builds one in Excel.

Then the workbook grows. Each tab holds deal numbers, gross, spiffs and adjustments, plus a signature line for the salesperson and another for the GM or owner. At month end, the totals get re-keyed into payroll as a separate bonus or commission run, often with negative offsetting entries so the draw comes back out.

It works. Until it doesn’t.

How a commission is coded matters too. Commissions are supplemental wages, and the IRS lets employers use an optional flat federal withholding rate when supplemental pay is identified separately from regular wages (see IRS Publication 15). A total typed into the wrong earnings code can throw that off, along with year-to-date totals and the W-2.

The bigger risk is concentration. The whole process depends on one person, one file and one sitting. If that person is out the week of month end, who else knows which tab is current?

Where the Monthly Commission Run Breaks Down

Draw recovery tracked in a single cell

A draw is an advance. Every month, someone has to net it against what the salesperson actually earned. If commission beats the draw, the difference gets paid. If it falls short, the balance carries forward or gets forgiven, depending on the plan. In a spreadsheet, that running balance is a cell somebody updates by hand. Miss one month and every month after it is wrong.

Guarantees that expire on a date nobody’s watching

New hires often start on a 90-day guarantee so they can earn while they build a book of customers. On day 91, the pay plan changes. At many stores, the controller counts out the 90 days, writes the date down, and updates the pay setup when it arrives. If that date slides past a payroll, the dealership either overpays the guarantee or has to claw money back. Neither conversation is fun.

Month-end payrolls that have to run in order

Some groups run three commission payrolls every month: sales, then parts and service, then managers. The order isn’t random. Sales commissions feed the financial statement, and manager pay plans often depend on what that statement shows. So sales goes first, the statement gets populated, and the other two follow. That’s why the first few days of the month hurt. Commission payouts, the GM’s financial statement review and payroll finalization all land at once.

Late sheets and corrections after submit

Then there’s the washout sheet that shows up two hours after payroll was submitted. At a bigger group, a few sheets slip through entirely, and the salesperson finds out when the deposit hits. Now it’s a correction check, a note in the file, and a top performer who trusts the next check a little less.

Notice the pattern? Almost every one of these is a timing problem, not a math problem.

Pay Plan Changes Need a Paper Trail

Commission plans change far more often than base pay. A new tier, a revised spiff, a sales manager’s bonus tied to a different line on the statement. Each change needs sign-off, and the dealership needs to show the employee saw it and agreed. At a lot of stores, that still means a paper payroll action form walked from desk to desk, with the signed plan filed wherever it ends up.

That paper matters more than it looks. Commission disputes usually come down to what the plan said on the day the deal closed. State wage laws also vary on when a commission counts as earned and what can be deducted from it, so a signed, dated plan is often your best evidence.

Year-over-year questions create the same kind of headache. When ownership asks how a salesperson’s earnings compare to last year, someone opens last year’s workbook, hopes the layout didn’t change, and builds the comparison by hand. Salespeople feel it as well. A commission check nobody can explain is one of the fastest ways to lose a good closer, and NADA’s dealership data shows how much turnover the industry already carries.

Running Dealership Commission Payroll Inside Netchex

Instead of calculating in one place and paying in another, you can keep the whole cycle in payroll. Here’s how that works day to day.

Commission data comes in from your DMS. Netchex integrates with Dealertrack, CDK Global, Tekion, Reynolds & Reynolds, Automate, Dominion and Autosoft. With the Dealertrack integration, commissions, draws, spiffs and technician time flow into payroll, and GL data pushes back into Dealertrack after payroll runs. No manual export.

Draws, spiffs and commissions run natively. Netchex payroll handles commissioned pay, draws, spiffs and mixed-rate pay in a single run. You can add and order earnings codes on the payroll grid the way your store thinks about pay, so Commission (New), Commission (Used) and spiffs stay separate on the stub.

Guarantee end dates get scheduled, not remembered. Compensation changes can be effective-dated. Set the regular pay plan to start on day 91 when you hire the salesperson, and it takes effect on that date automatically, with the change recorded in the audit history.

Problems show up before you submit. OneScreen Payroll flags discrepancies and missing data across every rooftop and entity before payroll goes out. A duplicate payroll warning stops an accidental second submission for the same check date.

Late sheets have a clean path. A missed commission can go out on a supplemental payroll, paid by direct deposit with about two business days’ lead time, or as a same-day on-demand check printed in the office. We cover the options in more detail in our post on off-cycle compensation payments.

Pay plan changes carry their own signatures. A compensation change can route through an approval workflow with tiered approvers and electronic signatures, and the employee can get an acknowledgment once it’s complete. Each approval, decline and comment lands on the employee’s timeline as an audit trail.

Last year’s numbers are a report, not an archive dig. Report Builder saves templates for reports you run every month, and point-in-time reporting shows what the data looked like on any given date. Earnings comparisons come from the same system that paid the commissions.

When a question does come up, you’re talking to a support team that understands flat-rate pay, draw compensation, flag time and DMS environments. More than 1,700 dealerships run payroll on Netchex, and the team is rated 8.9/10 for Quality of Support on G2.

You don’t have to retire the spreadsheet overnight. Start with the piece that hurts most, usually the re-keying or the guarantee dates, and move that into payroll first. The rest tends to follow.

Frequently Asked Questions

This guide reflects publicly available product information and independent reviewer data (G2, Capterra, Trustpilot, Yelp, Better Business Bureau, Reddit, Software Advice, GetApp) as of 2026. Feature availability and pricing may vary by plan. Contact each provider for current details.

Disclaimer: Any product roadmap or future plans provided herein are for informational purposes only. They do not represent a commitment to deliver any material, code, feature, or functionality. Plans may change without notification. The development, release and timing of any features or functionality described remain at the sole discretion of Netchex, its affiliates, and partners. Netchex does not give legal, tax, or accounting advice. You are responsible for ensuring your use of Netchex product meets your individual business and compliance requirements.

Print this page