For business management solutions email us or call 020 3004 4600

Fund Accounting in Business Central

Fund accounting is the practice that distinguishes charity finance from commercial finance most clearly. Where a commercial business needs to know whether it made a profit, a charity needs to know whether it spent each donor's or funder's money on exactly what that money was given for. Getting this right is a legal obligation, not a reporting preference, and the systems that make it manageable without significant manual reconstruction are genuinely different from what a standard commercial accounting setup provides out of the box. This guide covers what fund accounting requires, how Business Central handles it through dimensions, and what SORP-compliant reporting actually looks like in practice.

Why Fund Accounting Is Different from Commercial Accounting

A commercial business needs a single bottom line: revenue minus costs equals profit or loss. A charity needs multiple bottom lines, one for each fund, because income received for a specific restricted purpose cannot legally be treated as part of the general pool of money available for any charitable purpose. A grant received to fund a specific project belongs to that project, and spending it on anything else, even a different charitable activity of the same organisation, is a breach of trust that trustees are personally accountable for.

This means charity accounts need to track income and expenditure separately by fund throughout the year, not just calculate a combined total at year end and then try to apportion it. The fund-level tracking needs to happen at the transaction level, as every donation is received and every cost is incurred, rather than being applied retrospectively through a year-end allocation exercise.

The Three Fund Types Under SORP

The Charities SORP requires accounts to report separately across three fund categories. Restricted funds are those given with a specific condition set by the donor or funder that the trustees cannot override, such as a grant designated only for a building project or a particular programme. Designated funds are unrestricted funds that trustees have chosen to set aside for a specific purpose of their own choosing, which they retain the flexibility to redesignate if circumstances change. Unrestricted funds are the general pool available for any of the charity's charitable purposes at the trustees' discretion.

A complete set of SORP-compliant accounts presents income, expenditure and closing balances separately for each of these categories, with a clear reconciliation showing how each fund balance has moved during the year. Producing this from a single set of transaction records requires that every transaction has been consistently tagged with the correct fund throughout the year.

How Business Central's Dimensions Handle Fund Tracking

Business Central's dimension functionality allows every transaction to carry additional coding beyond the standard chart of accounts, tagging each entry with, for example, a fund code that identifies which restricted or designated fund it relates to, alongside the normal income and expenditure coding. This means a grant receipt can be posted to the income account in the normal way while simultaneously being tagged as belonging to a specific restricted fund, and a project cost can be posted to the relevant expenditure account while being tagged as a draw against the same restricted fund.

Because this fund tagging happens at the transaction level, the fund-by-fund income and expenditure report is simply a filtered view of the same underlying transaction data, rather than a separate calculation that has to be performed at year end. Adding a new fund is a matter of creating a new dimension value rather than setting up a separate company or legal entity, which keeps the accounting structure manageable even as the number of active restricted funds grows.

What SORP-Compliant Reporting Looks Like in Practice

The Statement of Financial Activities, the primary income and expenditure report in charity accounts, presents income and expenditure across rows showing activity type, donations, grants, trading, and columns showing each fund category, restricted, designated and unrestricted, with a total column for the period. Producing this directly from Business Central requires that the dimension structure maps clearly to these categories, which is the design work that determines whether the reporting system actually serves the SORP requirement.

The balance sheet equivalent in charity accounts, the Balance Sheet or Statement of Financial Position, then reconciles the closing fund balances, showing what remains in each fund at the year end. An auditor or independent examiner reviewing these accounts will check that the fund balances are credible and that restricted fund expenditure genuinely matches the conditions set by each funder, which depends on the underlying transaction tagging being consistent and accurate throughout the year.

What This Looks Like in Practice

A charity managing six active restricted funds alongside designated and unrestricted funds used Business Central's dimension reporting to produce its SORP-compliant Statement of Financial Activities directly from posted transactions at year end, without the manual fund-by-fund reconciliation exercise its previous spreadsheet-based approach had required. The finance trustee was able to review the fund positions monthly throughout the year, catching a restricted fund that was approaching its funder's spending deadline with a significant unspent balance several months before the deadline, giving time to address the issue with the funder before it became a compliance problem.

A church using Business Central for its general financial management configured a fund dimension structure that separated its general fund, building fund and several designated reserves, allowing the annual accounts to be presented in the format the independent examiner required without a separate year-end reconstruction exercise.

Getting Started with Fund Accounting

The most important design decision is defining the dimension structure before transactions are posted, since retrospectively retagging a year's worth of transactions is far more work than getting the structure right at the outset. Organisations with existing restricted funds should map each current fund to a dimension value, confirm that the dimension structure covers all likely future fund types, and train finance staff on consistent posting before the system goes live.

The Advantage Transformation Sprint is a free, no-obligation session that reviews current fund tracking practices and identifies how a Business Central dimension structure would need to be designed to produce SORP-compliant reporting for your specific organisation.

Produce SORP-Compliant Fund Reporting with Business Central

Advantage configures dimension-based fund accounting within Business Central for charities, churches and not-for-profit organisations, producing SORP-compliant reporting directly from transaction data. If you want fund accounting that works as a normal part of daily bookkeeping rather than an annual reconstruction exercise, speak to our team.

Contact Advantage today or call 020 3004 4600.

Read more about our Not for Profit solutions or explore Dynamics 365 Business Central.

Related Resources

Glossary: Restricted Fund
Gift Aid Management in Business Central
Glossary: Dimensions
Glossary: Gift Aid
Dynamics 365 Business Central