This article is relevant if you are not satisfied with NetSuite’s built-in Financial Statement report writer to create Balance Sheets, Income Statements / Profit & Loss, and Cash Flow Statements and you wish you could instead just use Excel without difficulty.
NetSuite’s Financial Report writer works generally well. However, for many organizations, it simply does not offer enough flexibility. In contrast, Excel is the ultimate tool for flexibility. Yet, you can’t easily get to your NetSuite financial data in Excel. Until now!
- Rigid Titles: The account description always starts in the first column on the left. What if you want it to be in the middle?
- Relative Date Columns: What if you want a rolling 12 month income statement with the current month at the far right and the previous 11 months to the left?
- Multiple Budget Displays: What if you want to display two budget scenarios against your actual performance?
I can go on. The point is, when you need to get control over what you want to do, an accountant’s instinct is to first think Excel.
NetSuite’s Enterprise Reporting (ODBC) is only Half the Solution
The general response to the NetSuite reporting challenge is to get connectivity to your data through NetSuite’s ODBC add-on. This is a good start but the way information is organized is excellent for operational or management reporting — and this works well with common third party reporting tools (insiders call these “banded report writers”) such as Crystal Reports or even Microsoft Access.
But when it comes to Financial Reporting, you need something different from a “banded report writer“. You need a tool with the flexibility to understand a Financial Row and Financial Column and and mechanism to assemble these constructs into meaningful formats (e.g, an income statement).
Example tools include Microsoft FRxÂ or Infor F9. But to get these financial report writer products to work, they need information in a specific, proprietary format. Unfortunately, these formats drive you to start a project which often looks like building a data warehouse.
We worked with a client that desperately needed superior financial report writing capacities. While they possessed NetSuite’s ODBC and they had in-house Crystal Report skills, building a financial statement was a challenge. Their preferred format was Excel. We worked together to evaluate tools to produce a solution.
- You will learn that you need to extract data out of NetSuite on a regular basis into a target database repository that your financial reporting tools can read.
- You will need to setup IT infrastructure — somewhere, by someone.
- You will need to maintain and monitor the data extracts and loads — daily.
- Your reports will not be real time. When you make a journal entry in NetSuite, the change will not reflect in your report until the next scheduled data load.
In my mind, this is all going backwards — aren’t these some of the reasons we adopted NetSuite? We want ease of use, real-time, and no IT. Â Let’s avoid all this if we can.
The Excel Financial Reporting Solution
While in good faith on the journey to build a “traditional” solution, sure enough, many technical risks emerged, and different technology offerings were evaluated and explored. We had to pull back a number of times resulting in waste and dissatisfaction.
Finally, the client found a product by a firm in the United Kingdom that was under development but not ready for general release. For the last decade, the firm, Solution7, had brought Excel based financial reporting capacities to a number of old-school client-server accounting packages. And Solution7 was now seeking to extend its expertise to the NetSuite platform.
Formula Based Excel Financial Reporting
If you are an Excel user, you will find this extremely intuitive. Which means every accountant and analyst will be right at home. Our client has saved at least 16 hours a month in financial report generation moving to SmartView.
SmartView leverages the NetSuite ODBC connection and an Excel Add-on. The tool connects Excel, in real-time, to your NetSuite system through simple functions:
- NSGLATITLE (account): returns the account name.
- NSGLABAL (subsidiary, account, from period, to period, class, department, location): returns a balance.
- NSGLABUD (subsidiary, budget category, account, from period, to period, class, department, location): returns a specific budget balance.
These three new Excel functions form the basis of producing any type of Financial Report (e.g, Balance Sheet, Income Statement / Profit & Loss, and Cash Flow Statement) so long as we are referencing general ledger actual and budget buckets.
But more is offered making Excel a powerful reporting and analysis platform:
- Draw lists and tables from account information using account masks.
- Drill down from any balance into a list of underlying transactions with link back to base NetSuite transaction.
- Detach the formulas and save the values to distribute to anyone without SmartView.
Compared to the any NetSuite financial reporting alternative on the market today, the pricing is very reasonable given you can solve your financial statement challenges with practically no assistance.
Download 30 Day Risk Free Evaluation
Because we helped Solution7 work on a mutual client to stabilize the product, they have offered my firm, Prolecto Resources, a promotion that I can pass to you. Â For a limited time, you can try out the software free without any financial risk. Â And, they Solution7 is offering “early adopter” pricing.
If you already have NetSuite’s ODBC module, and Excel, you are ready to evaluate SmartView. Just fill out the form below or visit our site and we will send you a link to the software.