Time Clock

Your name Enter your PIN

Currently on the clock

Agency Department Name

Name	Agency	Department	Clocked in	Hrs this week

No one is currently clocked in.

Admin PIN required

Weekly Agency Reports (Email)

Every Monday morning, one styled Excel workbook per agency — hours by day, Sunday through Saturday, for the week that just ended — is emailed automatically to the recipient below. Use "Send Now" to send this week's batch immediately instead of waiting for the schedule (e.g. to resend, or before the scheduled run is set up).

Send to

Week to send (any date in that week — leave blank for the most recently completed week) Send this time only to (optional — doesn't change the saved recipient above)

AP Project Rollup Report (Email)

A separate Monday-morning report emailed to ap@onqsolutions.com (with an automatic retry roughly 2 hours later): one consolidated workbook with every agency's temps in a single sheet, showing Sun–Saturday/weekly hours plus each temp's hours broken out per currently-active Job #. QC, Shipping & Receiving, and Fulfillment temps have their hours split proportionally across active jobs — but only whatever time isn't already on a real job assignment; an actual assigned job's hours are never overwritten by the split. Use "Send Now" to send this week's rollup immediately instead of waiting for the schedule.

Week to send (any date in that week — leave blank for the most recently completed week) Send this time only to (optional — defaults to ap@onqsolutions.com)

NetSuite Job Costing Entry (Weekly)

One balanced NetSuite journal-entry CSV per agency, ready to import — a real job's hours debit to 1440 (WIP Professional Services), the credit clears against 2355 (Accounts Payable Accrual). An agency's entry is only emailed once every fix it needs (a Vendor ID, a job's External ID, an unassigned temp's Job #, a missing pay rate) is resolved — see the NetSuite Review section in Manage Employees. Emailed automatically to accounting@onqsolutions.com every Monday morning; any still-outstanding issues get a reminder email roughly once a day until fixed.

Week (any date in that week — leave blank for the most recently completed week)

Agency	Total	Status

Agency Department Employee From To Job #

Daily Detail

Use "+ Add punch" if someone forgot to clock in for an entire day — editing an existing punch line only works for days that already have one.

Employee	Agency	Department	Date	Punches	Raw Hrs	Lunch	Deduction	Net Hrs	Line	Job #	Opportunity Name	Pay Rate	Cost

Weekly Summary (Sunday–Saturday)

Employee	Agency	Department	Week	Days Worked	Net Hrs	Overtime	Line	Job #	Opportunity Name	Cost	Raise Eligible

Activity Log

Punch edits/deletions, employee management, admin sign-ins, kiosk opens, and report exports — who did what, and when. Entries older than a year are cleaned up automatically.

When	Category	Who	Action	Employee	Details

Admin PIN required

Employees

Agency Department Status

	Name	PIN	Agency	Department	Rating	Notes	Start Date	Pay Rate	Admin access	PM access	Status	Actions

"Admin access" lets someone open Reports and Manage Employees using their own PIN — the one they already clock in with. "PM access" lets someone sign into the read-only Job Costing tab with their own PIN — they're a normal roster entry, just not expected to actually clock in (so they won't show up in the kiosk's name list). Check the boxes on the left and use the bar above the table to change Agency/Department/Status for several employees at once.

Bulk Change Start Date

Change the Start Date for every employee (active or inactive) currently dated with a specific value — e.g. correcting a batch of temps who all got the same wrong date. Matches on the exact current Start Date; works for any from/to pair, not just one specific date.

Current Start Date New Start Date

Add employee

Import employees from CSV

Upload a roster CSV with columns for Name, PIN, Agency, Department (optional), and Admin (optional — "yes" grants admin access). Download a template.

Preview — check this looks right before importing.

Row	Name	PIN	Agency	Department	Admin

Agency geofencing

Restrict clock-ins/outs to within a set distance of a job site. OnQ is exempt by default; other agencies default to a starting location that should be confirmed — stand at the actual site and click "Use current location" (or paste exact coordinates from a map) before relying on it.

Agency	Enabled	Latitude	Longitude	Radius (ft)	Actions

Trusted IP addresses

Clock-ins/outs from any IP address listed here skip geofencing entirely, regardless of agency — e.g. the OnQ office network. One per line.

Master admin PIN

This is a fallback PIN that always works, separate from any individual admin's personal PIN — useful for initial setup or if every admin employee is ever deactivated.

Lines (OnQ staff only)

The fixed list of production lines temps can be assigned to below. One per line.

Job #/Opportunity Name list (OnQ staff only)

Synced automatically from Smartsheet on a schedule. Use "Sync now" to pull the latest list immediately instead of waiting for the next scheduled sync.

Line/Job # Assignment (OnQ staff only)

Assign each temp's current production line and job #. Whatever is set here stays their assignment until it's changed again, and is stamped onto their time punches automatically — including on Daily Detail and Weekly Summary exports.

Include closed jobs in the Job # list

Effective date/time (leave blank for right now) Set this to go back and record a transfer that already happened — e.g. entering today that someone actually moved to a different job # yesterday at 2:00 PM. Applies to row Save, Save All, and Apply to Line below. Past reports for that temp/line are automatically re-split between jobs to match.

Bulk update: set Job # for everyone on Line

Name	Agency	Department	Line	Job #	Opportunity Name

Saves every row shown above in one go — safe to use even if you've edited several rows without saving each one individually.

Raise-eligibility policy (OnQ staff only)

Flags a temp as due for a raise on Weekly Summary once they've worked at least this many cumulative hours (all-time, not just one week) AND their current pay rate is below their department's target rate below. A department left off this list is never flagged.

Hours threshold

Target rates by department — one per line, as "Department: rate" (e.g. Production: 14).

Pay rate history (OnQ staff only)

Editing a temp's Pay Rate (in the Employees table) takes effect today by default — past Daily Detail/Weekly Summary/NetSuite reports won't show that rate for weeks before it was entered unless you set an "Effective as of" date when saving it. When entering a rate for a temp who doesn't have one on file yet, that field is pre-filled with their Start Date so their whole history is covered right away — you can still change it to a different date.

For temps who already had a Pay Rate entered before this "Effective as of" option existed, use this action to backdate their current rate — by default, to their Start Date, so past reports for their whole tenure stop showing "missing pay rate." To instead backdate everyone still missing coverage to a specific date (e.g. 2 weeks ago), enter it below — a temp who started more recently than that date is still only backdated to their own Start Date, never earlier. Safe to run more than once — it only fills in temps that still need it.

Backdate to (blank = each temp's Start Date)

Bulk Change Pay Rate Effective Date (OnQ staff only)

Changing an employee's Start Date (Employees → "Bulk Change Start Date") does NOT also move their pay rate history's effective date — the two are separate. Use this to correct existing pay rate history entries currently dated a specific day (e.g. an old Start Date that's since been corrected) to a new day, across every employee at once. This only changes WHEN an entry took effect, never the rate itself.

Entries currently dated Change to

Bulk Pay Rate Change (OnQ staff only)

Apply the same new rate to every ACTIVE employee matching the filters below — e.g. an across-the-board raise for one agency or department. Loops the same per-employee pay rate update used by editing one row in the Employees table (its own history entry and Activity Log line per person), so a large group can take a moment.

Agency Department New rate ($/hr) Effective as of (blank = today)

NetSuite Job Setup (OnQ staff only)

The weekly NetSuite job-costing journal entry (below) needs each job's real NetSuite identifier, not the shortened Job # used everywhere else in this app — some jobs (multi-brand retailer jobs especially) need an extended External ID like "10003-J20" instead of the plain Job #. Leave External ID blank to fall back to the plain Job # as typed in Smartsheet. Location defaults to "OnQ Akron Chapel Hill" if left blank.

Show closed jobs too Only jobs missing an External ID

Job #	Opportunity Name	External ID	Location

Bulk rename a Location value

Every job whose Location is currently set to the exact text below gets switched to the new text in one click — useful after a naming correction like "OnQ Akron" → "OnQ Akron Chapel Hill" instead of opening each job one at a time. This only touches jobs that already have that exact Location saved; a job left blank (using the built-in default) doesn't need this and picks up the current default automatically.

Rename every job with Location to

Agency Names (OnQ staff only)

Link two spellings of the same agency together — a genuine rename over time (e.g. "Aspire" becoming "VPL") or a short/long name mismatch that was never really two different agencies (e.g. "Armada" vs. "Armada Staffing Group"). Once linked, every report, NetSuite export, geofence setting, and Vendor ID all treat both names as one agency, always showing the current name below. Employees currently on the retired name are switched over automatically; past punches keep whatever name was on file at the time they were worked, but still roll up correctly into today's reports.

Old / retired name Current name

Retired name	Current name

Agency Vendor IDs (OnQ staff only, NetSuite)

Each staffing agency's NetSuite vendor internal ID, used as the Vendor column on the weekly NetSuite journal entry below. An agency with no ID set here will still generate an entry, just with a blank Vendor field flagged for review.

Agency	NetSuite Vendor ID

NetSuite Review (OnQ staff only)

Everything currently blocking a clean NetSuite journal entry for this week — fix each item below (or use the search boxes elsewhere on this page for job-assignment/pay-rate issues) and refresh this list. Leave "Remember this for future weeks" checked to save a fix permanently; uncheck it to apply a fix for this week's entry only.

A temp with existing job entries who's missing less than the threshold below (and has a real job bordering the gap) is covered automatically, with no flag at all — this never touches their real assignment record, only this NetSuite entry. A gap at or above the threshold still shows up below with an "Auto-correct" button.

Gap auto-extend threshold (hours)

PM PIN required

This is a separate PIN from the admin PIN — ask an OnQ admin for a PM Job Costing PIN.

Hours & cost by job number

Company-wide, every agency combined — no per-employee detail.

Week

Job #	Opportunity Name	Net Hours	Cost

Currently on the clock

Admin PIN required

Weekly Agency Reports (Email)

AP Project Rollup Report (Email)

NetSuite Job Costing Entry (Weekly)

Daily Detail

Weekly Summary (Sunday–Saturday)

Activity Log

Admin PIN required

Employees

Bulk Change Start Date

Add employee

Import employees from CSV

Agency geofencing

Trusted IP addresses

Master admin PIN

Lines (OnQ staff only)

Job #/Opportunity Name list (OnQ staff only)

Line/Job # Assignment (OnQ staff only)

Raise-eligibility policy (OnQ staff only)

Pay rate history (OnQ staff only)

Bulk Change Pay Rate Effective Date (OnQ staff only)

Bulk Pay Rate Change (OnQ staff only)

NetSuite Job Setup (OnQ staff only)

Bulk rename a Location value

Agency Names (OnQ staff only)

Agency Vendor IDs (OnQ staff only, NetSuite)

NetSuite Review (OnQ staff only)

PM PIN required

Hours & cost by job number

What's changed