Fund accounting done properly
Restricted, unrestricted and endowment funds tracked in the ledger, so spend against restriction is evidenced rather than reconstructed.
ERP for Museums
Why an ERP is best practice for museums
A practical look at what an ERP does for a museum or gallery, where the value sits, and how to choose a platform that handles restricted funds, exhibitions and trading activity in one place.
Overview
What an ERP does for a museum
A museum runs several different financial models at once: grant and donation income with restrictions attached, exhibition projects with fixed budgets, and commercial trading through retail, catering and venue hire.
An ERP (enterprise resource planning system) keeps those separate but reportable together, so trustees see the charitable position and the trading position without a month of spreadsheet work.
Collection management and ticketing systems keep doing their jobs. The ERP governs money, cost and accountability.
For most museums, an ERP is where the following live:
Benefits
Why your museum needs an ERP
The value is accountability. Showing exactly how restricted money was spent and what the trading operation adds.
Exhibitions costed like projects
Budget, commitments and actual spend by exhibition give a genuine forecast while there is still time to adjust.
Trading margin visible
Retail, catering and venue hire reported with their own cost of sale shows what the commercial activity actually contributes.
Grant claims from live data
Eligible spend tagged to the funder means claims and returns are produced rather than assembled from receipts.
Faster close and cleaner audit
Automated reconciliation and full audit trail shorten period end and reduce audit queries.
One picture for trustees
Charitable and trading activity reported together from one dataset instead of separate systems that never quite agree.
ERP stats
Why your museum needs an ERP
Data taken from a survey we commissioned in December 2024. Click here to view
0%
of businesses are utilising an ERP
0 in 0
businesses are dissatisfied with their current ERP
0%
of businesses say using an ERP has contributed to achieving business outcomes
In practice
What this looks like in a museum
Six everyday situations where one connected system changes the outcome.
01
A grant is awarded
The fund is set up with its restriction and reporting dates, so eligible spend is captured from the first invoice.
Choosing an ERP
What to look for when comparing ERP platforms
Museum finance combines charity rules with commercial trading. These are the questions worth asking before you shortlist.
Does it cover the whole operation?
Finance, purchasing, stock, projects and reporting should sit in one system. Anything left in a spreadsheet quickly becomes the version everybody argues about at month end.
Does it fit how you actually work?
A system designed for a different sector rarely suits museums and galleries. The platform should reflect your real processes, approvals and cost structures rather than forcing a rewrite of how you operate.
Can you close and report faster?
Consolidation, reconciliation and management reporting should be routine rather than a fortnight of manual work. Ask to see a month end demonstrated, not described.
Does it stand up to audit?
Role-based permissions, approval workflows and a complete audit trail should be built in, so compliance is a by-product of daily work rather than a separate exercise.
How long until it is live?
Cloud platforms with standard processes go live in weeks rather than years. A long implementation is usually a sign the system is being bent into shape.
Will it grow with you?
New sites, entities, currencies or product lines shouldn't need a replacement system. Check licensing and functionality for where you expect to be in five years.
Our recommendation
Introducing Business Central - the perfect ERP for museums
Once you know what an ERP should do, the question becomes which platform fits how your teams already work. Microsoft Dynamics 365 Business Central brings finance, purchasing, projects, stock and reporting into one cloud system connected to the Microsoft tools you already use.
For museums that means dimension-based fund accounting, project tracking for exhibitions and capital works, retail and catering stock control, approval workflow on spend, and Power BI dashboards for trustees and department heads.
It connects to ticketing, EPOS and fundraising systems through standard APIs, so income reaches the ledger without rekeying.
Why Business Central
The features that make Business Central the right fit
It isn't just an accounting package. These are the capabilities teams tell us make the biggest difference day to day.
Finance and reporting in one place
Ledgers, budgets, cash flow and management reporting run from the same data, with Power BI dashboards leadership can open themselves rather than waiting for a pack.
Copilot built in
AI drafts descriptions, reconciles bank entries, chases anomalies and answers questions about your data, taking a chunk of routine admin off the finance team.
Native Microsoft 365 connection
Approvals, quotes and reports work inside Outlook, Teams and Excel, so people use the tools they already know instead of learning another interface.
Automation without developers
Approvals, alerts and handovers can be automated with Power Automate using low-code tools your own team can maintain.
Security and audit trails
Role-based access, approval limits and full traceability protect the financial and operational data museums and galleries are accountable for.
Modular and scalable
Start with finance and operations, then add supply chain, projects, service or Dynamics 365 CRM as you grow - without another migration.
FAQ
Frequently asked questions
No. Collections, cataloguing and loans stay where they are. The ERP handles funds, purchasing, projects, trading and reporting.
Yes. Fund and restriction are carried as dimensions on every posting, so fund balances and spend are reported directly from the ledger.
Yes. The trading company can be a separate entity with its own statutory accounts, consolidating into group reporting.
Eligible spend is tagged to the funder as it happens, so claims and end-of-grant reports come from records rather than reconstruction.
Yes. Per user per month licensing suits a small finance team while still supporting funds, projects and trading.
Enquiry form
Not sure which ERP is right for your museum?
Tell us how funds, exhibitions and trading are handled today and we'll talk through what an ERP would change, which capabilities matter most and where to start. No obligation, just a straight conversation.