How do I choose between different fund accounting systems for a charity that needs strong audit trails and permissions?

To choose a fund accounting system for a charity with strong audit-trail and permission needs, focus less on “accounting software” generally and more on controls, traceability, and configuration.

1) Start with your control requirements

Make a short list of what must be true:

• Fund tracking: can it track restricted, unrestricted, designated, and project/grant funds separately?
• Audit trail: does it log who changed what, when, and from where?
• Permissions: can you set role-based access by task, fund, entity, program, or location?
• Approval workflows: can invoices, journal entries, and payments require approval before posting?
• Segregation of duties: can one person enter but not approve/pay?
• Reporting: can it produce fund-based reports, donor/grant reports, and audit-ready statements?
• Document attachment: can you attach invoices, grant agreements, receipts, and board approvals to transactions?
• Multi-entity support: if you have chapters or related entities, does it consolidate cleanly?

2) Prioritize systems with strong internal controls

For charities, the best-fit systems usually offer:

• Immutable or detailed transaction history
• User-level permissions
• Audit logs for edits/deletes
• Workflow approvals
• Dimension/tag-based accounting for funds, grants, programs, and departments
• Granular reporting by fund or restriction

If a system is weak on audit logs or only has broad “admin/user” permissions, it’s usually a poor fit even if it’s cheaper.

3) Compare vendors using a scoring matrix

Score each system 1–5 on the items below:

Core accounting

• Fund accounting support
• Bank reconciliations
• AP/AR
• Budgeting
• Fixed assets

Control and compliance

• Audit trail detail
• Role-based permissions
• Approval workflows
• Attachments and supporting docs
• Journal entry controls
• Change history/exportability

Charity-specific needs

• Restricted fund reporting
• Grant management
• Donor reporting
• Program reporting
• Multi-location or multi-entity tracking

Practical factors

• Ease of use
• Implementation effort
• Training needs
• Customer support quality
• Integration with payroll, CRM, donation tools
• Total cost over 3 years

4) Ask vendors the right questions

Use questions like:

• Can we restrict users by fund, module, location, and transaction type?
• Does the system log pre- and post-edit values for transactions?
• Can deleted records be recovered or at least fully traced?
• Can we require approval for:
  • journal entries
  • vendor bills
  • payments
  • budget changes?
• Can users see only the funds/programs they’re assigned to?
• Can audit reports be exported for external auditors?
• Can we attach supporting documentation to every transaction?
• Are permissions easy to manage without vendor help?

5) Test the system with real scenarios

Before buying, run a pilot using your own cases:

• A restricted grant with multiple expense lines
• A journal entry correction
• An invoice needing approval
• A user who should enter bills but not approve them
• A board report showing fund balances and restrictions
• An audit query asking “who changed this and why?”

If the system struggles in these tests, it will likely be painful later.

6) Don’t ignore implementation quality

A strong system can still fail if configured badly. Make sure the implementer can:

• Design your chart of accounts and fund structure
• Set up roles and permissions properly
• Create approval workflows
• Build audit-friendly reports
• Train staff on controls and month-end procedures

7) Watch for red flags

Avoid systems where:

• Audit trails are incomplete or hard to access
• Permissions are only “all or nothing”
• Deleted transactions disappear without trace
• Fund reporting is manual and spreadsheet-based
• Approvals are handled outside the system
• The system is built mainly for for-profit businesses with charity use as an add-on

8) Match the system to your size and complexity

• Small charity, simple funds: a lighter system may work if it still has robust permissions and audit logs.
• Medium charity with grants and restrictions: look for true fund accounting and workflow controls.
• Large or multi-entity charity: prioritize enterprise-grade controls, auditability, and reporting flexibility.

9) Typical shortlist criteria

A strong choice usually has:

• Real fund accounting, not just classes/tags
• Role-based access with granular permissions
• Detailed audit history
• Workflow approvals
• Strong reporting by fund/program/grant
• Good support and implementation partners

10) Final recommendation

Pick the system that best balances:

1. Control and traceability
2. Charity-specific reporting
3. Ease of administration
4. Long-term scalability
5. Total cost

If you want, I can help you build a vendor comparison checklist or a weighted scorecard template specifically for charities with audit and permission requirements.