Customisation of Modano

VBAImport AssumptionsAPI
2 posts / 0 new
Log in or register to post comments.
Last post
6 years ago
#1
Vitaliy Pikhtin A+ 0
VP
Customisation of Modano

Hi All, 

I have reviewed all notes and tested different templates available in the Modano library, however I cannot find notes or tutorials providing guidance re the following customisation:

  1. How to upload the opening Balance Sheet and actual Trial Balance accounts into Modano spreadsheets directly from an accounting database using MS queries. 
  2. How to properly combine customised VBA codes to meet different in-house accounting requirements without breaking consistency of the Modano codes.
  3. Michael mentioned that a new Modano update will release the API and Consolidation % Intercompany functionality, how far is that away from now (it will definitely open a lot of doors to us as modellers)?

Thanks and regards
Vitaliy

6 years ago
Michael Hutchens A+ 189

Hi Vitaliy,

Sorry for the belated reply, things have been crazy this past week!

Going forward, can you please post one topic per post, as grouping them into multiple items in a list in a single post makes the forum much harder to search and filter. Also, if you'd like immediate support from our team, you can always buy support credits and request support via the Support section of your Modano account (www.modano.com/account/support).

With regards to your questions:

1. How to upload the opening Balance Sheet and actual Trial Balance accounts into Modano spreadsheets directly from an accounting database using MS queries.

Personally, I've never used MS queries, so I'm not best placed to speak about them. However, I can say that the Import Assumptions tool is designed to provide for the easy importing, mapping and reconciling of financial statements data from either an Excel worksheet, Xero or QuickBooks.

Modano does not currently support directly importing into module component assumptions, but there's nothing stopping you either:

  1. Inserting a freeform sheet and using things like MS queries to import into ranges within this sheet, before importing into module components using the Import assumptions tool or entering formulas into assumptions cells or using freeform formulas; or
  2. Writing VBA macros to automate the importation of opening balance sheet assumptions.

We regularly help clients to both of these things as workarounds to get data into historical financial statements efficiently.

2. How to properly combine customised VBA codes to meet different in-house accounting requirements without breaking consistency of the Modano codes.

VBA can still be used to do things within module components such as goal seeking, clearing or entering assumptions. It can also be used along with the API - which we haven't released yet publicly but can show you via support credits if you'd like to see it - to do all sorts of things like add categories, etc.

Here's a couple of examples of modular workbooks containing VBA:

3. Michael mentioned that a new Modano update will release the API and Consolidation % Intercompany functionality, how far is that away from now (it will definitely open a lot of doors to us as modellers)?

We have developed the Modano API and have been using it while supporting clients for 6 months, but not yet released it because it will require documentation prior to its release.

You're more than welcome to purchase some support credits and one of our team will provide you with a pre-release version of the API and provide you with an overview of how you use it.

Bear in mind that, while the API is really cool in what it can do, it's not something that our Implementation Team experts rely upon much because it shouldn't be necessary in most cases if modular workbooks are built correctly.

I hope this helps!