Astrolinks

Daily work log template: 4 free formats you can copy

Free work log templates to copy into a doc or spreadsheet: simple daily log, per client, developer and field or shift log, plus what to write in each.

Someone writing in a small notebook beside a cappuccino
Photo: engin_akyurt on Pixabay

Short answer

A work log template is a simple table for recording what you did each day: the date, the time, the task, the result and any notes. Copy one of the formats below into a doc or spreadsheet, add a line whenever you finish something, and review the log for five minutes at the end of each day.

Want your EOD report written for you? Astrolinks writes it from your actual workday when you clock out. Get it free →

A work log is the simplest productivity tool there is: a list of what you did, written down while you still remember it. It sounds too basic to need a template, but the format matters. A log with the right columns turns into a timesheet, a client update or a performance review with almost no extra work. A log without them turns into a page of "emails" and "meeting."

This page gives you four work log templates to copy into a document or spreadsheet: a simple daily log, a log per client, a developer log, and a field or shift log. After the templates, you'll find what to log, how to keep the habit going, and the mistakes that make a log useless.

Work log template (copy and paste)

If you just want to start, copy these lines into a doc or a blank spreadsheet. In Google Sheets, paste into cell A1, then use Data, Split text to columns, with a custom separator of |.

Date | Time | Client or project | Task | Result | Notes or next step
Nov 19 | 9:00 to 9:45 | Halcyon Dental | Patient reminders | 31 reminders sent | None
Nov 19 | 9:45 to 10:30 | Brightline Co. | Instagram scheduling | 9 posts scheduled | Need holiday photos from Dana

Add one row each time you finish something or switch tasks. The four formats below adapt this for different jobs.

What is a work log template?

A work log template is a ready-made table for recording your workday. Each row is one piece of work. The columns hold when it happened, what it was, and what came of it. Some people call it a daily log, a work diary, an activity log or a daily log template. They are all the same idea.

People keep work logs for different reasons:

  • Employees use them to remember what they did when review time comes, and to answer "what did you work on this week?" in seconds.
  • Freelancers and virtual assistants use them to bill accurately and to show clients what the hours went into.
  • Developers use them to record decisions and dead ends, so they don't repeat them.
  • Field and shift workers use them to record jobs, incidents and handovers.

A work log is not the same as a timesheet. A timesheet answers "how many hours?" A work log answers "what happened?" If you need hours for pay, our timesheet template covers that, and the log on this page is where those hours come from.

What should a daily work log include?

Every work log needs four fields:

  • Date
  • Time or a time range (9:00 to 9:45)
  • Task: what you worked on
  • Result: what came of it

Add these when they apply:

  • Client or project, if you work for more than one
  • Duration in minutes or decimal hours
  • Notes: problems, decisions, who you spoke to
  • Next step: what happens with this item tomorrow
  • Status: done, in progress or blocked

The column people skip most is Result, and it's the one that makes a log worth keeping. "Worked on the newsletter" tells you nothing a week later. "Newsletter draft sent to Maria for review" tells you exactly where things stand.

Template 1: Simple daily work log

Use this if you work for one employer or one client and just want a clear record of the day. It fits on one page.

Daily work log: Thursday, November 19

Time Task Result Notes
9:00 to 9:30 Inbox and calendar 22 emails cleared, 3 meetings confirmed Moved Friday sync to 2 p.m.
9:30 to 11:00 Q4 budget sheet First draft done, shared with Sam Waiting on travel figures
11:00 to 11:30 Team meeting Agreed launch date of Dec 3 Notes in shared folder
13:00 to 14:30 Vendor contracts 2 of 3 reviewed Third one missing page 4
14:30 to 16:00 Customer survey Survey live, sent to 400 customers
16:00 to 16:30 Planning Tomorrow's list written

Blocked: Travel figures from finance, page 4 of the Acme contract. Tomorrow: Finish budget sheet, third contract, check survey responses.

The two lines at the bottom are the most useful part. They turn the log into a ready-made end-of-day update.

Template 2: Work log per client

Freelancers and virtual assistants need to know which client each entry was for, and whether it's billable. This version adds those columns.

Date Client Start End Hours Task Result Billable
Nov 19 Halcyon Dental 8:00 9:15 1.25 Patient reminders 31 reminders sent for next week Yes
Nov 19 Brightline Co. 9:15 10:00 0.75 Instagram scheduling 9 posts scheduled through Nov 27 Yes
Nov 19 Brightline Co. 10:00 10:15 0.25 Call with Dana Approved holiday campaign brief Yes
Nov 19 Own business 10:30 10:50 0.33 Invoicing Sent 2 invoices No
Nov 19 Halcyon Dental 13:00 14:30 1.50 Insurance claims 12 of 18 entered Yes

The clients are made up. Short rows are fine: a 15-minute call deserves its own line, because those are the ones that go unbilled. In a spreadsheet, =SUMIFS(E:E,B:B,"Halcyon Dental",H:H,"Yes") totals one client's billable hours. Our guide on tracking time across multiple clients has a routine for keeping clients separate through the day.

Template 3: Developer work log

A developer's log is less about hours and more about decisions. When something breaks in three weeks, the log is where you find out why you did it that way.

