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.

A business owner smiling at her computer

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.

You do not switch alone

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.

Start with your employee list