Trending article

5 compelling reasons why you need a dimensional nonprofit chart of accounts

Volunteers framing a house

Over time, traditional accounting systems tend to produce unwieldy charts of accounts (CoA) with thousands—if not tens of thousands—of unique account numbers. That is because most financial solutions use a hard-coded structure for the chart of accounts. For example, to track receivables across 6 locations, with 5 departments each, and 15 projects, you’d need 450 account code combinations—and that’s before you get started with accounts for expenses.

Before long, you end up with a complicated, unmanageable set of codes. Adding a new location, department or program would force the finance team to create dozens or hundreds of additional accounts. Many nonprofit organizations find themselves having to choose between creating a sprawling, difficult-to-manage chart of accounts or not tracking all of the information that they would like. Luckily for today’s nonprofit organizations, a better way exists to organize your data through a dimensional chart of accounts.

A Dimensional Chart of Accounts Reduces Complexity

Modern cloud financial management solutions, like Sage Intacct, use a table-driven architecture to structure your financial and operational data around logic-based “dimensions.” Dimensions offer an entirely new way to manage your general ledger, making it much easier for you to set up and use your chart of accounts.

In Sage Intacct, nonprofit organizations can define up to eight dimensions to use in accounting and reporting, like program, department, location, grant, and project. You can track revenue and expenses for any of these dimensions, while simplifying your chart of accounts.

Multi-dimensional accounting lets nonprofit organizations keep it simple—you only need to set up your primary account codes. As you open new locations, new funds, or new programs, there’s no need to add hard-coded segment combinations to create account numbers. You can use dimensions for any transaction—general ledger, receivablespayablestimerevenue managementfixed assets, and more.

A dimensional chart of account eliminates the need to create so many account numbers. For example, instead of creating fixed asset accounts for each of your locations in the GL, you would simply set up a single fixed asset account and tag each asset with location. You would then use the location dimension to filter assets by location in your real-time reports.

“We especially love Sage Intacct’s dimensions-based approach, which ahs greatly simplified our chart of accounts, and is flexible enough to track all of the detail we need and evolve with our organization over time.”

Julie Suderman, Associate Commissioner, Finance, BIG 10 Conference

Goodbye Spreadsheets! Tag Transactions to “Twitterize” Your Data

Having a dimensional chart of accounts means you no longer need to pull information out of your accounting system and manipulate it in a spreadsheet to get the report you want. Dimensions let you track performance more closely and search for information instantly.

Think of dimensions within your chart of accounts like hashtags on Twitter—they make it easy to search and sort data for reporting with meaningful context. Simply “tag” transactions with dimensions so you can slice and dice your data later to produce the financial reports you need.

By filtering on dimensions at the time you produce reports, you can show exactly the information you need in the format you need it. You can then save those filters and format settings to repeatedly produce reports that fit your needs.

Before adopting Sage Intacct, Georgetown Visitation Preparatory School couldn’t prepare consolidated reports and the finance team spent at least six hours each month wrestling with Excel spreadsheets. Now, they instantly produce over 100 financial reports–including consolidated reports across their operating, plant, and capital campaign funds, as well as reports for each individual entity, department, project, grant, and endowment.

“Before Sage Intacct, we were coding all graduation-related expenses under a general admin account, but when we started tagging them with the project dimension, we found out that we were actually spending nearly three times the amount we had estimated. With this transparency, we can make more informed decisions as we start next year’s graduation planning.”

Roberta Hopkins, CFO, Georgetown Visitation Preparatory School

Dimensions Enable More Insightful Financial Analysis

Because dimensionality lets you organize information by the attributes that matter most to your mission, a dimensional chart of accounts empowers you to perform more meaningful analysis of organizational performance. With multi-dimensional analysis, you can increase visibility by drilling down from a top-level dashboard to see granular transaction details.

Dimensions will help you analyze financial performance across one or more entities in a real-time dashboard. You can tag projects in transactions, then analyze financial performance, project by project. Quickly compare expenses and revenue between programs, locations, and more.

Organizations can rename dimensions to better reflect their structure and mission. Many nonprofit organizations rename the “Class” dimension to a “Fund” dimension and then use it to track revenue and expenses against different funds.

As your organization changes, add dimensions to track new things that become important to your board or donors. For example, the Hilton Foundation used to organize its budget reports by expense categories.  Then one board member preferred to monitor budgets by department. Using Sage Intacct, the finance team easily created a report providing budget vs. actuals by the dimension of department.

“Because of Sage Intacct’s multi-dimensional approach, it’s so easy to instantly pull up the exact reports or specific expenses we need. We no longer have to rely on Excel to track and calculate expenses for individual departments or program areas when we want to make comparisons.”

Monica Emerson, Controller, Hilton Foundation

Added Operational Context Improves Visibility

Sage Intacct offers a statistical account feature that enables you to bring non-financial operational data into your financial reporting. Any traditional GL should contain the financial information needed to create GAAP financial reports. But by enhancing the GL with non-GAAP statistical data, nonprofits can also track and report on operational outcomes.

By applying dimensions to the operational data, you can create more contextually rich reporting that includes critical outcome and performance metrics. This increases overall visibility and provides organizational decision-makers with a more complete picture of performance.

Gateway Church uses statistical accounts to marry financial and attendance data for analysis. The church tracks weekly in-person attendance and online viewers, then adds a statistical journal entry in Sage Intacct. They run the attendance data against weekly revenue to calculate the average amount given per adult attendee and then analyze this metric by location to compare church campuses for budgeting.

“One of the ways we benefit from Sage Intacct – given the size of our church – is the different dimensions… dimensions such as locations, dimensions as funds and projects… We’re utilizing those in order to better capture expenses coming in and better budget the different events for the Gateway Church as an organization.”*

Libni Rodriguez, Project Manager, Gateway Church

Dimensional Reporting Increases Transparency with Donors

Combining financial performance data with real-world outcome metrics produces reports that truly reflect your organization’s success in accomplishing its mission. Multi-dimensional analysis increases your transparency and visibility with your donors by bringing together financial, operational, and impact data that tell donors the complete story of how your organization makes an impact.

“Thanks to the dimensional insight we have in Sage Intacct, we can be very strategic in the way we use our grants. Most importantly, we are more transparent with our donors, providing information about where their money goes and how quickly we apply those funds.”

Christopher Sue, CFO, Children’s Hunger Fund

Conclusion

As you can see, a dimensional nonprofit chart of accounts offers nonprofit organizations many advantages, including:

  • Reduced complexity and higher efficiency in transactional data entry
  • Greater ability to slice and dice reports without spreadsheets
  • More-informed decision making with real-time analysis
  • Wider and deeper financial visibility with greater operational context
  • Increased transparency for donors
  • Better visibility into missional impact

To leverage the power of multi-dimensional accounting, organizations need to use a modern cloud financial management solution. Not only will dimensionality greatly simplify the lives of your finance team, it will also empower program managers and executives with greater insight and help your organization support a more compelling story for donors.

The Nonprofit Finance Team Survival Guide

Download