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? 

Rookie Asked on September 20, 2021 in SuiteAnalytics Connect.
Add Comment
3 Answer(s)

We have a few customers using Solution 7 which is an excel addin that makes financial reports using the ODBC connector simpler.

Rookie Answered on October 28, 2021.

do you happen to know the cost of the service?

on November 2, 2021.
Add Comment

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

Rookie Answered on November 9, 2021.

thank you

on December 6, 2021.
Add Comment

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 and feel free to ask any questions if you them… My 2 cents anyways.

Rookie Answered on December 6, 2021.

thank you, will take a look

on December 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor