Clients and contracts
Clients, their contracts and contacts
Clients sheet
Name (text, required), Status (Prospect, Active or Former), Account owner (person, whoever adds it), Industry (text), Website (url), Billing email (email), Address (long text), Notes (long text).
Contracts sheet
Client (one row from Clients, required), What it covers (text, required), Kind (Retainer, Fixed fee or Time and materials), Value a year (money), Start (date), Renews on (date, Start + 1 year), Notice (days, 30), Signed contract (file).
The form: Basics (Client, What it covers, Kind and Value a year), Dates (Start, Renews on and Notice), Documents (Signed contract). Asked when creating: Client and What it covers.
Contacts sheet
Client (one row from Clients, required), Name (text, required), Role (text), Email (email), Phone (phone).
Steps
Draft → Signed → Active → Renewal due → Renewed or Ended
What happens by itself
60 days before a contract's notice date, move it to Renewal due and ask the client's account owner to decide.
30 days before the notice date, if it is still in Renewal due, tell the partner.
Who can see and do what
Operations and Partner see every client, add, edit and move them, and change how it works.
Project managers see every client, add and edit them.
Account owners see their own clients and can add, edit and move them.
Everyone else sees nothing.
Connections
People fills Account owner.
Later
Proposals and statements of work
A client's projects and hours on its record