Painting Timesheet Template: Fields Worth Recording

Most painting timesheets record hours so that people can be paid. That is the least interesting
thing a timesheet can do, and a business that only uses it for payroll is throwing away the one
routine record that tells it whether its pricing is right.

The difference between a payroll timesheet and a useful one is a single column: which job, and
which task within it. Without that, hours are an expense. With it, hours become the feedback loop
that corrects every estimate you write afterwards.

The two things a timesheet is for

Paying people accurately, and finding out what work actually takes. These pull the document in
different directions, and pretending otherwise is why so many timesheets satisfy neither.

Payroll wants totals per person per week. Job costing wants hours split by job and task, which is
more work for the painter filling it in. The resolution is to design for job costing and derive
payroll from it, never the other way around, because you can always sum a detailed record and you
can never split a summarised one.

That asymmetry is worth sitting with, because it decides the whole design. A business that starts
with a payroll sheet and later wants costing data has to change the form and retrain everyone, and
it has no history to compare against. A business that starts with task level recording can produce
payroll totals from day one and has usable costing history the moment it thinks to look. The extra
cost at the point of collection is perhaps a minute a day per painter.

The fields

Two of these do the heavy lifting, and both are usually missing.

Both are copied straight from the sheet the crew already has in front of them, since the job
number and the task list appear on the work order. Keeping the two
documents using identical task wording is what lets you compare expected against actual without
anybody translating between them.

Task is what makes the data usable. Knowing a job took a certain number of hours
tells you the job was expensive. Knowing that preparation took most of them tells you what to change
in the next estimate. Keep the task list short and fixed, because a free text field produces
categories nobody can total.

Non job time is the number every painting business underestimates. Merchant
runs, moving between sites, loading and unloading, waiting for access. It is real paid time that
gets silently absorbed into whichever job happened to be running, which makes that job look worse
than it was and hides the actual size of the overhead. What that time costs sits inside
painting labour burden.

Why clock in and clock out is not enough

A start time and a finish time produce a day length, which you already knew. What you cannot get
from it is where the day went, and that is the only part that changes decisions.

A painter who arrives at eight and leaves at four has done an eight hour day on every timesheet
of that design, whether it contained seven hours of rolling or three hours of rolling, two hours at
the merchant and two hours waiting for a customer to come home with a key. Those are completely
different days and only one of them is a pricing problem.

Recording against task also removes the adversarial framing. A sheet asking when did you arrive
is checking up on somebody. A sheet asking what did you work on is asking them to report, which is a
different relationship and produces better data.

Getting it filled in honestly

This is the real problem, and no amount of form design solves it on its own. Three things help
more than anything printed on the sheet.

Fill it in daily, on site. A sheet completed on Friday for the whole week is
fiction, reconstructed from memory and rounded to whatever feels defensible. Two minutes at the end
of each day produces something usable. Anything longer than that and it will not happen at all.

Never use it to criticise an individual for being slow. The moment a timesheet
becomes evidence in a performance conversation, every painter learns to write hours that look
reasonable, and the data stops describing reality. Use it on the estimate, not on the person. If
somebody genuinely is not performing, that is a management conversation, held separately, as in
managing a painting crew.

Close the loop out loud. Tell the crew what the data changed. A painter who
hears that prep hours on cabinet work were consistently under allowed, and that the next quote
carries more, understands why the sheet matters. One who never hears anything concludes it goes in a
drawer, which is usually correct.

Reading it back

The record is only worth keeping if somebody looks. Three comparisons are worth making regularly
and none of them takes long.

• Estimated against actual, by task. Not by job. Job level totals hide the
  pattern, because an over on prep and an under on rolling cancel out and look like an accurate
  estimate.
• Non job time as a share of paid time. Track the direction rather than the
  level. A number that is drifting upward usually means the schedule has too much movement between
  sites, which is a routing problem covered in
  scheduling painting jobs.
• The same task across different job types. Cutting in on new construction and on
  an occupied repaint are not the same activity, and pricing them from one production rate is a
  standing source of loss. See new construction versus repaint.

Where those numbers land feeds directly into your rates, and the mechanism for turning them into
a price is in tracking painting job costs.

The half hour rounding question

Recording to the nearest half hour is deliberate, and it is worth explaining to a crew rather than
imposing it. Finer granularity produces a false impression of precision and makes the sheet feel like
surveillance. Coarser granularity, which usually means rounding to whole days, destroys the task
level detail that the whole exercise exists to capture.

