A foreman and crew in work jackets and caps going over drawings on a truck tailgate at a steel-frame site

Crew of 5 · Mon to Fri

202 hrs 4 at 1.5x

Built For The Trades brand imagery.

Foreman timesheet app

The foreman timesheet app for a whole crew's week

Appello's Bulk Timesheet Entry lets a foreman or the office enter every worker's hours for the week on one grid, with overtime split by the agreement as you type. It's live today in the Appello web app, on a laptop or tablet, for crews of any size on any ICI job.

Try the grid

Tremblay's crew at Lakeshore General, Monday and Tuesday in. Type Thursday's ten hours, copy last week, apply a template, then save.

Bulk Timesheet Entry · 26-014-01 Lakeshore General · Wing B

Week of Sep 6–12, 2026

WorkerMon 7Tue 8Wed 9Thu 10Fri 11Total
1x1.5x1x1.5x1x1.5x1x1.5x1x1.5x
Mechanical Insulators ICI
M. Tremblay Foreman–––––16.0
P. Wilson Journeyperson–––––16.0
J. Alvarez Journeyperson–––––16.0
R. Singh Journeyperson–––––16.0
S. Okafor Apprentice 3rd Year–––––16.0

Crew total 80.0 hrs

A working model with a fictional crew and an illustrative rule (over 8 hours a day at 1.5x). In Appello, Auto-Calculate OT uses your agreement's overtime rule set for the job's wage region, daily and weekly, and counts hours the worker has on other jobs that day.

Twelve paper sheets, or one grid

The paper week

Friday
The foreman fills a sheet per worker, from memory and a notebook.
Monday
The sheets ride in on the dash. Two are missing, one is a photo.
Tuesday
The office types each one in and works out the overtime by hand.
Wednesday
Payroll finds a 10-hour day split wrong and phones the site.

The bulk entry week

Each day
The foreman opens the grid; the scheduled crew is already there.
As they type
Auto-Calculate OT splits the long days by the agreement.
On save
Every timesheet goes straight to review. No retyping.
Friday
The office approves the crew's week; the hours are on the job cost.

Every button on the grid, and what it saves

Bulk Timesheet Entry sits under Timesheets in the web app. Anyone who can edit timesheets can use it, so it works for a foreman, a superintendent or the payroll office.

Rates come from union payroll: each worker's trade level, the job's wage region and the agreement's rate labels. The grid is for hours; travel, board and notes live on the timesheet row.

By Person
One row per worker, grouped by employee agreement, with their trade level beside the name. Columns are the days of the week, split by the agreement's rate labels.
By Day
One day at a time, with a Cost Code split for each worker, so labour lands on the right line of the job's budget. Copy Yesterday fills today from yesterday.
Auto-Calculate OT
Splits overtime as you type, using the agreement's overtime rule set for the job's wage region, daily and weekly, and the worker's hours on other jobs that day.
Copy Previous Week
Same crew, same pattern as last week. Change what changed and save.
Copy To Users
Enter one worker's hours and copy them to the rest of the crew.
Add Worker
The crew loads from the job's schedule for the week. Add anyone else assigned to the job; unscheduled workers need permission.
Export CSV
Take the grid out as a spreadsheet when someone wants to check it on paper.

Timesheet templates

Save the standard week. Apply it on Monday.

Most crews work the same pattern most weeks. In the By Person view, Save Template keeps each worker's hours by weekday and rate label, with their cost-code splits, under a name and a description. Tie it to one job, or leave it open for any job.

Apply Template fills next week from it in one click; you change the day it rained and save. Tick “Make available to all users (global template)” and every foreman can use it, so a superintendent can set up the standard week for each crew once.

Your AI assistant can find and read templates through the Appello connector, so “what's in the Lakeshore standard week?” gets a straight answer.

Save as Template

Template Name

Lakeshore crew · standard week

Description

Mon–Fri 8 hrs, 210 pipe insulation; Thu 10 hrs

Job (optional)

26-014-01 Lakeshore General · Wing B

Make available to all users (global template)

CancelSave

Coded recreation of the template dialog. Fictional job and crew.

The grid for the foreman, the phone for the crew

Some shops have every worker punch in on their phone. Some have the foreman keep the crew's hours. Most do a bit of both. Appello is built for either.

The crew, on their phones

Each worker clocks in on the job with the time clock app. It works offline in the mobile app, so no signal on site isn't a reason to skip the punch.

Time clock app →

The foreman, on a laptop or tablet

Bulk Timesheet Entry runs in the web app, in the trailer, the truck or the office, and needs a connection. The foreman checks or enters the whole crew's week and saves.

