Skip to content

—— 02 Subsystem: Time Tracking & Proof/02 Procedure: Daily Evidence Export.md ——§

DraftSOP · Procedure · TT-SOP-2 – Daily Evidence Export · 2025-05-14-r1§


Big-Picture Overview§

Block Content
Purpose & Scope Export and attach auditable proof of the day’s work so DH-SOP-1 (Daily Hygiene) can flow without delays.
Artifacts:
• Clockify “Today” CSV • Insightful productivity-% screenshot • Eisenhower Q-grid PNG • Link to DailyReport row (with Exception? flag).
Map / Flow 17 : 00 stop timers → export CSV → store in Drive (Daily CSVs/YYYY-MM/…) → paste link in DailyReport (new row) & set Exception? Y/N + note → grab Insightful % PNG → grab Eisenhower PNG → attach all 3 files to Daily Hygiene card → move card to Waiting for Approval → send Daily Digest in /manager thread.
Roles / RACI Freelancer Operator R · Ops Manager A · Systems-Ops Lead C · GPT Assistant I
KPIs 100 % minutes exported same day · Digest ≤ 3 min to read
Tools Clockify · Insightful · Google Sheet (DailyReport) · Trello · Telegram
Risks (ISO 31000) Missed export ⇒ unpaid time · Wrong CSV range · Screenshot blur
Open Question Automate Insightful % screenshot?
Next Action Pilot for one day; verify operator export time & Digest clarity.

Detailed SOP — Daily Evidence Export (≤ 7 bullets)§

# Step & Owner Key Points / Controls
1. Stop Timers 17 : 00
Operator
Ensure no running Clockify timers.
2. Export & Store CSV • In Clockify → Export › Today CSV.
• Move file to Drive:/Daily CSVs/YYYY-MM/.
3. Log in DailyReport • Open DailyReport Sheet → new bottom row.
• Paste CSV Drive-link.
Set Exception? column → Y/N and add a short note if Y.
4. Capture Screenshots Insightful dashboard → take productivity-% PNG.
Trello Eisenhower frame → take Q-grid PNG.
5. Attach & Stage Card • Attach CSV, both PNGs to Daily Hygiene card.
• Move card to Waiting for Approval.
6. Send Daily Digest Post in /manager thread (template ↓).
7. Follow-up Ping manager until ✅/❌. No next-day work without ✅.

Daily Digest template (copy-paste, edit placeholders; ≤ 3 min read)

🗓 2025-05-14 Daily Digest  
CSV: <Drive-link> · Insightful %: 87 · Exception? N  
Eisenhower PNG: <link>  
Status: ✅ All Q1 closed – starting Ops card #42 tomorrow

SLA — All artifacts submitted & Digest sent by 17 : 15.


WGLL (“What Great Looks Like” snapshot)§

Criterion ❌ Miss ✅ Meets ⭐ Exceeds
CSV timing After 17 : 15 By 17 : 15 By 17 : 05
Screenshots Missing / blurry Both clear PNGs PNGs + annotated highlights
Digest Walls of text Uses template + one-line tomorrow plan

(Full exemplars → Drive › 01-SYSTEMS › WGLL_Gallery)


ArchitectureSnapshot JSON — schema-valid§

