Filling in a weekly timesheet when you cannot remember Tuesday
· 7 min read
A timesheet written from memory on Friday afternoon is mostly a guess about Tuesday. You can get much closer by rebuilding each day from what your Mac already recorded (meetings in Calendar, sent mail, file dates), anchoring each day to a real total, and then splitting that total across the codes your employer asks for. The split is still a judgment call. The total does not have to be.
Why Friday memory gets the week wrong
Memory keeps the unusual things: the meeting that ran over, the urgent request, the problem that took all afternoon. Routine work blurs, and by Friday the middle of the week has often merged into one long day that is hard to divide.
Two habits make it worse. The first is rounding toward the expected number, so every day becomes a neat eight hours whether or not it was. The second is allocating by importance, so the project you worried about most gets the most hours, even if the time actually went to email.
Neither is dishonest. They are what memory does when it is asked to reconstruct a whole week at once. The fix is to stop asking memory to do it.
Rebuild this week from what the Mac already kept
If you are filling in this week’s timesheet now and have no record, these traces will get you most of the way. Take each day in turn.
- Calendar first. Open Calendar in week view. Meetings are the fixed skeleton of each day, and they are usually named after the project they belonged to.
- Sent mail next. In Mail, open the Sent mailbox and scroll to the day. What you sent, and to whom, tells you what you were working on and roughly when.
- Files you touched. In Finder, press Command-F, make sure the search covers This Mac, change the Kind criterion to Last modified date, and set it to within the last 7 days. Add the Date Modified column if it is not showing. Documents saved on Tuesday afternoon are evidence of Tuesday afternoon.
- Browser history. In Safari, choose History, then Show All History; other browsers have an equivalent. Useful for web-based tools that keep no local files.
- Chat. Most chat apps let you search or scroll by date. The threads you replied in show which projects pulled you in.
For each day, write a few lines: the meetings, the main pieces of work, and when the first and last traces appeared. Be careful with that last one: a first message at 8:40 and a last one at 6:15 do not mean you worked every minute between them. How to see your workday when you forgot to track it goes deeper into rebuilding a single day this way.
Anchor each day to a real total
The rebuilt day tells you what happened. It does not tell you how long the day was, and that is the number your timesheet rests on.
This is the part Punchcard handles without any effort from you. It sits in the menu bar, notices which app is in front through the day (app names only), and at the closing time you set it prints a receipt: each app with its time, and a day total. By Friday you have five receipts and five totals, and those are the numbers each day’s column should add up to. The Sunday week roll gives the week total as a check.
The app lines help with the split. If Tuesday’s receipt shows most of the day in the spreadsheet and your sent mail shows the budget review going out that afternoon, the spreadsheet hours were almost certainly the budget review. If Wednesday is half video calls, Calendar tells you which projects those calls were for.
To make next week easier than this one:
- Set your closing time to the end of your normal day, so the receipt arrives while the day is still fresh.
- When it prints, write one line next to it: which codes today, and a rough split. “Mostly the audit, about an hour on the proposal, rest was admin.”
- On Friday, copy each day’s total onto the timesheet and apply your notes. Five one-line notes and five totals turn a half hour of reconstruction into a few minutes of copying.
If you keep your own records in a spreadsheet, Export CSV gives you the underlying data to keep alongside the timesheets you submit.
When the numbers do not match what you expected
The total is under your contracted hours. The receipt only counts time with an app in front on this Mac. In-person meetings, phone calls, time on a second computer and thinking at a whiteboard are real work that it cannot see. Add those from your calendar. Work that happens away from the Mac covers what goes missing and how to account for it.
The total is over your contracted hours. That is worth knowing, whatever your timesheet policy says about recording it. Follow your employer’s rules for what goes on the sheet, but keep the real figure for yourself.
One code got far less time than you thought. Trust the record over the feeling, and say so if the project needs more time than it is getting. A timesheet built from real days is a much stronger basis for that conversation than one built from memory.
It stays a personal record
Punchcard is not employee monitoring software, and the difference matters. It never records window titles, document names, URLs, keystrokes or screen contents. It has no account, no cloud and no networking code at all; the record is one SQLite file on your Mac. Your employer sees the timesheet you submit and nothing else. What employee monitoring software sees sets out the difference in detail.
If you work on a Mac your employer manages, check your IT policy before installing anything. Punchcard asks for no macOS permissions at all, but a managed Mac has its own rules.
Questions
Can Punchcard fill in the timesheet for me? No. It has no projects, client codes or integrations, and it will not split time between them. It gives you a daily total and the time in each app. The allocation is yours, helped by a one-line note each evening.
What if my Mac was asleep at closing time? The receipt prints late, headed SORRY WE MISSED YOU. The day’s record is still there, so the total is still usable for the timesheet.
Does it round to fifteen-minute blocks like my timesheet? No. It records the time each app was in front and prints it as hours and minutes. Round according to your employer’s rules when you copy the totals across.
Is it free? Tracking never expires and the first seven receipts are free, which covers your first week of timesheets. After that it is $9 once, for two Macs.