Backing up Data In QuickBooks®

Hi, I’m Jayne Miller, the QuickBooks Gal. Welcome to another in our series of “Quicklets” –informational podcasts about QuickBooks and related bookkeeping topics.

Today’s topic is Backing up Data In QuickBooks®
Today, I’m going to talk about backing up your data in QuickBooks. This is probably the most important task in the bookkeeping/accounting process. I back up every time I access my data file.

There are many ways to back up your data.

1. Floppy disks - While you still can use floppy disks, the scarcity of computers with floppy drives combined with the size of many data files has nearly eliminated this choice.

2. CD’s – most of us have a stack of CDR or CDRW disks…great way to secure your data.


To do this task you must be in single-user mode to do this. Microsoft® Windows XP includes an integrated CD Writing Wizard as part of the operating system.

Important: After backing up in QuickBooks, you must then use the Windows XP CD Writing Wizard to actually write the file to your CD.

• Insert a recordable CD into your computer's CD-R or CD-RW drive.

• Go to the File menu and click Save Copy or Backup to open the backup wizard.

• Click Backup copy and then click Next.

• Click Local backup.

• If you have not already done so, click Options to set your backup defaults, such as where you want to save your local backup.

• Click Next.

• Click Save right now or Save right now and schedule future backups if you also want to create a routine backup schedule.

• Click Next.

• Click Browse and select your CD-R or CD-RW drive as the backup location. If you want to change the name that QuickBooks suggests for the backup file, type your changes in the File name field.

Note: The Save In field will not show your CD-ROM drive letter. Instead, it will show the Windows XP default location for files waiting to be written to CD in C:\Documents and Settings\(user name)\Local Settings\Application Data\Microsoft\CD Burning\.

• Click Save to start the backup. QuickBooks verifies the integrity of your company file based on the backup defaults you set, and closes and then reopens your company file.

• In the prompt about completing the CD burning process, click Burn Now to burn the backup file to CD now, or click Burn Later if you want to burn the backup file later.

o In Windows Explorer, browse to your CD-ROM drive.

o Under CD Writing Tasks, click Write these files to CD.

Follow the instructions in the CD Writing Wizard to finish burning the file to your CD. Important: You must complete this step to complete the backup process

3. USB Flash Drives – these great little devices offer the ease of floppy disks and the ability to save a lot of data on one little device (a 512 mb flash drive is the equivalent of 350 floppy disks!)

To do this task, you must be in single-user mode.

o If you are using a USB flash drive or other removable storage device, prepare the device now. for example, insert the flash drive into the USB port.

o Go to the File menu and click Save Copy or Backup to open the backup wizard.

o Click Backup Copy and then click Next.

o Click Local Backup.

o If you have not already done so, click Options to set your backup defaults, such as where you want to save your local backup.

o Click Next.

o Click Save right now or Save right now and schedule future backups if you also want to create a routine backup schedule.

o Click Next.

o (Optional) If you want to change the name or location that QuickBooks suggests for the backup file, type your changes in the File name field and click the Save In drop-down arrow to select another location.

o Click Save to start the backup.

o QuickBooks verifies the integrity of your company file based on the backup defaults you set, and closes and then reopens your company file.

4. External hard drives – you can pick up an external hard drive that will connect to your computer via USB port. I found one that is equivalent to my computer’s hard drive for under $100. Follow the same instructions for backing up to Flash Drives….just change the drive.

5. QuickBooks Online Back up - The Online Backup service can make scheduled backups of your QuickBooks company files to a remote location. If you register for and use this service, you will no longer need to remember to make these backups, nor will you need to worry about loss or damage of local storage media.

To find out more about QuickBooks Online Backup go to the File menu, click Save copy or backup, click Backup copy, click Next, and then click the Learn more about QuickBooks Online Backup link.

6. Scheduling backups in QuickBooks – you can schedule automatic backups in QuickBooks. You must be in single user mode to do this:
You have two options when scheduling local backups:

You can schedule automatic backups that take place when you close your company file.

You can schedule backups that take place at regular intervals, even when you're away from your desk. (Your computer must be on and your data file closed.)

Note: If you are using QuickBooks Online Backup, you must schedule your backups using that service.


To schedule automatic backups