Date Ticket What I did Outcome Decisions and dead ends
Nov 19 PAY-412 Fixed rounding in invoice totals PR #318 open, tests pass Used integer cents instead of floats
Nov 19 PAY-415 Investigated slow report page Found N+1 query on line items Tried caching first, didn't help
Nov 19 Review Reviewed PR #314 Approved with 2 comments
Nov 19 Ops Rotated staging API keys Done, team notified

Blocked: PAY-415 needs a database index, waiting on DBA approval. Tomorrow: Merge #318, write the index migration.

Keep this log in a plain text or Markdown file next to your code if a spreadsheet feels heavy. Some developers keep one file per month, with a heading for each day. If you work freelance, see Astrolinks for developers.

A hand writing notes in a notebook at a desk
Photo: pexels on Pixabay

Template 4: Field or shift work log

Field technicians, drivers, security staff and anyone who works in shifts need a log that records where they were, what they found and what the next person needs to know.

Time Location or job Work done Issues found Follow-up needed
7:00 Depot Vehicle check Low tire pressure, fixed None
7:45 14 Elm St, job 2231 Replaced water heater valve None None
10:15 220 Oak Ave, job 2234 Inspected HVAC unit Fan motor worn Order part, return visit
13:30 9 Pine Rd, job 2240 Customer not home Rebook with office
15:00 Depot Restocked van Out of 3/4 inch fittings Order more

Shift summary: 3 of 4 jobs completed, 1 rebook, 1 part on order. Handover note: Job 2234 needs the fan motor before the return visit.

If your shift ends with a handover to someone else, the last two lines matter most. Write them as if the next person has never seen the job.

How do you keep a work log every day?

The template is the easy part. The habit is harder. These steps keep it going:

  1. Keep the log open all day. A pinned tab, a sticky window or a notebook on the desk. If you have to go looking for it, you won't.
  2. Log when you switch, not when you remember. Each time you finish a task or change clients, add one line. It takes 20 seconds.
  3. Write the result in the moment. "Sent," "approved," "blocked by X." You won't remember the detail at 6 p.m.
  4. Review for five minutes at the end of the day. Fill gaps, add the blocked and tomorrow lines, and total the hours if you need them.
  5. Keep a week per sheet or file. One tab per week in a spreadsheet keeps it fast and easy to search.

If you already send an end-of-day update, your log is the first draft. The format is covered in our EOD report template guide, and the free EOD report generator turns a day's log lines into a report you can paste into Slack or email. And if you're not sure what "EOD" means in a request from your manager, see EOD meaning.

What should you log, and what can you skip?

Log these:

  • Finished work, with the result
  • Work in progress, with where it stands
  • Meetings and calls, with the decision or next step
  • Problems, blockers and who you're waiting on
  • Decisions and the reason behind them
  • Small tasks for clients, even five-minute ones

Skip these:

  • Every single email. Group them: "Inbox, 22 emails, 3 needed follow-up."
  • Personal breaks, unless your timesheet needs them
  • Passwords, customer card numbers or anything private. A log gets shared and copied; keep sensitive data out of it.

Common work log mistakes

  • Activities without results. "Worked on report" says nothing. "Report draft sent for review" says everything.
  • Filling it in on Friday. Memory drops the small items first, and the small items are often the billable ones.
  • One giant row per day. "9:00 to 17:00, client work" can't be billed, searched or reported on.
  • No blocked line. Problems that aren't written down don't get solved.
  • Too many columns. If a row takes more than 30 seconds, you'll stop. Start with four columns and add more only when you miss them.

Which work log template should you use?

  • One job, one manager: Template 1.
  • Several clients, billed by the hour: Template 2.
  • Software work: Template 3.
  • Shifts, jobs on site, or handovers: Template 4.

You can mix them. Many VAs keep Template 2 for billing and add the blocked and tomorrow lines from Template 1 at the bottom of each day.

A work log that fills itself in

The hardest part of any work log is remembering to write it. Astrolinks is a Mac and Windows app that keeps a private log of your workday on your own computer and sorts it by client, with no screenshots and no keystroke logging. Notes you type with a keyboard shortcut land in that client's report. At clock-out it writes each client's end-of-day report from the day. See how automatic time tracking works. The templates above work fine without it.

Let the report write itself

Astrolinks keeps a private log of your workday on your Mac and Windows and writes each client’s end-of-day report when you clock out. You check it and send. 7 days of Pro to start, no card.

Questions

What is a work log?

A work log is a running record of what you did during the day: tasks, results, decisions, problems and how long things took. It's for your own memory first, and it becomes the source for timesheets, status updates and end-of-day reports.

What should a daily work log include?

At minimum the date, a time or time range, the task and the result. Useful extras are the client or project, notes on problems or decisions, and what's next. Write results, not just activities.

How is a work log different from a timesheet?

A timesheet records hours for pay or billing: start, end, breaks and totals. A work log records what happened: what you worked on, what came of it and what got in the way. Many people keep the log and build the timesheet from it.

How often should I fill in a work log?

Add a line whenever you finish something or switch tasks, then spend about five minutes at the end of the day tidying it. Filling it in once a week from memory misses the small items that matter.

Can I keep a work log in Google Sheets or Excel?

Yes. Copy one of the tables on this page into a blank sheet, freeze the header row, and add one row per entry. A spreadsheet makes it easy to filter by client or total the time.

Clock out with the report already written

7 days of Pro to start. No card. Your log stays on your computer.