Data Dashboard

Finance

Overall Goal

We will have the organizational culture, structure, governance, and funding that support our success.

Objectives

Increase Financial Resilience
Diversify and Grow Recurring & Renewing Revenue
Build Scalable Financial Systems

Edit notes

Key Performance Indicators

Wired KPIs

KPI Name	Current	Details	Goal 2026	Goal 2030	Trend
Reserve Funds (as Months of Operating Expense) Organization cash reserves measured by how many months of average operating expenses they could cover.	3.06Snapshot Finance entered through Jun 30, 2026; the next quarter has not been added to the finance sheet yet. As of Jun 30, 2026 · refreshed Oct 12, 4:36 PM. 102% of goal	—	3.00	6.00
Earned Income Sustaining Core % Measure of how much our core recurring revenue (dues, etc.) covers our core operating expenses.	101%2026 to date Finance entered through Jun 30, 2026; the next quarter has not been added to the finance sheet yet. As of Jun 30, 2026 · refreshed Oct 12, 4:36 PM. 106% of goal	—	95%	100%	8 Quarters
Member Revenue (Quarterly) Total revenue received from individual recurring membership dues.	TBDQuarter Prior quarter (Jul-Sep 2026) Current value unavailable. Finance entered through Jun 30, 2026; the next quarter has not been added to the finance sheet yet. Refreshed Oct 12, 4:36 PM.	—	$116,188	$137,500	12 Quarters
Member Lifetime Value (Projected) Projected total revenue a new member will contribute over their entire tenure, based on current retention rates.	$1,767Snapshot As of Oct 12, 2026, 4:36 PM. 110% of goal	—	$1,600	$2,000	n/a
Revenue vs Expense Index (per member) Ratio showing how close individual member dues are to covering the total cost per member of operating the space.	0.692026 to date Finance entered through Jun 30, 2026; the next quarter has not been added to the finance sheet yet. As of Jun 30, 2026 · refreshed Oct 12, 4:36 PM. 99% of goal	—	0.70	0.70	n/a

KPIs In Development

KPI Name	Current	Details	Goal 2026	Goal 2030	Trend
No in-development KPIs currently listed.

Annual Data (history and targets)

This table runs past the current year on purpose: it puts each KPI’s measured history next to the targets adopted for the years ahead. Years through 2025 are measured actuals, 2026 is measured but incomplete (year-to-date for some KPIs, a rolling 12-month window for others, so it will not line up with a completed year), and later years are goals from the strategic plan, not forecasts or recorded data. Cells are flagged individually because a single year can hold a measured value for one KPI and a goal for another. An “n/a” means neither an actual nor a goal exists for that year.

Actual — measured, completed year
Current — measured but incomplete year
Goal — target we are aiming at, not data

KPI Name	2023	2024	2025	2026	2027	2028	2029	2030
Reserve Funds (as Months of Operating Expense)	n/a	n/a	1.50goal	3.00goal	3.50goal	4.00goal	5.00goal	6.00goal
Earned Income Sustaining Core %	n/a	n/a	90%goal	95%goal	100%goal	100%goal	100%goal	100%goal
Member Revenue (Quarterly)	n/a	n/a	$109,149goal	$116,188goal	$120,313goal	$127,875goal	$134,063goal	$137,500goal
Member Lifetime Value (Projected)	n/a	n/a	$1,450goal	$1,600goal	$1,700goal	$1,800goal	$1,900goal	$2,000goal
Revenue vs Expense Index (per member)	n/a	n/a	0.70goal	0.70goal	0.70goal	0.70goal	0.70goal	0.70goal

KPI Calculation Notes

