In practice
A practical explanation of what the system looks like in day-to-day use — from the administrator's perspective and from each participant's point of view.
The basic concept
The system is designed around a single administrator — typically a member of the group who takes on the record-keeping role. This person is responsible for entering contributions as they happen, running the monthly reconciliation, and distributing status reports to the rest of the group.
Participants interact with the system primarily through the status dashboard, which gives them a clear view of their own position without requiring them to understand the underlying spreadsheet structure.
Two roles, two experiences
System at a glance
| Item | Tracked by the system | Outside system scope |
|---|---|---|
| Contribution amounts per participant | ||
| Contribution dates | ||
| Equity percentage per participant | ||
| Currency (ARS / USD) | ||
| Monthly reconciliation status | ||
| Movement of funds between accounts | ||
| Investment decisions or project selection | ||
| Legal or tax obligations | ||
| Custody or safekeeping of funds |
The monthly cycle
As participants make transfers during the month, the administrator enters each one into the spreadsheet. The system recalculates percentages automatically with each entry.
The administrator follows the reconciliation protocol: reviewing all entries, cross-referencing against actual transfers, and documenting any discrepancies found.
A monthly summary showing each participant's balance and percentage is distributed to the group. Participants can verify their own figures against what they know they've contributed.
The closed month's records are archived according to the system's structure, creating a clean, organized history that can be referenced at any future point.