home / use cases / back-office operations / timesheet-collection

Timesheets collected before the cutoff, not after

Ahead of every payroll cutoff, your Aivell reminds whoever hasn't submitted hours, compiles what comes back into one master sheet, queries anything odd — twelve-hour days, missing Fridays — instead of guessing, and hands payroll a complete, flagged, on-time file. Late sheets still get compiled, marked late.

Watch the demo

starts when: Three days before the monthly cutoff, on schedule

The problem

Every month ends the same way: payroll needs the hours by the 5th, and on the 3rd, a third of them are missing. So someone starts the chase — the group reminder, then the personal reminders, then the transcribing of whatever arrives: a filled template here, a photo of a paper sheet there, an email that just says “same as last month”. By the time the master sheet is complete, the person compiling it has done two days of copy-paste and diplomacy.

It is pure email-shaped overhead in a workweek that already loses more than a quarter of its hours to email — and unlike most overhead, it has a hard deadline attached to everyone’s salary.

How your Aivell does it

  1. The chase starts early and stays personal. Three days before cutoff, everyone who hasn’t submitted gets a reminder in their own language with the blank template attached — no group blast that everyone assumes is for someone else.
  2. Returns are compiled on arrival. Each sheet that comes back flows into the master — one row per person per day, your format — instead of piling up for a transcription marathon on deadline day.
  3. Anomalies become questions, not assumptions. A twelve-hour day, a missing Friday, overlapping entries: the sender gets a short query, and their answer is what gets recorded. The Aivell does not guess about payroll.
  4. The boundaries hold themselves. Subcontractors are contacted at their office address only, and past months are locked against any edit — the guardrails enforce both, regardless of what arrives in the inbox.
  5. Cutoff day produces the truth. Luca gets the gaps list — submitted, missing, queried — and once he taps his approval, payroll gets the finished file. Stragglers are still compiled afterwards, honestly flagged late.

The whole procedure is one chore in plain language: your cutoff, your template, your patience with latecomers. When the payroll provider changes the format or the cutoff moves to the 3rd, you edit two sentences and the next month runs the new way.

The chore, as you'd write it.

No flowcharts, no code — a chore is just a message to your Aivell, in your own words. It shapes it into a solid, guarded procedure and follows it to the letter. This one:

Giulia Aivell · collect monthly timesheets ● active

three days before cutoff, email everyone who hasn't sent their hours

write each reminder in the person's language, blank template attached

as sheets come back, copy the hours into the master — one row per person per day

more than 10 hours in a day or a missing day — ask the sender, never guess

subcontractors are chased at their office address, never a private one

the day after cutoff, send Luca the gaps list — submitted, missing, queried

late sheets still get compiled, but flagged late for payroll

You
Got it — I'll start right away, and check with you whenever something needs a human.
Giulia Aivell

The tools it uses.

Connected with single-click passkeys — no copied tokens, no OAuth hell.

Schedule starts the collection round before cutoff
Email chases hours, queries the odd entries
Spreadsheets compiles everything into the master sheet

Sensible guardrails.

Every tool can be limited to exactly what this chore needs. For this one, you might set:

Spreadsheets May write into the current month's tab of the master sheet. Previous months are locked — history is not editable.
Email Sends only to the staff and subcontractor addresses listed in the master sheet, and to payroll. Nobody else.

Questions, answered.

People submit hours in every format imaginable. Does that matter? +

Less than you'd think. The reminder always carries your blank template, and what comes back — the filled template or plain "8 hours every day except Wednesday" in the email — gets compiled the same way. Odd or ambiguous entries are queried, not interpreted.

Hours are the raw material of salaries. Where is this data handled? +

On the box, behind your firewall. The reminders, the returned sheets and the master file are all read and written inside your network — no payroll-adjacent data ever passes through an outside AI service.

Can it change what someone submitted? +

No — it can ask. A twelve-hour Tuesday or a missing week produces a question to the person who submitted it, and their answer is what lands in the master. Nothing is silently corrected, and the handover to payroll goes out only after Luca has given it a thumb-tap from wherever he is.

What does payroll actually receive? +

One master sheet in the shape they asked for — a row per person per day, queried entries resolved or flagged, latecomers marked late — plus the gaps list. The compiling and the chasing disappear; the file is just there on time.

Related.

What is an Aivell?

An Aivell is an on-premise AI colleague: a small box that plugs into your network, runs its own AI onboard and takes the repetitive work off your desk. Prompts, documents, data — nothing ever leaves your office. Unplug the internet: it keeps working.

You describe each task as a chore, in plain language. Your Aivell turns it into a solid, guarded procedure and runs it in the background — with guardrails on every tool, a complete audit trail, and approvals in your hand when you want them. One-time setup, fixed monthly fee. No tokens, no overages.

Watch the demo

onboard inference · air-gapped · fixed monthly fee