How to Export Time and Attendance Data From Spectrum TimeClock

Spectrum TimeClock supports the export of time and attendance data in a variety of formats designed for import into different payroll programs and systems. Please contact Spectrum Research, Inc. to have an export for your payroll service installed to your Spectrum TimeClock service.

Before you can export time and attendance data out of Spectrum TimeClock, you will need to run a payroll batch as described on our page at Run a payroll batch. You should also review the data in the resulting payroll batch to make sure everything looks as you expect it. That is described in our article at How to view a payroll batch.

When you are ready to export the batched time and attendance data, use the following procedure.

  1. Login as an administrator.
  2. Click on the "Reports" menu.
  3. Scroll all the way down and click on "Custom Reports Menu".
  4. Find and run your payroll export report.
  5. Select the payroll batch you want to export from the list, and press "Submit".
  6. If your payroll firm or software requires additional company or batch ID information, enter that data into the form and press "Submit".
  7. Press the "Copy to Clipboard" button to paste the data into Notepad.exe, or press the "Save" button to directly save the data to a file. If the amount of export data is high, you may have to use the "Copy to Clipboard" button instead of the "Save" button.

by Alfred Heyman

Spectrum TimeClock Spectrum Research
Time Clock Software


Find out more about Spectrum TimeClock.

Topics


General Information

Spectrum Research, Inc.
Export to Excel

Accessing Your Clock

Save a Website Shortcut
Save a Smart Phone Shortcut
Time Clock Punching Options
Time Clock Punch Locations

Configuration

Forgot Password Function
Holiday Pay Setup
Time Clock Rounding

Running Payroll

How to Run Payroll
Run a Payroll Batch
View a Payroll Batch
Run a Quick Payroll Report

Exporting Time Data

Export Time Data from Spectrum

Import Time Data

Import time data into Peachtree
Import time data into QuickBooks

Employee Management

Delete / Deactivate Employees
Reactivate Employees

Punching IN / OUT

Employee Forgot Punch In
Employee Forgot Punch Out

Additional Modules

BioNetick Module Installation

Other Support.

Request Remote Assistance
TRACERT diagnostic

DOL Regulations

How to Calculate Overtime
Overtime Averaging
Fixed Salary for Fluctuating Hours
Weighted Average Regular Rate
Employee Training Hours & Overtime

All articles are
Copyright © 2004-2013
Spectrum Research, Inc.
and may not be reproduced without permission.