CERRITOS COLLEGE - ADULT EDUCATION            
INTRODUCTION TO QUICKBOOKS     COURSE      
              OUTLINE      
                     
  OVERVIEW            
        Terminology            
        Links to background information            
                     
# TODAY: December 21            
                     
  Please start QuickBooks immediately.            
                     
                     
    Vocabulary and concepts            
     - Open the terminology file (in Excel)            
        Terminology            
                     
                     
                     
    What is the Accountant's Copy file for?            
     - It's similar to a portable file            
       - You can e-mail it to your accountant for him/her to make changes            
      to your company file            
       - It splits control of the company file between you and your accountant            
      (based on what is before of after a cutoff date you select)            
     - Here is the procedure for making this file:            
        Make and cancel an Accountant's Copy of your company            
                     
                     
                     
    Setting up payroll - a demonstration            
     - QuickBooks makes it easy to buy a payroll service from Intuit            
     - Few people have the skill and patience to do payroll manually            
       - However, setting up to do payroll manually is very educational            
        Manual Set-up of Payroll (Without Buying QuickBooks Payroll Service)            
                     
                     
                     
    Customer payments            
     - Managing till (cash register) discrepancies            
        Till Exercise Overview            
                     
        Tracking Cash Shortages and Overages in the Cash Register Drawer (Till)            
                     
        Post Cash From a Cash Register (Till)            
                     
                     
                     
  PREVIOUS CLASSES            
        December 14, 2013            
                     
    Portable files            
     - Portable files have the extension .QBM            
     - They are much smaller files than the QuickBooks backup files            
     - It takes QB a little more time to make portable files or to turn a portable            
    file back into a full company file            
     - Let's practice turning a company file into a portable file            
       - Use the Sample Product Based business as the company file to be            
      saved as a portable file            
        Create a portable file            
                     
                     
                     
    Sell using a discount and a tax item            
     - Restore the Fourth Shoey Lacey Portable File            
     - Build an invoice to sell a taxable item            
       - And give the customer a 10% discount            
         Invoice with subtotal & multi-item discount            
                     
                     
                     
    Send an invoice by email            
        Send invoice by e-mail            
                     
                     
                     
    HOME WORK     Home      
     - If that's too hard, do this, instead:            
        Create a portable file            
         - Open the Sample Product-Base Company before you do this            
     - Build this invoice in the Fourth Shoey Lacey company            
         Invoice with subtotal & multi-item discount            
              Work      
                     
                     
        December 7, 2013            
                     
    Counting and adjusting physical inventory (cont'd)            
     - This is a tricky piece of work            
       o Clean Up Item Names and Prices            
         - The yellow section            
        Do a Physical Inventory & Fix Item Names / Prices            
                     
                     
                     
    Starting your business using Quickbooks            
     - The work of a business is selling things            
     - Does QuickBooks make this easy?            
       - Well, yes, after you get used to the QuickBooks system            
        How to Set Up to Sell Items in QuickBooks            
                     
                     
        November 16, 2013            
                     
    Counting and adjusting physical inventory            
     - This is a tricky piece of work            
       o Perform a count of inventory            
       o Adjust inventory counts            
         - This will fix a series of mistakes made when receiving inventory            
       o Adjust inventory dollar value            
         - Do this after adjusting the count            
        Do a Physical Inventory & Fix Item Names / Prices            
                     
                     
                     
    HOME WORK            
     - Are you up for a challenge?  Please repeat this exercise on your own:            
        Do a Physical Inventory & Fix Item Names / Prices            
                     
                     
        November 9, 2013            
                     
    Make a backup of the company file            
     - It is important to make backups of the QuickBooks company file            
    on a regular basis            
       - You may never need to use a backup to restore a corrupted company file.              
      However, you will have peace of mind from knowing that you could,            
      if necessary.            
     - Here is the procedure:            
        Create a backed up company file            
         - CAUTION: DO NOT SAVE DIRECTLY TO A FLASH DRIVE!            
        (See Step 6.)            
     - Let's make a backup of the sample product-based business            
                     
                     
                     
    Portable files - a more compact type of backup            
     - Portable (.QBM) files are much smaller than backup files            
       - In fact, you can send a portable file by e-mail            
       - Like a backup file, a portable file lets you recreate the company file            
     - How do you restore a portable file back to a company file?            
        Restore a portable file            
     - In the following exercise, we will restore a company file from a .QBM file            
                     
                     
                     
    HOME WORK            
     - Please repeat this exercise on your own:            
        Restore a portable file            
                     
                     
                     
        November 2, 2013            
                     
    A practice exercise involving customers, vendors and items            
     - To prepare, we will get a company file from a backup file            
       - Restore this backup file (after downloading it)            
        shoey-lacey-after-proc9.QBB            
         - This is a Backup File for the Shoey Lacey Company (after Procedure 9)            
                     
     - Bob will lead us through the procedure            
        Making Items, Vendors and Customers in an Unplanned Fashion            
                     
                     
                     
    HOME WORK            
     - Please repeat this exercise on your own:            
        Making Items, Vendors and Customers in an Unplanned Fashion            
                     
                     
                     
        October 26, 2013            
                     
    Vocabulary and concepts            
     - Open the terminology file (in Excel)            
        Terminology            
                     
                     
                     
    How do you restore a company file from a backup file?            
     - The backup file is a file format known as a QBB file            
      (QuickBooks Backup)            
        QBB Backup: Restore company from backup file            
                     
                     
        October 19, 2013            
                     
    Understanding QuickBooks Files            
     - The QBW file (QuickBooks Working file)            
       - There are actually several support files that QB needs in addition to            
      the main database            
       - Let's look in our QB Class subfolder!            
                     
                     
                     
    HOME WORK            
     - Please use QuickBooks to restore this portable file            
        PRACTICE-COMPANY-Backup            
                     
     - If you need to, you may review this tutorial on restoring backup files            
        QBB Backup: Restore company from backup file            
                     
                     
                     
        October 12, 2013            
                     
        Bob had an unscheduled absence.            
                     
        October 5, 2013            
                     
    Set up a company file - Detailed Start            
     - We already made a company file by skipping the interview            
     - Now, it's time to become familiar the the Detailed Start Interview            
       - Also known as the "EasyStep Interview"            
       - Doing this in class will make it easier to do on your own            
         - Start with the File menu, click on New Company…, then click on            
        Detailed Start            
                     
                     
                     
    HOME WORK            
     - Try these procedures on your own            
       - Note: You may come to our classroom during the week if you need to use QB            
                     
       - Make a company file (File menu > New company)            
        Set up a fake company using the Detailed Start (or EasyStep) interview            
                     
       - Restore a QuickBooks backup file            
        QBB Backup: Restore company from backup file            
                     
                     
                     
        September 28, 2013            
                     
    Looking at the chart of accounts            
    A. Use the Sample Product-based Business            
      "Rock Castle Construction"            
    B. Hierarchical vs. flat view            
    C. Show inactive accounts            
    D. Turn on account numbers            
                     
                     
                     
    Bob's brief overview of Accounting            
        Accounting Basics            
       - To really understand Accounting, you can take a course in it!            
                     
                     
        September 21, 2013            
                     
    Why is QuickBooks better for businesses?            
     - Comparisons of QuickBooks & Quicken            
        Comparison: Quicken vs. QuickBooks            
     - QuickBooks process model            
        The Basic Business Model            
                     
                     
                     
    Rule of Thumb: Learning QB requires experimentation            
     - You will want to make little practice companies before you enter real data            
    into your real company file.            
     - We will learn how to make the simplest QB company file: an empty company            
      PROCEDURE 1:            
        Make an empty company (PRACTICE-COMPANY)            
                     
                     
                     
    HOME WORK            
     - Try this procedure on your own            
        Make an empty company (PRACTICE-COMPANY)            
       - Note: You may come to our classroom during the week if you need to use QB            
                     
                     
        September 7, 2013            
        Oh, no!  Bob is out of town on Sept. 14.  Come back Sept. 21.            
                     
    Getting started with a QB sample company            
     - How to load the Sample Product-based Company            
     - Now, let's explore            
       - Three centers: Customer, Vendor, Employee            
       - Basic window management skills            
        Close the current window:            
        The Esc key            
        The open window list            
        View menu > Open window list            
                     
                     
                     
    Let's add a new customer            
     - Notice that the dialogue box has 5 tabs:            
      1. Address info, 2. Payment settings, 3. Sales tax settings, 4. Additional info, (5. Job info)            
                     
                     
        August 24, 2013            
                     
    Overview Information            
     - Course outline            
     - Introduce the web site            
       - The Internet address is easy to remember            
        nahlej.net            
         - Then click on the orange box            
     - Make (or clean) a "QB Class" folder under My Documents            
                     
                     
                     
    Evolution of computer-based bookkeeping            
     - The check register: first paper, then Quicken            
        Start simple: the check register            
                     
        The Quicken check register            
                     
     - The QuickBooks bank register            
        The QuickBooks register