The Spreadsheet That Killed Friendships
I know a community in southern France that tried to track sweat equity for two years and almost fell apart over it. They had a 14-column spreadsheet. Every shared task got logged with a time stamp, a category, and a complexity rating. Three people did most of the logging. Four people quietly stopped logging anything. Two left the community.
The spreadsheet was designed to make things fair. It made them weird. There's a lesson in that.
Tracking sweat equity in a community is necessary and dangerous. Necessary because unequal effort breeds resentment. Dangerous because the wrong tracking system breeds something worse: the constant, low-grade feeling that you're being audited by your friends.
This piece is about getting the balance right.
What Sweat Equity Actually Is
Sweat equity is the labor and care a member contributes to the community that doesn't show up as money. Hours building a chicken coop. Months coordinating the kitchen. The Saturday spent fixing the well pump.
In most intentional communities, sweat equity matters because:
- Some members can pay more, others can contribute more time. The balance has to work.
- Big projects (a new common house, a refurbished barn) require labor that nobody is paying market rate for.
- When someone leaves, there's a question of what their contribution was worth.
Ignore it and the people doing the work burn out silently. Track it badly and the people doing the work feel surveilled. Both are bad outcomes.
The First Question: What Is the Tracking For?
Before you build any system, get crystal clear on what the data is for. Three legitimate purposes:
1. Visibility. Make invisible labor visible so the community can see and appreciate it. 2. Equity at exit. When someone leaves, calculate a fair payout for what they put in. 3. Pattern detection. Notice when one person is doing 70% of a category and rebalance.
Three purposes. If you find yourself tracking sweat equity for any other reason ("to make sure people are pulling their weight," "so we can rank members"), stop. You've drifted into surveillance.
We made this mistake for about eight months in our first year. The spreadsheet existed. Nobody knew exactly what it was for. People logged things defensively. The vibe shifted. We rebuilt the system around the three purposes above and the weight in the room lifted.
The Three Tier Model That Works
After watching about a dozen communities try this, the systems that survive use three tiers of effort, deliberately blurry.
Tier 1: Routine chores. Cooking, cleaning, garden maintenance. Tracked through your Rhythm rotation. Not logged as sweat equity. The rotation itself is the accountability.
Tier 2: Project work. Building, repair, renovation, event planning. Logged in hours, not minutes. Estimated, not stopwatched.
Tier 3: Stewardship. Coordinating, mediating, holding the email account, answering the door. Acknowledged in a quarterly review.
Mixing the tiers is what kills systems. The moment someone tries to log "rinsed three plates" as sweat equity, you're done.
Estimate, Don't Stopwatch
Hours worked, rounded to the nearest half hour, logged at the end of the day or end of the week. That's it. No stopwatch. No "I started at 14:23." If you can't trust your community to honestly estimate that they spent three hours fixing the gate, you have a trust problem the spreadsheet won't solve.
In our Sanctuary, we use the Ledger to log Contributions. Most look like:
- "Built compost bin enclosure": 6 hours
- "Mediated kitchen conflict": 2 hours
- "Sourced and hauled gravel": 4 hours
Categories are loose. Five tags total: Build, Steward, Coordinate, Repair, Other. Nothing more granular. Granularity is the enemy.
Make It Voluntary, Make It Visible
The number one rule of sweat equity tracking: it has to be voluntary, and the data has to be visible to everyone.
Voluntary because mandatory tracking turns friends into employees. Visible because invisible tracking turns the steward into a judge.
In practice, this means: anyone can log anything, anytime. Anyone can see anyone's log. Once a quarter, we generate a simple report (total hours by member, total hours by category) and look at it together for thirty minutes. That's the entire ceremony.
About 70% of our members log regularly. 20% log sporadically. 10% never log. We don't pressure the non-loggers. Their contributions show up in conversation, in chore rotations, in the quality of meals. The Ledger is a tool, not a tax.
Convert to Money Carefully (Or Not At All)
The most dangerous step is assigning a monetary value to sweat equity hours. Once you do this, you've created a parallel currency, and parallel currencies have a way of poisoning relationships.
If you must (say, for an exit calculation), use a single low rate (€10 to €15 per hour in most of Europe), apply it only to Tier 2 and 3 work, and cap the total at something reasonable. Never use real market rates ("a carpenter would charge €60 an hour, so Maya is owed €X").
Better: don't convert it to money at all. Use it for narrative. "In the last five years, Maya put in roughly 800 hours on building projects. When she leaves, we'd like to honor that with a 4-week paid sabbatical and a 5% discount on her next-year membership." That kind of thing. Specific, generous, not algorithmic.
The Conversation You Have to Have Once a Year
Once a year, every member sits down with one other member for thirty minutes. They look at each other's Contribution log. They ask: "Does this feel right? What's missing? What feels heavy?"
This is the only quality control the system needs. Patterns surface. Resentments get named gently. The annual conversation does what no spreadsheet can.
We started this practice in 2022. It has caught roughly six situations where someone was burning out invisibly and four where someone felt unseen. Each one led to a small, real adjustment.
When People Stop Contributing
Sometimes a member contributes less for a season. Illness. A new baby. A job change. A breakup. The sweat equity log will show it before anyone says anything.
The right response: gentle check-in, no confrontation. "I noticed you've been on lighter duty lately. How are you doing?" Avoid: "You haven't logged in three weeks." The second framing makes the system feel like a panopticon.
If the pattern continues for six months, it becomes a Council conversation. Maybe their needs have changed. Maybe they should be on a reduced membership. Maybe they should leave. The data informs the conversation. The data does not replace the conversation.
The System Should Disappear
A good sweat equity tracking system is mostly invisible most of the time. People log things in 30 seconds at the end of the day. Reports get generated automatically. The data shows up at quarterly reviews and annual check-ins, and otherwise lives quietly in the background.
If your members are thinking about the system more than once a week, it's too heavy. Lighten it.
We run this through ARA's Ledger. Logging a Contribution takes fifteen seconds. The monthly report builds itself. Most of our members forget the system exists for weeks at a stretch, which is the highest compliment you can pay a tracking tool.
The whole point is a community where people feel seen for what they put in, where unfair patterns get noticed, and where the books balance gently when someone leaves. Tracking sweat equity exists to reduce drama. If yours is generating drama, redesign.
A spreadsheet won't save your friendships. A friend who occasionally checks the spreadsheet with you, over coffee, will.