Hi
I have only just started using Modano and already see massive benefits. I was able to build a 3-way model in hours (that is with me fumbling around) as oppose to weeks or even longer. Even using a standard such as FAST modelling there is really no comparison to this, so thank you Modano team.
My question is how would you create a module that would simply create the financials across P&L, Cash Flow and Balance Sheet into a database friendly table.
E.g. the Fields may look:
Date | Account | Amount
With information running down the page. Historically I have done this using VBA but wary I do not want to break/interfere with the Modano module structure. If using VBA is the solution then I'm ok with that just some pointers so I don't break the workbook.
The purpose is to use in this with BI reporting software.
Thanks
Josh
Hi Josh,
Thanks for the feedback, it's great to hear that we're faster than FAST. ;-)
As you can imagine, there are quite a few ways of doing what you're after here. Personally, I always take it as a challange to do it with minimal or no VBA, and in a way which is scalable as the model evolves over time.
Based on your comment, all you're looking to do here is convert the P&L, BS and CFS - which are structured as categories across multiple time series columns - into a list in a range of rows with 3 columns (Date, Account, Amount). Is this correct? And if so:
Also, can you provide an example of a standard Excel spreadsheet which contains such a list, so we can check it out.
I'd imagine this is something a lot of people would use as Power BI becomes more commonly used.
Thanks Michael
I've attached a file I've used for a current client (the modelling was done not using Modano), I've removed the confidential information. It has a few more columns as I have done department budgeting for this organisation (how to do that I realise is a new topic so I'll read the forum and post a separate question if I can't find the solution), but you should see the general flavour of what I am attempting.
Thanks
Josh
This is great, thanks for sharing Josh.
So, just to be clear, the order of the data doesn't matter, and it also doesn't matter if the date for each record is always the first (or last) day of its time series period in the forecasts?
Also, a couple more things?
Sorry about the large number of questions, I'm just trying to narrow down the limitations as there are a bunch of ways to do this.
Thanks, M.
Right, some answers:
Just another point, depending on what business intelligence solution is being used (Power BI, tableau, etc.) I often export the output to csv file for maximum compatible, this can be covered as last step. This can be hanlded via VBA (i know that is a dirty term).
Thanks Josh
Just wondering where this is at?
Thanks, Josh
Hi Josh,
I'd love to show you how I would do this, but I've been sucked into a couple of large projects, so I'm not realistically going to get a chance for the next few weeks.
If this is time-sensitive, purchase a support credit via the Support section of your account (www.modano.com/account/support) and submit a formal support reqeust. The Modano support team will then give you a response within 24 hours.
Cheers, M.
Thanks Michael
I only just realised you are the CEO, thanks for taking time. It is not a top priority so I will just keep plugging away at it.
Cheers, Josh
Hello Modano,
Is there any update on this front to get Modano data into a database or query to use in power query?
Thanks.
Just commenting on this - I use a freeform page which lookups up from the IY report outputs.
This gives me each line of the Business Unit Financials by month. I can then create keys / helpers to allocate and classes. It is this sheet I then target with Power Query.
For this to work however I have to:
We are implementing NetSuite so what is really cool is I have the data automatically updating for historical and then automated publishing of forecasts for the team to review.
One of my challenges is getting information into a Dollars per Tonnes view. This is very tricky as I need each business unit tonnes to be accurate for this to work. I'd share an example but as you can appreciate fairly sensitive information