Use cases / Payroll inputs
Run payroll from what was confirmed, not from an email.
A pay-period pack asks for hours, overtime, absences and changes in a table with one row per employee. Whoever knows the hours fills it in: the office manager if you run payroll for other businesses, a site manager if you run your own. You see the totals, export the CSV, and accept it or send it back with a note.
- ABAmira Begum160 hours
- JWJess Whitfield72 hours
- TETom Ellis38.5 hours
The table
A table, not a thread
Hours are numbers in a column, not sentences in an email. Required cells are required before submission, a starter missing from the list gets added as a row, and the totals are worked out for you.
An illustration. The names are made up.
By email, the hours arrive as sentences over a week: Jess did 72 hours, probably; Tom was off on Tuesday, sick or on holiday; a new starter begins on Monday with no name yet; Holly has overtime but not how much; and after the run, Jess turns out to have worked 76 hours on the rota. In Docsroom, one table has a row per employee with hours, overtime and absences, the new starter added as a row, the totals worked out, and the table submitted by the person confirming it.
Submitted with a statement, then the CSV
Whoever fills the table in saves a draft and submits it with a statement that they are confirming the hours. You see the totals, export the CSV, and accept it or send it back with a note.
- Preset columns for hours, or your own
- A submitted table shows who approved it, and when
- Download as CSV for your payroll software
- Hours270.5
- Overtime4.5
- Absence3
Every month, the same pack
Start it from the template, correct it without re-typing, and let the chasing stop by itself.
The monthly pack
The “Monthly payroll inputs” template starts a pack with the hours table, starters and leavers, new starter documents and the payroll summary to approve at the end.
Sent back, not re-typed
“Jess worked 76 hours on the rota, not 72.” The request goes back as needs correction; whoever filled it in edits the one cell and submits again.
Reminders that stop
Schedule a reminder to the person who fills the table in. It lists only what is outstanding and ends itself once the pack is done.
The pictures are illustrations. The names are made up.
Send next month’s pack from the template.
Free for 14 days, no card. Hours in a table, approved before you run payroll.