Work-time record export
Download a daily record of hours worked for the people you manage, ready for payroll or a labour inspection.
Most countries require an employer to keep a daily record of the hours each person works, and to be able to produce it on request. The work-time record export gives you that file in one click: a CSV with one row per person per working day, showing the exact times they started and finished.
Itâs useful well beyond compliance. The same file answers payroll questions, settles a dispute about a particular day, and gives an employee a copy of their own hours when they ask for one.
Who can export
Anyone who can manage people:
- Admins and owners export everyone in the workspace.
- Managers export the members of the teams they manage.
The export never includes people you canât manage.
Running the export
- Open Manage.
- Scroll to the bottom of the page and choose Export.
- Pick a format, or leave it on Automatic.
- Read the note about handling the file, tick the box to confirm, and choose Download CSV.
The download covers the last four years of data your workspace still holds, so a single click gives you everything available.
Whatâs in the file
A header block naming your workspace, the period covered, the timezone the times are written in, and when the file was generated. Then one row per person per working day, with:
| Column | Meaning |
|---|---|
| Company | Your workspace name |
| Worker | The personâs full name |
| Their email address | |
| Worker ID | Their internal Weqly ID |
| Date | The working day |
| Start time | When the dayâs work began |
| End time | When it ended |
| Breaks (min) | Unpaid break time inside the day |
| Effective hours | Hours worked, net of breaks |
| Source | Where the row came from (see below) |
| Time zone | The timezone the times are written in |
A daily total on its own doesnât satisfy most work-time rules, which is why every row carries the concrete start and end time.
Where the hours come from
Weqly prefers what actually happened over what was planned:
- If a person has a clock-in session that day, the row uses their real clock-in and clock-out times, and the source column says so.
- If they have no clock-in that day, the row uses the scheduled shift instead, and the source column marks it as planned time. Recurring shifts are marked separately from one-off ones.
Days removed from the schedule, whether dropped manually or covered by approved leave, donât produce a row.
That distinction matters when someone reads the file. Planned time is a reasonable record when your workspace doesnât use clock-in, but nobody should mistake it for a measurement. If you want the file to be entirely made of recorded time, turn on Clock-in.
Formats
The record is the same everywhere. Only its presentation changes: column language, the separator the file uses, how decimals are written, and whether a legal reference appears in the header.
- Automatic picks the format from your workspace timezone. A workspace set to a Spanish timezone gets the Spanish preset without anyone choosing anything.
- Spain produces the registro de jornada required by article 34.9 of the Estatuto de los Trabajadores (introduced by RD-ley 8/2019): Spanish column names whatever language you use Weqly in, the legal reference in the header, and the separator and decimal comma that Spanish Excel expects. Choose it explicitly if your company is Spanish but your workspace timezone isnât.
- Generic uses your workspace language, ISO dates and comma separators.
Whichever you pick, the file opens directly in Excel, Numbers, LibreOffice or Google Sheets.
Times and timezones
Times are written in your workspace timezone, which is the clock a working day is judged by, and that timezone is printed both in the file header and in every row. So a shift stored as 07:00 UTC reads as 09:00 in a workspace set to Madrid in summer.
How long the data goes back
The export can only include data your workspace still holds:
- Free workspaces keep three months of past shifts, leave and hours.
- Paid workspaces keep four years, which matches the longest retention duty weâre aware of, including Spainâs.
If you have a record-keeping obligation measured in years, keep a paid workspace, or export periodically and archive the files yourself.
Handling the file
The CSV identifies named people and what hours they worked. Thatâs personal data, and it leaves Weqlyâs protection the moment it lands in your downloads folder. Treat it accordingly:
- Store it somewhere secure and access-controlled. Donât email it around or drop it on a shared drive without protection.
- Use it only for the purpose you exported it for: an inspection, payroll, or an employeeâs request for their own record.
- Delete your copy once itâs no longer needed.
Every export is written to your workspace audit log, recording who ran it, when, and the period covered. Weqly doesnât keep a copy of the file itself. Itâs generated on request and streamed straight to your browser.
Need help?
Reach our support team at help@weqly.com. Weâre happy to help.