Newsletter banner

Caesar's Brook Babblings

QuickBooks News You Can Use

June 2012 - Vol 5, Issue 6

In This Issue
Backup or Portable Company File? How To Decide...
Storing QuickBooks Files In The Cloud
Finding Old Uncleared Items
Caesar's Brook
Eagle with American Flag



Welcome to the June issue of Caesar's Brook Babblings!


Our feature article this month is about copying and backing up your QuickBooks files. We also have a short topic on the dos and don'ts of QuickBooks files and cloud-based file sharing services, as well as a QuickTip on how to quickly find any old outstanding items and clear them up without impacting closed accounting periods.


Happy 4th of July!


 Happy July 4th

FeatureFeature Article

Backup Or Portable Company File? How To Decide ...Nuked Computer


QuickBooks provides two ways (actually, three) to create a copy of your QuickBooks data file. When is each appropriate, and how do you proceed?


When you think about it, it's pretty amazing that Intuit is able to pack the lion's share of your financial data into one giant company file. Certainly makes it easier to separate from QuickBooks and move when necessary.


There are actually three options for saving and relocating that file. You know about backups, since you should be producing them religiously. You generate them so that if QuickBooks -- or your computer itself -- stops working or your file becomes corrupt, you can re-create the entire environment. Portable company files are more limited, and are best used when you want to save your file to a temporary location and/or email it to someone else.


The third option is an Accountant's Copy.  This is used for transferring files back and forth to your accountant.  The advantage of using an Accountant's Copy is that you can continue to use the file for your day to day work and when your accountant returns the file to you, any changes they have made can be merged back in.  If you need to create an Accountant's Copy, your accountant should provide the instructions you will need. 

Figure 1
Figure 1: Once you save and send off an Accountant's Copy, you can't work on transactions created before the 
dividing date.


The Critical Backup


We can't emphasize this enough: Losing your financial data can be the beginning of the end of your company. You won't know what you're owed, so you'll be unable to collect. You'll miss vendor payments. Payroll will be impossible to reconstruct, and you won't be able to submit payroll taxes. And how will you know what your income tax obligation is? 


It can happen to you.


QuickBooks simplifies this process. Click File | Create Backup... You'll be asked whether you want to back up locally -- to a network folder or thumb drive, for example - or to the cloud, using Intuit Data Protect (fees apply). If you select the local preference, click on Options to designate a location in this window:


Figure 2 

Figure 2: Choose from options in this window to create a backup profile.


Click OK, then Next. QuickBooks will ask when you want to save your backup copy and offer scheduling options. When you're done, click Finish.


Warning: If you're using Intuit Sync Manager, there are special rules about copying the company file.


Just The Facts


Portable company files are more compact than backup files, so they can be easily e-mailed as attachments or copied onto another computer. But they don't contain everything that backups do. They lack, for example, letters, logos, attachments, images and templates. Don't use this option if changes will be made, since they can't be merged back into the file.


Be sure to create a current backup before you begin to move your file.


To save a portable company file, click on File | Create Copy (you can do this to copy any kind of file, actually). This window opens:


Figure 3 

Figure 3: Click File | Create Copy... to access any of QuickBooks' three options.


Select Portable company file and click the Next button. In the following window, you'll browse to a location for your file. QuickBooks will already have entered the name and will save your data in .qbm format. Click Save, then OK when QuickBooks tells you it must close and reopen your file first. Click OK again when you're told that the file has been created.


Opening The File Elsewhere


When you're ready to open the file at another location, click File | Open or Restore Company... In the window that opens, select Restore a portable file. The Open Portable Company File window opens; make sure that the file's location is displayed in the Look in: field. Click Open. QuickBooks then asks where you want to restore the file. 

Figure 4 

The following step is critical. Rename your file unless you want to overwrite your current company file. You can add a date or some other identifying information like a version number.


Click Save. QuickBooks will convert your portable file to a standard company file with a .qbw extension.


QuickBooks makes it easy to create copies of your data, but an error here can threaten your company's future. If you aren't comfortable with copying and moving your files, please contact us for help.

Storing QuickBooks Files In The Cloud


Do Not Enter The CloudFile sharing services such as Google Drive, Dropbox, SugarSync, and SkyDrive allow you to share your files with others and access them from any platform.  These services are a great place to store your backups or portable company files.  However, while it may be tempting to store your QuickBooks company file (.QBW) on a cloud-based file sharing service, it is definitely not a good idea. 

The problem is that QuickBooks files are actually accessed through a database manager whose job it is to control the reads and writes to the file.  Synching files between multiple systems and the file sharing service bypasses the database manager and can result in multiple copies of the file being created, or data corruption, even if you are the only person accessing the file.  The Intuit Community forum is rife with tales of woe.  Just don't do it.  Period. 


QuickTip: Finding Old Uncleared Items


I Love To Reconcile My FileMy month end checklist includes a reminder to review and investigate any uncleared items in the bank accounts that are over 90 days old.  The quickest way I've found to identify those items is to go to the register for the bank account.  In the "Sort by" dropdown at the bottom of the screen, select "Cleared Status".  Uncleared items will sort in date order at the bottom of the register.  Just scroll up to identify any old outstanding items.


When replacing a lost or destroyed check, be careful not to make changes in closed periods

Void PaycheckEnter a deposit for the same amount in the current period and issue a new replacement check to offset it.  You can clear the original check against the deposit when you reconcile.  Be extra careful with paychecks created using QuickBooks payroll that have associated tax and liability calculations.


Search the QuickBooks help for "Void paycheck" to find instructions for managing these situations.


banner 2
I hope you found these babblings useful.  Your feedback is important to me.  Please drop me a line and let me know what you think.


Susan Dugdale
Caesar's Brook Business Solutions, LLC
QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.
Copyright 2012 Caesar's Brook Business Solutions-All Rights Reserved

Caesar's Brook Business Solutions LLC | PO Box 1102 | Amherst | NH | 03031