280 likes | 492 Views
Orientation for Accounting 107 with QuickBooks Pro Paul R. St.John, CPA’s Online Class at Fullerton College. Required Textbook. Villani & Rosa, Paradigm Publishing Computerized Accounting with QuickBooks Pro 2008 with CD of Company Files ISBN 13: 978-0-76383-451-7
E N D
Orientation for Accounting 107 with QuickBooks Pro Paul R. St.John, CPA’s Online Class at Fullerton College
Required Textbook Villani & Rosa, Paradigm Publishing Computerized Accounting with QuickBooks Pro 2008 with CD of Company Files ISBN 13: 978-0-76383-451-7 DOES NOT COME WITH QuickBooks Pro software
Versions of Software & Textbook • 2010 QB Pro use 2008-2010 Text & CD with Co. Files • 2009 QB Pro use 2008-2009 Text & CD with Co. Files • 2008 QB Pro use 2008 Text & CD with Company Files • 2007 QB Pro use 2008 Text, but use 2007 Company Files available from instructor
Company Files that come with text • UnZip either the XP set or the Vista set • See top of page 1-5 to see the path to use for the Company Files
Browse if you don’t want to accept the default path • I selected Sample Company Files instead of Company Files to separate real companies from these course companies
Unzip and get 28 files • Remember the path, so you can find them when you open QuickBooks Pro 2008 or 2009 or 2010 • Click OK and then Close WinZip
A different Company File for each Chapter – Open one of the 28 files! • Note: You will have to Look in: to find the folder where you UnZipped those files
This brings you to the middle of page 1-8 in the text where you will learn about: • Title Bar with Company Name • Navigation Bar & Home Page • Using Single-User Mode • Backing Up and Naming Company Files • Restoring Company Files • Inserting your name in the Company Info
Every time you open a Company file you will be asked to do these 4 steps: • Open the company file • Make a backup copy while renaming • Restore the backup copy • Change the company name in Company Information – be sure to insert your name In real life you will start a Company File once and use it forever, but here we start a new file every chapter. Backing up and restoring are good to learn however.
After steps 1 thru 4 on LMS2 page 2-33 this is your screen shot • Yes, you have to change the file name twice and one more time in Company Info
After LMS2 steps 5 & 6, you will generate four reports for April 1- April 30, 2008: • Unpaid Bills Detail • Vendor Balance Detail • Vendor Contact List • Journal
Select the required report Now we need to change to the required date of April 30, 2008
Now Export your first required report to a new Excel workbook • Unclick explanation worksheet (optional) • Before clicking Export on the Export Report window go to the Advanced tab
In the Advanced tab be sure to Send header to screen in Excel • Now click Export -The new Excel workbook will probably be named Book1 • Change the sheet name in the workbook to Unpaid Vendor Detail • File Save as LMS2_Your_Name to a homework folder on your computer • Close the Excel file before trying to Export the next report
Now Export your 2nd required report to the Excel workbook you already created • You don’t have to go to the Advanced tab, it remembers that you want the header in the sheet
Note the header is showing at the top of the worksheet and the worksheets have been labeled appropriately • Now you are ready to Export the remaining 2 reports…be sure to close the Excel workbook before exporting
http://online.fullcoll.edu/ • Click on our eClassroom located in CE6 • Note occassional Log-in TIPS
Follow instructions here to Log In • It may take up to 24 hours after you register before you have access to CE6
Avoid some potential problems! Log In using your 8 digit student ID
You may be taking more than one course on CE6 • Click on ACCT-107F QuickBooks from the Course List
If you have CE6 access, use it for eMail questions to instructor!! • If you don’t have CE6 access, then use my campus address until you have CE6 access - pstjohn@fullcoll.edu
Final Exam • 50 multiple choice questions • Based on the chapter end progress reviews • No computer will be available for the Final • See syllabus for time, place and materials needed for the Final
Be Successful! • Print out and read the Syllabus • Introduce yourself in CE6 • Come in and see instructor at Office Hours • Get and give help in Discussions • Keep up with your work so you can weather the life and course difficulties that come up