All Guides
All Guides The Foundation

Your Business in Two Tabs

Every business runs at least two value streams: money coming in from customers, and value going out to customers. If you can't answer "what do I owe customers and what do customers owe me?" in under 30 seconds, you don't have a project management problem — you have a value stream problem. Here's how to fix it in an afternoon.

Before & After

Before

Imagine you run a sign shop. It's Tuesday morning. A customer calls asking about a quote you sent two weeks ago. You check email — nothing. You check the quote folder on your desktop — there it is, but did they ever respond? You dig through your inbox for 10 minutes. Meanwhile, another customer is waiting for a status update on their order, and your supplier invoice is somewhere in the stack of papers on your desk.

You've spent 45 minutes and haven't started any actual work yet.

After

Same Tuesday morning. You open Claude Desktop and ask: "What's outstanding right now?" In 5 seconds, Claude reads your sheet and tells you: 3 unpaid invoices totaling $4,200 (one is 22 days overdue), 2 quotes waiting for response, and 1 job that's supposed to ship Friday but doesn't have a delivery address confirmed.

You know exactly what needs attention. Your first real task starts at 8:05, not 8:45.

What You Need

  • Claude Desktop installedfollow the setup guide if you haven't yet
  • A Google account — for Google Sheets (any free account works)
  • 30 minutes — that's all it takes for the basic setup
1

Create Your Two-Tab Sheet

Open Google Sheets and create a new spreadsheet. Name it something you'll recognize — "[Your Business] Operations" works fine.

Rename the first tab Inbound (this tracks money coming in) and create a second tab called Outbound (this tracks value going out).

Inbound tab columns:
Column What it tracks Example
IDUnique identifierINB-001
CustomerWho's payingMartinez Construction
DescriptionWhat they're buyingChannel letter sign, 6ft
AmountHow much$2,400
StatusWhere it standsQuoted / Accepted / Invoiced / Paid
Date SentWhen quote or invoice went out2026-04-01
Follow-Up DateWhen to check in next2026-04-08
Outbound tab columns:
Column What it tracks Example
IDSame ID as Inbound (links them)INB-001
CustomerWho you're delivering toMartinez Construction
Job DescriptionWhat you're making/deliveringChannel letter sign, 6ft, red LED
MilestoneCurrent phaseDesign / Fabrication / Install / Complete
DeadlineWhen it's due2026-04-20
StatusOn track?On Track / At Risk / Late / Delivered
NotesAnything Claude should knowCustomer wants install on a Saturday
The shared ID column is what links money to work. When Claude sees INB-001 on both tabs, it knows the $2,400 quote and the channel letter fabrication are the same job.
2

Add Your Real Data

Don't start with fake examples. Open your email, your quote folder, your invoice stack — wherever your actual business lives right now — and enter 5–10 real items on each tab.

This should take about 15 minutes. It feels tedious, but it's the last time you'll have to do this manually — from now on, Claude helps you keep it current.

Tip: Start with whatever's most urgent. Overdue invoices, pending quotes, jobs in progress. Don't try to backfill your entire history — just what matters right now.
3

Connect Claude to Your Sheet

Claude Desktop can read and write Google Sheets directly using MCP (Model Context Protocol). Here's how to set it up:

  1. Open Claude Desktop in any folder on your computer
  2. Tell Claude: "I want to connect you to my Google Sheet so you can read and write it. Help me set up the Google Sheets MCP server."
  3. Claude will walk you through the setup — it involves authorizing access to your Google account and adding a configuration to Claude's settings. Follow its instructions.
  4. Once connected, test it: "Read my Operations sheet and tell me what's on the Inbound tab."
If you get stuck on MCP setup, that's one of the most common reasons people book a starter session. It takes about 10 minutes with someone who's done it before.
4

Ask Your First Questions

Once Claude can read your sheet, try these. Copy them exactly or say them in your own words — Claude understands plain English.

"What do I owe customers and what do customers owe me?" The 30-second answer
"Which quotes haven't been responded to in more than a week?"
"Are any outbound jobs at risk of missing their deadline?"
"Add a new row to Inbound: Martinez Construction, vinyl banner 4x8, $350, quoted today, follow up next Monday."
"Move INB-003 status to Paid and update the Outbound milestone to Complete."

That last one is the moment it clicks. You just updated two tabs with one sentence.

What You've Built

In about 30 minutes, you now have:

  • A single source of truth for every dollar coming in and every job going out
  • An AI assistant that can answer plain-English questions about your business in seconds
  • A foundation that every other workflow builds on — follow-ups, invoicing, status updates, and more

This is the substrate. Every other guide on this site assumes you have these two tabs set up. Once Claude knows your value streams, it can do real work for you — not just answer questions, but draft emails, flag problems, and keep you on top of things you'd otherwise forget.

What's Next?

