Export attendance to Rivhit
At the end of the month RayClock produces a KLT.TXT file — the time-clock file that Rivhit payroll imports directly, so nobody retypes hours for each employee. Here: what is in the file, what you set up once, how to import it and what to check.
What is in the file
The file follows the structure of Rivhit payroll's "Import from time-clock file": one row for each employee and each wage code, with the month's quantity. Rivhit has no fixed codes — each business defines its own wage codes — so the file speaks in your codes.
| Data | How it appears in the file |
|---|---|
| Hours by rate | Hours at 100%, 125%, 150% (and 175%/200% when there are any) — each under your wage code in Rivhit. The codes add up exactly to the total hours for the month. |
| Working days | The days actually worked, under your working-days code. |
| Vacation, sick leave, reserve duty | Usage in days, based on the absences approved in RayClock, under the code for each type. |
| Employee number and company number | The employee number in Rivhit and the company number in Rivhit, on every row. This is what ties the row to the right payslip. |
File name: KLT.TXT, always. RayClock gives it this name, and you do not rename it.
Set up once
- Your company number in Rivhit In Settings > Company details, enter your company number in Rivhit. It goes into every row of the file — without it there is no export.
- Employee number On the employee card, fill in the "Payroll employee no." field with the employee number as it appears in Rivhit. If an employee has no number, the system warns you before every export.
- Your wage codes In Rivhit each business defines its own wage codes, so you need to tell us which code is 100% hours, which is 125% and 150%, and which are working days, vacation, sick leave and reserve duty — at least one. Your payroll accountant knows them; send them to us and we will set them for your company once.
- Invite your payroll accountant Optional, but it saves you a message every month: invite them to the free accountant portal, and they download the file themselves with read-only access.
Every month, four steps
- Review and lock the month Go through the monthly report: days without a record, missing clock-outs and absence requests waiting for approval. After the corrections, lock the month so that the file imported into payroll does not change afterwards.
- Export On the "Payroll export" screen, choose the template 'Rivhit — KLT.TXT file' and the month, then click Export. You can also export a single department. The file is saved as KLT.TXT — do not rename it.
- Import into Rivhit In Rivhit payroll, on the "Integrated" tab, choose "Import from clock file" and point it at the file you downloaded; choose whether to import into payments or deductions, and confirm. Full instructions are in the Rivhit knowledge base.
- Check three things For one employee — that the total hours on the payslip equal the monthly report in RayClock. For an employee with overtime — that the 125% and 150% codes received the right hours. And for someone who was sick or on vacation — that the days reached the right code. After the first month it becomes a one-minute habit.
What the file does not do
It does not replace the payroll accountant's review. It carries hours by rate, not by reason — a Shabbat hour at 150% and an overtime hour at 150% go into the same code. A data point that has no code defined, or has nothing in it, is not written at all. And for an employee who has stopped working, export them before you deactivate their account.
The file is built to the structure that Rivhit publishes and checked automatically, field by field, in every release. On your first import, it is worth having your payroll accountant go over one payslip — and if anything does not add up, send it to us and we will fix it the same day.
Questions about the Rivhit export
What is a KLT.TXT file?
It is the time-clock file that Rivhit payroll imports through "Import from clock file". For each employee it has a row for each wage code — regular hours, overtime hours, working days, vacation and sick days — with the month's quantity. RayClock produces it under the name KLT.TXT, just as Rivhit expects.
Which wage codes do I need?
The codes defined for you in Rivhit: a code for 100% hours, codes for 125% and 150% hours, and, if you want, for working days, vacation, sick leave and reserve duty as well. Your payroll accountant knows them; send them to us and we set them for the company once. With no codes there is nothing to export, so the system will not produce an empty file.
How does Rivhit identify the employee?
By the employee number in Rivhit, which you fill in the "Payroll employee no." field on the employee card (up to 11 characters). An employee with no number is flagged before the export.
What about Shabbat and holiday hours?
The file carries hours by rate, not by reason: a Shabbat hour at 150% and a third overtime hour at 150% go into the same code. If you have a separate Shabbat code in Rivhit, your payroll accountant splits them using the monthly attendance report.
Can the accountant download the file themselves?
Yes. Invite them to the free accountant portal, and they download KLT.TXT for each month with read-only access, without asking you.
We use another payroll system?
Shiklulit and Michpal have dedicated files of their own; for other systems you build an Excel or CSV template with the columns your system imports. All the options are on the payroll export page.