cloud broker – Cooper Mann Consulting

May 13, 2014March 26, 2019

QuickBooks and Dropbox? Yeah… no.

Having your data available from anywhere is awesome. Storing files in the cloud and being able to sync them with files on the computer is a great way to make sure the files are centrally available regardless of which machine you use to access them with. Dropbox is among those favored solutions which provide users with the cloud drive storage and an ability to seamlessly sync those files to various computers. It’s pretty cool, but let’s face it: not every type of file loves living in a Dropbox or sync folder. Particularly for folks who want to be able to store and sync their QuickBooks and other business files to the cloud, there are a few things to be aware of when using these nifty sync solutions.

A file is not always just a file. What do I mean by this? Well, there are lots of different types of files an application might store and use, and not all of them work the same way. For example, Word documents are files that only one person can actually work on at a time – there’s no actual “multi-user” functionality when it comes to a Word doc. You either get the file in a state that allows you to make changes to it, or you get it in ready-only mode. Document files like this – Word docs, Excel spreadsheets, PDFs and text files – work great with sync solutions. This is because the type of file being sync’d is designed to allow only one person at a time to have it open and editable. You sync it to your computer, work on the file, and then sync it back. It’s pretty straightforward.

The file that isn’t just a file is a database – a file or series of files that make up a complete data set, and which have some type of database manager or other framework keeping track of things. It’s this type of solution that often has problems working in a sync folder or system. An Outlook data file (a .PST file) is a type of file which fits into this category. While the Outlook file isn’t generally viewed as a multi-user data file or a database file, it is being communicated with and written to by various processes while the application is running. There is information being added to the file as emails are received, even while the user may be writing an email or entering a calendar appointment. The point is that there are multiple types of data elements being updated all the time and by various processes. This type of file is always in use and getting changes, so there really isn’t a point in time when it’s closed and available to make copies of, which is what has to happen for a proper sync. And, because the sync solutions often try to sync incremental file changes, there is a big possibility of ending up with a damaged file because some changes were properly written where others might not be, ending up with file conflicts and corrupt data.

A QuickBooks company file is also a database file, so the same issues around syncing an Outlook data file exist with QuickBooks. When the QuickBooks software is open and a company file is being worked on, the file may get incremental changes throughout the work session. As each of these little changes happens, the sync program may attempt to copy those changes to the file in the cloud. Because the QuickBooks file is constantly being updated, the attempt to incrementally sync updates to the file in the cloud can easily cause damage and corruption to the file. Folks who have attempted to fake a sort of multi-user access to QuickBooks data files by using Dropbox or other sync services quickly find that the system isn’t going to work for them that way. Further, they often find that the QuickBooks data files can get pretty screwed up trying to manage the live company file in this manner.

The only way to use QuickBooks, Outlook and similar types of data files with Dropbox is to recognize that the sync folders are only viable as a backup storage location for the files, not the place where the actual, working data files can be stored. If using an application such as QuickBooks, businesses should store the “working copy” of the file in the documents area on the machine, and then backup or copy the data file to the sync folder periodically. Placing the backup files or file copies in the sync folder allows them to sync to the cloud, storing them as offsite backups in case you need them, and allows the file to remain where it can be used by the application.

Businesses who need access to QuickBooks applications and data from different computers or locations may want to consider checking out hosting services as an alternative to a sync solution. Hosting solutions can help businesses get their software and data available anytime, anywhere either from their own PC or from a secure environment so they can access their QuickBooks applications and data from any Internet-connected device.

When a company wants to keep backup copies of their information in the cloud, a sync service might be an okay solution. For folks who need to be able to access a live file and applications from a variety of locations, or if multi-user access is required (especially if those users are in different locations), then a full hosted solution might be the better answer. Hosting the applications and data in the cloud is a great way to get the company connected, and it’s a far better alternative to pretending the system can be multi-user when it really can’t.

jmbunnyfeet Make Sense?

February 4, 2013

Lean and Mean – Improving Sales and Distribution Performance

It is surprising that, even in this world of Internet marketing and online commerce, many businesses are operating at levels far below their potential. Reliant upon people rather than information and process, these businesses are weighted down by their legacy approach to getting things done. They throw money and personnel at the problem, adding more “fat” to the business and making sustainability just that much harder to achieve. The right approach, and the mantra of all manufacturers and distributors, should be to work “lean and mean”, applying technology and business principles which support agility and improved process efficiency.

