Skip to content
Timply

Reports with a column per figure, and an Excel export

One row per day and employee, with scheduled time, worked time, the difference, additional hours, overtime, time off in lieu and a column per shift differential category.

  • Part of

    Payroll and export

  • Included in

    Core · Pro · Enterprise

  • Available on

    Browser

What you get

  • The figures come out already separated, with no rearranging needed.

  • Any period can be read, not only the calendar month.

  • The export opens in Excel with the columns intact.

Already separated

A report that hands back a single total leaves the work undone. The figures that matter are separate from each other: what was scheduled, what was worked, what the difference was, and how the hours divide between ordinary time, additional hours, overtime and each shift differential category.

Timply puts each of those in its own column, one row per day and per employee. The shift differential columns use the names you gave the categories rather than codes, so the report reads without a key.

Any period

The report takes a start date and an end date. That sounds minor until your payroll period does not line up with the calendar month, which is common enough that assuming otherwise is a real limitation.

Hours against a job

In Pro, time is recorded against a project with participants, and the report shows the hours per project, per client and per person. A consultancy reads the same week two ways: as an employee's working time, and as hours drawn down on a client.

Two exports, two purposes

Excel is for reading, checking and sending to somebody who wants to look at the numbers. The PAXml file is for importing into a payroll system. They come from the same figures, so a total checked in one holds in the other.

The Excel export of a Timply time report with a column per figure
The export as it opens, with each figure in its own column.

How it works in Timply

  • Row

    One per day and employee

  • Columns

    Scheduled, worked, difference, additional hours, overtime, time off in lieu

  • Differentials

    A column per category, named as you named it

  • Period

    Any date range

  • Filter

    By employee, by department and by project

  • Project

    Hours per job, per client and per person

    Pro
  • Export

    Excel, with the columns and the number formats intact

Common questions

Can we choose the period?

Yes, any start and end date. The report follows your payroll period rather than the calendar month.

Does the export need rearranging before it is usable?

No. Each figure has its own column, so the numbers can be read or summed directly.

Can we see hours per project?

In Pro. A job is set up as a project with participants, and the report shows the hours per project, per client and per person for the chosen period.

What formats can we export to?

Excel for reading and checking, and PAXml 2.0 for importing into a payroll system.

Are shift differentials shown separately?

Yes, one column per category, using the name you gave it rather than a code.

More features

This feature is part of Timply's system for scheduling, time tracking and payroll files. See all features

Try Timply with your own staff

You can get going on your own, with your real schedule and your real staff. If you would rather be shown around first, book a demo.

Trial
14 days
Credit card
Not required
Refund
Within 30 days of purchase