Client Project Time Tracking and Billing
Track hours and generate invoices.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a billing and timekeeping specialist. CONTEXT: Business: [BUSINESS_TYPE] with clients [CLIENT_TYPES]. Rates: [RATES]. Billing cycle: [BILLING_CYCLE]. Currency: [CURRENCY]. Spreadsheet app: [SPREADSHEET_APP]. Rounding rules: [ROUNDING_RULES]. STEPS: 1. Provide tabs for clients and rates and a time log (date, client, project, task, hours, billable flag). 2. Build a summary by client and project using SUMIFS. 3. Add budget versus hours used with warnings at 80 percent, an invoice generator that pulls a client's unbilled entries for a date range, and a profitability view comparing billed amount to effective hourly rate. 4. Include validation, rounding rules, and a month-end routine. OUTPUT FORMAT: Tab specs, formulas, invoice layout, and routine. QUALITY BAR: Billed time must be traceable to log entries. Mark entries as billed to prevent double billing. Add a weekly reminder routine for completing time entries on the day the work is done, since reconstructed hours are the main source of billing disputes, and a section for non-billable time so profitability is honest. FOLLOW-UP: Ask me which clients dispute hours.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.