Before a chart of accounts redesign, consider the reporting power of Dynamics GP Account Categories

I see an awful lot of companies that want to redesign their chart of accounts. This happens when folks are moving to Microsoft Dynamics GP from another system and it happens if they've been on GP for a while. The reality is that as a business grows, the nature of the business can change and the company outgrows its account structure. But changing the chart of accounts can be huge undertaking. Most often, companies are really looking for a better way to report off of their existing data. While you're working on that massive chart change, there may be a way to help bridge the gap.

In Dynamics GP the setup for an account includes a field called Account Category.  This much maligned field is actually very useful, but I understand why it's confusing for people. By default, Account Categories are not listed alphabetically, they are listed by their typical placement in financial statements. This can make it a little hard to find what you are looking for. Plus, it's a required field, but what is it used for?

Most users of Dynamics GP don't use the very basic (despite the name) Advanced Financial Reports feature. Account Categories are designed to work with Advanced Financial Reports, but they can do a lot more.

Basic categorized financial statements can be built using account categories in FRx, Management Reporter, and just about any other CPM tool, providing a fast way to get started with financial reporting. They can also provide a fast way to reconfigure financial statements. Even if your chart of accounts is a mess, if the categories are set correctly, the accounts will at least roll up right.

Categories are also extremely useful for business intelligence analysis via Analysis Cubes for ...