# Match the file to the confirmation moment

Commission reconciliation is matching a vendor file to won deals by CRM email and address, then paying the rate that was live at confirmation, as the sales commission structure guide sets out. Knockdesk is field sales software that reads a CSV or Excel upload and never invents a rate.

## The file only pays what you already saved

You feel it when the vendor workbook and the desk disagree on Friday. How to reconcile commissions is not a paste into a new column. The rep column must be the CRM email. An email match adds 40. An exact address adds 50. 40 plus 50 is 90, which meets the default auto-confirm threshold of 80. 40 plus 25 is 65, which waits in review.

**The email.** Map Rep email to the user's CRM email, exact. A display name will not assign the row.

**The address.** Map the full address line, or street, city, state, and ZIP. Do not map both styles.

**The threshold.** It defaults to 80 and can be 0 to 100. A match below it goes to the review queue and is not confirmed.

## Mistakes that miss the file

The expensive miss is rebuilding Friday in a third sheet so the dollars match by force. If no won deal qualifies, a won deal can be created only when an active closed-won outcome stage exists. If it cannot, the row errors and no commission is written. A missing rate stays empty.

| Mistake | What you think you got | What the file holds |
| --- | --- | --- |
| Paste a new Friday column | A match | A rate nobody saved |
| Map a display name | An assigned rep | Names are not matched |
| Map full address and street through ZIP | More location | Do not map both styles |
| Skip the confirmation value | Every row pays | Only the status you pick is processed |
| Treat review as confirmed | A faster Friday | A score under 80 is not confirmed |

## Upload the file. Leave a blank empty.

On Knockdesk an admin opens Reconciliation, enables CSV upload, and processes a.csv,.xls, or.xlsx file up to 10MB. There is no live sync. The sample deal, Oak Ave install at $4,200, won and pending review, is a fixture, not a customer payout. Full desk is on the pricing page. A free trial is not open.

## Keep going from the file

- [Sales commission structure](/guides/sales-commission): The pillar this how-to sits under: the window the file has to hit.

- [Commission tracking on the desk](/features/commission-tracking): The product page for the vendor file, the match, and the ledger.

- [Sales commission calculator](/tools/sales-commission-calculator): Recompute the example dollars before you process the sheet.

- [Calculate the paid amount](/guides/how-to-calculate-sales-commission): Worked dollars for the rate the file should hit.

- [Handle the reversal](/guides/how-to-handle-commission-chargebacks): When the file says the sale should not pay, void writes a reversal.

- [Back to the guides hub](/guides): The index this how-to opens from.

- [Full desk pricing](/pricing): One Knockdesk plan: Full desk.

## FAQ

### What is commission reconciliation?

Commission reconciliation is matching a vendor file to won deals by CRM email and address, then paying the rate that was live at confirmation. A missing rate stays empty.

### How to reconcile commissions without inventing a dollar?

How to reconcile commissions is to upload the file, map the CRM email, pick the confirmation value, and leave a missing rate empty. Do not paste a new Friday column.

### Why is 40 plus 50 equal to 90?

An email match adds 40. An exact address adds 50. 40 plus 50 is 90, which meets the default auto-confirm threshold of 80. 40 plus 25 is 65, which goes to the review queue.

### What file can I upload?

A.csv,.xls, or.xlsx file up to 10MB. Only the first sheet is processed. This is a file in, not a live sync.

### What if no won deal matches the row?

A won deal can be created when an active closed-won outcome stage exists. If it cannot, the row errors and no commission is written.

### How much does Knockdesk cost?

Full desk is on the pricing page. There is no second Knockdesk tier. A free trial is not open. Book a walkthrough and bring the vendor sheet from this week.