One pool, dozens of funds
Ask a nonprofit controller what actually keeps them up before an annual audit, and the honest answer is rarely the operating budget — that's the part of the job that gets reviewed monthly. What actually costs sleep is the endowment: one pooled investment account, statement after statement from a custodian, and underneath it dozens or hundreds of individually named funds, each governed by its own gift agreement, each with its own restriction and its own spending rate.
Under ASC 958 and the spending rules most states adopt from UPMIFA, an organization doesn't get to treat its endowment as one number. Every fund carries its own net-asset classification — with donor restrictions or without — and its own share of the pool's contributions, gains, losses and management fees, all of which has to be allocated correctly and add back up to the custodian's own statement total. A reconciliation that can't prove that isn't a bookkeeping inconvenience; it's the finding an auditor is most likely to write up first.
This page describes how the documents behind that reconciliation — investment custodian statements, gift agreements, board designation memos — are read and organized by fund into one traceable workbook, not to replace the controller's own judgment on how a specific gift gets classified, but to remove the manual re-keying step where a fund's balance most often quietly drifts from what the custodian actually shows.
Where endowment books actually break
Endowment misstatements are almost never fraud. Auditors who review nonprofit financial statements for a living will say the same thing: the overwhelming majority of findings trace back to ordinary allocation drift in a manual process, repeated across every quarter's statement until the errors add up to something material. A handful of patterns show up again and again.
Pooled gains allocated by headcount instead of by unit
A custodian statement reports one total gain for the pooled investment account, and it gets split evenly across funds instead of proportionally by each fund's actual unitized share — overstating small funds and understating large ones.
A new gift posted to the wrong fund
Two similarly named funds — a scholarship fund and a scholarship endowment fund — and a new gift gets keyed against the wrong one, leaving one fund overstated and the other understated by the same amount.
A management fee never allocated down to individual funds
The custodian charges one investment management fee against the pooled account, and it sits unallocated in the overall total instead of being assigned proportionally to every fund that benefits from the pool.
A quasi-endowment treated as permanently restricted
A board-designated fund, which the board itself can undesignate, gets classified and reported as if it carried a donor restriction it was never actually given.
An underwater fund's deficit absorbed into the wrong net-asset class
When a true endowment's fair value drops below its original gift amount, the shortfall has to be tracked and disclosed a specific way — and a manual process often just lets the fund's balance go negative without flagging it.
None of these need a dramatic explanation — they're the ordinary cost of hand-keying figures from custodian statement PDFs into a spreadsheet, fund after fund, quarter after quarter. Reading every source document the same way, with every figure traceable back to it, closes most of this gap simply by removing the re-keying step where drift creeps in.
Why this isn't a simple investment reconciliation
Reconciling a single investment account to a general ledger balance — matching a custodian statement to one account's book value — is a task most accounting software already does well. An endowment reconciliation is a different shape of problem: one pooled custodian statement covering the whole investment account has to be split correctly across every individual fund that shares it, and each fund's own ledger has to independently sum back to the same pooled total.
Multiply that splitting task across a full year — quarterly statements, new gifts arriving throughout the year, a spending distribution calculated once annually — and what looks like an afternoon's reconciliation on a handful of funds becomes a recurring exercise that's easy to fall behind on, right up until the auditor samples a fund and asks for its full history of contributions and allocated gains.
What fund-level accounting actually proves
Fund-level endowment accounting checks that every individual fund's ledger — its opening balance, new contributions, its proportional share of pooled gains, losses and fees, and any spending distribution taken — sums correctly to that fund's closing balance, and that every fund's closing balance together adds up to the custodian's own statement total for the pooled account. When both ties hold, the endowment is proven clean — not because nothing could possibly be misclassified, but because a material allocation error would almost certainly break one of the two ties.
The pooled-account-to-custodian tie is usually close to automatic — most organizations already reconcile that against the statement monthly or quarterly. What actually takes the time, and what most manual processes struggle to keep current, is the fund-level leg: proving that every individual fund's allocated share, added together, produces the exact same pooled total.
The documents a fund's balance depends on
| Document | What it contributes to a fund's ledger |
|---|---|
| Investment custodian statement | Pooled account activity — contributions, gains, losses, dividends, fees and the total market value |
| Gift agreement / endowment instrument | The donor's restriction language, the fund's purpose and any spending or invasion limits |
| Board designation memo | The resolution establishing a quasi-endowment and its terms, distinct from a donor restriction |
| Fund unitization schedule | Each fund's proportional share (in units) of the pooled investment account |
| Spending policy calculation | The annual distribution rate applied to each fund's trailing average balance |
Every one of these documents typically exists as its own PDF, generated by a different party — the investment custodian, the donor's attorney, the board secretary. Reading each one the same way, and tagging every figure to the fund it belongs to, is the actual document work behind a reconciliation that ties.
What gets read
Contribution amounts, gain and loss lines, dividend and interest income, management fees, fund names or account numbers, and closing market values are extracted from each document exactly as printed. A figure that can't be read with confidence — a stamped-over total, a smudged scan, a handwritten gift agreement amendment — is flagged rather than filled in with a best guess, so a reviewer's time goes to the handful of lines that genuinely need a second look.
How it works
Upload the period's custodian statement and any new gift agreements
For the account and the period the reconciliation needs to cover — however many funds that involves.
Each document is read on its own
Amounts, dates, fund references and restriction language extracted from each document's own layout.
Activity organized by fund
Every contribution, gain, loss and fee tagged to the fund it belongs to, ready to sum against each fund's own ledger.
Gaps and mismatches flagged, not guessed
A transaction with an unclear fund reference, or a total that doesn't foot to the custodian statement, is marked for review.
Exported
Excel, CSV or JSON, with every figure traceable back to the document it came from.
A quarter of funds, reconciled
A community foundation with a single pooled investment account uploads its quarterly custodian statement alongside two new gift agreements received that quarter, ahead of its quarterly board finance committee meeting.
| Result | Count |
|---|---|
| Custodian statement lines processed | 196 |
| Individual funds in the pooled account | 68 |
| Funds with a clean allocation tie | 65 of 68 |
| Flagged for a fund-reference confirmation | 3 funds |
The three funds that didn't tie on the first pass turn out to share one root cause — a recent name change on two similarly titled scholarship funds that the custodian's own statement hadn't yet updated — caught and corrected the same afternoon, rather than surfacing weeks later during the year-end audit.
Underwater funds and spending-policy limits
A true endowment fund is "underwater" when its current fair value has fallen below its original gift amount — a market downturn that reduces the pooled account's value can push several individual funds below their historic dollar value at once. Under current accounting standards, an underwater fund's full fair value still reports within net assets with donor restrictions, but the amount of the deficiency requires its own disclosure, along with the organization's policy on whether spending continues from an underwater fund at all.
Spending itself is governed by each fund's own gift agreement and by UPMIFA's prudence standard as adopted in your state — most organizations apply a fixed percentage, commonly in the 4–5% range, against a trailing multi-year average market value rather than the current balance, precisely to smooth distributions through a downturn. None of this is a document-reading decision; what accurate fund-level data does is make it clear, fund by fund, which ones are underwater and by how much, so that policy can be applied deliberately instead of discovered at audit time.
Manual vs. automatic
| Manual | Automatic |
|---|---|
| Custodian statement lines re-keyed against a fund list by hand | Every document read and organized automatically |
| A misallocated gift found only when the auditor samples a fund | An unclear fund reference flagged for review as it's processed |
| Gift agreement retrieval means searching a shared drive | Every figure links directly back to its source document |
| Allocation effort grows with every new fund | Same method applies regardless of how many funds exist |
From a dozen funds to several hundred
A small nonprofit with a handful of named funds can reconcile its endowment by hand, if tediously. A university foundation or community foundation running several hundred individually named funds across one pooled account turns the same exercise into a recurring job that consumes real staff time every quarter — and a single missed allocation across that volume is far easier to lose track of.
Reading and organizing each period's documentation the same way, regardless of how many funds are involved, keeps the effort per document flat as the endowment grows — what changes is only how many lines need a human look, which accurate extraction keeps small.
Who uses this
Nonprofit controllers and CFOs
A traceable, fund-level reconciliation ready before a quarterly close or a board finance committee meeting.
Community and university foundations
Custodian statements and gift agreements read and organized without a manual re-keying pass.
Independent auditors
A structured starting point instead of a stack of unrelated custodian statement and gift agreement PDFs.
Small nonprofits with a single endowment
The same fund-level rigor a large foundation's back office applies, without needing the same headcount.
Edge cases worth knowing
A gift that arrives with a pledge paid over several years — an initial cash gift followed by subsequent installment payments landing on different statements months apart — needs every installment matched back to the one fund rather than treated as unrelated contributions with no connection to the original gift agreement.
A fund that starts as donor-restricted, then has its restriction released by the donor in writing — converting it to net assets without donor restrictions mid-year — needs that reclassification tied to a specific, dated authorization rather than applied retroactively without documentation.
How this differs from general nonprofit bookkeeping
General nonprofit bookkeeping — reading bank and donation-account statements to separate restricted from unrestricted funds for board and Form 990 reporting — is a different, broader problem than endowment accounting specifically. That work covers a nonprofit's operating cash and program donations; it doesn't typically involve unitizing a pooled investment account, applying a spending-rate formula, or tracking whether a specific fund has gone underwater against its historic dollar value.
Endowment accounting is a narrower, deeper problem: the money isn't sitting in a checking account, it's invested, pooled with other funds, and governed by gift instruments that each carry their own restriction language. An organization doing both — operating cash management and endowment stewardship — typically needs both kinds of document reading, applied to two genuinely different categories of source documents.
Why fund-level evidence beats a single balance
A reconciliation that shows only the pooled custodian total, without every fund's own allocated share behind it, is easy to trust until an auditor samples five funds and asks for support. Reconstructing that support later means going back through a year — or several years — of custodian statements and gift agreements and starting over under a deadline.
Keeping the source document attached to every figure in every fund's ledger — statement date, page reference, confidence level — turns that reconstruction from a scramble into a detail already sitting in the data, ready the moment a sample request comes in.
What this doesn't do
Doesn't classify a fund's net-asset category for you
It organizes the gift agreement's language and the fund's activity clearly — applying ASC 958 to a specific gift instrument's wording is an accounting judgment that stays with your controller or CPA.
Doesn't calculate your spending-policy distribution
It surfaces each fund's trailing balance history clearly — applying your organization's specific spending-rate formula is a policy decision your finance committee owns.
Doesn't replace a fund accounting system
It's the document-reading layer many organizations use alongside their books to gather and organize supporting evidence.
Doesn't give accounting, tax or investment advice
Any question about ASC 958 classification, UPMIFA compliance or investment strategy belongs with your CPA, counsel or investment committee, not this tool.
What it does fits in one sentence: turn a period's custodian statements and gift agreements into one consistent, fund-traceable workbook, so a fund-level reconciliation doesn't have to be rebuilt from scratch every quarter — or an auditor asks for it early.
Feeding into an annual audit
A nonprofit financial statement audit typically samples a set of endowment funds and asks for the full paper trail behind each one — the gift agreement, every contribution and allocated gain, and proof the fund's ledger ties to the custodian record for the period. Every one of those documents draws on the same underlying source material this tool reads.
Building the audit response itself — assembling exactly what the auditor requested, in the format they expect — stays a step your controller or CFO typically owns. What this tool changes is how much of the underlying legwork, pulling and organizing a year's worth of endowment documentation, is already done by the time that response needs to go out. See the step-by-step classification guide for how that process fits together.
Security and privacy
Uploads are encrypted with TLS from end to end.
Processing runs on infrastructure with SOC 2-aligned controls.
Original documents are deleted shortly after processing.
Nothing you upload is ever used to train AI models.
For financial records carrying donor gift information, that matters — details are on the security page.