Join Bonnie Biafore for an in-depth discussion in this video Using the exercise files, part of QuickBooks Desktop: Tips and Tricks.
- [Instructor] If you're a premium member, you have access to the exercise files used, throughout this course. You'll find the exercise files in the Exercise Files folder, which I've placed on the Desktop. But, you can store it wherever you like. These files reside in sub-folders, named according to the chapters. Each chapter has its own exercise file you can use, for all the movies, in that chapter. The exercise files for this course are backup files. So, you have to restore them, as regular company files, before you can work with them.
In addition, they were created using QuickBooks 2014, which means you can use them, if your computer is running QuickBooks 2014, or, a more recent version. Let's take a look at how you restore a backup file, in QuickBooks 2017. To do that, head up to the File menu, and choose Open or Restore Company. That opens up the Open or Restore Company dialog box. Select the option, Restore a backup copy, and, then, click Next.
Because the backup files are on this computer, you can keep the option, Local backup, selected, and click Next again. Then, you want to go to the folder where you have your backup files. So, I'm going to head to the Desktop, open up my Exercise Files folder, and, let's go to Chapter Three. I'm going to select the file, for Chapter Three, and, then, click Open. The next step, is to tell QuickBooks where you want to restore the file. This screen is just a message to you, so, go ahead, and click Next.
That opens up Save Company File as. Now, you want to set the file name, and, I'm just going to use Two Trees Olive Oil_03. But, I want to select the folder. So, once again, I'm going to go to the Desktop. And, I have a folder, QB Company Files. I'm going to double click that, so it appears in the Save in box. And, now, I'm ready to click Save, at the bottom right. When you restore the file, because this is a newer version of QuickBooks, you have to update your company file.
On this screen, head down to the bottom right corner, and click Update Now. You'll see a progress bar, and that'll tell you how far along the update has gotten. And, it could take a little bit of time. So, if you see that green bar just creeping along, go ahead, and go get yourself a cup of tea. When you see the message: You're all set! go down to the bottom right corner, and click Done. You've restored the backup file, and you've updated it, for QuickBooks 2017.
But, there could be a couple of additional steps, that you have to do. If you see the dialog box Sensitive Data Protection Setup, it means you need to set a password, for your Admin user. Go to the New Password box, and type in the password. Then, click in the Confirm New Password box, and type it again. Don't copy and paste, because then you won't know what your password is, if you make a mistake. The other thing you do, is set up a Challenge Question.
And, this comes in handy, if you forget your password, and need to reset it. Click the down arrow, in the Challenge Question box, and, then, select the question that you want, such as, City where you went to high school. Then, in the Answer box, type the answer. Click OK, and you'll see a message box, that your QuickBooks password has been changed. Click OK, to close that. If you see any other boxes, you can go ahead and click X, to close them.
Now, we have our restored, and updated file. Remember, you don't have to use these files. You can use files of your own. If you're a monthly, or annual subscriber, you don't have access to the exercise files. But, you can follow along, with your own work. Let's get started.
- Adding, hiding, and sorting list entries
- Changing fields in record windows
- Finding info quickly
- Numbering transactions
- Adding logos to checks
- Applying discounts and credits to bills
- Invoicing cost overruns or fixed-price jobs
- Receiving payments
- Using journal entries
- Saving time on common tasks
Skill Level Appropriate for all
Q: This course was updated on 12/08/2017. What changed?
A: The following topics were updated: using Find and Search, restarting transaction numbering, sorting bills, and tracking most recent year’s earnings and earlier retained earnings separately.