{
  "version_id": "2025-05-14-r1",
  "system_level": "Procedure",
  "lifecycle_state": "DraftSOP",
  "target_name": "TT-SOP-2 – Daily Evidence Export",
  "parent_name": "Time Tracking & Proof",
  "last_updated": "2025-05-14T21:50:00Z",
  "overview": {
    "purpose": "Export daily time-log evidence and attach it to the Daily Hygiene workflow.",
    "flow": [
      "17:00 stop all running Clockify timers",
      "Export 'Today' CSV and store in Drive (Daily CSVs/YYYY-MM/)",
      "Paste CSV link into DailyReport Sheet, set Exception? Y/N and note",
      "Screenshot Insightful productivity % and save PNG",
      "Screenshot Trello Eisenhower grid and save PNG",
      "Attach all artefacts to Daily Hygiene card, move to Waiting for Approval",
      "Send Daily Digest in /manager Telegram and follow up until approved"
    ],
    "roles": ["Freelancer Operator", "Ops Manager", "Systems-Ops Lead", "GPT Assistant"],
    "raci": {
      "Responsible": ["Freelancer Operator"],
      "Accountable": ["Ops Manager"],
      "Consulted": ["Systems-Ops Lead"],
      "Informed": ["GPT Assistant"]
    },
    "kpis": [
      "100% minutes exported same day",
      "Digest readability ≤3 minutes"
    ],
    "tools": [
      "Clockify",
      "Insightful",
      "Google Sheets (DailyReport)",
      "Trello",
      "Telegram"
    ],
    "risks": [
      "Export missed ⇒ unpaid work",
      "CSV covers wrong date range",
      "Screenshots unreadable"
    ],
    "controls": [
      "CSV naming convention Daily CSVs/YYYY-MM/",
      "Exception? column forces daily self-audit",
      "Digest template ensures uniform manager UX",
      "Manager weekly Exceptions tab review"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-02_Daily_Evidence_Export_v0.2.gdoc"
  },
  "procedure_core": {
    "procedure_id": "TT-SOP-2",
    "name": "Daily Evidence Export",
    "purpose": "Produce and attach all proof artifacts required for Daily Hygiene approval.",
    "trigger": "Every workday at 17:00 local.",
    "inputs": [
      "Clockify timer entries",
      "Insightful dashboard",
      "Personal Trello board Eisenhower frame",
      "DailyReport Google Sheet"
    ],
    "responsible_role": "Freelancer Operator",
    "steps": [
      "Stop all running Clockify timers at 17:00",
      "Export 'Today' CSV and move to Drive folder Daily CSVs/YYYY-MM/",
      "Paste CSV link into new DailyReport row; set Exception? Y/N and note",
      "Capture Insightful productivity % PNG",
      "Capture Trello Eisenhower grid PNG",
      "Attach CSV + PNGs to Daily Hygiene card and move it to Waiting for Approval",
      "Post Daily Digest message in /manager thread (use template) and follow up until ✅/❌"
    ],
    "outputs": [
      "Drive-stored CSV file",
      "Insightful PNG",
      "Eisenhower PNG",
      "DailyReport row with link & Exception flag",
      "Daily Digest Telegram message"
    ],
    "sla": "All artefacts submitted and Digest sent by 17:15 local.",
    "controls": [
      "Exception column forces operator to declare anomalies",
      "Manager weekly spot-checks Exceptions tab"
    ],
    "tools": [
      "Clockify",
      "Insightful",
      "Google Sheets",
      "Trello",
      "Telegram"
    ],
    "kpis": [
      "100% minutes exported same day",
      "Digest readability ≤3 minutes"
    ],
    "risks": [
      "Unpaid work due to missed export",
      "Incorrect CSV range",
      "Unreadable screenshots"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-02_Daily_Evidence_Export_v0.2.gdoc"
  },
  "insights": [
    {
      "note": "Added Exception? column workflow and standardized Daily Digest template for uniform manager review.",
      "date": "2025-05-14"
    }
  ],
  "children": []
}

End of TT-SOP-2 r1

—— 03 Subsystem: Daily Close-out & Hygiene/00 Subsystem: Daily Close And Hygiene.md ——§

DraftSOP · Subsystem · 2025-05-14-r3§

Target System — Daily Close-out & Hygiene Report (supersedes r2; deltas noted in the changelog at the end)


Big-Picture Overview§

Block Content
Purpose & Scope Provide managers with daily, human-readable proof of work and the operator’s well-being.
Outputs:
1. Hygiene Evidence Packet – Clockify CSV, Insightful %, Eisenhower PNG, DailyReport link.
2. Daily Digest – GPT-prompted message that stitches the evidence plus “What went well / Challenges / Tomorrow plan / Mood-score (1-5)”.
(A separate Channel-Ops SOP covers domain-specific reports such as the Reddit Ops Daily Report; operators simply reference that SOP here.)
Map / Flow 16 : 45 stop timers → run TT-SOP-2 Daily Evidence Export16 : 55 generate Digest GPT prompt → paste evidence links + W↑C↓T→M → send in /manager Telegram → move Hygiene card ➜ Waiting for Approval → follow up until ✅/❌.
${DIAGRAM: Daily Close-out swim-lane – evidence export → digest compose → manager approve}
Roles Freelancer Operator · Ops Manager · Systems-Ops Lead · GPT Assistant
RACI Snapshot R Operator · A Manager · C Sys-Ops Lead · I GPT
KPIs Hygiene evidence posted by 17 : 00 (100 %) · Manager reaction within 24 h (100 %) · Digest ≤ 3 min read · Mood-score reported daily
Tools Trello Hygiene list · Google Sheet DailyReport (+ Exceptions tab) · Clockify · Insightful · Telegram · GPT Digest Prompt
Risks (ISO 31000) Evidence or Digest missing → unpaid work / blind spots · Links break · Operator fails to flag challenges · Manager approval delay
Open Questions Automate Insightful % screenshot? · Telegram bot reminder if Digest late?
Next Action Draft two child SOPs (see table) & pilot for 3 days.

Detailed SOPs (owned by this subsystem)§

ID Procedure Purpose / Notes
DC-SOP-1 Daily Evidence Export (TT-SOP-2 upstream) Already drafted – collects CSV, screenshots, Sheet link.
DC-SOP-2 Compose & Send Daily Digest NEW – adds W↑C↓T→M template, GPT prompt & follow-up loop.

(Domain-specific reports, e.g. “Reddit Ops Daily Report”, live in their own Channel-Ops subsystem; operators run them before DC-SOP-2 and hyperlink the output inside the Digest.)


Appendix – Full Specs§

omitted — ShowAppendix=false


ArchitectureSnapshot JSON§

{
  "version_id": "2025-05-14-r3",
  "system_level": "Subsystem",
  "lifecycle_state": "DraftSOP",
  "target_name": "Daily Close-out & Hygiene Report",
  "parent_name": "Personal Management OS for Freelancers",
  "last_updated": "2025-05-14T22:10:00Z",

  "overview": {
    "purpose": "Package daily time-proof and operator reflections into a single digest managers can approve within 24 h.",
    "flow": [
      "16:45 stop all running Clockify timers",
      "Run TT-SOP-2 Daily Evidence Export (CSV, % screenshot, Eisenhower PNG, DailyReport link, Exception Y/N)",
      "16:55 open GPT Digest prompt, paste evidence links",
      "Add sections: What went well, Challenges, Tomorrow plan, Mood 1-5",
      "Send Digest + Hygiene card link in /manager Telegram",
      "Move Hygiene card to Waiting for Approval",
      "Operator follows up until manager reacts ✅/❌ (no next-day work without approval)"
    ],
    "roles": [
      "Freelancer Operator",
      "Ops Manager",
      "Systems-Ops Lead",
      "GPT Assistant"
    ],
    "kpis": [
      "Hygiene evidence posted by 17:00 (100%)",
      "Manager reaction within 24h (100%)",
      "Digest readability ≤3 minutes",
      "Daily mood-score reported"
    ],
    "tools": [
      "Trello Hygiene list",
      "Google Sheet DailyReport + Exceptions tab",
      "Clockify",
      "Insightful",
      "Telegram",
      "GPT Digest prompt"
    ],
    "risks": [
      "Evidence or Digest missing",
      "Broken links in Digest",
      "Challenges not surfaced",
      "Approval delay ≥24h"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-03_Daily_Close-out_v0.3.gdoc"
  },

  "children": [
    { "system_level": "Procedure", "target_name": "DC-SOP-1 – Daily Evidence Export", "version_id": "TT-SOP-2-r2" },
    { "system_level": "Procedure", "target_name": "DC-SOP-2 – Compose & Send Daily Digest", "version_id": "DC-SOP-2-TBD" }
  ]
}

Changelog (r2 → r3)§

Area Change Reason
Purpose / Flow Added “What went well / Challenges / Tomorrow plan / Mood-score” to Digest; clarified Reddit Ops report runs elsewhere. Capture emotional state & external report dependency.
Tools / KPIs Added Exceptions tab, GPT Digest prompt, mood KPI. Align with brainstorm details.
Child SOPs Split out DC-SOP-2 for Digest composition; kept Evidence Export reference. Clear separation of tasks.
Risks Added “Challenges not surfaced”. Reflect new emotional check.

✅ Subsystem now matches every brainstorm point.

                  ┌──────────────────────────────┐
                  │      Time-Tracking & Proof    │
                  │  (Clockify ▸ Insightful ▸     │
                  │   DailyReport Sheet rows)     │
                  └──────────────┬───────────────┘
                                 │ 17:00 data
                                 ▼
┌────────────────────────────────────────────────────────────────────────┐
│        DAILY CLOSE-OUT & HYGIENE REPORT  (Subsystem r3)              │
│                                                                      │
│   ┌──────────────────────────────┐        ┌───────────────────────┐  │
│   │ DC-SOP-1  Daily Evidence     │        │ DC-SOP-2  Compose &   │  │
│   │ Export                       │        │ Send Daily Digest     │  │
│   │ ─ Export Clockify “Today”    │  CSV   │ ─ Fill W↑ C↓ T→ M     │  │
│   │ ─ Screenshot Insightful %    │  PNG   │   template            │  │
│   │ ─ Screenshot Eisenhower grid │  PNG   │ ─ Attach evidence     │  │
│   │ ─ Paste links into Sheet     │  link  │ ─ Move Hygiene card   │  │
│   │ ─ Attach 3 artefacts to card │◀───────┤   → Waiting-Approval  │  │
│   └───────────┬──────────────────┘        │ ─ /manager Telegram    │  │
│               │ artefacts                 │   ✔/❌ follow-up       │  │
│               ▼                           └──────┬────────────────┘  │
│       ┌─────────────────────┐                  feedback              │
│       │  Hygiene Trello     │<───────────────────────────────────────┘
│       │  card (Waiting)     │        (Manager taps ✔/❌ ≤24 h)         
│       └─────────────────────┘                                              
└────────────────────────────────────────────────────────────────────────┘
                                 │
                                 │   If ❌ → Operator fixes & resends
                                 ▼
                        ┌─────────────────────────────┐
                        │   Weekly / Monthly Rituals  │
                        │   & Invoicing Subsystem     │
                        │   (uses approved Daily rows │
                        │    for metrics & invoices)  │
                        └─────────────────────────────┘

Legend:
W↑  what-went-well C↓  challenges T→  plan for tomorrow M  mood / wellbeing

How this subsystem ties into the rest of the Personal Management OS§

Up-stream input Down-stream consumer What flows & why
Time-Tracking & Proof – DC-SOP-1 pulls the day’s CSV, Insightful % and Eisenhower PNG. Daily Close-out (here) Raw evidence → attachments & Sheet links.
Work Intake & Prioritisation – the Eisenhower grid screenshot is generated from the Personal board. Meeting next-day planning (operator & manager) Gives instant view of Q1/Q2/Q3 after triage.
Daily Close-out & Hygiene (this subsystem) Weekly / Monthly Rituals & Invoicing Approved Sheet rows feed WeekMetrics formulas and operator-crafted invoice PDFs.
Gap-Fix & Continuous Improvement Reads the “challenges / blockers” section in each Digest. Persistent pain-points become Kaizen cards in Q2 backlog.

This ASCII swim-lane shows the full path from raw time evidence → Daily Digest → manager approval → data warehouse for metrics & invoices, plus the feedback loops into tomorrow’s work and continuous improvement.

—— 03 Subsystem: Daily Close-out & Hygiene/02 Procedure: Compose and send daily digest.md ——§

DraftSOP · Procedure · DC-SOP-2 — Compose & Send Daily Digest · 2025-05-15-r1§

First formal draft. Builds on subsystem r3, folds in the brainstormed template, GPT prompt, follow-up rule and risk controls.


Big-Picture Overview§

Block Content
Purpose & Scope Convert the raw time-evidence gathered in DC-SOP-1 into a three-minute, manager-ready Telegram message that also surfaces the operator’s daily reflections and mood.

Outputs:
1️⃣ Digest message (Markdown) in /manager chat.
2️⃣ Daily Hygiene Trello card moved to Waiting for Approval with all artefacts attached.
Trigger / Owner Operator immediately after finishing Daily Evidence Export (≈ 16 : 55 local, every work-day).
Up-stream Inputs • Clockify “Today” CSV link
• Insightful productivity-% screenshot (30 -sec shots, idle guard 1 / 5 min)
• Eisenhower Q1/Q2/Q3 PNG
DailyReport Sheet row link & Exceptions Y/N flag
• (Optional) Channel-Ops report link or card
Tools Trello Daily Hygiene card · Google Sheet DailyReport · Clockify · Insightful · Telegram /manager chat · GPT prompt /daily-digest
KPIs Hygiene evidence posted by 17 : 00 (100 %) · Manager reaction ≤ 24 h (100 %) · Digest readable in ≤ 3 min · Mood-score reported daily
Risks (ISO 31000) Evidence / Digest missing → unpaid time · Broken links · Challenges not surfaced · Approval delay blocks next-day work
Controls • GPT /tip daily-digest checklist before send
• If Mood ≤ 2 or Insightful % < 60 → add 🔴Low-Productivity tag
• Telegram late-Digest bot reminder (open question)

Digest Template & GPT Prompt (/daily-digest)§

🗓️ {{date}} — Daily Digest ({{operator}})

⏱ Clockify CSV: {{csv-link}}
📊 Insightful %: {{productive-percent}}
📈 Eisenhower: {{eisenhower-link}}
📑 DailyReport: {{sheet-link}}  (Exceptions: {{Y/N}})
📣 Channel reports: {{channel-status}}

W↑ What went well
• …

C↓ Challenges / blockers
• …

T→ Plan for tomorrow
• …

M Mood-score 1–5: {{mood}}

(Operators may ask the Coach in creative mode: “👉 Fill today’s digest with a friendly tone, keep under 120 words.”)


Detailed SOP — Digest Loop (7 steps)§

# Action & Owner Key points / Controls
1 Open GPT prompt /daily-digest (or Markdown snippet). Prompt auto-inserts date & operator name.
2 Paste evidence links (CSV, % PNG, Eisenhower, Sheet). Verify links work in incognito tab.
3 Complete reflection fields W↑ / C↓ / T→ / M. If Exceptions Y explain briefly in C↓.
4 Run /tip daily-digest & fix any ❌ items. Ensures length ≤ 120 words & no PII.
5 Send digest in /manager Telegram. Copy Markdown directly for clean formatting.
6 Attach artefacts to Daily Hygiene card → move card to Waiting for Approval. Tag card 🔴Low-Productivity if Mood ≤ 2 or Insightful % < 60 %.
7 Follow-up loop – ping manager after 12 h if no reaction; no new work next day until ✅/❌. Record ping as reply to original Telegram thread.

SLA — Digest sent & card moved by 17 : 00; manager must react within 24 h.


WGLL (What Great Looks Like)§

❌ Miss ✅ Meets (baseline) ⭐ Exceeds
Digest late or unreadable (> 180 words) Digest ≤ 120 words, clear bullets, all links valid Adds short “One insight” line & a 20-word thank-you to team; no follow-up needed
Mood missing Mood 1–5 provided Includes one concrete self-care plan if Mood ≤ 3
Challenges unflagged Challenges listed, blockers labelled 🔴 where relevant Challenge auto-converted to Trello Blocker card with link in Digest

ArchitectureSnapshot (JSON) – r1§

{
  "version_id": "2025-05-15-r1",
  "system_level": "Procedure",
  "lifecycle_state": "DraftSOP",
  "target_name": "DC-SOP-2 – Compose & Send Daily Digest",
  "parent_name": "Daily Close-out & Hygiene Report",
  "last_updated": "2025-05-15T01:05:00Z",

  "overview": {
    "purpose": "Transform daily evidence and reflections into a concise Telegram Digest, attach artefacts, and secure manager approval.",
    "flow": [
      "16:55 open /daily-digest GPT template",
      "Paste Clockify CSV, Insightful %, Eisenhower PNG, DailyReport link, Channel report",
      "Fill W↑ C↓ T→ M fields; run /tip checklist",
      "Send Digest in /manager chat",
      "Attach artefacts to Daily Hygiene card and move to Waiting for Approval",
      "Follow up until manager reacts ✅/❌; no next-day work without approval"
    ],
    "roles": ["Freelancer Operator","Ops Manager","Systems-Ops Lead","GPT Assistant"],
    "kpis": [
      "Digest sent by 17:00",
      "Manager reaction within 24h",
      "Digest ≤3-min read",
      "Mood-score captured daily"
    ],
    "tools": [
      "Trello Daily Hygiene card",
      "Google Sheet DailyReport",
      "Clockify",
      "Insightful",
      "Telegram",
      "GPT /daily-digest prompt"
    ],
    "risks": [
      "Missing digest or artefacts",
      "Broken links",
      "Challenges hidden",
      "Approval delay"
    ],
    "controls": [
      "GPT /tip checklist before send",
      "Low-Productivity flag if Mood≤2 or Insightful<60%",
      "Telegram late-Digest reminder (TBD)"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-03_Daily_Digest_v0.1.md"
  },

  "procedure_core": {
    "procedure_id": "DC-SOP-2",
    "name": "Compose & Send Daily Digest",
    "purpose": "Daily wrap-up message plus artefact attachment and approval loop.",
    "trigger": "After completing Daily Evidence Export, every work-day ~16:55.",
    "inputs": [
      "Clockify Today CSV link",
      "Insightful % screenshot",
      "Eisenhower grid PNG",
      "DailyReport Sheet row link",
      "Exceptions flag",
      "GPT daily-digest prompt"
    ],
    "responsible_role": "Freelancer Operator",
    "steps": [
      "Open GPT /daily-digest template",
      "Insert evidence links & data",
      "Fill reflection fields W↑ C↓ T→ M",
      "Run /tip daily-digest checklist and correct issues",
      "Send digest in /manager Telegram",
      "Attach artefacts to Daily Hygiene card and move to Waiting for Approval",
      "Ping manager if no reaction after 12h; halt new work until approved"
    ],
    "outputs": [
      "Digest message in /manager chat",
      "Daily Hygiene card with artefacts",
      "Manager ✅/❌ reaction"
    ],
    "sla": "Digest sent by 17:00; manager approval within 24h.",
    "controls": [
      "Checklist enforcement",
      "Low-Productivity tag",
      "Telegram reminder (future)"
    ],
    "tools": [
      "GPT chat",
      "Telegram",
      "Trello",
      "Clockify",
      "Insightful",
      "Google Sheets"
    ],
    "kpis": [
      "Digest on-time rate",
      "Approval SLA hit rate"
    ],
    "risks": [
      "Unpaid day due to missing digest",
      "Manager blind spots",
      "Evidence link rot"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-03_Daily_Digest_v0.1.md"
  },

  "insights": [
    { "note": "Added mood-score & Low-Productivity auto-flag to surface wellbeing.", "date": "2025-05-15" }
  ],

  "children": []
}

End of DC-SOP-2 v0.1

—— 04 Subsystem: Rituals & Invoicing/00 Subsystem: Rituals And Invoicing.md ——§

DraftSOP · Subsystem · 2025-05-14-r3§

Target System — Weekly / Monthly Rituals & Invoicing**

(supersedes r2; purpose expanded to include operator wellbeing & continuous-improvement)


Big-Picture Overview§

Block Content
Purpose & Scope 1) Package proof-of-work → invoice → payout on a predictable cadence and 2) sustain the well-being & growth of every freelancer through a lightweight Friday Mini-Retro & Kaizen loop.
Result: managers approve in minutes; operators get paid on time and have a clear channel to voice challenges and suggest process tweaks.
Map / Flow Fri 16 : 45 export WeekMetrics CSV → GPT /weekly-metrics → attach PDF to Trello Weekly Metrics card ⮕ Telegram /manager.
Fri 17 : 00 Mini-Retro note (Keep / Stop / Start) + promote one Kaizen card.
Fri 17 : 05 /invoice-draft prompt fills Invoice-Template → save PDF → new Invoice card ⮕ Telegram ping.
Mon EOD manager reacts ✅/❌.
Tue bulk PayPal payout; paste TxID in card + PDF footer.
Roles Freelancer Operator · Ops Manager · Finance Admin · Systems-Ops Lead · GPT Assistant
RACI Snapshot R Operator · A Manager · C Systems-Ops & Finance · I GPT
KPIs WeekMetrics PDF sent 100 % Fri 16:45 · Invoice PDF sent 100 % Fri 17:05 · Manager approval ≤ Mon EOD · PayPal payout ≤ Tue EOD (bi-weekly) · Invoice error rate < 1 % · ≥ 1 Kaizen promoted weekly
Tools Clockify CSV · Insightful PNG · WeekMetrics Sheet · GPT prompts (/weekly-metrics, /invoice-draft, /retro) · Google Docs Invoice-Template · Trello cards (Weekly Metrics, Mini-Retro, Invoice) · Telegram
Risks (ISO 31000) Missed export → unpaid work · Wrong date range / project tag · Manager forgets approval → payout delay · TxID not logged → audit gap · Kaizen ideas lost → stagnation · Operator burnout signal missed
Open Questions Add Monday 09 : 00 bot reminder if invoice still un-approved?
Next Action Draft RI-SOP-1…4; pilot one full cycle and survey operator stress & manager workload.

Detailed SOPs (to be authored)§

ID Procedure Status / Notes
RI-SOP-1 Weekly Metrics Snapshot (CSV → PDF) stub
RI-SOP-2 Mini-Retro & Kaizen Promotion (well-being) stub
RI-SOP-3 Invoice Generation & Manager Approval stub
RI-SOP-4 Bi-Weekly Payout & TxID Trail stub

(Apps Script removed; GPT prompts replace scripting.)


ArchitectureSnapshot JSON§

{
  "version_id": "2025-05-14-r3",
  "system_level": "Subsystem",
  "lifecycle_state": "DraftSOP",
  "target_name": "Weekly / Monthly Rituals & Invoicing",
  "parent_name": "Personal Management OS for Freelancers",
  "last_updated": "2025-05-14T22:15:00Z",

  "overview": {
    "purpose": "Bundle weekly proof-of-work, operator wellbeing check-ins and bi-weekly payouts into one streamlined loop.",
    "flow": [
      "Friday 16:45 export WeekMetrics CSV; GPT /weekly-metrics → PDF → Trello Weekly Metrics card → Telegram /manager",
      "Friday 17:00 Mini-Retro (Keep/Stop/Start) & promote one Kaizen card",
      "Friday 17:05 GPT /invoice-draft fills template → PDF → Invoice card → Telegram ping",
      "Monday EOD manager approves (✅) or rejects (❌)",
      "Tuesday bi-weekly PayPal bulk payout; TxID pasted in card + PDF"
    ],
    "roles": [
      "Freelancer Operator",
      "Ops Manager",
      "Finance Admin",
      "Systems-Ops Lead",
      "GPT Assistant"
    ],
    "kpis": [
      "WeekMetrics PDF sent on time 100%",
      "Invoice PDF sent on time 100%",
      "Manager approval by Monday EOD 100%",
      "Payout executed by Tuesday EOD 100%",
      "Invoice error rate <1%",
      "≥1 Kaizen promoted weekly"
    ],
    "tools": [
      "Clockify CSV export",
      "Insightful PNG",
      "WeekMetrics Google Sheet",
      "GPT prompt set",
      "Google Docs Invoice Template",
      "Trello",
      "Telegram"
    ],
    "risks": [
      "Missed exports cause unpaid work",
      "Incorrect CSV range or tags",
      "Approval delay blocks payout",
      "TxID not logged for audit",
      "Kaizen loop ignored",
      "Burnout signals missed"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-04_Rituals-Invoicing_v1.1.1.gdoc"
  },

  "children": [
    { "system_level": "Procedure", "target_name": "Weekly Metrics Snapshot",    "version_id": "RI-SOP-1-TBD" },
    { "system_level": "Procedure", "target_name": "Mini-Retro & Kaizen Promotion", "version_id": "RI-SOP-2-TBD" },
    { "system_level": "Procedure", "target_name": "Invoice Generation & Approval", "version_id": "RI-SOP-3-TBD" },
    { "system_level": "Procedure", "target_name": "Bi-Weekly Payout & TxID Trail", "version_id": "RI-SOP-4-TBD" }
  ]
}

End of Subsystem r3

Below is a simple ASCII timeline that shows how the “Weekly / Monthly Rituals & Invoicing” subsystem stitches together its four procedures and touches the other subsystems.

(Feel free to paste it into Miro/Docs and tweak alignment or colours.)

┌───────────────────────────────  Time-Tracking & Proof  ────────────────────────────────┐
│  Clockify CSV ▸ Insightful PNG ▸ WeekMetrics Sheet  (live all week)                    │
└─────────────────────────────────────────────────────────────────────────────────────────┘
          │
          │  (Fri 16:45)  ┌──────────────────────────────────────────────────┐
          └──────────────►│  RI-SOP-1  Weekly Metrics Snapshot               │
                          │ • /weekly-metrics  ⇒ PDF                         │
                          │ • Trello “Weekly Metrics” card  ➜ Telegram ping  │
                          └──────────────────────────────────────────────────┘
                                      │
                                      │  (input for Mini-Retro reflection)
                                      ▼
                           ┌──────────────────────────────────────────┐
                           │  RI-SOP-2  Mini-Retro & Kaizen Promotion │
                           │ • K/S/S note in Miro                     │
                           │ • Promote 1 Kaizen → Q2 To Do (🔵)       │
                           └──────────────────────────────────────────┘
                                      │
               (Fri 17:05)            │
        ┌─────────────────────────────┴──────────────────────────┐
        │  RI-SOP-3  Invoice Generation & Manager Approval       │
        │ • /invoice-draft  ⇒ PDF                                │
        │ • Trello Invoice card  ➜ Telegram ping                 │
        └────────────────────────────────────────────────────────┘
                                      │
               (Mon EOD ✅/❌)         │
                                      ▼
                      ┌─────────────────────────────────────────┐
                      │   RI-SOP-4  Bi-Weekly Payout & TxID     │
                      │   • Bulk pay  (PayPal / Wise / Crypto)  │
                      │   • Paste TxID in card + PDF            │
                      │   • Ledger row  + operator confirms     │
                      └─────────────────────────────────────────┘
                                      │
                                      │      (Tue EOD SLA met)
                                      ▼
┌───────────────────────────────  Finance / Admin ledger  ───────────────────────────────┐
│ Immutable entry: date · operator · amount · currency · TxID · processor · FX rate      │
└─────────────────────────────────────────────────────────────────────────────────────────┘

Legend§

  • RI-SOP-1 … RI-SOP-4 = the four procedures defined inside the subsystem
  • Solid arrows ► = primary hand-off of artefacts / actions
  • Grey boxes = neighbouring subsystems that feed data in (top) or receive data out (bottom)

Key integrations you can see at a glance:

  • Inbound from Time-Tracking & Proof → raw Clockify / Insightful data that fuels WeekMetrics.
  • Outbound to Finance / Admin → final TxID trail in the master ledger.
  • Every Friday flow stays inside Trello + Telegram; Monday/Tuesday close the financial loop.

This diagram matches Subsystem 2025-05-14-r3 exactly (no new logic added).

—— 04 Subsystem: Rituals & Invoicing/RI-SOP-1 - Weekly Metrics Snapshot (CSV → PDF).md ——§

DraftSOP · Procedure · RI-SOP-1 — Weekly Metrics Snapshot (CSV → PDF) · 2025-05-14-r0§


Big-Picture Overview§

Block Content
Purpose & Scope Produce a one-page PDF every Friday that summarises the week’s effort (hours, productivity %, Q1/Q2 throughput, exception count) so managers can approve pay and spot trends in < 1 minute.
Map / Flow 16 : 45 Card-Repeater spawns Weekly Metrics card → open WeekMetrics tab (Google Sheet) → review formulas & dates → File ▸ Download ▸ PDF (portrait, 1 page) → save in Drive 02-OPERATIONS/Reports_Archive → attach PDF to Trello card → /sendDocument in /manager Telegram → manager reviews by Mon 09 : 15.
Roles / RACI Freelancer Operator R · Ops Manager A · Systems-Ops Lead C · GPT Assistant I
KPIs 100 % packets sent Friday < 17 : 10 · Packet review Monday ≤ 09 : 15 · Exceptions acknowledged 100 %
Tools Google Sheets (DailyReport → WeekMetrics) · Trello · Clockify CSV archive · Insightful dashboard · Telegram
Risks (ISO 31000) Wrong date range · Missing Insightful % graph · Exceptions column not cleared · PDF not attached
Open Question Add auto-reminder if packet not posted by 17 : 15?
Next Action Pilot one Friday with live data; verify manager can approve in < 1 min.

Detailed SOP — Weekly Metrics Snapshot (≤ 7 bullets)§

# Step & Owner Key Points / Controls
1 16 : 45 – Card Spawns (Trello Card Repeater) Weekly Metrics card appears in Hygiene list.
2 Open WeekMetrics tab – Operator Sheet auto-aggregates Monday→Friday DailyReport rows → check totals & dates.
3 Embed Insightful graph – Operator In Sheet cell B2, Insert ▸ Image ▸ Image in cell → paste weekly productivity-% screenshot (manual, no script).
4 Export PDF – Operator File ▸ Download ▸ PDF, setting: Portrait · one page · fit to width → filename WM_<YYYY-WW>.pdf.
5 Save & Attach – Operator Store PDF in 02-OPERATIONS/Reports_Archive/<year>; attach to Trello card.
6 Send Packet – Operator Telegram /sendDocument with PDF + message:
Weekly Packet YYYY-WW • Hours: {{total}} • Prod%: {{avg%}} • Q1:{{q1}} Q2:{{q2}} • Exceptions: {{ex}}
7 Manager Review – Manager By Mon 09 : 15 react ✅ (approve) or ❌ (comment fixes). Operator addresses ❌ and re-sends.

SLA — Packet posted by 17 : 10 Friday; manager approval ≤ Mon 09 : 15.


WGLL (“What Great Looks Like” Snapshot)§

Criterion ❌ Miss ✅ Meets ⭐ Exceeds
Packet timing After 17 : 10 Fri 16 : 45–17 : 10 Fri ≤ 16 : 50 Fri
PDF clarity >1 page, small fonts 1 page, legible 1 page + coloured KPI bars
Exceptions Not listed Count + link Count + resolved note
Manager effort Needs questions Approves in 1 min “Perfect, thanks” emoji

(Full exemplars live in Drive → 01-SYSTEMS/WGLL_Gallery.)


ArchitectureSnapshot JSON§

{
  "version_id": "2025-05-14-r0",
  "system_level": "Procedure",
  "lifecycle_state": "DraftSOP",
  "target_name": "RI-SOP-1 – Weekly Metrics Snapshot",
  "parent_name": "Rituals & Invoicing",
  "last_updated": "2025-05-14T22:05:00Z",
  "overview": {
    "purpose": "Generate a one-page weekly PDF that summarises hours, productivity and throughput for manager approval.",
    "flow": [
      "16:45 Card-Repeater spawns Weekly Metrics card",
      "Open WeekMetrics tab and verify totals",
      "Insert Insightful productivity-% screenshot manually",
      "Export PDF (portrait, 1 page) and save in Reports_Archive",
      "Attach PDF to Trello card and send /manager Telegram message",
      "Manager approves by Monday 09:15 or requests fixes"
    ],
    "roles": ["Freelancer Operator", "Ops Manager", "Systems-Ops Lead", "GPT Assistant"],
    "kpis": [
      "100% packets sent Friday <17:10",
      "Manager review ≤ Mon 09:15",
      "Exceptions acknowledged 100%"
    ],
    "tools": [
      "Google Sheets (DailyReport & WeekMetrics)",
      "Trello",
      "Clockify CSV archive",
      "Insightful dashboard",
      "Telegram"
    ],
    "risks": [
      "Wrong date range selected when exporting",
      "Missing or blurry Insightful graph",
      "Exceptions column ignored",
      "PDF not attached or wrong channel"
    ],
    "controls": [
      "Operator cross-checks Monday & Friday dates in WeekMetrics",
      "Manual screenshot ensures no automation gap",
      "Trello card cannot move to Waiting for Approval without attachment (Butler rule pending)",
      "Manager SLA reminder every Monday 08:30 (Telegram bot idea)"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-04_Weekly_Metrics_Snapshot_v0.1.gdoc"
  },
  "procedure_core": {
    "procedure_id": "RI-SOP-1",
    "name": "Weekly Metrics Snapshot",
    "purpose": "Compile and deliver the weekly KPI PDF for rapid managerial approval.",
    "trigger": "Every Friday at 16:45 local (Card Repeater).",
    "inputs": [
      "WeekMetrics tab (auto-aggregated)",
      "Insightful productivity-% screenshot",
      "Trello Weekly Metrics card"
    ],
    "responsible_role": "Freelancer Operator",
    "steps": [
      "Open WeekMetrics tab and confirm date range",
      "Insert Insightful productivity-% screenshot in cell B2",
      "File > Download > PDF (portrait, one page)",
      "Save PDF in Reports_Archive and attach to Trello card",
      "Send Telegram /sendDocument message with KPI summary",
      "Await manager ✅/❌ and resolve if needed"
    ],
    "outputs": [
      "Weekly Packet PDF in Drive & Trello",
      "Telegram message with summary"
    ],
    "sla": "Packet posted by 17:10 Friday; manager approves by Monday 09:15.",
    "controls": [
      "Weekly self-check list on Trello card",
      "Manager spot-checks Exceptions tab"
    ],
    "tools": [
      "Google Sheets",
      "Trello",
      "Telegram"
    ],
    "kpis": [
      "Packet on time",
      "Manager approval on time",
      "Exceptions acknowledged"
    ],
    "risks": [
      "Late packet",
      "Data mismatch",
      "Missing attachment"
    ],
    "doc_link": "Drive:/01-SYSTEMS/Personal-OS/SOP-04_Weekly_Metrics_Snapshot_v0.1.gdoc"
  },
  "children": []
}

End of RI-SOP-1 (r0)