Try the grid →

The office, at approval

Supervisors and admins approve the week from the timesheet matrix, then lock it and export it to payroll.

Payroll exports →

Ask your AI

Ask for the crew's hours in a sentence

Add the Appello connector to Claude, ChatGPT, Microsoft Copilot and Grok and sign in on Appello's own login page. Your assistant gets 800+ tools, and every answer is limited to what your Appello role allows.

  • “Enter 8 hours Monday to Friday on 26-014 for Tremblay's crew, cost code 210 pipe insulation. Show me before saving.”

    Drafts each worker's timesheet for the week, priced at their trade level's rate, with the hours on the cost code, and waits for your yes before it writes anything.

    create_timesheetcreate_timesheet_detail_recordadd_timesheet_hoursallocate_time_to_cost_codes

  • “Who on Tremblay's crew has no hours in for Wednesday?”

    Compares Wednesday's schedule for the job with the timesheets that came in and names the gaps.

    get_schedule_for_dateget_weekly_timesheet_statussearch_timesheets

  • “Which saved timesheet templates do we have for Lakeshore, and what's in the standard week?”

    Lists the templates, global and job-specific, and shows the hours by worker, weekday and rate label in the one you ask about.

    search_timesheet_templatesget_timesheet_template

  • “Submit the crew's sheets for review once I've checked them.”

    Sends the timesheets you've confirmed to the office for approval. It doesn't approve them; a person does.

    search_timesheetssubmit_timesheet

Tool names are the connector's own; your assistant picks them. Works inside your Appello role. Every call is logged. Anything that leaves the business waits for a person. You can delegate the work, but not the responsibility for it.

Small agent playbook

Foreman end-of-day nudge

The problem. The office spends Friday morning phoning foremen whose crews' hours never made it in.

1 · Goal
By 5 p.m. each day, every foreman knows which of their crew have no hours for today's scheduled job.
2 · Connections
Appello schedules and timesheets; Appello notifications to the foremen.
3 · Context
Who leads which crew, start and finish times by site, and who's on leave.
4 · Skills
Compare who was scheduled with what was entered, and send each foreman only their own list.
5 · Cadence
Weekdays at 4:30 p.m.

The gate. Foremen enter and fix their own crews' hours. The agent never enters, edits or approves time.

Measured by: Timesheets missing at the payroll cut-off, and office hours spent chasing them. Built by our AI implementation team or your own people.

Timesheets are what Appello does most

259,712

timesheets approved on Appello

Across every customer account, counted 2 September 2026.

22,000

timesheets a year

At a typical 200-person contractor.

420

timesheet approvals a week

At a typical 200-person contractor.

Based on usage across a sample of Appello customers, scaled to 200 people over 12 months. Rounded.

Questions foremen and payroll ask

Is bulk entry on the phone or the computer?

The computer. Bulk Timesheet Entry is a screen in Appello's web app, made for a laptop or tablet browser in the trailer, the truck or the office, and it needs a connection. Crew members who clock in on their own phones use the mobile app, which works offline. Many crews use both: phones for the punch, the grid for the foreman's check.

Who loads into the grid?

The workers scheduled on that job for the week, so the crew is already there when you open it. Add Worker brings in anyone else assigned to the job, and someone with permission to add time to unscheduled jobs can add a worker who wasn't scheduled. Each worker's row sits under their employee agreement, with their trade level beside their name.

How does overtime get split?

Turn on Auto-Calculate OT. Appello uses the overtime rule set on the worker's agreement for the job's wage region, with its daily and weekly thresholds, and counts the hours that worker already has on other jobs that day. So a tenth hour lands at the overtime rate label as you type, without anyone doing the arithmetic.

Is there a draft I can come back to?

No. In Appello every save, including the autosave, writes the timesheets and sends them for review, so the office sees hours as soon as they're in. If something changes, edit the cell and save again before the timesheet is approved. Once approved, changes go through the office like any other timesheet.

Can I add travel, board or notes in bulk entry?

No. The bulk grid is for hours by rate label and, in the By Day view, cost codes. Travel, board and parking are priced on the timesheet row from the agreement's rate card, and notes go on the individual timesheet or the clock-in. Keeping the grid to hours is what makes twelve people fit on one screen.

What is a timesheet template?

A saved week. In Bulk Timesheet Entry, Save Template stores each worker's hours by weekday and rate label, with cost-code splits, under a name and description, optionally tied to one job. Apply Template fills a new week from it. Mark it available to all users and every foreman can use it, not only the person who made it.