One of the most important tasks for a business that uses computers is backing up your accounting data. Everyone knows that, right? Yet, few businesses do a proper job. In this article we’ll discuss how you should be handling backups.
Why You Need a Backup Plan for QuickBooks
Backups are boring, time consuming, and almost always put off until later. Many business people don’t understand what needs to be done – they treat their computer like a file cabinet that is holding all their papers safely and don’t do backups. Others will tell you that they DO take care of backups and do it often! In BOTH cases there is still risk. Consider the following points:
- Computers are not failsafe – they CAN lose information.
- People are not failsafe – they CAN accidentally erase files.
- People are not always honest, they CAN erase files (see this CNN video for an example).
- Disasters can happen – fires, floods, tornadoes, hurricanes, even power failures can destroy your files in a moment.
- Backup programs and hardware are not failsafe – backups are WORTHLESS unless you test them periodically.
QuickBooks Backup Philosophy
There are many ways that we can talk about this topic. This article is not going to get into the mechanical details of how to make backups at this time. Right now we want to talk philosophy. The key elements are:
- Make backups often enough so that it isn’t painful to recreate lost work if you have a problem. If you enter a few transactions a day and then lose a week’s worth of work, it could be easy to recreate that in a short time so make weekly backups. If you enter several hundred transactions a day, losing even one day’s worth of work is a problem, so make backups daily.
- Layer your backups. Have causal backups that are easy to make and are used often, intermediate backups that are more formal and are marked in a log, archival backups that mark major events (new month, end of fiscal year). You can add more layers than this depending on your situation.
- Vary your backup methods. Don’t rely on just one backup method, such as copying to a CD. Use local backups with removable media or on-line backups to the Internet. If one method fails for some reason, you have other methods.
- Test your backup procedures. This is the concept that is missed most often. How do you know if your backups are any good? Don’t wait until a disaster to find out…
A QuickBooks Backup Plan
Examine the way your computers are set up, the kind of work you do, the volume of transactions you are entering, the number of people involved, and so forth. A custom backup plan would be implemented to fit your business needs. I know that backups are a pain to do so we have to find a balance between security and convenience – the most comprehensive backup plan won’t work if it is too much trouble to implement!
Here is a basic plan to start with:
- Use the Save Copy or Backup feature in QuickBooks (in the “file” menu) to make a backup copy (not a portable company file) at least once a month. This backup file (QBB) should be saved to removable media, NAS device, or offsite internet location. This is a very important process that many QuickBooks users miss. People who make backup snapshots of their file system or file server tend to ignore this, thinking that they have taken care of making a backup, but there are other good reasons for doing this. Without going into a lot of detail, your QuickBooks database needs some “house cleaning” periodically. If you don’t do this, performance starts to suffer. QuickBooks is keeping a transaction log (a “TLG” file) which continues to grow as you use the program. If this gets too big your system starts to slow down. The only good way to handle this file is to run the QuickBooks backup procedure, which reconciles and reduces that file. If you have a multi user system you must run this backup from the same computer that is hosting the database.
- Test your backups periodically. This is a critical procedure. If you are making backups it is because you may someday need to restore those backups. If a disaster happens and you need to restore, that is a terrible time to find out that you either don’t know how to restore, or that your backups weren’t working and you have bad data backed up. You must test your ability to restore a backup from each of the methods you are using, and you must validate that the backed up data is good. It is not uncommon to hear a backup was being made to a tape drive, with no errors being generated, but when someone tried to restore from the backup tape the data was found to be scrambled due to a hardware problem. Testing restore procedures is complicated, and very time consuming, but you should do it on a regular basis.
If you have taken the time to get this far in this article you deserve a pat on the back! It isn’t a fun topic to read, and it is a lot of work to follow through with, but it is critical to any business. Good backups are like insurance, you don’t want to have to use it but you absolutely need that protection. This is one of the cheapest kinds of insurance you can buy for your business.
Article courtesy of ebsAssociates, Inc–Dawn Ashpole, Vice President www.teachmequickbooks.com

In clinics, assisted living facilities, and hospitals everywhere, patient information that once was filed in folders and stored in massive document filing systems, is now managed electronically. Pen and paper have been replaced with precise databases designed for patient data to be saved, sorted, and parsed.
Revealing the hidden costs of paper in small business operations
Ponemon Institute recently surveyed over 4,000 IT security leaders in 12 countries to learn more about social media and its impact on their businesses. The survey provided interesting insights into the real and perceived consequences of social media use in the workplace.
The kind of email system you use makes a difference. Full access and full control of your email account – even when on the go – can be essential tools for people who work in the field. But just the same, you might need a few tweaks to a less fully featured system to keep operations efficient and cost-effective.
Your reputation and your company’s reputation are important. When people talk about you or your company, depending on what’s being said, it can have either a helpful or a damaging effect. In the online world this can be even more challenging, as the proliferation of websites and social media tools make monitoring these comments more difficult to do. Here are some tools to help you make sense out of the sea of information—so you can keep track of and manage what’s being said about you or your business.
While the decision to have some of your IT resources “in the cloud” can be a complex one, one area we get asked about often is email and productivity applications. Below is a summary from two industry giants: one from Google and the other from Microsoft, and see how they compare: