# Sales rep tracking spreadsheet for the shift you cannot see

A sales rep tracking spreadsheet is the shift row: clocked in, clocked out, knocks, contacts, appointments, and confirmed sales. Knockdesk is field sales software for that activity while the rep is on the turf. This sales rep tracker excel file is a CSV that opens in Excel and Google Sheets. No email is required.

## How to fill this sales activity tracker template

One row per rep per shift. Clocked in is not knocking time. An unverified visit still belongs on the row so Friday does not hide the gap.

1. Write the rep name and the clock-in time when the shift starts.
2. Write the clock-out when the shift ends, not when the last text arrives.
3. Count knocks, contacts, appointments, and confirmed sales from the same day.
4. Mark unverified visits in their own column. Do not fold them into knocks.
5. Open the CSV in Excel or Google Sheets. Do not treat clocked time as time at the door.

## Where a sales rep tracker excel file goes quiet

The sheet can hold a clock. It cannot tell you who is still in the field, and it cannot flag a quiet route until someone pastes the evening numbers. The manager learns the shift from a phone call.

**The clock.** Clocked in is hours on the roster. It is not proof the rep was at a pin.

**Unverified.** A visit typed without a location still looks like a knock if you only read the knock column.

**The call.** If the sheet updates after dinner, the late clock-in and the no-show already happened.

## Run this in Knockdesk on the activity

See the crew that is clocked in, the knocks on the turf, and the unverified streak while the shift is still on. Full desk is on the pricing page. A free trial is not open.

## Keep going from this rep tracker

- [Field sales resources](/resources): The hub this template opens from, with the other sheets in this batch.

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

- [Sales rep tracking](/features/sales-rep-tracking): The live crew map and the shift the rep is in.

- [Sales territory plan](/templates/sales-territory-plan-template): See the area that person was supposed to own that day.

- [Sales route planner](/templates/sales-route-planner-template): Line the open stops up against the clocked shift.

- [Sales call report](/templates/sales-call-report-template): Read the visit next to the knock count on the shift row.

- [Door knocking tracker sheet](/templates/door-knocking-tracker-spreadsheet): Split knocks and unverified visits at the pin, not in a total.

## FAQ

### What is a sales rep tracking spreadsheet?

A sales rep tracking spreadsheet is one row per shift: clocked in, clocked out, knocks, contacts, appointments, confirmed sales, and unverified visits.

### Does this sales rep tracker excel file open in Google Sheets?

Yes. The download is a CSV. It opens in Excel and Google Sheets. No email is required.

### What is a sales activity tracker template on this page?

A sales activity tracker template is this same shift row. Clocked in is not knocking time. Unverified visits stay in their own column.

### Why keep unverified visits off the knock total?

A typed knock without a location still looks like work if you only add the knock column. The unverified column is how Friday stays honest.

### Can this sheet show who is in the field right now?

No. It holds the clock after someone types it. It cannot show a live shift or a quiet route while the day is still on.

### How much does Knockdesk cost?

Full desk is on the pricing page. There is no second Knockdesk tier. A free trial is not open.