How Can Your Small Business Start Using Analytics With Your Financial Accounting System?

How Can Your Small Business Start Using Analytics With Your Financial Accounting System?

Data analytics is a huge deal right now, and most small- and medium-sized businesses (SMBs) agree that delving deeper into their own financial accounting business information is a requirement for success.

The good news is that although most SMBs don’t have significant resources to dedicate to mining Big Data, they can get more insight out of the data they already have without specifically paying for this kind of effort.

The need for improved business analytics is one of the primary drivers that SMBs consider when upgrading their enterprise resource planning (ERP) financial accounting software. QuickBooks and spreadsheet systems work great for a while, but they aren’t powerful enough to provide the insight and business intelligence that most companies need to stay ahead of the competition in today’s landscape.

In addition to a general need for more and better information, there seem to be two specific business scenarios that drive companies to invest in new financial accounting software, and thus small-scale analytics capabilities.

For starters, growing SMBs frequently have two or three companies they’re managing. Often, each of these companies uses QuickBooks, which means the parent company may have three separate sets of QuickBooks to manage.

The companies in this scenario can’t consolidate the data quickly or efficiently enough to perform timely analysis. Remember, without advanced software, consolidation can only occur by exporting the data to Excel, and then merging the companies’ data into a giant spreadsheet. This process can take hours, even days, just to get the information in one location.

The second most common reason that SMBs need analytics is that they’re operating multiple types of applications to help run their businesses, and none of these programs are compatible with each other.

In today’s world, most business applications needed to run a company are siloed. For example, if a company were running as its customer relationship management (CRM) solution, or using Excel or a database to keep track of customer information, then to manage its accounting efforts it might use QuickBooks or some other kind of spreadsheet system. Finally, if it were selling products online, it might run an e-commerce solution to manage the effort.

Suddenly, a company has three independent applications to keep financial data, and none of these programs can talk to each other.

Many SMBs may take in as much as $1.5 million annually, but by running all these incompatible applications, they’re missing opportunities. They have no ability to analyze customer data in terms of billing, e-commerce, inventory or a hundred other indicators. Essentially, they’re flying blind. They have multiple applications keeping the business afloat, sure, but they can’t actually view the data and make strategic decisions about the future.

This is a huge loss for companies. Performing analytics on their financial data — including closes and trends — is where they’ll discover their best value and greatest insights.

So how does a small business begin to incorporate analytics? Assuming it has a powerful financial accounting system, where should it start?

First, financial data should be the anchor of a company’s analytics efforts. Financials contain the most important customer data, including receivables. They house contact information, billing, purchase orders and everything related to how a company interacts with its customers. This kind of data is in an accounting system. In other words, the most important first step for quality analytics is to invest in a quality accounting system.

Second, be sure to incorporate and analyze customer information by purchasing a CRM system that salespeople will actually use. Unfortunately, most companies won’t use their CRM system to facilitate business transactions and so salespeople aren’t inclined to really get the most out of the application.

To find one that will actually benefit the company, compile a list of the information or key performance indicators (KPIs) that will drive success in the business. What does that data look like — is it customer or inventory data?

Next, identify the location of the data that you’re trying to access. Is it housed in one financial application or in multiple applications? Is all the data in a separate system or just a spreadsheet? Is the business built around an e-commerce billing system? Where’s the data today?

Once you know the information you need and where the data’s located, figure out how to get the information out. Remember, if your company is running QuickBooks or just using spreadsheets, it’ll be difficult and time-consuming. It’s better to find a system that can better provide access to the needed data.

Performing data analytics is one of the most important things that an SMB can do. And fortunately, investing in Big Data isn’t a requirement to collect quality insights from the data the company’s already generating. The key is to invest in a quality financial accounting system.

No Comments

Post a Comment


This site uses Akismet to reduce spam. Learn how your comment data is processed.

Steve’s been with SMB Suite since 1998 and has been involved with nearly every aspects of the Company’s business as a strategist, professional services executive, cloud solutions architect, and senior consultant. In his current role, Steve is responsible for SMB Suite’s revenue and oversees the execution of ERP, CRM and BI projects for customers across a broad range of industries. Steve combines his expertise in MS Dynamics GP, CRM and other Microsoft products with a strong foundation in accounting and business to identify gaps and streamline customers’ processes. Prior to co-founding SMB Suite, Steve was previously Corporate Controller for MEHLE Behr and, prior to that, Audit Senior for Ernst & Young. Steve holds a Bachelor of Business Administration degree from the University of Texas at Arlington.

Jeremy is responsible for SMB Suite’s technology vision, strategy and implementation and is the architect of the Company’s Dynamics Cloud Platform. Highly adept in every facet of managed services, ERP systems and e-commerce platforms, Jeremy’s expertise spans the implementation and support of business and financial software solutions, as well as the customization and integration of SMB Suite’s cloud ERP technology stack. He holds numerous Microsoft and industry-related certifications, and was primarily responsible for designing the Company’s progressive business services platform in the early days of the Cloud. Prior to SMB Suite, Jeremy served as the financial analyst, systems administrator, and information systems liaison for a $2 billion financial services corporation.

Monty is responsible for SMB Suite’s day-to-day operation and, most importantly, its customers. As a leader, motivator and mentor, Monty creates loyal high performance teams willing to “walk through walls” to accomplish their goals. Prior to SMB Suite, Monty served as President of The Bradshaw Group (TBG), a global distributor, manufacturer, and repair facility for digital printers. In this role, he was the Company’s ambassador to its most important domestic, European and Latin American customers and TBG achieved a best-in-class Net Promoter Score of 74 for its superb customer satisfaction. Prior to TBG, Monty served as the General Manager of Sam’s Clubs three highest grossing U.S. stores and was named Regional Operator of the Year in 1999. Monty holds a BBA in Marketing from Texas Tech University and is an active member of Business Navigators. He has been active in Vistage International, Executives in Action, the Dallas/Fort Worth Retail Executives Association, as well as, A.P.I.C.S., the leading professional association for supply chain and operations management. Monty also volunteers with Hunger Busters and ManeGait, a therapeutic horsemanship organization.

David is a proven financial and information technology professional with expertise in providing business accounting software and computing solutions. He began his career by starting and managing a successful independent consulting practice for several years. He then launched the local systems consulting unit of Ernst & Young’s Entrepreneurial Services Group, leading the office into the hi-tech consulting arena. After successfully developing the unit for Ernst & Young, David founded NextCorp (which became SMB Suite in 2013) to serve the business software needs of clients throughout the US. David has made SMB Suite one of the best cloud ERP providers in the industry. In addition to being a successful entrepreneur and leader, he is a software and technology specialist, holding certifications in various Microsoft and other technologies.