file sync – Cooper Mann Consulting

January 12, 2016November 13, 2017

Mobilizing QuickBooks Desktops

Hosted QuickBooks for Remote and Mobile Access

There was a time not too long ago when the “thought leaders” in information technology said that the desktop is dead, and all software will be accessed via the web. (Note: I put “thought leaders” in quotes because industry thought leaders are often those with the greatest media influence. After all, you can’t lead them if you can’t reach them, right?). The whole no software thing is a dramatic oversimplification of what is happening with computer software, but one thing is kind of coming true: nobody wants to be tied to their desktop. It’s not that the desktop is dead… it’s just not all there is. For users of the desktop editions of Intuit QuickBooks software, the question really isn’t whether they intend to give up their familiar and trusted software to use a different, online solution. The question is how to use the QuickBooks desktop software they want in the cloud so they can use it on desktops that aren’t the primary desktop computer, or on mobile devices.

Computing technology has finally reached a level of accessibility that was previously only imagined in science fiction stories. Communicating instantaneously with anyone anywhere around the world; accessing extensive (limitless?) libraries of information, art and music with a simple handheld device – these are the things that people do every day without a second thought. Business users may even be able to access their business documents, email, contacts and appointments etc. from mobile devices, enabling a productive and functional mobile workforce.
Yet the desktop remains as the primary workhorse for most business users. This is where the productivity applications live, where large spreadsheets and full-screen applications are run, and where keyboarders and production data entry users operate. Tablets, touchscreens and mobile devices just don’t provide the same capabilities unless you tether them to full size monitors and keyboards. Even then they may not because they might not run the same OS as the desktop. The point is that the desktop hasn’t gone away and isn’t likely to any time soon. Users may use more mobile apps and devices, but this isn’t diminishing use on the desktop as much as it augmenting it. This is what fuels the interest in application hosting and virtual desktop computing models – the desire to mobilize desktop and network applications and working environments.

Hosting applications and data gives businesses the flexibility of working in desktop applications and accessing data just as if they were in the office, yet users may be located anywhere there is Internet connectivity. When the applications and the associated data are managed in the datacenter, businesses are able to centralize their information assets and manage them more effectively than if the data were distributed among multiple computers. While most sync and share solutions require files to be downloaded to local computers in order to open and edit, a hosted application service with virtual desktops and file sharing provides a security model which keeps business data secure yet available for user access without compromising security by downloading information to the user device.

A hosted solution approach can make license utilization more efficient and compliance easier to maintain, too. By enabling access to applications on a centralized platform and eliminating the installation and maintenance of software on individual computers, businesses reduce the reliance on local IT personnel to install and update applications and user accounts, and improve their ability to control application assignments and usage.

Hosting helps businesses take advantage of technology that would otherwise be unaffordable, and delivers the mobility and centralized management required to boost productivity and contain costs. There is a high cost to managing a business network, and creating secure mobile access to that network can represent an exponential increase in IT spending (just to initially set up, not to mention ongoing costs for security management, monitoring and support). Rather than taking on the entire burden of service management and delivery directly, businesses electing to work with hosting providers find that they are able to focus more on business operation, strategy and growth – and spend less time worrying about the IT supporting them. Costs are reduced, workers are empowered, and capabilities are increased while knowledge and process investments are preserved. When it comes to mobilizing business applications like QuickBooks desktop editions, it all starts with a hosted approach.

Joanie Mann Bunny Feet Make Sense?

July 16, 2014April 20, 2017

Accounting for Point of Sale

There are a lot of solutions available to help retail businesses get business done. From touch screen technology to mobile credit card and payment processing, retailers have many choices when it comes to selecting the right technology for the establishment. But even the best point of sale system can lack the critical element that makes it truly valuable for the business. This critical element is integration to a trusted accounting and finance solution. While the POS system may include a level of basic accounting functionality, the reality is that a dedicated financial application will perform better in the long run.

Just as specialized line of business applications are used to handle operational functions, the financial application should be considered to be the “line of business” solution for the accounting and finance department (even if it is a department of one). This system not only services essential processes like receivables management, bill payments and bank account reconciliation, it serves as the basis for payroll, financial, tax, performance and other reporting. Further, the financial systems are often the first and primary source of analytical data, illuminating KPIs and cash flows and ultimately the business value.

The point of sale application generally handles the selling of and payment processing for goods and services sold by the business. Whether it is composed of registers and terminals connected to a host system, PCs running POS software, or mobile phones and tablets running mobile payment processing apps like Square or GoPayment, point of sale addresses the retailers need to capture and record sales and payment information, sometimes customer information, and often inventory information.