Reserve Funds (as Months of Operating Expense): Organization cash reserves measured by how many months of average operating expenses they could cover. Last snapshot: 2026-06-30
Earned Income Sustaining Core %: Measure of how much our core recurring revenue (dues, etc.) covers our core operating expenses. Last snapshot: 2026-06-30 Source: Google Sheets: (Total Income - Grants/Donations) / (Total Expense).
Member Revenue (Quarterly): Total revenue received from individual recurring membership dues. Last snapshot: 2026-06-30 Source: Google Sheets: Jul-Sep 2026 has not been posted to the Income-Statement tab yet.
Member Lifetime Value (Projected): Projected total revenue a new member will contribute over their entire tenure, based on current retention rates. Last snapshot: 2026-10-12 Source: Automated: Projected LTV for members in their first year (Year 0).
Revenue vs Expense Index (per member): Ratio showing how close individual member dues are to covering the total cost per member of operating the space. Last snapshot: 2026-06-30 Source: Calculated: (Monthly Dues Revenue per Head) / (Monthly Operating Expense per Head).

Key insights

Revenue mix by income stream

Quarterly revenue broken out by source so the finance team can see how the org's income is composed and how the mix is shifting over time.

Loading chart…

Data notes

Source: Income-Statement Google Sheet (rows: income_membership, income_education, income_storage, income_workspaces, income_media, income_grants, income_individual_donations, income_corporate_donations, income_total).
Processing: 8 trailing quarters; "Other earned income" = income_total minus the sum of named streams, so any line not yet broken out (event hosting, future store/lending) still shows up.
Caveat: Quarterly granularity matches the source sheet. Updates to the sheet refresh within an hour.

Revenue vs operating expense

Quarterly total revenue, total operating expense, and net surplus/deficit. Pair with the Reserve Funds KPI for runway context.

Loading chart…

Data notes

Source: Income-Statement Google Sheet (income_total, expense_total).
Processing: 8 trailing quarters; expense values are absolute (sheet stores them parenthesized/negative). Net = revenue − expense.

Monthly Recurring Revenue Trend

Aggregate by billing source to highlight sustainability of recruitment and retention efforts.

Loading chart…

Data notes

Source: Canonical member profile creation timestamps paired with recorded monthly payment values.
Processing: Includes joins within the selected six-month window and applies assumed monthly values ($50 individual, $75 family, others default to $0).
Definitions: Additional membership types require configured pricing before contributing to this model.

MRR change waterfall

Monthly recurring revenue gained from new members vs. lost to ended memberships, with net change line. Predictive companion to the MRR trend chart above.

Loading chart…

Data notes

