Payroll Clerk – Payroll Systems Migration

Knightscope; California (MO); On-site; USD 41,000 - 45,000; Full time

Benefits offered by this job

Stock options

Medical/dental/vision

401(k)

PTO

Job summary

Knightscope, headquartered in Sunnyvale, CA, is migrating its payroll systems and seeks a detail-oriented Payroll Clerk. You will gather historical payroll data from ADP TotalSource and ADP Workforce Now, verify records, and support the payroll team through transition and ongoing data integrity tasks.

Responsibilities include coordinating with ADP and internal teams, reconciling benefits data, building Excel tools, and ensuring strict confidentiality of payroll information.

Qualifications

• Associate degree (2 years) in accounting or business admin, or 1–2 years of payroll experience.
• Strong Microsoft Excel skills including VLOOKUP, XLOOKUP, pivot tables, and multi-file comparisons.
• Knowledge of payroll principles (gross-to-net, deductions, withholdings, GL basics).
• Experience with ADP TotalSource and/or ADP Workforce Now preferred.

Responsibilities

• Support end-to-end payroll systems migration: download, extract, and organize multi-year payroll data from ADP systems.
• Coordinate with ADP account reps and implementation team on data formats and migration timelines.
• Collect and reconcile benefits and retirement plan data, verify employee records as needed.
• Perform side-by-side comparisons across multiple payroll reports and data exports to ensure accuracy.
• Build and troubleshoot Excel workbooks and formulas to support reconciliation and reporting.
• Identify discrepancies and help build repeatable data migration processes.
• Provide post go-live payroll support: timesheets, overtime calculations, onboarding payroll data.

Skills

Excel proficiency

Education

Associate degree

Tools

ADP TotalSource

ADP Workforce Now

Job description

About Knightscope Knightscope (NASDAQ: KSCP) is a security technology company building the nation's first Autonomous Security Force - autonomous machines, AI-driven software, and elite security professionals operating as one integrated managed service. The Company is on a mission to make the United States of America the safest country in the world. One Team. One Force.

About Knightscope Knightscope (NASDAQ: KSCP) is a security technology company building the nation's first Autonomous Security Force - autonomous machines, AI-driven software, and elite security professionals operating as one integrated managed service. The Company is on a mission to make the United States of America the safest country in the world. One Team. One Force.

About The Role Knightscope is seeking a detail-oriented and highly organized Payroll Clerk to play a key role in a major payroll systems migration and to provide ongoing support to the Payroll team. In this role, you will gather, organize, and verify a large and time-sensitive volume of payroll-related data - historical payroll and multi-year tax records from ADP TotalSource and ADP Workforce Now, plus benefits and retirement plan data - and perform meticulous, large-scale comparisons to ensure a smooth and accurate transition to Knightscope’s new payroll system. This requires coordinating directly with ADP, People Operations, Finance/Accounting, and employees. Once the migration is complete, this role continues as an ongoing member of the Payroll team, supporting repetitive, comparison-heavy work - reconciling reports and data sets, checking work for accuracy, and maintaining organized, audit-ready records in Excel.

Location: ONSITE - Sunnyvale, CA HQ

Key Responsibilities

• Support the end-to-end payroll systems migration: download, extract, and organize multi-year historical payroll, timekeeping, and tax data from ADP TotalSource and ADP Workforce Now, including prior-year Forms 941/940, state and local withholding/unemployment filings, and W-2/W-3 records.
• Coordinate directly with ADP account representatives and the new system’s implementation team to confirm data extraction formats, file specifications, and migration timelines.
• Collect and reconcile benefits and retirement plan data processed through payroll, and verify employee-level records as needed.
• Perform detailed side-by-side comparisons across multiple payroll reports, pay periods, and data exports to confirm accuracy and completeness - often across five or more data sets at a time.
• Build, maintain, and troubleshoot Excel workbooks and formulas (VLOOKUP/XLOOKUP, pivot tables, conditional formatting) to support payroll reconciliation and reporting.
• Identify and document discrepancies, elevate issues, and help build repeatable processes for future data migrations or system changes.
• Provide ongoing payroll support after go-live: collect and verify timesheets, confirm overtime/double-time/shift differential calculations, and verify new hire tax, direct deposit, and onboarding payroll data.
• Maintain strict confidentiality and data accuracy standards when handling sensitive employee and payroll information.

Required Qualifications

• Strong Microsoft Excel skills, including VLOOKUP/XLOOKUP, pivot tables, and multi-file/report comparison techniques - this is the core skill set for the role.
• An associate degree (2 years of college) in accounting, business administration, or a related field, OR 1-2 years of experience in bookkeeping, accounting, payroll, or payroll support.
• Working knowledge of basic payroll or accounting principles (gross-to-net calculations, deductions, tax withholdings, general ledger basics).
• Experience with ADP TotalSource and/or ADP Workforce Now strongly preferred - candidates with direct payroll software experience will be considered for the top of the pay range.
• Exceptional attention to detail, organization, and accuracy when working with large volumes of repetitive or comparative data.
• Strong time management skills, a self-starter mindset, and the ability to meet recurring payroll deadlines while managing a temporary increase in project workload.

Compensation & Benefits

Base Pay: $30.00 - $33.00 per hour, based on experience (ADP TotalSource/Workforce Now experience considered for top of range)

Equity: Stock options

Benefits: medical/dental/vision, 401(k), PTO

Location Requirement: Sunnyvale, CA HQ