The data from the POS solution must make it to accounting in some manner, yet point of sale applications are too-often approached as a standalone business requirement, somehow disconnected from other aspects of the business including the back-office. Sales and items may be recorded in the POS system, yet only summary sales data ends up being re-keyed into the accounting system. Centralized inventory management is all but nonexistent in these cases, and gross sales total are often recorded rather than individual transactions and receipts being transmitted to the accounting system. The process of re-keying information from the POS to accounting systems is not only an efficiency-killer, it is also introduces a great potential for errors. When the business elects to conserve on data entry and post only summary information to the accounting system, valuable detailed sales and transaction data may be lost.

The right approach to bringing point of sale together with accounting is to automate the process of integrating POS data with accounting on a regular basis – with AUTOMATION being the key. Rather than establishing a process that requires manual entry of information from either system, a data integration solution is the best approach, with an import/export solution running second. The point is the elimination of manual re-entry of information.

There are numerous tools available that can take formatted POS data and import it into products like QuickBooks, for example, where it can be properly accounted for. While QuickBooks Point of Sale integrates with QuickBooks desktop products, other POS solutions can also connect with QuickBooks if the right integration tool is selected, and there are quite a few available. Check with the POS vendor and ask about a direct integration with QuickBooks desktop or whatever financial system you use. If there isn’t a packaged integration solution available, then check out products like Transaction Pro Importer, which can automate a variety of data import processes and ease the burdens moving external data into QuickBooks. pointofsale

The other factor in getting point of sale data to accounting is actually getting it there… transporting the data from the POS location to where the accounting system lives. In many situations it is not desirable to keep the accounting system on the same computers as the point of sale systems, and in some cases it isn’t even possible. But there is generally a way to get the information in a form that makes it possible to transmit it in some manner. Among the most popular approaches to solving the “getting the POS data from here to there” problem is to use a data sync solution like Dropbox.

If the point of sale data can be exported or output to a file on a PC hard drive, then it may be able to be stored in a Dropbox folder on that PC. At the home office where the accounting system resides, the operator would access the sync’d files from the local PC Dropbox folder and import the data to QuickBooks. For QuickBooks Point of Sale there is an option to create a “mailbag” of sorts from the POS data of a remote store, which QuickBooks POS at the home office would pick up from the Dropbox folder and push to the QuickBooks financial application.

For businesses using POS systems like Micros or POSitouch and others, there is likely a service or application that will produce the POS data for import to QuickBooks or other financial system, pulling POS data files placed in the Dropbox folders by the POS app or performing the function as a web service or SaaS integration.

While I am a big fan of application hosting services and running QuickBooks desktop editions in the cloud, I’m also a realist and recognize that many POS solutions either can’t or shouldn’t be hosted. There are situations where a hosted point-of-sale makes a lot of sense, and then there are cases where no bandwidth or proprietary hardware-based solutions make hosting not even an option. That doesn’t mean that the financial systems shouldn’t be hosted, though, and there are numerous ways to get the sync’d POS exports to the hosted QuickBooks environment, for example.

The key for retailers is to make sure there is a solid process for getting detailed and accurate POS information into the accounting system on a regular basis. Manual entry is never the best answer. With all of the technology and tools available, manually re-entering sales information is a waste of time and is likely to produce errors. The better answer is to use an approach that automates the regular collection of point-of-sale data from all sources, delivering the data in a regular and consistent manner to accounting, and providing the basis for end-to-end automation supporting the integration of the point of sale system data with the rest of the business accounting.

jmbunnyfeet Make Sense?

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?

August 6, 2013April 25, 2019

The Most Popular Models for Working with QuickBooks Desktop Editions and the Cloud

cloud-computing When Intuit created the Authorized Commercial Host for QuickBooks program, a variety of providers were enabled to offer not only managed application hosting services for QuickBooks desktop products, they were also permitted to provide QuickBooks desktop product licenses for rent. By allowing these hosting providers to also license the QuickBooks products on a subscription basis, the entire solution – the hosting of the QuickBooks, the management of the company data files, and the licensing of the software – was able to be packaged together and offered as an equivalent of the SaaS solution. The benefits of running tried-and-true business applications on the business network had already been proven, and creating the ability to access this resource at any time and from anywhere (mobility!) became the feature which encouraged a wide variety of large and small business to move to “cloud” and online working models.

