New Business Direction LLCWhat is Cloud Computing? 
By now, we’ve all heard about the subject of Cloud Computing. Working in the Cloud simply means that you are accessing servers, software and technology via the internet.
It’s something that most of us are already using on a daily basis when we access our bank accounts and pay our credit card bills online; or when we use Facebook and other social media websites.
That’s the infamous Cloud – you access it with a browser from any computer or mobile device with an internet connection and you log in to use applications that you do not own and that are stored elsewhere to retrieve your data.
Hosting QuickBooks®
Many businesses are looking for an online solution for their QuickBooks® software but are hesitant to move to QuickBooks® Online because it does not have the full functionality of the Desktop versions of the software that we’ve all become familiar with.
A great option for those who want to move to the cloud but don’t want to change everything all at once is to have their licensed QuickBooks® Desktop software hosted by an Intuit Authorized Hosting Provider.
The average cost of hosting is approximately $50/month/user for basic setup and storage space, plus the cost of the software. The following is a list of certified secure data centers with proven reliable up-times:
Many of these providers are also licensed to rent QuickBooks® licenses for currently supported versions of the software which is quite cost-effective.
Benefits 
The hosting service provider installs and manages the QuickBooks® software and the company data files on their cloud-based servers. They install the software, update it and maintain it and provide system maintenance, redundant servers, improved security, virus protection and managed data backups.
It’s the full version of your licensed QuickBooks® software hosted on a secure server that users can access anytime, anywhere – remotely and simultaneously with proper licensing. There’s no data conversion and no retraining of users because it’s the same software that they have already been using.
There is no more dealing with Accountant’s Copies and Transfer Files at year end for your tax preparer, as access can be provided to outside professionals to seamlessly share data and collaborate with the business.
You are not required to upgrade to the newest version of the software each year in order to use hosted services, as long as the version is still supported by QuickBooks®, you do not have to upgrade.
If you aren’t satisfied with the hosting service, you can move to a different hosting vendor or you can move back to your desktop – you’re not tied in – it’s your data and your software.
Challenges
There are a number of areas of the QuickBooks® application which are designed directly in conflict with the concept of a hosted, shared application service model, making QuickBooks® hosting a fairly complicated business.
Installing the correct application licensing levels and multiple editions of the product, allowing individual user settings for printers and forms, and even providing multi-user access are areas where some service providers fall short.
In addition, not all hosting service providers support additional third party applications that integrate with the QuickBooks® software and there may be issues with hardware integration, e.g. scanners, bar code readers and so forth.The biggest drawback of all – no internet, no access.
Conclusion
Hosting QuickBooks® can be a great solution for many businesses. It is best to spend some time in advance choosing the right hosting provider; one that best fits your business needs. If you need help, please call us.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
When deciding between QuickBooks Online and QuickBooks Desktop accounting solutions, you will need to consider the pros and cons of each platform, the various features available, as well as how you use the software and what works best for your particular situation.
QuickBooks Desktop:
|
Positive:
|
Negative:
|
QuickBooks Online:
|
Positive:
|
|
Negative:|
Features in Desktop Only:
|
Features in Online Only:
|
It is best to spend some time in advance choosing the software that best fits your business needs. If you need help with choosing the right software, please call us. It’s what we do.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
The arrival of QuickBooks® Online (QBO) has provided many new possibilities for 
small business owners. It is a user-friendly and convenient option for those who are looking for more remote accessibility with their company file. Here are a few quick tips outlined to assist you in navigating the new software.
Supported Web Browsers
Even though Chrome and Internet Explorer are the most popular web browsers, Firefox and Safari also work with QuickBooks® Online. They all have a different look and feel, but the basic features are all the same. Many users feel that Chrome works the best.
Windows
- Internet Explorer for Windows, version 9 or higher
- Firefox for Windows, version 4 or higher
- Google Chrome (recommended)
- Safari for Windows 5.0.1 or higher
Mac
- Safari for Mac, version 4.1.1 or higher
- Firefox for Mac, version 3.6 or higher
- Google Chrome (recommended)
Mobile support for Blackberry, iPhone, Android and iPad. There is a mobile version of QuickBooks® Online for the iPad using Safari to login, but the features are limited.
Open Multiple Windows
This feature has different results depending on the browser you are using. If you are using Internet Explorer, you will already be logged into a QBO screen. With Firefox and Chrome, you will have to type the QBO URL into the address bar, but you won’t need to enter your user name and password. Another option is to open a new tab in the current browser window. For Chrome, right click the tab you’re in and then click Duplicate.
Side by Side Windows
If you want to see the windows side by side, just pull the tab out into its own window. When you are done, drag the tab back over the original browser window to return it.
Open Multiple Companies
Chrome offers a very useful feature by allowing you to create multiple users. This enables you to have two (2) different QBO companies open at the same time. This is helpful if you have a client who owns multiple and related companies and you need to work back and forth between them.
- Open Chrome.
- Click the Customize and Control Chrome button, and then click Settings.
- Click Add new user.
- Create a Buddy Icon and Name for your new user.
- Once you add an additional user, you can open up a Chrome browser window for each user and log in to QBO separately.
We hope these tips help familiarize you with the basic interface of QBO. As always, if you have any further questions, please do not hesitate to contact our office.
Using QuickBooks Mobile, you’ll improve business relations, put out fires before they start and unchain yourself from your office computer.
There are only a few reasons why you wouldn’t be using QuickBooks Mobile on your smartphone. Maybe you don’t have a smartphone. Or when you’re out of the office, you don’t want to be available for accounting work. Or you might not think that it has enough features to make it worth using.
While the first two reasons are matters of personal preference, the third just isn’t true. QuickBooks Mobile automatically – and almost instantly – synchronizes the data from your desktop or laptop computer copy of QuickBooks. While it’s only focused on sales, not payables or payroll, you can manage receivables quite nicely whether you’re in a customer’s office or at a trade show or community event – or sitting on the couch at home.
Figure 1: You can see this screen no matter where you and your smartphone are (the-recently-upgraded Android version is pictured here).
Countless Scenarios
There are numerous situations where you might want to access, add or edit customers, estimates, invoices, sales receipts or payments when you’re not near the PC where QuickBooks is installed, like these:
- You’re a mobile service provider (i.e. appliance repair, locksmith, tow truck operator, pizza delivery) and you want to accept payment on site.
- You do a half day of onsite training and your client wants to pay you cash right then. You can record the payment and email a sales receipt.
- You’re on the road and you want to see how well your bookkeeper is managing receivables. QuickBooks Mobile displays three views: recent activity, today and upcoming.
- You’re with a client who would like to give you a check to get current, but he or she can’t find the invoice. Rather than calling your office and sitting on hold until someone has time to look, you can pull up the form on your smartphone to discuss it.
Figure 2: You can record sales receipts and payments on your smartphone – even schedule appointments that move to your Google calendar.
The Perils of Payroll
QuickBooks Mobile doesn’t support payroll, but Intuit Online Payroll does. Like QuickBooks Mobile, the app itself free (of course, you have to pay for the service itself). You can view the most recent payroll run and employee information, as well as preparing, previewing and approving the current payroll.
Neither app is available yet for the iPad, though QuickBooks Online is.
Figure 3: Missed your flight and afraid you’ll miss the current payroll run, too? Intuit Online Payroll gives you access from your Android or iPhone.
Paper or Plastic?
If you’ve been in business for very long and still don’t accept credit cards, you have an idea of how many sales you’ve lost. You’ll need to get a merchant account from Intuit Merchant Service for QuickBooks (fees apply). A merchant account allows you to accept plastic through QuickBooks itself, your web browser, your web storefront – and on your smartphone or iPad.
You can also download Intuit’s free GoPayment app. You can either swipe cards on the free mobile reader or type numbers in. Your customers sign their names on the surface of your mobile device, and you can print, text or email a receipt. There are no monthly fees, no long-term contracts, and you pay as you go. 
Figure 4: You’ll need to get acquainted with the Intuit Merchant Service Center to work with credit card payments.
It would be nice if those credit card payments were just instantly zapped into the right places in QuickBooks, but alas, it isn’t so. You’ll need to do some setup and processing both within QuickBooks and in the online Intuit Merchant Service Center. We can help you with setup and your initial transactions to make sure all of your payments get through and are deposited and/or credited correctly.
We think you’ll find that once you start using all of the mobile payment services that Intuit offers, you’ll wonder what took you so long.
QuickBooks® 2013 has a number of new features as well as improvements to existing ones. It also has a few problems as evidenced by the fact that they have already issued Release 3 to fix the bugs and it only just hit the retail store shelves in October.
Changes in the User Interface
There are major changes in the visual design of the program and how you navigate each of the screens. Fonts, spacing and colors have changed in just about every area of the program. This was done to try to standardize the look and feel throughout QuickBooks®. Change is not always welcomed by people who are used to things the way they were and it will take a little bit of getting used to in order to find where they put your favorite things.
Left Icon Bar
Instead of the top icon bar that we have been using since 2006, the navigation bar is now on the left hand side of the screen much like it used to be back in 2005. If you have a low resolution monitor, this icon bar takes up a great deal of real estate on your screen. You do have the option of moving this back to the top, but it’s not as pretty as it used to be and harder to read with gray on black.
More White Space, Smaller Labels and Scroll Bars
The Home Page and other screens have more white space which makes things less busy but it also shows less information – about 30% less information is displayed in the same size window. Some of the Labels are really small and the light gray color is too faint to actually see. The Scroll Bars are so small it can be difficult to get your mouse cursor on them.
Ribbons on Transaction Windows
The most commonly used transaction windows will have a new “ribbon” interface at the top similar to the ones in Microsoft Word 2010. This combines the features that relate to these transaction windows into one easy to use place. The content of the ribbon will change from form to form, but the general layout is the same.
Improved Centers
This is the most improved area as far as additional features for small business owners who use the software for their bookkeeping needs. In the Customer, Vendor and Employee Centers, Tabs have been added to quickly access Transactions, Contacts, To-Do’s and Notes. You can now have multiple Notes per record, instead of just one. There are now 24 contact-related field labels and you can choose which eight (8) to show on your screen. The To-Do list is much more convenient and can be filtered by Customer, Vendor or Employee.
Color Scheme Preference
In QuickBooks® 2012 we could set each QuickBooks® file to have a different color scheme in the Desktop View preferences. This was helpful when working in multiple company files. This has been removed in QuickBooks® 2013. If you don’t like the color settings in the new program, you can’t change it. You do still have control of some of the colors used in some individual windows and the colors are less intrusive.
QuickBooks® Accountant
There are a number of changes in the QuickBooks® Accountant version of the software. Send general journal entries to clients via email is a simple way to send the year end journal entries back to clients, batch enter transactions allows you to quickly enter (or import) large numbers of checks, credit card charges or deposits, Starter Copy is easier to find and work with, toggle to the Bookkeeper edition is available and the QuickBooks Statement Writer is now supposed to be compatible with 64 bit versions of Microsoft Excel. Client Data Review received a few improvements in converting the Other Names and Writing Off Invoices.
QuickBooks® Enterprise
There are a few improvements that are only available in the QuickBooks® Enterprise version of the software. We now have Automatic Purchase Orders, Default Classes and Larger List Limits. In the Advanced Inventory add on feature to Enterprise, we now have Barcode Scanning, Bin Location Tracking and FIFO Cost Lot History by item Reporting.
Conclusion
Look before you leap. If you don’t have to upgrade right now, don’t – It’s buggy at best and for the regular small business owner using the software for everyday bookkeeping needs, it has no real improvements over the prior year. QuickBooks® will be sun-setting the 2010 version of the software in May of 2013 and hopefully by then they will have resolved most of the issues and we can help you make a smooth transition to the latest version.
Did you know that there are at least 40 different file extensions in QuickBooks®? Those are just the ones that I found when researching this article – I am sure there are many more!
There are extensions for everything from Loan Manager and Financial Statement Designs to Online Banking and Images. There is even one called LGB which stands for Little Green Box. This file contains encrypted information on user names and passwords.
Here is just a sampling of the file types and extensions in QuickBooks.
It is important for accounting professionals to understand the different file types and file extensions involved with QuickBooks®.
There are five (5) main file extensions used for holding transactions and data for a QuickBooks® company file. The table below describes these file extensions.
| Extension |
File Type |
Description |
| .QBW
|
QuickBooks® for Windows company file |
This is the main file type for a QuickBooks® company file. All of your data is entered into this file. |
| .QBB | QuickBooks® backup file
|
A backup file is a compressed file containing everything you need to recreate your company file and QuickBooks® environment. Use a backup file to safeguard your QuickBooks® files against accidental data loss. When you create a backup, QuickBooks® starts a log of transactions (.TLG) that you have entered since the last time you backed up. To open a .QBB file, go to the File menu and click Restore. Double-clicking the file and choosing Open from the File menu will NOT restore or open a backup file. |
| .QBM
|
QuickBooks® Portable company file | This is a compressed file that contains all of the data of a QuickBooks® company file, but not the database indexing, so it is much smaller than the .QBW or .QBB files. It is useful for transferring data through the Internet because the data file size is much smaller than any of the other file types and it can be restored to the full .QBW on the receiving end. |
| .QBX
|
Accountant’s Copy (Export File) |
This is also a compressed file format and it is used specifically for transferring a file from an end user (client) to an accountant for review. This includes a Dividing Date which prevents the client from creating transactions on or before this date. |
| .QBA
|
Accountant’s Copy (Working Copy) |
When the accountant opens a .QBX file they must restore and convert it to a .QBA file in order to enter transactions and run reports. |
It is important to assess the client’s needs and determine which file type is appropriate for the situation. It will depend on the type of work to be performed, the condition of the client’s current data file, the nature of their operations and a number of other factors. If you have a solid
understanding of the different file types and options available, then you can make a more informed decision on how to best serve the needs of your client.
QuickBooks® also uses many other file extensions to access or store other types of data associated with QuickBooks®. The table below describes a few of these file extensions. It is not an all-inclusive list.
|
Extension |
File Type |
Description |
|
.QBW.TLG
|
Transaction Log File for QuickBooks® company file
|
When you backup a company file, QuickBooks® starts a log of transaction that you have entered since the last backup. In case of accidental loss of data, Intuit Technical Support can use your most recent backup in conjunction with the transaction log file to recover your data. This log file is also used if you sync your QuickBooks® data with certain online services using Intuit Sync Manager. This allows ongoing syncs to happen much more quickly than the initial full upload of QuickBooks® data into your online service. Note: A manual backup (not an automatic backup) is required to ‘reset’ the .TLG file. If the .TLG file is too large, create a manual backup. |
| .QBA.TLG
|
Transaction Log File for Accountant’s Copy
|
When you backup an Accountant’s review copy, QuickBooks® starts a log of transaction that you have entered since the last backup. In case of accidental loss of data, Intuit Technical Support can use your most recent backup in conjunction with the transaction log file to recover your data. Note: This file is created during backup provided that you have set a verification level. |
| .QBY
|
Accountant’s Copy (Import File)
|
When you (the Accountant/Consultant) are finished making changes in an Accountant’s Copy, you provide the client with a .QBY file to be imported into their company file. Note: This file only includes the changes made by the Accountant and not all of the transactions of the company. |
| .IIF
|
Intuit Interchange Format file
|
You can import and export lists and/or transactions using text files with an .IIF extension. |
| .ND
|
QuickBooks® Network Data file
|
A configuration file that allows access to the QuickBooks® company file. Note: DO NOT DELETE this configuration file. |
| .DES |
Form Design Template file |
This file type is created when you export a form design from the templates list. |
For a printable list of file types and extensions, click here.
This article of QuickBooks Tips and Tricks was based on the 2012 version of QuickBooks.
