Business Central fund accounting built on dimensions
Business Central fund accounting runs on dimensions, not a separate module. Every entry carries a fund tag, and often a grant and a program. So you can report income and spending for each. Our consultants design that structure and enforce it at posting. They also build the statements funders and boards expect. We say plainly where an add-on is the better route.
Last updated
How Business Central fund accounting is structured
A dimension is a label attached to a ledger entry. For a nonprofit, we typically create Fund, Grant, Program and Department dimensions. Each has its list of values. Two can be global dimensions, which work as filters everywhere. Up to six more are shortcut dimensions, shown directly on journals and documents.
The chart of accounts stays short, with natural accounts such as salaries or contributions. The dimensions answer who paid for it and what it was for. Separate equity accounts hold net assets with and without donor restrictions. We settle this design before any data goes in. Global dimensions are hard to change later.
Design your fund structure →
- ✓Fund or funding source
- ✓Grant or contract
- ✓Program or service
- ✓Department or site
- ✓Functional expense class
Making sure no Business Central fund accounting entry posts without a fund
A fund structure fails quietly when entries post without a fund code. You can set default dimensions on G/L accounts, vendors and bank accounts to Code Mandatory. Then posting stops until someone gives a value. Or use Same Code, which allows only one value.
Dimension combinations can block pairs that make no sense, such as a closed grant with a new program. Allowed values per account narrow the choice further. We set these rules account by account. We test them with your typical transactions. So the system guides staff at entry. Nobody has to fix entries after month-end.
Tighten your posting rules →- ✓Code mandatory on accounts
- ✓Same code where fixed
- ✓Blocked dimension combinations
- ✓Allowed values per account
- ✓Defaults on vendors and staff
Reports from Business Central fund accounting data
Financial reports use row definitions for accounts and column definitions for periods or dimension values. You can produce a statement of activities with a column per fund this way. A statement of financial position and a statement of functional expenses work too. You can filter any of them to a single grant when a funder asks.
Analysis views summarize entries by chosen dimensions for faster reporting. Power BI adds charts for board packs. We build the core statements with you. We tie each one back to the trial balance. Then your finance team can add a new grant column without calling us.
See fund reports built →- ✓Statement of activities by fund
- ✓Statement of financial position
- ✓Functional expense statement
- ✓Grant spending against budget
- ✓Program cost summaries
Budgets and allocations in Business Central fund accounting
You can enter G/L budgets by account and by dimension. So each grant or program has its own budget, and the same financial reports show budget against actual. Several budgets can exist side by side. One example is the board-approved budget next to a revised forecast made later.
Shared costs such as rent or the finance team are spread with allocation accounts or recurring journals. They use fixed or variable splits, and each resulting line carries its fund and program. We document the basis of every allocation. Funders and auditors ask how indirect costs hit their grant.
Plan grant budgets together →- ✓Budget by grant dimension
- ✓Multiple budget versions
- ✓Allocation accounts
- ✓Recurring allocation journals
- ✓Documented allocation basis
Where dimensions are enough and where they are not
Dimensions give reporting by fund. However, they do not make each fund a self-balancing set of accounts. Standard Business Central will not stop a journal that debits one fund and credits another. A manual procedure must reconcile both sides through due-to and due-from accounts.
Encumbrance accounting reserves budget once someone approves a purchase order. Many public bodies require it, and the standard product does not offer it in that form. You may need either feature. If so, we compare AppSource solutions for nonprofit and public sector accounting with you in a sandbox. We also keep the dimension design compatible with whichever you choose.
Check your fund requirements →- ✓Must funds self-balance
- ✓Are encumbrances required
- ✓Grant reporting formats
- ✓Number of active grants
- ✓Audit expectations
Business Central fund accounting questions
Does Business Central have a fund accounting module?
No. You do fund accounting with dimensions on a standard general ledger. That works well for many nonprofits. Organizations that need self-balancing funds or encumbrances add a specialist solution built for that purpose on top of it.
How do we show restricted and unrestricted balances?
Net assets split into equity accounts with and without donor restrictions. A fund dimension names the specific restriction. When you meet a restriction, a journal entry releases the amount from one class to the other. Reports show both.
Can one invoice be split across several grants?
Yes. Each purchase invoice line carries its own dimensions. So one bill can split into lines for different grants and programs. Allocation accounts can also split a single line by fixed shares as it posts.
Is there nonprofit pricing for Business Central?
Microsoft offers licensing programs for eligible nonprofits. Microsoft sets eligibility and current terms and publishes them on its site. We can point you to the right program. We can also help match license types, such as Essentials and Team Members, to your staff.
How are grants that span fiscal periods handled?
A grant is a dimension value, so it is not tied to your fiscal calendar. You can filter reports to the grant's own start and end dates. You can also enter budgets for the grant period, whenever your accounting period closes.
Book a discovery call
Let's talk through your move to Business Central.
A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.
What happens after you send the form