While the complete hosted application model – where the business desktop applications and associated data are installed and managed on the service provider servers – addresses a broad requirement for many companies, there remains a large community of users who have needs which do not extend to “cloud server” or remotely hosted desktops and complete managed application services. For these users, having access to the data file from anywhere is the primary goal (maybe even multi-user access for just a couple of users), and management of the software and license across multiple computers is not their first consideration.

Here are the most popular models for working with QuickBooks desktop editions in/with the cloud. Each of these approaches solves a different business problem, so it is important to understand which problems need to be solved before shopping for the solution.

1. Storing the QuickBooks file in a file sync solution

Solves: gives access to the data file from various locations (not at the same time)

Doesn’t solve: no multi-user access in real time, still have to purchase QuickBooks licenses, install and manage applications, and secure and backup data

The popularity of Dropbox and similar file sync solutions clearly demonstrates the value of giving users the ability to store, sync and share files securely via the Web. Further, these services allow people at different locations to access files in a relatively collaborative manner, giving otherwise disconnected users the ability to sort of work like they’re on the same network and using the files in near-realtime. While this approach works awesomely well for Word documents, PDFs and other files, it doesn’t work as well for QuickBooks company data files. It’s pretty much an automated approach to using a file storage solution (like any web drive, file share service or such). To clarify, users can store copies of QuickBooks company files in a Dropbox or sync folder to have that file sync’d to the host and to other permitted computers, but a “live” QuickBooks data file doesn’t like living in this type of folder. The sync or file sharing method of applying a cloud solution to QuickBooks allows for only one person to be in the “real” file at a time, and each user still has to purchase, install and manage the QuickBooks software on their PC. Oh, and bandwidth will become an issue when files must be sync’d frequently and when the files are fairly large (which QB files tend to be).

2. Using secure remote access to QuickBooks, remote desktop or remote app solution (like hosting, but the host just happens to be an on-premises computer already in place)

Solves: gives access to the file and applications from various locations, allows for multi-user access to company file, allows access to just QuickBooks or any combination of applications on the host computer; low-cost solution providing mobility and device independence just like commercial hosting but at a fraction of the cost

Doesn’t solve: have to purchase QuickBooks licenses, install and manage applications on the host, and backup data

Secure remote access solutions like MyQuickCloud allow users to connect to applications that are installed on existing workstations or servers. This approach provides users with access to QuickBooks and other software installed on the in-house computer. The problem with this model is that the bandwidth and the in-house computer need to be sufficient to support remote users, and the activities of the user sitting at the in-house computer will take priority over the remote user requests.

3. Using a hosting provider and/or platforms for QuickBooks, remote desktop or remote app type of solution

Solves: gives access to the file and applications from various locations, allows for multi-user access to company file, may allow for rental licensing of QuickBooks software, files are backed up by service provider

Doesn’t solve: commercial hosting is not a very low-cost solution for those who only need file sharing

Application hosting models allow users to connect to servers where the applications are installed and managed by the service provider and delivered to customers as subscription service. This approach provides customers with flexible options for accessing QuickBooks software installed and maintained on the host’s servers, and to have the multi-user capabilities of the product just as it would function on a local network. Application hosting models are generally offered as standardized service or as custom service, with variable pricing and features associated with each.

Because these hosting models require that all components of the delivery be combined to deliver the service – from networks to servers to desktop virtualization to application virtualization, application licensing, data management… it’s a big list of things – the cost of service may seem a bit high for a single user or very small business to bear. This is among the reasons for continued popularity of do-it-yourself remote access solutions that deliver mobility but fail to address any sort of system management benefit.

When business users ask about using their QuickBooks desktop editions in the cloud, it makes sense to drill down into the details of what they’re really looking for. In many cases, the QB user simply doesn’t know how to ask for what they want, using popular terms without real understanding of what they mean. This is something which frequently happens when a prospective customer contacts a QuickBooks hosting provider, and the sales department of the hosting provider isn’t generally in a position to offer consultation – they are there to sell their solution to the prospect. The result is that the customer doesn’t really get what they want, and the provider gets a bad review.

The problem isn’t necessarily with the provider or service (I wish more sales teams were able to offer more consultative approaches, but that’s an entirely different conversation); the problem occurs largely due to the variety of services being offered around “cloud QuickBooks” and the ambiguity which exists in much of the marketing language around them. Maybe this information will help businesses as they look to find solutions to the variety of problems with “enabling” their desktop QuickBooks to work with the cloud.

Joanie Mann Bunny Feet Make Sense?