Help Center

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

  1. Open Manage.
  2. Scroll to the bottom of the page and choose Export.
  3. Pick a format, or leave it on Automatic.
  4. 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:

ColumnMeaning
CompanyYour workspace name
WorkerThe person’s full name
EmailTheir email address
Worker IDTheir internal Weqly ID
DateThe working day
Start timeWhen the day’s work began
End timeWhen it ended
Breaks (min)Unpaid break time inside the day
Effective hoursHours worked, net of breaks
SourceWhere the row came from (see below)
Time zoneThe 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.