---
name: time-audit-sheet-manager
description: "Turns your logged hours into a clean time-audit table with category totals and a copy-paste CSV, then points to where the time leaks. Use when you have a daily hours log for a freelance project and want it organised into a table with category totals and a CSV. Do not use for creating a blank sheet to fill in later or planning how to schedule your week. Related topics: productivity, work, time."
---

# Time Audit Sheet Manager

Turns your logged hours into a clean time-audit table with category totals and a copy-paste CSV, then points to where the time leaks.

## When to use

Use this skill when you have a daily hours log for a freelance project and want it organised into a table with category totals and a CSV. Do not use it for creating a blank sheet to fill in later or planning how to schedule your week.

## Workflow

1. Ask the user for each input listed below in a single message, skipping any they have already given. Where options are listed, offer them, but accept other answers too.
2. Parse each day of the log into Date, Category, Hours, and Notes rows and attach observations to the right days.
3. List any day whose total hours look implausible without changing the numbers.
4. Add a summary row of hours and share of week per category.
5. Output the same table as a header-first CSV suited to the chosen export tool.
6. Add two observations on time leaks grounded in the logged numbers.

## Inputs

- **Project name** (free text, e.g. "Project or client name")
- **Date range** (free text, e.g. "2026-09-01 to 2026-09-07")
- **Work categories** (choose any: Development, Meetings, Research, Administration, Breaks)
- **Daily hours log** (longer free text)
- **Observations** (longer free text)
- **Export format** (choose one: Google Sheets, Excel, CSV)

## Output

A markdown table with Date, Category, Hours, Notes and a totals row, then a CSV version of the same table, then two short observations.

## Prompt template

Fill the inputs into this template and follow it as the full instruction.

### Time Audit Sheet Manager

Convert my hours log into a time-audit table I can paste into a spreadsheet.

- Project name: {{Project name}}
- Date range: {{Date range}}
- Work categories: {{Work categories}}
- Daily hours log: {{Daily hours log}}
- Observations: {{Observations}}
- Export format: {{Export format}}

Parse the daily log into rows with Date, Category, Hours, and Notes, attaching my observations to the days they describe. Flag any day whose hours do not add up to a plausible working day and ask nothing, simply list it for me to check. Add a summary row with total hours per category and the percentage of the week each takes. Then provide the same table as plain CSV with a header row, formatted for pasting into the chosen export tool. Close with two observations on where time leaks, based only on my numbers and notes.

## Pitfalls

- Silently correcting hours that look wrong, which corrupts the audit.
- Putting commas inside CSV note fields without quoting them, which shifts columns on import.
- Drawing conclusions the log does not support, such as blaming meetings with no meeting data.
