Fund accounting patterns for nonprofits on Dynamics 365

Nonprofit accounting is commercial accounting with one extra axis: every pound or dollar belongs to a fund, and some funds carry donor restrictions that dictate what the money can be spent on and how it must be reported. Under US GAAP (ASC 958) that shows up as net assets with and without donor restrictions; under the UK Charities SORP as restricted, unrestricted, and endowment funds; most other jurisdictions have an equivalent. Dynamics 365 has no "nonprofit edition" of its ledgers. It has dimensions, and in Finance a specific public-sector fund model, and the design question is which to use. This guide covers both. For the wider picture see Dynamics 365 for nonprofits.

The fund-as-dimension pattern

The universal approach is a Fund dimension on every posting. Business Central makes it a global or shortcut dimension; Finance makes it a financial dimension in the account structure. Every transaction — donation receipt, grant expense, payroll allocation — carries a fund value, and reports filter or group by it.

That gives you an income statement by fund without difficulty. What it does not give you, by itself, is a balance sheet by fund. Bank accounts, receivables, and payables are posted with the fund of the transaction, but a payment from one bank account for expenses across three funds leaves the bank balance in one fund and the expenses in three. The books balance in total; they do not balance per fund.

There are three responses:

• Accept it. Many smaller nonprofits report fund balances (net assets by fund) from the income statement roll-forward and do not attempt a balance sheet per fund. Auditors generally accept this if net assets by restriction are correct.
• Enforce balancing. Finance supports a balancing financial dimension in the ledger setup: the system generates interfund due-to and due-from entries automatically so that every fund balances on its own. This is the feature that makes true fund-level balance sheets possible without an ISV, and it is the reason larger nonprofits end up on Finance rather than BC.
• Use an ISV in Business Central. BC has no balancing-dimension feature. Nonprofit ISV apps on AppSource add interfund balancing, fund-level statements, and restriction handling. They vary in depth; ask specifically how the interfund entries are generated and reversed.

The public-sector fund model in Finance

Beyond dimensions, Finance's public-sector configuration adds funds as a first-class ledger concept with fund types and classes, fund-level budget control, and derived financial hierarchies that roll funds into reporting groups. It was built for government but the mechanics — restricted funds, budget enforcement per fund, encumbrance — fit larger nonprofits well, especially those with government grants that impose budget control. The public sector features guide covers what turning it on changes. It is heavier to configure than dimensions alone and only worth it if fund-level budget control or encumbrance is a requirement, not a nice-to-have.

Restrictions and releases

Restricted funds are spent on their purpose and then "released" to unrestricted — the accounting entry that moves net assets between restriction classes as the restriction is satisfied. In both products this is a journal, either manual at period end or generated by a report that identifies restricted expenses in the period. There is no first-party automation of releases; nonprofits build a recurring journal template or a Power Automate flow over a query, and larger ones get it from the ISV. Set up a Restriction dimension (or fold restriction class into the fund dimension's hierarchy) so the release entry can be produced from a query rather than a spreadsheet.

Allocations

Shared costs — rent, IT, the finance team — must be allocated across funds and programmes, and funders often dictate the basis. Business Central has cost allocation through recurring journals with allocation keys and, more formally, cost accounting allocations. Finance has ledger allocation rules with basis on fixed percentages, spread, or another dimension's balances; the allocations guide covers them. Either way, define the allocation basis once per cost pool, run it monthly, and keep the basis documentation with the close, because it is the first thing a grant auditor asks for.

Interfund transactions

Loans and transfers between funds need to be visible and reversible. Use dedicated interfund transfer accounts, post transfers as two-sided journals with both fund values, and reconcile the interfund accounts to zero in total each month. With Finance's balancing dimension the due-to and due-from entries are automatic; without it, they are a control that someone owns.

Budgets by fund

Funders approve budgets by fund and category, and overspend against a restricted fund is a compliance breach, not a variance. Business Central budgets carry dimensions, so a budget per fund per account is straightforward, and budget-versus-actual reports by fund come from financial reports with a fund filter. Finance's budget control can block or warn on postings that exceed a fund's budget, which is the enforcement funders sometimes require; the budget control guide covers the setup. Grant-level budgets and drawdowns are a separate concern, covered in grant tracking.

Reporting

Statement of activities by fund and by restriction class, statement of financial position with net assets by class, and per-fund or per-grant statements for funders. Business Central's financial reports (formerly account schedules) with column layouts by dimension handle all three for a modest number of funds; beyond a few dozen funds the reports get unwieldy and Power BI over the GL entries with the dimension set is the better tool. Finance's financial reporting handles fund and hierarchy roll-ups natively. Neither product produces the statutory nonprofit formats — the SORP statement of financial activities, the US Form 990 schedules — out of the box; those are mapped in the reporting layer or through a partner.

Deciding

A nonprofit with a handful of funds, straightforward restrictions, and no funder-mandated budget control should run Business Central with a fund dimension, a restriction dimension, and disciplined releases, adding an ISV only if the auditor demands balanced funds. A nonprofit with many restricted funds, government grants with budget control, or a requirement for true fund balance sheets should look at Finance with the balancing dimension or the public-sector configuration. The dimension design, either way, is the decision that cannot be changed cheaply later; the BC dimensions design and financial dimensions guides are worth reading before the chart of accounts is touched.