Split a category so two lines roll up to one

Categories
5 posts / 0 new
Last post
X 0
Split a category so two lines roll up to one

I am looking to split a category into two or more parts. Perhaps I am asking too narrow question, let me present the problem:

I have a category "subscription fees" which maps directly to a general ledger account. For budgeting purposes, I want to be able to budget a few of the main subscription items on seperate rows but have them roll up to the single general ledger account which will carry historical and forecast numbers in the income statement.

How are people getting around this problem?

Thanks

Josh

Michael Hutchens A+ 162

Hi Josh,

Can you provide a simple example workbook, either modular or normal Excel file, which shows what you're trying to do here?

Is this a general Excel/modeling challenge, or a challenge specifically relating to how best to do this within the categories automation infrastructure provided by Modano?

Thanks, M.