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?