From the File menu, click Save Copy or Backup to open the backup wizard.
Click Backup Copy, then click Next, then click Local Backup.
If you have not already done so, click Options to set your backup defaults (such as where you want to save your local backup) then click Next.

Click Only schedule future backups (to create a schedule without running a backup) and click Next.

Select the first check box and enter a number to specify how often you want your company file to be backed up. For example, to back up your data file every fifth time you close it, type 5 in the field provided.

The backup will be stored in the location you specified in the Set Backup Copy: Options window. To view or change this location, click Options.

Click Finish to close the wizard.

To schedule regular backups

Note: For the backup to take place, the computer you use to run QuickBooks must be on, but the company file you want to back up cannot be in use. Be sure to schedule your backups accordingly.

From the File menu, click Save Copy or Backup to open the backup wizard.

Click Backup Copy, then click Next, then click Local Backup.

If you have not already done so, click Options to set your backup defaults (such as where you want to save your local backup) then click Next.

Click Save and schedule future backups (to run a backup and create a schedule) or Only schedule future backups (to create a schedule without running a backup).

Click Next and in the Save Backup: When window click New.

Enter a Description for your scheduled backup.
Click Browse to select the folder where you want to store your backup copies. This can be on a network drive, or on local media.

Optionally, click the check box to Limit the number of backup copies in this folder and enter a number in the field provided. If you do not specify a number, QuickBooks saves all of your scheduled backups.

Click Set Password to open the Enter Windows Password window and enter the requested information. This provides permission to run the scheduled backup.

Select the time, frequency, and day for the backup to take place.

Click OK to return to the Save Backup Copy: Schedule window. The backup appears in the list in the Schedule backups: section.

Click Finish to close the wizard.

Visit my blog at blog.quickbooksgal.com for more detail and written instructions for backing up your data.


Got a QuickBooks Mess? Call the QuickBooks Gal!


Upcoming:

• Payroll – Ugh! I have a business with employees– now who wants a piece of me? (Social Security, Medicare, State Unemployment, FUTA, who else?)

• Starting a business – Discussion & Checklist

• Using Credit Cards to pay bills, make purchases

• Converting Peachtree to QuickBooks

• Creating a new file in QuickBooks from an old one (Import lists vs. deleting transactions)

• Recording cash purchases and owner purchases/contributions

• QuickBooks Point of Sale – What’s new in 2007

Are you backing up your data?

Well, that’s it for now. I appreciate your time and hope you will join us again next time for another in our Quicklet© series.

If there are topics you would like me to cover, send me an email at jayne@quickbooksgal.com. I welcome your ideas, questions, and comments.

Don’t forget to visit our website, www.quickbooksgal.com to learn more about me, the services we offer and our workshops.

I’m Jayne Miller, The QuickBooks Gal. Thanks for listening.


Jayne Miller is the owner of Custom Business Solutions, a consulting firm in Reno, Nevada that specializes in providing bookkeeping and software support.

Hodge Podge, Product Updates, and QuickBooks Gal News

Hi, I’m Jayne Miller, the QuickBooks Gal. Welcome to another in our series of “Quicklets” –informational podcasts about QuickBooks and related bookkeeping topics.

Today, I’m going to address a hodgepodge of topics…time to catch up a little and answer some questions from listeners. First, I want to thank my listeners and subscribers for their time and for helping to make The QuickBooks Gal such a success in the first few months of broadcasting. We are growing fast and it all thanks to you! I appreciate everyone’s interest and comments…thank you.
I received an email and follow-up phone call from one of our listeners in New York. Geetha Krish is a CPA and QuickBooks ProAdvisor who listens regularly and reminded me that I haven’t done a follow-up podcast about backing up data. Thanks for the reminder Geetha….I will do that one very soon. I have put a link to Geetha’s website on my blog for those of you in New York who may be looking for an experienced QuickBooks professional. If you are looking for QuickBooks support, give her a call! Geetha asked me some great questions about marketing your practice. If you are a QuickBooks service provider, or any small business owner, look for my tips for marketing your business in a future podcast.

If you are starting a new business, and you don’t need a complicated software program, then you may want to take a look at QuickBooks Simple Start.
QuickBooks Simple Start Edition is the simplest way to succeed with just the right essential tools for your small business. It’s easy to track sales and expenses and get organized for tax time. Simple Start easily upgrades to QuickBooks when your business and accounting needs expand and outgrow the program.
Simple Start Key Features
• Print checks, pay bills & track sales & expenses
• Create estimates & invoices
• Tools for payroll & tracking employee time
• Works with Microsoft® Office
• Track inventory and set reorder points
• Download credit card & bank transactions

