Everyday, more and more companies are turning towards Internet based solutions to manage their accounting and operating systems. IT departments are being simplified and investments in servers, routers, and storage systems are being radically reduced or eliminated. Internet (aka Cloud) based solutions provide many advantages including dedicated security experts to monitor and protect systems, guaranteed backup, minimizing downtime, and easy access to data and information from anywhere you have an Internet connection. The desktop is also being replaced with options to access information from tablets and phones and without having to install a bunch of software on every device that you use.
But moving your systems online is not perfect and comes with some new challenges. For example if your Internet connection goes down you can’t access your data. As more data is consolidated from multiple organizations into a single data center it becomes a larger target for cyber criminals. You also run the risk of logins being compromised through phishing attacks and various other pitfalls now that your data can be accessed online.
Perhaps the biggest challenge is that you create remote data silos where it can become very hard to impossible to report across all of the data an organization accumulates into these systems. The systems together may require re-entry of the same data multiple times. I.e. if you have online systems for ERP and CRM then you may find that you have to enter the customer name in both systems. This can also make it harder to align the data for reporting. Some online systems may charge you to access your data remotely or to use third party reporting tools or not allow any remote access at all. You may also experience throttling and performance delays when trying to report over a larger data set or period of time. Some systems can “talk” to each other but you have to create openings in security and share connection or login information with multiple systems to enable this. Combining online data with legacy on premise systems also makes things more challenging.
Vivid Reports Business Intelligence helps organizations overcome these challenges and to work with your data efficiently regardless of where that data resides. So long as your data is accessible it can be reported on, combined with other data and presented with Vivid Reports for easy understanding and insights.
Vivid Reports Business Intelligence uses Microsoft Excel to format and present reports but it does so with numerous advantages and efficiencies allowing you to view, interact with and understand your data securely. Vivid Reports also offers web-based viewers that take a traditional Excel report and make it accessible through a browser such as Google Chrome. All the same functionality of the desktop version are available but you no longer need Excel to view and work with the reports. The nice thing about this is that you can also view reports on a mobile device such as iPhone or Android.
But perhaps one of the biggest benefits of Vivid Reports is that it allows you to still use Desktop Excel or Office 365 – Excel (desktop version) to access online data. The desktop version of Excel is still miles ahead of the online version, especially when it comes to speed and your ability to navigate and interact with reports. Vivid Reports does this by treating Excel as if it was a browser! That’s right, just like you open Chrome or Safari to go online, you can open Excel to go online with your information! Vivid Reports does not store any of your data in Excel, it is all stored in the Vivid Database or is accessed live directly from the source. This allows you to only transfer down to your report the information you have chosen whether it be for a particular product, customer set, or period of time. Vivid Reports enables that data to flow across the Internet into Excel.
Vivid Reports CPM (Corporate Performance Management) software that provides financial reporting, budgeting, consolidations, and analysis also comes with a Vivid Database. If your ERP is online such as Dynamics 365 (D365) or Acumatica, or Epicor then the Vivid Reports database can reside in an Azure server. You do not need to have data on your local servers. The only thing that you need is Microsoft Excel and the Vivid Reports client. The Vivid Database can be set up so that it syncs with your ERP at preset times and then the data you need to produce a report or populate a drill-down screen will flow directly over the Internet and into Vivid Reports!
Today Vivid Reports is already integrated with many cloud ERP including D365, Acumatica, Epicor, Blackbaud, QBO, and other systems. Please contact us today to learn more.
Before we ever wrote a single line of code when we were developing Vivid Reports we set out to invent a new way to interface with Excel that would not be based on a formula, but would still be flexible, and most important would be secure and reliable. Even though we were very familiar with Excel, and had used it for years, we researched Excel extensively to find a better way to integrate. The unique method we created and resulting stability, flexibility and performance has far exceeded anything we could have imagined. (more…)
Graphs, Charts, Traffic Lights, Thermometers, Spinning Monkeys, you name it….
We are a visual species, and the seemingly endless onslaught of data visualization BI tools would suggest that we are becoming even more accustomed to making business decisions with the help of pretty pictures.
I don’t mean to diminish the value of these types of tools. Without question, data visualization is a great way to merge all sorts of data together from disparate sources. Until recently, it was nearly impossible to provide decision makers with access to this variety of information in a format that was easy to configure and consume.
Data Visualization tools are helpful for presentation and analysis of both Flexible and Stuctured G/L based Reporting. Unfortunately, you can’t file an Executive Dashboard with the IRS..
If Data Visualization is the Sizzle in Business Intelligence, Financial Reporting is the Steak.
Structured Reporting is often left out of the BI discussion, yet all organizations require and rely on Financial Reports/Statements.
Your management team might like dashboards, but anyone responsible for the financial performance of the organization, in addition to your Shareholders, your Auditors, your Banker, your Government and others all require accurate financial reports.
Cash Flows, Balance Sheets, and P&L Statements are not going anywhere, and the preferred format for creating them is still Microsoft Excel. Admittedly, Excel isn’t perfect… Human error, Security, Version Control, Ability to Collaborate all present challenges to growing organizations.
That is why we created Vivid Reports. We encourage you to learn how we are helping organizations manage their businesses more efficiently, close month end faster, and produce accurate Financial Reports in a timely fashion. We even built in some Data Visualization Tools (Spinning Monkeys are in Development).
In this brief article we will examine the Multidimensional Chart of Accounts. Don’t forget to download the Free Top 10 Tips for Organizing your Chart of Accounts Document at the end of this article.
Over the years we have seen a lot of Chart-Of-Accounts (COA), and some are set up much better than others. There can be various reasons for this such as change in organizational focus, the length of time the system has been used, staff turnover, and a poor design.
The intent of this article and the accompanying “Top 10 Guide” is to provide some tips based on our observations over the years related to the design that can hopefully save you time and help you get the most out of your financial reports and analysis.
COA Definition & Meaning
A multidimensional Chart-Of-Accounts (COA) is an account numbering system that has multiple segments (aka dimensions) and is typically used by a larger organization. These organizations are more complex (for example they have multiple physical locations or product lines) and need to track their Assets, Liabilities, Equity, Revenue, and Expense transactions from more than one perspective or identifier within the General Ledger. They are also, of course, running an ERP that supports this enhanced structure such as Microsoft Dynamics, Epicor, or SAGE.
A typical example is an organization, such as a restaurant chain, that has many locations. They cannot track revenue and expenses at just the account level but need to identify each transaction on a location by location basis so they can produce and analyze financial reports per location. This will enable management to know which location is the most profitable, the most expensive, has the best margins, where physical assets are located, and so on.
This basic example would require each transaction to be coded so that it identified two things: the main account (aka core, primary, object) segment and also the location number. In figure #1 below there are three segments because this organization also wants to track things on a departmental basis. This figure shows the “Full Account” (segment combinations that are used), the individual segment values and descriptions, and lastly the definition.
For additional Information Download the Free 10 Tips for creating and organizing your Chart of Accounts (COA) .
When we were designing Vivid Reports CPM we decided to go the route of a separate data warehouse layer. We are often asked why, and what we feel the advantages are. I hope this article will shed some light on why we feel a data warehouse layer provides a superior reporting experience.
There are two fundamental data access methods when it comes to reporting. You can either access the data directly at the source for “real-time” information (note only as “real time” as the data is entered). Or you can access a Data Warehouse that is updated as part of a scheduled process.
If real-time information is not a requirement (which is often the case with financial reporting) then a data warehouse offers many distinct advantages. Below are some of the major benefits of utilizing a data warehouse layer for corporate performance management and reporting solutions:
1) You can modify or enhance the data without affecting the core system. For example you could rename fields to make them more meaningful, or attach comments to information that may not be supported in the core system.
2) Improved processing speed, independence, and reducing or preventing record locking or other data access issues. Because a data warehouse is a separate database you have the ability to:
- Run the database on a dedicated server
- Index or optimize data in a way that is designed purely for reporting and analysis
- Perform calculations and store the results of complex queries and relationships
- Separate data write and read operations
3) Security and permissions can be different from the core system. This can enhance the security of the core system by having fewer logins. You can also potentially enhance security through data separation. For example the source database might have payroll information whereas the data warehouse does not.
4) Ability to combine disparate systems into a single cohesive view of information. An example would be to take the General Ledgers from two distinct ERP systems and combine them in a single database to produce consolidated financials.
5) By having a separate data layer you can often change the core system without having to upgrade the reporting system. For example if a field is renamed during an upgrade to the core system this field could potentially be remapped in the data layer of the data warehouse without having to rewrite each report.
6) You can control when data is synchronized with the core systems. Therefore you can schedule this to occur “after hours” or during periods of reduced demand on the core system. A second advantage is that you can take a “snap shot” of the data which allows you to compare updates to help identify what has changed.
7) You can usually reduce license fees when some of your users only need to view information that is captured and stored in a data warehouse versus the core system that might have much more expensive licensing requirements.
The ideal reporting solution uses a hybrid of both a data warehouse and real-time connection to the source. This can be accomplished by allowing the user to perform an “on demand” data synchronization or update of the data warehouse in addition to a scheduled update. This feature is useful when the user knows a significant or important change has occurred in the core system and wants this reflected in the data warehouse. These “on demand” updates can perform very efficiently if certain techniques are built in. One example is something we call an “incremental update”, which means the software can quickly find what has changed and therefore has very little work to do.
Vivid Reports CPM will actually generate the data warehouse for you and update and maintain the structure eliminating the burden of having two separate databases while providing all the advantages.