What matters far more than the rounding interval is consistency of coding. If one painter records
setting out and masking as preparation and another records it as cutting in, your production rates
for both tasks are wrong, and no amount of precision on the clock fixes it. Agree the categories
once, write them on the sheet itself as a reminder, and expect to correct the coding for the first
few weeks.

Do not chase the last few minutes of a day. The value in this record is in the pattern across
dozens of jobs, not in the accuracy of any single entry, and a crew that believes it is being
audited to the minute will start producing tidy numbers instead of true ones.

The weekly summary line

One row at the bottom of each sheet, totalling hours by category rather than by job: productive
job hours, travel, and non job time. It takes seconds and it is the number most painting businesses
have never seen.

The reason it matters is that estimates are built from productive hours while wages are paid on
all of them. A business quoting as though every paid hour is a productive one is systematically
under recovering, and the gap does not show up anywhere else in the accounts because the money was
genuinely spent on painting, just not on painting that particular job. This is the same arithmetic
that sits underneath painting business break even.

Watch the ratio over months rather than weeks. A single bad week means a job fell through or the
weather stopped exterior work. A trend means something structural: jobs too small, sites too far
apart, or too much time spent collecting materials that could be delivered.

Subcontractors and day rates

Subcontracted painters on a day rate still need to record job and task, even though the hours do
not drive their pay. Otherwise every day a sub works is invisible in your costing, and job types
where you lean on subs will look artificially cheap.

Record their time as cost at the rate you are paying, not at your charge out figure. Mixing the
two is the single most common way a job cost record ends up meaningless, because the resulting
number is neither what the work cost you nor what you sold it for, and it cannot be reconciled
against anything later. Where the boundary between
employee and subcontractor sits, and why it matters beyond the paperwork, is in
employee versus subcontractor, and the day rate arithmetic is in
painting crew day rate.

Public and prevailing wage work

On publicly funded jobs the timesheet stops being an internal document. Certified payroll
reporting requires records of hours by worker, by classification and by day, submitted on a schedule,
and the format is prescribed rather than left to you.

If you take that kind of work, design your ordinary timesheet so it already captures what the
certified report needs: worker classification against each block of hours, and the job identified in
a way that maps to the contract. Retrofitting it afterwards from a sheet that recorded only totals is
painful and error prone. What else that work carries is covered in
prevailing wage painting jobs.

Who gets to see them

There is rarely a reason to circulate individual timesheets, and doing so turns a costing record
into a comparison between painters, which is the fastest way to make the numbers stop being honest.
Somebody who believes their sheet will be set against a colleague’s will write hours that look
defensible rather than hours that happened.

Share the conclusions freely and the source sheets narrowly. Telling a crew that prep on a
particular job type is consistently running over what was allowed is useful to everyone and names
nobody. That is the version of transparency that improves both the estimates and the willingness to
keep filling the sheet in.

Frequently asked questions

How granular should the task list be?

Short enough to remember without looking, which in practice means a handful of categories. A long
list produces inconsistent coding between painters, and inconsistent coding is worse than coarse
coding because it looks like data.

Should breaks be recorded?

Record them as their own category if you need to for compliance, and otherwise simply do not count
them in job hours. What you must not do is leave them inside task time, because that inflates every
production rate you derive.

Can I use photographs or messages instead?

They are better than nothing for a solo painter and do not scale past one person, because
somebody then has to reconstruct hours from them. The reconstruction is where the accuracy goes, and
it also lands the admin on whoever is least willing to do it. A dated note on a phone at the end of
each day is a reasonable minimum if a formal sheet will genuinely never get filled in.

What if a painter works on three jobs in a day?

Three lines, with travel between them recorded separately. This is exactly the situation a
day total cannot describe, and it is more common than most schedules admit.

How long should I keep timesheets?

Follow whatever your jurisdiction requires for employment records, which is usually several
years, and keep them longer than that for costing purposes. Historic task data becomes more useful
the more of it you have, because seasonal effects and job type differences only separate out once
you have several cycles to compare.

Does software make this easier?

It removes the transcription step and makes the reading back almost automatic, which is where
most of the value is lost on paper. It does not solve the honesty problem, which is cultural.
Options are covered in painting business software.