I am now a Certified Enterprise Solutions ProAdvisor. This is the first year that Intuit has offered this certification as an option and I, for one, am glad to have the opportunity to test my skills and knowledge in this great program. Our office now has two Enterprise Solutions ProAdvisors, so if you have questions, call The QuickBooks Gal!
Enterprise Solutions is great for clients hitting list limits or having performance issues. They may want to consider upgrading to Enterprise Solutions. It has the same great features you love in Premier with the added benefit of scalability.
What’s new and wonderful about Enterprise Solutions 2007?
• Everything in QuickBooks: Premier Editions 2007
• Scalable from 5 to 20 simultaneous users (Now comes in 5, 10 , 15, 20 user licenses)
• Capacity for tracking inventory items, customers or vendors - 100,000+
• Advanced user permissions to 115 activities in QuickBooks
• Retrieve QuickBooks data using ODBC compliant applications
• Combine reports from multiple company files
• Create custom financial statements using built-in designer
• Manage fixed assets
• Manage employees using the Employee Organizer
• 24/7 product support
• Automatically receive new versions of Enterprise Solutions
Enhanced functionality to meet the more complex needs of your mid size clients
• Real-time access to your QuickBooks information from any location using Windows Terminal Services
• Advanced inventory tools to help product-based businesses' manage the flow of products through their business, from purchasing to production, from inventory controls to sales.
• NEW! Clients can now purchase & sell the same item in different Units of Measure
• Enhanced security features, including user access permissions to over 115 areas and activities and audit-tracking with no slow-downs.
The ability to expand and customize to meet your client's more specialized needs:
• Expand your client's capabilities through 3rd party QuickBooks compatible software that easily integrates with Enterprise Solutions
• Add optional QuickBooks services and tools as you grow such as payroll services, point-of-sale systems, checks and supplies and credit card processing.
• NEW! For product-based businesses, add a comprehensive EDI solution by TrueCommerce that integrates seamlessly with Enterprise Solutions
For a comparison chart, you can go to this chart.
I want to remind you that quarterly payroll reports are due in April. The 941, 940 FUTA and applicable state and local quarterly filings are due by the end of the month.
If your business pays mileage to your staff members, you may want to visit the IRS website at www.irs.gov for 2007 figures. 2007 business mileage rate is 48.5 cents per mile, up from 44.5 cents in 2006. Also, don’t forget that Social Security wage limit for 2007 is $97,500.
There’s great news from Intuit for small business owners with 1-3 employees who want to process their own payroll. The new program is called QuickBooks Basic Payroll (Limited Employees). It’s just right for clients who have 1 to 3 employees and who either do their tax forms and filings themselves, or have a bookkeeper, ProAdvisor or accountant to help with these critical tasks. It enables payroll processing only (no federal or state tax forms, but all the information to prepare the forms, and includes tax table updates.
The price for the first year is $69 and will be $99 for subsequent years. This great new product will be available April 2.
Coming Soon: Starting a New Business - Checklist & Discussion

Future Topics:
• Backing up in QuickBooks
• Marketing your business
• Payroll – Ugh! I have a business with employees– now who wants a piece of me? (Social Security, Medicare, State Unemployment, FUTA, who else?)
• Using Credit Cards to pay bills, make purchases
• Converting Peachtree to QuickBooks
• Creating a new file in QuickBooks from an old one (Import lists vs. deleting transactions)
• Recording cash purchases and owner purchases/contributions
• QuickBooks Point of Sale – What’s new in 2007


Are you backing up your data?



Well, that’s it for now. I appreciate your time and hope you will join us again next time for another in our Quicklet© series. If there are topics you would like me to cover, send me an email at jayne@quickbooksgal.com. I welcome your ideas, questions, and comments.

Don’t forget to visit our website, www.quickbooksgal.com to learn more about me, the services we offer and our workshops.

I’m Jayne Miller, The QuickBooks Gal. Thanks for listening.




Jayne Miller is the owner of Custom Business Solutions, a consulting firm in Reno, Nevada that specializes in providing bookkeeping and software support.