The center of lean business is in operations, and includes all aspects of the “order” processing and support systems. From the point where an order is sought, to the point of order entry, and through to delivery and service – all aspects of the operation must be addressed for the business to achieve maximum success. Innovating in operational areas, such as in order management and distribution, can help the business rise above others in the market and create a significant competitive advantage.

What becomes challenging for many businesses is the fact that years of working in established “silos” often makes it difficult to introduce the cross-functionality necessary to support lean operations. It is not sufficient to simply suggest that the organization work collaboratively to streamline processes from order through to service and support. Work groups and team members must work together and adapt to delivering process improvements, following through with the actions necessary to turn the philosophy into bottom line results. Good support is required to keep customers, and a good product is necessary to support increased sales. No aspect of the operation stands alone, so each is necessary to participate in making end-to-end improvement. Additionally, back-office processes must be aligned to work collaboratively where required, supporting efficient operations rather than creating unnecessary bottlenecks or delays.

The key to developing a lean and mean, high performance operation is applying the technology and principles which translate into improved profitability and customer retention. In many cases, the same solutions which create customer “self-help” capabilities are also solutions which can address similar needs for internal business users. Ultimately, the goals are elimination of redundant or error-prone processes, establishing the sharing and secure collaboration of information throughout the organization, implementing integrated systems which allow users to efficiently perform their particular tasks, and working cooperatively with others in the supply chain to maximize the real-time capability and efficiency.

Rather than continuing to utilize basic record keeping solutions, or accounting products which aren’t prepared to address the specific operational aspects of the business, owners and managers should be looking to the tools and solutions which will help them develop the framework to support improving operational performance, turning people knowledge into sustainable business profitability.

Make Sense?

Accountants and Small Manufacturers: Getting in Front of the Ball

October 18, 2012November 15, 2019

Accountants and Small Manufacturers

Getting in Front of the Ball

There’s a lot more to accountability in a manufacturing or inventory-based business than simply keeping track of money in and money out. Particularly in an economy when nobody can afford to build or stock products too far ahead of demand, it is essential that these businesses have a means to not only track and manage purchasing, manufacturing, distribution and stocking activities, but to understand conditions or trends which impact the flow of materials and cash through the business. Further, this understanding must come in a timely manner in order for the business owner to make decisions and take action when it matters most. Unfortunately, many business owners find themselves “behind the ball”, constantly pushing to make forward strides, and often due to not having the information they need to make business decisions that matter now, today.

Why is it so critical for these businesses to have more and better information to help them make strategic decisions and answer daily operational questions? In a word: connectedness. The Internet has truly made the world smaller when it comes to participation with even the smallest of local businesses. Globalization of markets has impacted manufacturers in significant ways, and these businesses (like so many others) must now be prepared to address the realities of global supply chains, outsourcing, and a remote or mobile workforce and market. While many of the software solutions addressing the functional business requirements of manufacturing and inventory or warehouse management are “locally implemented” solutions, extending and integrating these solutions to address the new global and mobile paradigm may represent a significant expenditure in time and resources for the small enterprise.

Application hosting and web-based solutions have emerged to help businesses address the need to “modernize” legacy applications and enable greater levels of system management and access. Introducing the applications into a centralized and remotely accessible environment allows the business to immediately deliver the necessary support for remote work and mobile access, and positions the system to facilitate collaboration within the business and with outside participants, such as outsourced bookkeepers, accounting and finance professionals.

These professionals can be instrumental in assisting their clients manage the change to new collaborative computing paradigms. Where accounting was previously viewed as an after-the-fact process, accountability through detailed activity tracking and reporting is now a focus which begins at the front end of the business, and accounting professionals are finding far greater value in helping structure and manage this daily activity in order to deliver greater operational information and insight. Rather than being the last people to know what is happening in the business, accounting professionals are recognizing that their ability to positively impact business performance requires getting “in front of the ball”, initiating process structure, data control and collection which ultimately results in better and more informed decision-making through better and more timely access to more meaningful information.

Businesses at all levels are realizing that new computing paradigms can ease the burdens of collecting and sharing information, yet most small companies need help in determining exactly how to approach this “enabling” of the business and systems. While accountants are also experiencing dramatic change in how they do business, it makes sense for them to embrace the opportunity and recognize that enabling client systems will ultimately allow the accounting professional to work more closely and to deliver more tangible value to their client on an ongoing basis. Online accounting approaches are no longer a fad but are the new reality supporting how many bookkeepers and accountants work with their business clients. Extending access beyond accounting and bookkeeping systems, and incorporating support for operational and line-of-business solutions, is the next step which will bring the accountant closer to the client business, and position both to benefit from deeper collaboration and useful insight.

Make Sense?