Triva isn't available right now.
Check out the support page for our phone number and hours
Solutions
Law firms
Tax, audit & accounting firms
Success stories
-
A true competitive advantage
Law firm Zarwin Baum’s embrace of generative AI as the natural next step in the evolution of legal work and their adoption of CoCounsel Legal has helped them achieve remarkable efficiency gains and improved client relationships.
-
Workflow transformation drives impact
Brinks, a global leader in secure logistics and security solutions, used CoCounsel to reimagine what was possible with AI tools, turning legal challenges into a competitive advantage.
-
The forefront of audit tech
A better auditing workflow solution was the answer to multiple challenges faced by The Mercadien Group. Find out how they achieved greater efficiency by embracing Cloud Audit Suite.
Questions? We are here to help.
Products
Legal
Trade & supply
Tax, audit & accounting
- 1040SCAN
- Audit Intelligence Analyze
- CoCounsel Audit
- CoCounsel Tax
- Ready to Advise
- Ready to Review
- View all
Corporate tax
Recommended products
-
CoCounsel Legal
Transform your work with the only AI legal solution uniting research, drafting, and document analysis in a single experience. Designed by legal experts and built on trusted content and advanced AI, CoCounsel Legal accelerates multistep work so you can better serve your clients and grow your business.
-
CoCounsel Tax
Transform your tax practice with CoCounsel Tax, an AI-powered assistant that combines trustworthy answers, automation, and firm knowledge into one seamless platform. Enhance efficiency, reduce risk, and improve client confidence with CoCounsel Tax.
-
CLEAR
Powerful software designed for law enforcement, compliance, risk, and fraud investigators. Conduct thorough investigations with ease using our intuitive online investigation software. Efficiently, prevent, detect, and solve crime.
Questions? We are here to help.
Purchase
Buy solutions
Resources
Insights
Events
Product training
Product communities
Developers
Highlights
-
2026 SKILLS showcase
Join weekly sessions to experience in-depth demonstrations of the leading legal AI products while connecting with strategic law firm leaders in knowledge management, innovation, and AI.
-
Ghosts on the ledger
Payroll fraud is a major compliance risk. Learn how payroll analytics and AI-powered tools can help exorcise phantom employees and employers.
-
Future of professionals report 2025
The Thomson Reuters Future of Professionals Report 2025 reveals how AI continues to shape professional work — and what it takes to get ahead. This year’s report shows that increased efficiency, productivity, and cost savings top the list of benefits professionals attribute to AI, making it indispensable for organizations facing rapid change.
Time clock import ASCII file structure
The Time clock import file is an ASCII file containing records in the following format.
Number fields are 9 characters in length. These may be zero or blank-filled.
Section | Position | Description |
|---|---|---|
EEEE | 1-4 | Employee Number Employee IDs are restricted to four numeric characters and the Employee ID in the import file must match the Employee ID in the application. |
DD | 5-6 | Department ID The Department ID in the import file must match the Department ID of a department in the application. If the Department ID field is left blank, amounts will be entered in the department associated with the employee's primary work location if a department has been added to the employee. |
## | 7-8 | ASCII Time Clock Import ID The time clock import ID in the import file must match the corresponding ASCII Time Clock Import ID for pay or deduction items set up in the Main tab of the Setup > Payroll Items screen. |
111111111 | 9-17 | Number of regular hours The number of regular hours to be imported into the Reg Hours field for the pay item. |
222222222 | 18-26 | Number of overtime hours The number of overtime hours to be imported into the OT Hours field for the pay item. |
333333333 | 27-35 | Number of double-time hours The number of double-time hours to be imported into the DT Hours field for the pay item. |
L | 36 | Control character defining amount 444444444
|
444444444 | 37-45 | Other (Depends on L) |
555555555 | 46-55 | Reported tips The amount of reported tips to be imported into the Reported Tips pay item. |
note
- Amount and number of hours fields are assumed to have 2 decimal places. For example 000004000 is interpreted as 40.00 hours.
- There should be a CR/LF (carriage return / line feed) after each record.
- You can't use ASCII/TCI format files to import accruable benefit hours. If you need to import accruable benefit hours, you will need to use an XML import file or use a spreadsheet import.
The following example shows 2 lines of an import file for an employee who works as a customer service representative in a fast food restaurant.
- Employee ID.1001 - John Smith
- Department.02 - Service Staff
- Pay item 1.Wages - pay description number 10. (40 hours regular pay, 10 hours overtime this week)
- Pay item 2.Shift Premium - pay description 41 (10 hours this week)importantEach payroll item must have its own line entered in the import file. Within each line you can combine the regular, overtime, and double-time hours for single payroll item.
- Tipped employees.If the employee is a tipped employee with a Reported Tips pay item, you can include the tips amount in position 47-54 on the same line as the tipped-wages hourly pay item.
- Wage rate changes.Wage rate changes made using special characterW(position 36) can be included on either the same line as the regular hours, or can be entered using a separate line. For salaried items, the 444444444 amount is annualized and entered as an annual salary. For hourly items, it is assumed to be an hourly rate.Note:If a rate change is included in the import file, the change will take effect on that check regardless of the location of the rate change line.
- Deduction amount override.If you want to override the deduction amount normally calculated on a check, you must use a separate line for each deduction item.
This article applies to:
- Product: Accounting CS