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
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.
Hi Josh,
This might be along the lines of what you're requesting. I put this together quickly using content library, along with mirrored modules. I did this on an annual time series, but the principle is the same for other time series.
There are redunancies/automation that can be done to ensure the categories remain clean on insertion/deletion, but I thought I'd keep this as a simple example.
Let me know if I'm on the right track with what you're requesting.
Jun
Hi Michael and Jun
Sorry for the delay.
Firstly Michael, this is something that I am trying to understand using the categories infrastructure. Using excel, the simplest method I have used previously is two fields, one for accounts and another for the item split (see attached) and use something like a SUMIFS for the rollup.
Jun, thanks for the attached. I think I see where you are trying to go but each driver based module rolls up to a different category, unless I'm not following. What I am looking to do is have them roll up to the same category.
I was wondering how to practically use mirrored modules
Thanks
Josh
Hi Josh,
I'm pretty sure this is along the lines of what you're after.
The categories in the Revenue (For Ledger) module can be used to map to your GL accounts for H&F purposes - I assume you have more than just the 6200-subscription fees. This is comparable to your "summary" tab.
Each Revenue (Driver Based) module can then be used to split out your specific inputs by simply adding categories. Each module will be comparable to an "Input" tab.
I just used mirrored modules, to speed up any changes you may have that would be applicable across the board, while still allowing for differing categories. I've re-attached with more categories to illustrate the point.
There's a lot of other options e.g. you can also use duplicate modules, customise modules for different drivers, or even have no modules and simply enter the forecasts as amounts (just add a category to the Revenue (For Ledger) module. I just kept it very simple with slight customisations to two library modules.
One thing I would caution using this method is to watch out for the linking when creating new categories and modules.
Hope that helps.
Jun