A person counting cash beside documents and a laptop
Finance use case · Non-profit

Restricted funds are a dimension, not a footnote

The restriction exists from the moment the gift is received. If the ledger only learns about it in the disclosure note, the control is a reconstruction.

Key Takeaways
  • Donor restrictions attach to funds when they are received and govern what the money can be spent on afterwards.
  • Tracking restriction as a ledger dimension makes the balance available continuously rather than reconstructed for the disclosure note.
  • Release from restriction depends on satisfying purpose or time conditions, which is a transaction level event rather than an annual adjustment.
  • Overspending a restriction is a stewardship failure that is usually discovered after the fact, when it cannot be corrected.
  • The same dimension supports grant reporting, so the effort is shared across two obligations.

Fund accounting is often described as a reporting requirement. Two categories in the statements, a note explaining the composition, and a release schedule prepared at year end.

That description gets the sequence backwards. The restriction is a condition attached to money at the point it arrives, and every subsequent spending decision either respects it or does not.

If the ledger only learns about the restriction at reporting time, then compliance with it is a reconstruction rather than a control.

Fund AccountingRestricted FundsNon-profitDimensionsReporting
01

What the restriction actually governs

A donor restriction limits how funds may be used, either to a purpose, to a time period or to both. It is a condition on the gift rather than a preference expressed by the donor.

Satisfying the restriction releases the funds, which is an event tied to expenditure or to the passage of time rather than to a reporting date. The indirect cost element of that expenditure follows the same logic, which is why the election described in claiming the de minimis rate should be applied consistently across restricted and unrestricted work.

Tracking that at transaction level means every expenditure carries the fund it is drawn against, so the available balance for each restriction is known continuously.

That is a dimension in the ledger rather than a schedule in a spreadsheet, which is the same argument made in the dimensions you never populate.

Hands reviewing balance sheets over a desk
The restriction is a property of the money, so it belongs on the transaction.
02

Four questions the dimension answers immediately

Each of these is difficult to answer from a year end schedule and trivial to answer from a populated dimension.

What is available for this purpose?: The current unspent balance for a specific restriction, which is the question programme staff ask before committing spend.
Have we overspent anything?: A negative available balance is visible immediately rather than at year end when it cannot be unwound.
What was released and why?: Release schedules become a report rather than a reconstruction, with the triggering expenditure identifiable.
What do we report to this funder?: Grant reporting draws on the same tagging, which is why the effort serves two obligations, as close metrics that change behaviour also do.
03

Why year end tracking fails

Reconstructing fund activity annually means deciding retrospectively which expenditures were funded from which gifts, and that decision is being made by whoever prepares the schedule.

It usually produces an answer that balances, because the preparer allocates until it does. That is not the same as having spent the money as the donor intended. Where federal awards are involved, the same tagging supports expenditure tracking against the threshold described in the single audit threshold, so a single dimension serves two obligations.

It also removes any possibility of prevention. An overspend identified in March of the following year cannot be avoided, only explained.

The stewardship consequence is the serious one. Donor relationships depend on the organisation being able to say precisely how a restricted gift was used, and the answer should not be an allocation exercise.


A schedule that balances is not evidence that the restriction was respected. It is evidence that somebody allocated until it did.
04

Three levels of fund tracking

Most organisations sit on the first or second and the third is achievable in any modern ledger.

LevelHow it worksWhat it prevents
Annual reconstructionFund activity allocated retrospectively for the disclosure note.Nothing. It reports rather than controls.
Separate fund accountsDistinct ledger accounts per major restriction.Overspend on major funds, at the cost of a chart of accounts that grows with every gift.
Restriction as a dimensionA dimension on every transaction, with the account structure unchanged.Overspend on any restriction, with reporting available at any level of aggregation.

Classification of net assets and the treatment of releases depend on the applicable framework and the terms of each gift. Confirm the treatment with your auditors.

"

The restriction arrives with the money. The ledger should learn about it then.

ChatFin
05

Implementing the dimension

The work is mostly in the setup and in the discipline afterwards, rather than in the system configuration.

Record the restriction at receipt

From the gift agreement or award letter, with purpose, period and any conditions, at the point the money is recorded.

Make the dimension mandatory on expenditure

So an expenditure cannot be posted without stating which fund it is drawn against, which is what makes prevention possible.

Report available balances to programme staff

Monthly, in a form they use, because they are the people who commit the spend.

Prepare releases from the transactions

Rather than as a year end schedule, which turns the disclosure into a report, as structuring the ledger properly allows.

Two people analysing financial documents with a calculator
Available balances are only useful to the people committing the spend.
06

Two objections from small finance teams

Both come from small finance teams with limited capacity, and both are reasonable.

Objection

We have too many small restrictions

Group them. A dimension can carry a grouping structure so that small gifts with the same purpose are tracked together, without a separate account for each.

Objection

It slows down transaction entry

Only where the fund is genuinely ambiguous, which is a decision somebody has to make eventually. Making it at entry is cheaper than making it in a reconstruction.

07

How ChatFin handles fund dimensions

Restricted fund tracking is a completeness problem, and completeness problems respond well to being checked continuously rather than reviewed periodically.

Flags unassigned transactions: Expenditure posted without a fund dimension is surfaced as a queue rather than allocated by default.
Maintains available balances: Balance by restriction calculated continuously from NetSuite, SAP Business One, JD Edwards, Acumatica, Dynamics 365 or Sage Intacct, and reported where programme staff can see it.
Prepares the release schedule: Releases derived from qualifying expenditure and presented for review, which also supports data quality having no owner.

Interpretation of gift terms and the classification of net assets remain judgements for your team and your auditors.

Free tool

AI Cost Estimator for the CFO Office

Four inputs. A first year range, a timeline, and three delivery models compared. No login required.

Frequently Asked Questions

Do we need separate ledger accounts for each fund?

Usually not, and it is a poor design for an organisation with many small restrictions because the chart of accounts grows with every gift. A dimension applied to transactions gives the same control with reporting available at any level of aggregation.

When is a restriction released?

When the purpose or time condition attached to the gift is satisfied, which is generally an event tied to qualifying expenditure or to the passage of time. Treating it as an annual adjustment obscures both the timing and the link to the expenditure that triggered it.

What happens if we overspend a restriction?

It is a stewardship issue and potentially a legal one depending on the gift terms, and it usually requires a conversation with the donor. The important point is that it is preventable at the point of commitment and only explainable afterwards.

Does this help with grant reporting?

Yes. The same tagging supports reporting to funders on how their money was used, which is a separate obligation drawing on the same underlying data. That shared benefit is usually what justifies the setup effort.

Tag at receipt, spend against it

The restriction is a dimension, not a disclosure.

Recording restrictions when the money arrives and requiring the dimension on expenditure turns fund compliance from a year end reconstruction into a live balance.

If you want a first year range for fund dimension tracking and release preparation, the estimator gives one in about a minute.

Open the estimator
Book a Demo
Put it on your own numbers

See what this looks like in your ERP.

We will walk through the workflow behind this article on the system you already run, using your own data, and show what a first phase would actually cover.

✓Runs on the ERP you already have, on the version you already run
✓Every action prepared as a draft that a person approves before it posts
✓A first phase scoped against your real workflows, not a generic package
Schedule a Demo
Confidential & private

This article is general information for finance and accounting teams. It is not legal, tax, accounting or investment advice. Dates and thresholds are given as published at the time of writing and several of these timelines have moved before, so confirm the current position with your advisers and with the relevant authority before acting.

Photos by Artem Podrez and Pavel Danilyuk, free to use under the Pexels License (commercial use, no attribution required).