Payroll Check Entry . . . Time Clock Import

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

The Time Clock import allows you to create check records in Payroll CS from formatted text files. The application uses the text file to automatically create unprinted checks from an external source.

To import Time Clock data, first open the Tasks > Payroll Check Entry window and then choose Time Clock Import from the Edit menu or from the F3 or right-click context menu. In the Time Clock Import dialog, select the file you wish to import. If the import file is in the departmental format, mark the Departmental import format checkbox. Click the Import button.

Time Clock import files must be named xxxxx.TCI, where xxxxx is the desired file name.

  • If you are importing a SwipeClock file, you will need to manually change the file extension to TCI.
  • For former users of BASS Payroll, the import file name may be RBASSDAT.xxx, where xxx is the BASS client ID.

Special information

  • You can review the checks created by the import in the Payroll Check Entry window or by printing an Unprinted Check Listing from the File > Print Reports dialog.
  • For former users of BASS Payroll: The file structure used for the Time Clock import is identical to that used in BASS Payroll.
  • Time clock files can be imported from application output files from the following vendors:
    • Kronos, www.kronos.com, 800.225.1561
    • Points North,* www.points-north.com, 888.561.2072
    • Qqest Software Systems, Inc. (TimeForce), www.mytimeforce.com, 800.733.8839
    • Sierra Computer Solutions, www.time-clock.com, 800.822.0973
    • SwipeClock, www.swipeclock.com, 888.223.3450
    • TimeRack, www.timerack.com, 951.284.1500 ext. 1

* Points North does not produce a time clock but instead prepares formatted files from existing time clocks to meet the specifications of the CSA application.

Top of page

Fields & buttons

Files available to select

Select the file(s) you wish to import from this list. The selection will only be available when a Payroll CS client is active

File name

Enter the file name(s) to list in the Files available to select list. You can use the wildcard (*) in the file names.

Example: *.TCI or RBASSDAT.*

File location

Enter the drive and folder in which your Time Clock data is currently stored or click the Change file location button to search for the data folder.

Change file location button

Click the Change file location button to change the drive and/or folder for the application to search for your Time Clock data.

Departmental import format

Mark the Departmental import format checkbox to use the EEEEDD format, where EEEE is the four-digit employee number and DD is the two-digit department number; otherwise the EEEEEE (six-digit employee number) format is used.

Import button

Click the Import button to begin importing your Time Clock data.

Top of page

Related topics

Time Clock import file data structure

Sample time clock import file

Setting up a CSA client for time clock import

Importing from time clocks to Payroll CS

Importing employee time entry from an Excel spreadsheet

Top of page

Was this article helpful?

Thank you for the feedback!