Implementing Financial Dimensions with D3FO - Part 1
Part 1 – Dimension-based GL’s vs. Traditional Segmented GL’s
- Account combinations were longer than the Black Friday line at Kohl's. Back in the day, the GL was the only system we really trusted, so the tendency was to jam every financial analysis we ever wanted into the GL.
- Accounts often had more zeros than a Houston Astros scorecard (apologies to Astros fans, but admit it…you laughed). Since every segment was required for every account, you had to put something in the field.
- Account definitions typically required someone to pre-create every possible combination of values. So adding a new natural account was time-consuming because it would require potentially hundreds of entries. Later systems, on the other hand, would explode out the combinations for you. The problem with that approach was that you had a bunch of account combinations that would never, ever get used.
- Charts of account that had hundreds of thousands of accounts. I once reduced the chart of accounts for a division of a Fortune-250 company from 106,000 accounts to around 34,000 accounts. 34,000 accounts. That’s still a lot of reclasses, reconciliations, and so on.
- Users were forced to enter every single character. Let’s just say a lot of Accounts Payable keyboards had worn-out “0” keys.
- The inclusion of “future” segments….just in case.
- Significantly reduces the number of GL account combinations because you no longer need to explode dimensions against accounts that make no sense.
- Alpha-numeric combinations. I’m a bit of a purist who doesn’t like alpha characters in their account logic. I just think keeping it numerical streamlines reporting, facilitates memorization of accounts, etc. But with dimensions such as expense purpose, it completely makes sense to use full word values like Airfare, Meals, etc.
- Values for many dimensions default from master data, thus minimizing manual entry. Examples include items, vendors, customers, etc.
- When you inactivate a dimension like project or asset, it doesn’t leave gaps in the core account that is used for reporting, etc.
- Dimensions are more extensible. How many of you have charts of account with logic built into them and then ran out of room? It’s easy to recreate a dimension with more characters if needed.
- Dimensional data becomes part of a standard monthly reporting package, as well as any post-close analysis that you generate.
- Dimensional data can be used in general ledger allocations.