Export financials in database format table

income statementBalance SheetdatabaseexportCash Flow Statement
8 posts / 0 new
Log in or register to post comments.
Last post
8 years ago
#1
X 0
Export financials in database format table

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

8 years ago
Michael Hutchens A+ 162

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:

  1. Are you happy if the date is always the 1st day of each forecast time series period?
  2. Does the list need to be in date order, or can it by ordered by account then date?

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.

8 years ago
Michael Hutchens A+ 162

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?

  1. Does the list need to be on an unprotected sheet for use within Power BI, or any other reason?
  2. Does it matter if the list contains formulas, or does it need to all be constants?

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.

8 years ago
Michael Hutchens A+ 162

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.