Payroll > Master File Maint Payroll > Advanced Options > Time Entry Options

Setup up for Pak Accounting Standard Time Clock Interface for the Windows version:

1.	To use the Standard Time Clock interface layout, you must set the Payroll Company Master > Advanced Options > Time Entry Options tab / import layout file format to zero.

2.	The Time Clock file should be saved as a text file in your GLN32\xxxxx folder. The xxxxx is the Pak Accounting company code. The Import file name must be TIMxxxxx.txt, where xxxxx is your company code for the payroll cycle. The format for each line of the files is as below:

Description	From	Thru	Length	Comment
Spaces	1	6	6	Fixed Spaces
Constant	7	10	4	Fixed "0700"
Hours or amt depending on type of detail	11	18	8	Required, decimal
Spaces	19	26	8	Fixed Spaces
Override Account	27	30	4	Optional or spaces
Spaces	31	36	6	Fixed spaces
Override Hourly Rate	37	44	8	Decimal not assumed
Spaces	45	58	14	Fixed Spaces
Optional Tax State (State Withholding, WC, and SUTA)	59	60	2	Optional or spaces
Override Detail Description	61	70	10	Optional or spaces
# Override WC Code	71	74	4	Optional or Spaces
Detail Code	75	78	4	Required
Override Company Code	79	83	5	Optional or spaces
Employee Nbr	84	93	10	Required
Override Sub-Account	94	103	10	Optional or spaces

The Employee#, Override Sub-Account, and Detail Code are alpha-numeric fields. All other fields are numeric.

Hours do not have an implied decimal. You must code the decimal in the field if needed (Example: 5 1/2 hours would be 000005.5, where 5 hours will be 00000005). If the Detail Code is not an hourly code, then this will be the amount that is paid for the Detail Code (for example - Salary).

The Override Account and Override Sub-Account are optional. If used, they will override what is in the employee master for this time record. If they are not used, then these fields need to be filled with spaces.

The Override Hourly Rate is optional. If used, it will override the rate coded on the employee master. If this field is not used, then it needs to be filled with spaces.

The Override Tax State will override the State Withholding State, the SUTA state, and the Workers Comp State. If not used, it needs to be filled with spaces.

The Override Detail Description will override the detail code description at the employee level. If not used, it needs to be filled with spaces.

# - This override is only available if the Company's WC Coding option is set to "Employee Detail" in #80 Basic Options > Worker's Comp tab. If not used, then this field needs to be filled with spaces.

The Override Company Code is a five (5) character field, must be right justified and zero filled on left (Example: if company code is ABC, then this field would be 00ABC). This override will work for companies set up for multi-company payroll.

3.	When starting the Payroll Cycle check mark the import field and it will import the last file saved to the path location

NOTES:

•If something is coded in an optional field, it will override what is setup in the employee master.

•The import will cause the employee to be included in the pay cycle. If a pay detail record already exists in the current with this detail code and the same account, Sub-Account, state, detail description, rate and worker's comp code; the system will combine this import record with the existing, otherwise it will add a new one with the next sequence number.

Setup for Paychex Time Clock Interface:

1.	Set payroll company master > advanced options > Time Entry tab>/ import layout file format for 7 = Paychex

2.	In Time Entry > Paycode Maintenance - setup 5 codes

E 1 = Regular Earnings

E 2 = Overtime Earnings

EMO = Misc Regular

EO = Misc Hourly Earnings

EP = Vacation Time

3.	Payroll > employee Master > Other Tab > time clock field - put the employee "badge" number in the Time clock # field.

4.	Save the time clock file as a txt file in your gln32/ccccc directory

5.	When starting the payroll cycle check mark the import field and it will import the last file saved to the path location

Format 8 - XLS - reads first Sheet. File name is prompted for in cycle

File name stored in company master.

Column 2 (B): SSNumber if this is blank, import skips this row without errors.

Column 5 (E): override Sub-Account/cost center

Column 8 (H): Payroll Detail Code (H1RG, H1OT, etc)

Column 9 (I): Hours

Column 10+ (J): override Rate if rate is not specified, import will look for rate in column 10, then 11, etc until it either finds a non-zero amt or runs out of columns. If no rate is specified, then it will use the default rate.

Format 9 - CSV

To only be used by Pak Accounting support technicians to load historical cycles.

Field 1: Employee#

Field 2: DtlCode

Field 3: optional Override G/L Account#

Field 4: Amount (if for detail type of D,T or C, assuming import is negative number) Import changes the calc type to "F" (Fixed) on whatever detail codes it imports in.

Format 11 (modified Time-Entry for Jobs <format 6>)

No Sub-Account is loaded from import, uses Sub-Account already in pay detail

Format 12: XLS starts on row 2 specialized XLS import used to load prior history.

Not support by the Customer Success Team

Column A (0) Emp#

Column E (4) Optional Cycle# - if specified, will only import those records that match current cycle

Column L (11..until blank value in row 1, row 1 contains # or $ followed by detail code being loaded, # loads Qty, $ loads Ext Amt)

if #, then following column is assume to be the $ amount for the same detail code.

Format 15: AccuPrint ATR 2020 time clock:

Format is a CSV file that has the clock# or employee# in the first colum, 3 column for the rate# (00001 or 00004 for rate 1, 00002 for rate 2, 00003 for rate 3 and 00007 for Vacation hours), 8th column for Regular Hours, and 9th column for Overtime hours.