From Excel or another attendance system
Switching your attendance system to RayClock
Import the employee list from a file, set up work profiles and a clock-in method, run one month alongside your current system — and only then export payroll from the new one.
In short
Employees move over from a file. History stays in the old system, and you keep its reports. You check the first month against the old system before changing anything in payroll.
Import from Excel and CSV
One month in parallel
Help with setup
What moves over, what you enter, what stays behind
Imported from a file
The employee list
Name, email and phone, employee number and payroll number, ID number, department, position, work profile, start date, job percentage and employment type — plus address, emergency contact, bank details and custom fields. Only first name, last name and email are required.
Entered by hand
Vacation and sick balances
The system admin records each employee's balance on the switch date as an adjustment in the accrual statement, with a date and a reason. From there, monthly accrual continues automatically. Importing balances from a file is not currently available.
Set up again
Work profiles and rules
Work days, standard hours, overtime and break deduction are set in the work profile. Start from a template for a Sunday–Thursday or Monday–Friday week and fine-tune.
Stays in the old system
Attendance history
Punches from earlier months are not imported. Keep the reports for the earlier period from the old system; RayClock starts recording from the switch date.
The file can come from any system: Excel or CSV, with Hebrew or English headers. The system works out what each column is, and you review and correct it in a preview before importing. To detect the columns, the column names and a sample of up to 10 rows are sent to our AI provider; the rest of the file does not leave the system. Departments and positions that do not exist yet are created during the import. More on employee management and the employee file.
A six-step switch plan
The simplest is to start at the beginning of a month, so the whole first month is recorded in one system.
01
Import employees
Export an employee list from your current system or spreadsheet, upload it, check the column mapping and import. You can save the mapping for the next file with the same columns.
02
Set up work profiles
One profile per group of employees with the same rules, and assign them. An employee without a profile shows up as an alert on the dashboard.
03
Choose a clock-in method
Phone, computer, a shared station at the entrance, or NFC tags and cards — then send employees an invitation by email or SMS. Which clock-in method to choose.
04
Enter opening balances
Each employee's vacation and sick balance on the switch date, from the previous system or the latest payslip.
05
One month in parallel
In the first month employees clock in on both systems. At the end, compare hours, overtime and absences for each employee and resolve every difference before changing anything.
06
First payroll export
Lock the month and generate a Shiklulit file or an Excel/CSV template. It is worth checking the first file with the payroll accountant before importing.
After the parallel run, stop clocking in on the old system. A detailed guide for a new account: setup guide. For payroll: exporting attendance to Shiklulit · Excel/CSV templates.
What to keep from the old system
Before cancelling the old subscription, download what you will need later. The limitation period for wage claims is seven years, so attendance records for the earlier period should stay available for at least that long.
Monthly attendance reports
For every employee and every month, including overtime and absences — in a file you can open without the old system, such as PDF or Excel.
Balances on the switch date
Vacation and sick balances for every employee, so you can enter them as opening balances and explain them later.
Signed documents
Form 101s, employment agreements and certificates stored in the old system.
The team that builds RayClock also helps with the switch: choosing a clock-in method, setting up work profiles and checking the export against your payroll system. Reach us on WhatsApp, by phone at 052-607-6777 or by email at info@rayclock.co.il; we usually reply within one business day. Support page.
Questions about switching
Can we import employees from our previous system?
Yes. Export an employee list from it to Excel or CSV and upload it. The system recognises the columns even if the headers are in Hebrew or use other names, and shows a preview you can correct before importing.
Can we import punch history?
No. RayClock starts recording attendance from the switch date, and punches from earlier months are not imported. Keep the reports for the earlier period from the old system.
What about vacation and sick balances?
The system admin enters each employee's balance on the switch date as an adjustment in the accrual statement, with a date and a reason. From then on, monthly accrual continues automatically.
How long does the switch take?
The setup itself — importing employees, a work profile and invitations — can be done in a day. We recommend running both systems in parallel for one month before relying on RayClock for payroll.
Do we need to change anything on the payroll side?
If you use Shiklulit, there is a dedicated export file, and every employee needs a payroll number that matches Shiklulit. For another payroll system, define an Excel/CSV template and check it with the payroll accountant before the first month.
Can we try before deciding?
Yes. The trial lasts 14 days, up to 100 employees, with no credit card, and nothing is charged automatically at the end. Start a free trial.
The information on limitation periods and record keeping is general and is not legal advice.