Investment Fund Subaccounting for Nonprofits: Moving Beyond Spreadsheets
‍

The Challenge

Many nonprofits manage multiple funds or endowments within a single investment portfolio. Whether it’s donor-restricted funds, board-designated reserves, or quasi-endowments, the challenge is the same:

How do you fairly track each fund’s share of the overall portfolio?

For many organizations, the answer has been spreadsheets.

The Spreadsheet Reality

Many nonprofits rely on spreadsheets to track funds within an investment pool and for good reason. They are flexible, familiar, and easy to implement, particularly for organizations managing a smaller number of funds.

But as complexity grows and organization leaders turn over, spreadsheets can become more difficult to maintain with confidence.

Common challenges:

• Manual inputs increase the risk of errors
• Version control becomes harder across teams
• Calculations grow more complex as contributions and withdrawals increase
• Tracking performance across multiple funds becomes time-intensive
• Preparing reports for donors, committees, boards, or auditors requires additional effort
  ‍

What works well for a handful of funds can quickly become difficult to maintain, signaling that it’s time for a more structured approach.

A Better Way: Investment Fund Subaccounting (Unitized Accounting)

Subaccounting or unitized accounting is a method used to track individual funds within a pooled investment portfolio. Each fund owns a portion of that pool, represented by “units,” similar to shares in a mutual fund.

How It Works

• Each fund holds a number of units in the pool
• Unit values change based on portfolio performance
• Contributions purchase new units
• Withdrawals redeem units

This allows multiple funds to participate in a single investment portfolio while still maintaining separate ownership and reporting.

‍

Sample Illustration

A nonprofit has three funds invested in a single portfolio:

‍

‍

Each fund owns units in the pool based on the value of its investment. As the investment pool changes in value, the unit value changes as well.

‍

The Pool Grows Through Investment Gains

If the portfolio grows by 10%, the unit value increases from $10.00 to $11.00:

Each fund participates proportionally in the portfolio’s performance based on the number of units it owns.

‍

When a Contribution is Made to a Fund

Assume there is a $10,000 contribution made to the Endowment Fund during the month.

The Endowment Fund purchases additional units at the month end value of $11:

• New units purchased = 909.09 ($10,000 ÷ $11.00)
• Fund B’s total units increase from 30,000.00 → 30,909.09

‍

Updated Pool After Contribution

The Subaccounting Advantage

A structured approach to subaccounting helps nonprofits:

• Maintain a single investment pool for similar funds to reduce multiple custodial accounts
• Track contributions and withdrawals systematically, without manual calculations
• Allocate returns fairly across all funds
• Provide transparency and confidence to boards, donors, and auditors
• Protect institutional history through organization leadership and staff turnover

‍

A More Integrated Approach

As part of our nonprofit investment services, we offer a subaccounting feature that allows organizations to move away from spreadsheets and track underlying funds within a pooled investment portfolio.

‍

‍

When Spreadsheets Are No Longer Enough

Subaccounting is an important function for nonprofits managing multiple funds within a single portfolio. While spreadsheets can serve as a starting point, they often become difficult to maintain as organizations grow.

Embracing a structured subaccounting framework allows organizations to anchor their financial operations across three critical pillars.

• Accuracy: Eliminate manual calculation errors in legacy spreadsheets
• Governance: Provide transparent reporting for boards and donors
• Efficiency: Effortlessly manage allocations for many individual fundst

FAQs

1. What is subaccounting for nonprofit investment funds?

Subaccounting, or unitized accounting, is a method used to track individual funds within a pooled investment portfolio by assigning each fund ownership units that fluctuate in value based on portfolio performance.

2. Why do nonprofits move beyond spreadsheets for fund tracking?

As organizations manage more funds and transactions, spreadsheets can become difficult to maintain accurately due to manual calculations, version control issues, and increasingly complex reporting requirements.

3. What are the benefits of unitized accounting?

Unitized accounting helps nonprofits allocate returns fairly, automate contributions and withdrawals, improve fund-level reporting, reduce administrative effort, and strengthen transparency for boards, donors, and auditors.