Back to Blog

Why A Table-Driven Chart of Accounts Matters

Decrease in profitWhen implementing a financial accounting and reporting system at a nonprofit organization, few would disagree that an optimized Chart of Accounts design is critical to success. Being able to produce accurate compliance reports and meaningful management reports is the point of the exercise. Failing to get it right can add substantially to the workload and effectiveness of both the finance department and the organization as a whole.

Given this fact, most organizations give careful consideration to how to segment and code their accounts to address these requirements, but when evaluating different nonprofit accounting software options, the way that chart gets implemented from technical perspective can be drastically different.

Generally speaking, there are two technical approaches to implementing the chart of accounts in accounting software.

  • Linear – The segments of the account code are concatenated into a single string of values with a separator (often a hyphen) between each value. For example, an account may look something like this 10-5850-210-3501 where the first value “10” represents a division, “5850” represents the type of expense (natural account classification), “210” may represent a program or department and “3501” might relate to a specific project. The entire 13-character string represents an account in the linear model and often a single description is available.
  • Table-Driven – In the table-driven model, the account segments or dimensions are considered independently and only combined at the point of transaction entry. A single, unduplicated list of valid divisions, a separate list of natural account values, etc. are maintained independently from one another. At transaction entry, the appropriate combinations of codes are assigned to transaction lines based on the nature of the transaction.

JMT strongly recommends the table-driven approach to our clients for a number of practical reasons:

  1. The table-driven method greatly simplifies maintenance of the Chart of Accounts. New values, for example a new project, can be added to one of the segment tables as needed. It is not necessary to build an entire list of 13-character account codes that include that new value in every anticipated combination. Further, when a project is complete or discontinued, it is relatively simple to deactivate a single project code to prevent coding of new transactions to that code. There are other similar advantages.
  2. The linear method frequently results in chart of accounts bloat. Nonprofit organizations typically slice and dice their data using a number of different dimensions and when you must concatenate the values together to make a code, you end up with potentially dozens of accounts that all refer to the same type of expense in different contexts. In one organization we helped recently, their list of active account codes was over 80 pages when printed and there were 26 active accounts that were all just ambiguously labeled “Telephone Expense”. To the untrained eye that could not decipher the segment values from memory, there was no easy way to know you were using the right code during data entry. Further, reports can be difficult to read for those same untrained eyes. This ambiguity often results in more frequent corrections since finance team members performing data entry don’t always get clear, immediate feedback when they select an improper code.
  3. A table-driven chart usually makes aggregate and summary reporting easier. While some linear model-based systems have come up with workarounds to this limitation, linear model report writers often rely on report filtering and account “masking” to exclude accounts and values that you don’t want included in your report. For instance, your report writer might allow you to apply filters at each segment position, but the output is all of the detailed activity or balances only at the 13-character level of detail. Summary amounts, such as total personnel expenses for a department or program, often can only be achieved through subtotals of much more detailed information. Most table-driven systems allow you to query and report in a much more intuitive fashion. If you ask the system to show you “total personnel expenses for a department”, you are able to get that data back at that very specific level of detail. The data is automatically summarized at the level of detail requested. It makes reports easier to produce and more readable for those attempting to use it.

While there is no such thing as the perfect system, we have worked with a large variety of systems that employ both models. At JMT, we feel strongly that the table-driven model generally serves the unique and complicated needs of nonprofit financial reporting more effectively and better addresses the needs of organizations as they evolve.

Related Posts:
It’s an Open Book: How Nonprofits Can Achieve Financial Transparency
August 7, 2018
It’s an Open Book: How Nonprofits Can Achieve Financial Transparency

All charities differ in their missions, but all are alike in one important way—to succeed, they must practice financial transparency and accountability.  In fact, Charity Navigator, the nation’s largest and most-utilized evaluator of charities, uses these values as key criteria in rating nonprofits. Charity Navigator defines transparency as “an obligation or willingness by a charity…

Two Truths and a Lie: Fundraising in a Pandemic
May 26, 2020
Two Truths and a Lie: Fundraising in a Pandemic

My dear friends, colleagues, soul sisters and brothers in the Development department… I see you. You work your tails off when times are flush, and now in the middle of this pandemic and economic fallout, you’re pushing yourself to even more extreme limits. You carry the weight of the organization’s worry within you. You pore…

How To Reduce Financial Risk for Your Nonprofit
April 16, 2018
How To Reduce Financial Risk for Your Nonprofit

Many nonprofits walk a razor-edge financially. Nonprofits address society’s most difficult issues, compete for limited funding and struggle to find and keep qualified staff to run their organization. A new report by Oliver Wyman, SeaChange Capital Partners, and GuideStar, which examines the finances of more than 219,000 U.S. nonprofits, reveals sobering realities: Around 50% have…

Nonprofit CFOs Shape their Legacy by Defining and Communicating the Big Picture
October 15, 2019
Nonprofit CFOs Shape their Legacy by Defining and Communicating the Big Picture

You are the CFO of a nonprofit that’s focused on long-term mission fulfillment, financial sustainability, and organizational independence. How do you guarantee that your legacy is aligned with the organization’s long-term success? You may have thought that years of successfully ensuring your debits equaled your credits, that audits ran smoothly, and that financial reports were…

 Back to Blog