Timesheets

🕐

No timesheets found

Import from Google Sheets, upload a CSV, or add entries manually.

Add Timesheet Entry

📥 CSV Import

ℹ️ CSV must have headers: candidate_name, client_name, week_start_date, week_end_date, regular_hours, overtime_hours, bill_rate, pay_rate, status (status optional: pending, approved, rejected)

🤖 Format timesheets with AI

Copy the prompt into ChatGPT, Claude, or Gemini, then paste your raw data below the prompt. The AI will list missing fields under Needs your input — reply with those values. When complete, copy the AI's table into Paste from Excel (assignments) or save as CSV (timesheets).

Preview prompt

You are helping import **timesheets** into AccountingPro (Accounting_Shamal). Convert the user's raw data into a CSV-ready import table.

## Your workflow (follow in order)
1. Read all data the user provides.
2. Identify every **missing or ambiguous required field** per row. Do NOT guess or invent values.
3. Reply with a clear section titled **"Needs your input"** listing each gap, for example:
   - Row: John Doe, week of Jan 6 — missing: week_start_date, regular_hours
   Ask the user to supply the missing values.
4. Wait for the user's reply. Merge their answers.
5. Only when every row is complete, output the **final import block** (header + data rows) as plain text with NO markdown code fences unless the user asks.

## Output format (strict)
- Line 1 MUST be this header exactly (lowercase, underscores, comma-separated):
candidate_name,client_name,week_start_date,week_end_date,regular_hours,overtime_hours,bill_rate,pay_rate,status
- Use comma (,) between columns (CSV)
- One timesheet per data row after the header
- Dates: YYYY-MM-DD (week_start_date = start of work week; week_end_date = end of week, often 6 days later)
- Hours and rates: numbers only, no symbols

## Required fields (every row)
- candidate_name
- week_start_date

## Optional but recommended
- client_name
- week_end_date (if missing, use same as week_start_date)
- regular_hours, overtime_hours (default 0 only if user confirms no hours)
- bill_rate, pay_rate (0 if unknown; prefer asking)
- status: pending, approved, or rejected (default pending if not specified)

## Duplicate rules
Do not output two rows with the same candidate_name + week_start_date.

## Rules
- Never fabricate names, dates, or hours.
- If data is incomplete, stop at step 3 — do not output the final table yet.
- After the user fills gaps, output ONLY the header and data rows (ready for AccountingPro → Timesheets → Import from CSV, or save as .csv file).

## Example final output (after all required data is known)
candidate_name,client_name,week_start_date,week_end_date,regular_hours,overtime_hours,bill_rate,pay_rate,status
John Doe,Acme Corp,2025-01-06,2025-01-12,40,0,95,65,approved
Jane Smith,Global Tech,2025-01-06,2025-01-12,38.5,2,110,80,pending

---
User data to convert (paste below this line):

📄

Drop CSV file here or click to browse

Duplicates (same candidate + week start) are automatically skipped

🔗 Import from Google Sheets

Use the full Google Sheets filter tool to connect via OAuth, map columns, and push timesheets directly into the database.

Open Timesheet Filter →

📜

No timesheets found

No import logs yet

⚠️ Confirm Delete