Teamwork.com

Promptfree, for everyone, and the only version there is

Copy the prompt for Claude CodeCopy the prompt for CodexCopy the prompt for Cursor

Copy

Build me the client-work project system that replaces Teamwork.

The distinguishing feature is money: **an agency needs to know whether a project made a profit, and most project tools cannot answer that.** Build for that question.

STACK
- Node 20+ with Fastify, server-rendered HTML with a little vanilla JS
- SQLite through better-sqlite3, WAL mode
- Caddy in front

THE DATA MODEL
- clients: id, name, billing_json
- projects: id, client_id, name, kind, budget_cents, budget_kind, currency, starts_on, ends_on, status — budget kind is fixed price, retainer, or time and materials
- tasks: id, project_id, title, assignee_id, estimate_minutes, due_on, status, is_billable
- time_entries: id, task_id, person_id, minutes, on_date, is_billable, rate_cents, note, locked_at
- rates: id, person_id, client_id, effective_from, cost_cents, bill_cents — **cost and bill are different numbers and profitability needs both**
- invoices: id, client_id, period, total_cents, sent_at, paid_at
- Money in integer minor units, always, with the currency stored

TIME, WHICH MUST BE FRICTIONLESS
- A timer and a manual entry, both one action from any task
- **A weekly grid: days across, tasks down, type the minutes.** That is how time actually gets entered — on Friday, from memory — and a tool without it collects nothing
- A note per entry, required on billable time, because that note becomes the invoice line the client reads
- Entries locked once invoiced. **An edit to invoiced time silently changes history that has already been billed**, so lock it and require a credit note instead

BUDGETS AND THE ANSWER YOU BUILT THIS FOR
- Burn against budget in both hours and money, visible on the project page, updated as time is entered
- Alert at 70% and 90% of budget, to the project owner and not to everybody
- **Profitability equals billed minus cost, where cost is the person's cost rate and not their bill rate.** Getting this wrong makes every project look profitable, which is the most common and most expensive mistake an agency makes with its own numbers
- Per project, per client and per person, over any period

CLIENT ACCESS
- A client user sees their own projects, the tasks marked visible, and the time summary. **Never the rates, never the costs, never another client's anything** — checked on the server for every query, default deny
- A comment thread the client can use, with internal comments visually unmistakable and impossible to send by accident

INVOICING
- Generate a draft from unbilled billable time with the notes as lines, editable before sending
- Mark entries invoiced with the invoice reference, atomically, so nothing is billed twice
- Export to the accounting system rather than becoming the accounting system

WHAT MATTERS MOST
Cost rates separate from bill rates, and locked invoiced time. One makes the profitability true; the other keeps the billing defensible.