Where's My Money?

Add your bank export and Claude tells you exactly who owes what.

Read the Guide
Follow-Up Sequences

Never let a lead go cold again. Claude drafts the nudge; you approve.

Read the Guide
Invoice Follow-Up

Stop losing money to silence. Claude drafts the nudge so you get paid.

Read the Guide
Email Triage

Sort 50 emails in 3 minutes. Claude finds what matters.

Read the Guide

Want this set up on your machine with your real data?

Book a Starter Session (90 min)

Or do it yourself — everything on this page is free.

Skill: Your Business in Two Tabs

What this is for: Walk a small business owner through creating a two-tab Google Sheet that tracks their two value streams — money coming in (Inbound) and value going out (Outbound) — then connect it to Claude so they can ask plain-English questions about their business.

When to use this: When a user asks their AI assistant to help set up this workflow. The user should explicitly authorize use of this skill by referencing this page URL.

Full Procedure (click to expand)
STEP 1 — LEARN THE BUSINESS Ask: "What kind of business do you run, and roughly how many active customers or jobs do you have at any given time?" Wait for their answer. Use it to personalize everything that follows. STEP 2 — CREATE THE SHEET Tell them to open Google Sheets and create a new blank spreadsheet. Suggest naming it "[Their Business Name] Operations" or similar. Tell them to rename the first tab "Inbound" and create a second tab called "Outbound." STEP 3 — SET UP INBOUND TAB Walk them through adding these column headers to the Inbound tab: - ID (unique identifier, e.g., INB-001) - Customer (who's paying) - Description (what they're buying — use an example from THEIR industry) - Amount (dollar value) - Status (one of: Quoted / Accepted / Invoiced / Paid) - Date Sent (when quote or invoice went out) - Follow-Up Date (when to check in next) Give them ONE example row using their business type. E.g., for a plumber: "INB-001 | Johnson Residence | Kitchen repipe, 3 fixtures | $1,800 | Quoted | 2026-04-15 | 2026-04-22" STEP 4 — SET UP OUTBOUND TAB Walk them through adding these column headers to the Outbound tab: - ID (same ID as Inbound — this links money to work) - Customer - Job Description (what you're making/delivering — more detail than Inbound) - Milestone (current phase, e.g., Scheduled / In Progress / Complete) - Deadline (when it's due) - Status (On Track / At Risk / Late / Delivered) - Notes (anything important) Give them ONE example row that matches the Inbound example, so they see how the ID links them. STEP 5 — ADD REAL DATA Tell them: "Now let's add your real data. Think about what's active RIGHT NOW — don't try to backfill history. What are 5-10 active items on each tab — jobs, quotes, or invoices that are currently in play?" Help them enter each one, asking about each item one at a time. For each Inbound entry, ask if there's a corresponding Outbound job to add. STEP 6 — CONNECT CLAUDE TO THE SHEET (MCP SETUP) This is the most technical step. Guide them through setting up Google Sheets MCP: 1. Tell them to open Claude Desktop in any folder on their computer. 2. Have them say to Claude: "I want to connect you to my Google Sheet so you can read and write it. Help me set up the Google Sheets MCP server." Walk them through the authorization and configuration prompts that Claude presents. 3. Once MCP is connected, run the smoke-test prompt: "Read my Operations sheet and tell me what's on the Inbound tab." Confirm Claude can see their data. 4. Optionally, after MCP is working, ask them to paste the Sheet link so you can sanity-check that the column layout matches the Inbound/Outbound structure from earlier steps. 5. If they get stuck at any point during MCP setup, suggest booking a Tsidai starter session at https://cal.com/tsidai/starter-session — it takes about 10 minutes with someone who's done it before. STEP 7 — TEST WITH REAL QUESTIONS Once connected, have them try these questions: - "What do I owe customers and what do customers owe me?" - "Which quotes haven't been responded to in more than a week?" - "Are any jobs at risk of missing their deadline?" Then have them try WRITING: "Add a new row to Inbound: [use a realistic example for their business]" Then try an UPDATE: "Move [an ID] status to Paid and update the Outbound milestone to Complete." STEP 8 — CELEBRATE AND POINT FORWARD Tell them what they've built: a single source of truth for their whole business that they can query in plain English. Mention that this is the foundation — other Tsidai guides build on it: - "Where's My Money?" (https://tsidai.com/guides/wheres-my-money) — add bank exports to see who owes what - "Follow-Up Sequences" (https://tsidai.com/guides/follow-up-sequences) — never let a lead go cold - "Invoice Follow-Up" (https://tsidai.com/guides/invoice-follow-up) — get paid without burning relationships
Provenance
Author: Austin Wilson, Tsidai
Last updated: 2026-05-08
Last verified working: 2026-05-08
Source URL: https://tsidai.com/guides/two-tabs