Timesheet summary prompt: hours by person and project, gaps flagged
Updated · By Robert Breen
To summarize timesheets with ChatGPT, export the pay period from your time tracking tool, paste or upload it with the prompt below, and you get hours by person and by project, plus a list of entries to ask about before you approve. Approving timesheets is the kind of job that gets ten minutes on a Friday and the errors land on payroll or a client invoice. A missing Tuesday, 14 hours on one line, or time logged to a closed project is easy to spot in a summary and nearly invisible in 300 rows.
The prompt does not change anyone's hours, decide pay or say who broke a rule. It shows you what to ask. If the problem is vague descriptions on billable lines rather than the hours, the time entry description cleanup prompt rewrites those.
Have a professional review it. This prompt helps you draft, not decide. Employment rules vary by state and country, so have HR or an employment attorney review it before you share it.
The prompt
Copy it into ChatGPT (or Claude, Gemini or Copilot) and replace every [BLANK] with your own details. It uses the four parts from Prompt Writing 101: Role, Context, Task and Format.
Role: You are helping the [YOUR ROLE] at [BUSINESS] review timesheets before approval. You summarize and flag; you never change hours or decide pay. Context: Below is the timesheet export for [PAY PERIOD]. Our normal workday is [NORMAL DAY]. Use only the rows below. If a column is unclear, tell me what you assumed. Task: First give the total hours by person and by project. Then list entries to ask about: workdays with no time, single entries over [LONG ENTRY], time on any project marked closed or on a weekend, and lines with no project or no description. For each flag, give the person, the date, the hours and why it is flagged. Format: Two small tables (by person, by project), then a numbered list headed Ask before approving. Neutral wording: say "no entry" or "over the limit," never "missed work" or "padded." Under 300 words. Timesheet export: [TIMESHEET ROWS]
Fill in the blanks
[YOUR ROLE]- Who approves, such as "office manager" or "project lead."
[BUSINESS]- Your business name and the kind of work, so project names make sense.
[PAY PERIOD]- The dates the export covers, for example October 6 to 17.
[NORMAL DAY]- What a full day looks like, such as "8 hours, Monday to Friday." The flags depend on it.
[LONG ENTRY]- The number of hours on one line that should get a second look, such as 10.
[TIMESHEET ROWS]- Name, date, project, hours and description. Remove pay rates, employee ID numbers and any note about health or leave reasons.
Example, filled in
A made-up example from the free lesson Answer an Employee's Leave Questions Without Overpromising using ChatGPT for Recruiting & HR. Fernhill Architecture is the small firm in the leave questions lesson, where Renée is the HR manager. Here she checks two weeks of project timesheets before payroll and client billing. The rows and hours are an illustration.
Role: You are helping the HR manager at Fernhill Architecture, a small architecture firm, review timesheets before approval. You summarize and flag; you never change hours or decide pay. Context: Below is the timesheet export for October 6 to 17. Our normal workday is 8 hours, Monday to Friday. Use only the rows below. If a column is unclear, tell me what you assumed. Task: First give the total hours by person and by project. Then list entries to ask about: workdays with no time, single entries over 10 hours, time on any project marked closed or on a weekend, and lines with no project or no description. For each flag, give the person, the date, the hours and why it is flagged. Format: Two small tables (by person, by project), then a numbered list headed Ask before approving. Neutral wording: say "no entry" or "over the limit," never "missed work" or "padded." Under 300 words. Timesheet export: Name | Date | Project | Hours | Description Kofi Mensah | Oct 7 | Alder Library (closed) | 3 | revisions Kofi Mensah | Oct 14 | Harbor Clinic fitout | 12 | drawings for permit set June Park | (no rows Oct 9) | | | June Park | Oct 11 (Sat) | Harbor Clinic fitout | 4 | site visit ...
What a good answer looks like
- A by-person table and a by-project table whose totals match each other.
- Kofi's 3 hours on Alder Library flagged because the project is marked closed, with the date and hours.
- Kofi's 12-hour line on October 14 flagged as over the limit, not called an error.
- June's October 9 listed as "no entry," and her Saturday site visit listed as weekend time to confirm.
How to check it before you use it
An AI draft can sound right and still say something you never told it. Use the habit from the Reply Faster lesson: check every promise, name, date and number against what you gave it before anything goes out.
- Add up one person's hours yourself and compare. AI arithmetic on long lists can slip.
- Ask each person about their flags before you change anything. A Saturday site visit may be exactly right.
- Make the fixes in your time tracking tool, not in the chat, so payroll and invoices use the corrected hours.
- Payroll or HR applies overtime and pay rules, which depend on your state and each role.
Practice it in the free lesson
Analyze a Spreadsheet with ChatGPT: Upload a CSV, Get a Chart and Three Takeaways: Upload a CSV of sales to ChatGPT, have it check the data first, ask your questions, get a chart you can download, and finish with the three takeaways that matter. You do every step yourself in a practice copy of ChatGPT, and nothing touches your real accounts.
Also useful: Answer an Employee's Leave Questions Without Overpromising using ChatGPT for Recruiting & HR
Terms used here
Related prompts
- Legal time entry cleanup prompt: A ChatGPT prompt for time entry descriptions: turn rough notes into clear billing narratives with task and purpose, without…
- Overtime and attendance report prompt: A ChatGPT prompt for an overtime and attendance report: overtime by person and week, the trend against last period, and items…
- Weekly team report prompt: A ChatGPT prompt for a weekly team report: paste this week's and last week's numbers and notes, get a short owner report with no…
- End of day report prompt: A ChatGPT prompt for an end of day report: paste your rough notes and get a short EOD report with what got done, what is still…
More reports and planning prompts
- Vendor quote comparison prompt: Compare vendor quotes side by side on price, what's included, timing and warranty, with "Not in quote" for gaps and the…
- Weekly leads summary prompt: Paste a week of form leads from your Google Sheet and get counts by type, who is still waiting, patterns with row numbers and…
- Weekly status email to manager prompt: A ChatGPT prompt for a weekly status email to your manager: wins with numbers, what slipped and why, what you need from them…
Frequently asked questions
- How do I summarize timesheets with ChatGPT?
- Export the pay period as a CSV or paste the rows, say what a normal workday is, and ask for hours by person and project plus a list of entries to ask about. Check one person's total by hand before you approve.
- What should I check on a timesheet before approving it?
- Missing workdays, very long single entries, time on closed projects, weekend time and lines with no project or description. Each one is a question for the employee, not proof of a mistake.