Source: canonical profile creation timestamp, reactivation date, and end date, each paired with the per-member recorded monthly payment value. Restricted to members with a non-empty Chargebee plan so the chart matches Chargebee's MRR scope (excludes comps, founders, manually-billed members).
Processing: 12 trailing months. New joins and reactivations both add MRR; ends remove MRR. Net = joins + reactivations − ends.
Known blind spot: Plan upgrades/downgrades, pauses, resumes, and mid-tenure price changes still aren't visible here — they require monthly MRR snapshots. The makerspace_snapshot module captures these (ms_fact_revenue_snapshot table) but the historical record is mostly seed values until the cron writes a few months of real data.
Currently at risk: $232 in monthly dues from active members with failed payments (today's snapshot — not plotted on the chart). See the Retention section's intervention charts for recovery details.

Payment Method Mix

Breaks down active members by their recorded payment method.

Loading chart…

Data notes

Source: profile field_member_payment_method values on active members.
Processing: Counts the first recorded payment method per member; multi-select entries contribute once per unique value.
Notes: Historical view will replace this snapshot once plan-based snapshots become available.

Supplemental context – Additional charts and tables providing deeper context.

Payment outreach outcomes: associated annualized dues

Current recorded monthly dues × 12 for members contacted each month, grouped by outreach outcome. Positive outcomes include payment updated, will return, and no action needed; they do not establish cash collected or revenue saved.

Expand section to load chart.

Data notes

Source: member outreach records and current recorded monthly dues, annualized (× 12). Historical bars can change when recorded dues change.
Processing: Each member appears once per month. Confirmed cancellation takes priority over a positive outcome, followed by unresolved contacts. A member can appear in several months; do not sum the bars as unique savings.
Note: For per-channel and resolution-rate breakdowns of the same activity, see the intervention charts in the Retention section.

Average Recorded Monthly Payment by Membership Type

Uses recorded monthly payment fields to estimate typical recurring revenue by membership category.

Expand section to load chart.

Data notes

Source: field_member_payment_monthly on active default member profiles with status = 1.
Processing: Averages non-zero monthly payment entries per membership type; blank values are excluded.
Definitions: Provides directional signals only—reconcile against billing exports before reporting revenue.
Overall recorded average: $55.15 per month
Projected monthly revenue from recorded entries: $36,066.50

Estimated Cumulative Dues by Membership Type

Average estimated dues to date among active members, grouped by their current membership type.

Expand section to load chart.

Data notes

Source: Active member profiles with valid join dates and monthly payment values.
Calculation: (Months Active) * (Current Monthly Payment).
Note: This is an estimate based on current payment rates and does not account for past rate changes or pauses.

Lifetime Value by Tenure (Realized + Projected)

Total estimated value of members by tenure, combining what they have already paid with what they are expected to pay in the future.

Expand section to load chart.

Data notes

Data Sources: "profile__field_member_payment_monthly" (Revenue) and "profile.created" (Tenure).
Realized Value: Sum of (Months Active * Monthly Payment) for all members currently in each tenure bracket.
Projected Value: (Avg Monthly Payment) * (Projected Future Months). Future months are derived from a 3-year smoothed churn curve of all historical member tenure records.
0 Years Bucket: Represents a hypothetical new member paying the current average rate, projected using the year-0 churn rate.

Average Member Tenure by Plan Type

Comparing how long members on different billing plans have been with the organization.

Expand section to load chart.

Data notes

Source: Active users with assigned Chargebee plans.
Metric: Average number of months since "Member Join Date" for currently active members on this plan.
Interpretation: Higher values indicate plans associated with longer-term members.

Cohort LTV curves (actual)

Cumulative monthly dues paid per joiner, plotted by months since their join date, one line per quarterly cohort. A newer cohort tracking below older ones is an early signal that the projected LTV KPI is overstating future revenue.

Expand section to load chart.

Data notes

Source: canonical profile creation timestamp (or a later recorded reactivation), end date, and recorded monthly payment value.
Processing: For each member we compute tenure as (end_date or today) − join_date in whole months. Cumulative dues at month N = min(N, tenure) × monthly_value. The cohort line is the per-member average; cohort size shown in legend.
Caveat: This is an expected-collection proxy, not a payment-ledger. It assumes everyone paid their stated monthly dues for every active month — failed payments and partial collections aren't deducted. Newer cohorts naturally show shorter curves until they age into the horizon.

Chargebee Plan Distribution

Active users grouped by Chargebee plan assignment.

Expand section to load chart.

Data notes

Source: user profile field_user_chargebee_plan for published members.
Processing: Counts distinct users per plan; empty values appear as "Unassigned".
Notes: Historical view will replace this snapshot view once plan snapshots are populated.

Forward-booked workshop revenue (next 90d)

Sum of registration fees for upcoming events in the next 30 / 31–60 / 61–90 days, broken out by event type. A leading indicator of education income before it lands in the books.

Expand section to load chart.

Data notes

Source: civicrm_participant joined to civicrm_event; only counts registrations whose status type is_counted = 1 (registered/attended).
Processing: Buckets by days-until-start_date. Total forward-booked: $4,572.
Caveat: Free events with $0 fee_amount are excluded. Cancellations after registration drop out automatically (status changes flip is_counted = 0).

In development – Early or in-progress charts that are still being refined.

Grant pipeline funnel ($)

Requested grant dollars at each stage from research to decision. Pipeline stages (research → submitted) are point-in-time totals; Won/Lost sum the trailing 12 months for an apples-to-apples view of recent performance.

Expand section to load chart.

Data notes

Source: civicrm_value_funding_7 (request_amount_24, grant_status_14, date_due_21).
Counts: Researching: 8 · Inquiry: 0 · Writing: 0 · Submitted (awaiting decision): 3 · Won (last 12mo): 2 · Lost (last 12mo): 0
Caveat: Won/Lost reflect the request amount, not the awarded amount (no separate awarded-amount field exists today). Adding one would make the funnel sharper.