Creating unit level P&Ls in excel with SuiteAnalytics Connect
Happy Monday all,
I work in the Finance department of my company and have been tasked with revamping/revolutionizing reporting. Currently, we use the standard reporting templates offered by NetSuite. Personally, this is my first time using this environment. I was spoiled by the robust reporting capabilities and flexibility provided by Hyperion Essbase.
Ultimate goal is to produce store level P&Ls, executive/board reporting, etc. I personally prefer creating reporting templates in excel that will allow me to pull in data behind the scenes while populating the more organized, consumable reports. A typical report would contain selection menu (location, month/period, etc), the actual report tab, and a hidden tab that pulls in the data from SuiteAnalytics Connect or any other data warehouse offered by NetSuite.
Anyone else doing something similar?
We have a few customers using Solution 7 which is an excel addin that makes financial reports using the ODBC connector simpler.
do you happen to know the cost of the service?
HI, There is an option of making NS reports available as web queries, through which you can connect the standard NS reports with Excel or PowerBi.
You can look into this tutorial for help
thank you
Probably late to answering this question but I would argue revamping/revolutionizing reporting isn’t possible within the confines of NetSuite. Per your note about Hyperion Essbase, there are modern analytics stacks that can be implemented quickly and cheaply that would outshine even Hyperion… a modern analytics stack using Sigma Computing / Distilled Data / Snowflake would take any SMB company from a house of pain to data heaven as quickly and inexpensively as possible. A data lake is typically the next evolutionary step for any company running into the limitations of their ERP system. Here are some case studies http://mondoanalytics.com/casestudies and feel free to ask any questions if you them… My 2 cents anyways.
thank you, will take a look