Current PBOX Manual

Transcription

Learning Manual15PBOX-MD1

Mastering QuickBooksLevel 2Learning Manual CopyrightCopyright 2014 by David J. O’Brien and/or National Real World Training, Inc. All rightsreserved. Screen shots 2014 Intuit Inc. All rights reserved. This publication, or any partthereof, may not be reproduced or transmitted in any form or by any means, electronic ormechanical, including photocopying, recording, storage in an information retrievalsystem, or otherwise, without the prior written permission of David J. O’Brien or NationalReal World Training, Inc.Trademark AcknowledgementsIntuit, Quicken, QuickBooks, QuickBooks Pro, TurboTax, ProSeries, Lacerte, EasyStep,QuickZoom, and ProAdvisor are registered trademarks or service marks of Intuit Inc.Windows, Microsoft, Excel, and Outlook are registered trademarks of MicrosoftCorporation. Mac and Apple are registered trademarks of Apple Inc. Other brand namesand product names are trademarks or registered trademarks of their respective holders.DisclaimerThese training materials are provided without any warranty whatsoever, including, but notlimited to, the implied warranties of merchantability or fitness for a particular purpose. Allnames of persons or companies in this manual are fictitious unless otherwise noted.Real World Training5501 LBJ Freeway, Suite 180Dallas, TX 75240-5525Phone (214) 515-0577Fax (214) 515-0580www.quickbookstraining.com

Table of ContentsCHAPTER 1-INTRODUCTION & PRODUCT OVERVIEW . 1INTUIT RESOURCES . 3EDITIONS OF QUICKBOOKS. 5WHAT QUICKBOOKS DOESN’T DO . 6CHAPTER 2-SETUP ISSUES . 7SHOULD I START OVER? . 8SETUP ORDER . 9EXPRESS START . 11COMPLETE YOUR SETUP . 12DETAILED START . 14ENTER OPENING BALANCES . 16PAYROLL SETUP . 20ENTER HISTORY . 21CHECK SETUP . 22CHAPTER 3-CUSTOMIZING QUICKBOOKS. 25PREFERENCES . 27CUSTOMIZE ICON BAR . 29CUSTOM FIELDS . 30ACCOUNT NUMBERS . 32CLASSES . 33CHAPTER 4-ITEMS & INVENTORY . 35EXPENSES VS. ITEMS . 36INVENTORY LIMITATIONS . 37GROUP ITEMS . 40INVENTORY ASSEMBLIES . 41UNITS OF MEASURE . 44CHAPTER 5-SALES TRANSACTIONS . 45ESTIMATES/INVOICE FROM ESTIMATE . 47PRICE LEVELS . 50SALES ORDERS . 53BATCH INVOICING . 56BILLABLE COSTS . 58ADVANCED SALES TAX . 59CHAPTER 6-SALES TRANSACTION WORKAROUNDS. 63CUSTOMER DEPOSITS . 64BAD DEBTS . 70CUSTOMER UNDER/OVER PAYMENTS . 73MULTIPLE A/R ACCOUNTS . 77RETAIL SALES. 79DEPOSIT CREDIT CARD RECEIPTS . 82CHAPTER 7-PURCHASES & PAYABLES . 83PURCHASE FIXED ASSETS . 85LOAN MANAGER . 87LINES OF CREDIT . 91FIX BILL PAYMENT ERRORS . 961099S/1096 . 98

CHAPTER 8-ADVANCED PURCHASE TRANSACTIONS . 101EMPLOYEE/OWNER PURCHASES . 102PREPAID EXPENSES . 104VENDOR DEPOSITS . 106SUPPORT SCHEDULES . 108VENDOR REFUNDS . 111TRADING A/R & A/P ACCOUNT BALANCES . 113VOID PRIOR PERIOD CHECKS . 116CASH FLOW PROJECTOR. 118CHAPTER 9-PAYROLL . 121MAPPING PAYROLL ITEMS . 126PAYCHECK ISSUES . 128TRACK EMPLOYEE LOANS . 133COMPANY & EMPLOYEE EXPENSES . 136W-2S AND W-3 . 138MANUALLY ADJUST W-2S & W-3 . 139TIME REPORTS BY BILLED STATUS . 145SUMMARIZE PAYROLL DATA IN EXCEL . 146CHAPTER 10-REPORTS . 147TYPES OF REPORTS . 151CUSTOM REPORTS . 152MODIFY REPORTS . 154MEMORIZE AND MANAGE REPORTS . 158CHAPTER 11-REPORTS- EXPERT . 161REPORT CONSIDERATIONS . 162SPECIAL FIELDS . 163WORK WITH MICROSOFT EXCEL . 170QUICKBOOKS STATEMENT WRITER. 176CHAPTER 12-FILE UTILITIES . 177SCHEDULED BACKUPS . 178CONDENSE DATA . 179IMPROVE PERFORMANCE . 181CORRUPT DATA FILES . 182VERIFY/REBUILD DATA FILES . 183CHAPTER 13-IMPORTING & EXPORTING . 185BETWEEN QUICKBOOKS FILES . 186QUICKBOOKS AND OTHER PROGRAMS . 190QUICKBOOKS AND EXCEL . 193ADD/EDIT MULTIPLE LIST ENTRIES . 194CHAPTER 14-WORKING WITH ACCOUNTANTS . 195JOURNAL ENTRIES . 196YEAR-END PROCEDURES . 197ACCOUNTANT-CLIENT SCENARIOS . 198ACCOUNTANT’S COPY-STEP BY STEP . 200CONDENSE DATA . 203FIND PRIOR YEAR CHANGES . 208REPORT ISSUES. 210APPENDIX-MULTICURRENCY . 215SET UP MULTIPLE CURRENCIES . 216FOREIGN PRICE LEVEL . 219MULTIPLE CURRENCY TRANSACTIONS . 220REPORTS/ACTIVITIES . 223

Chapter 1Introduction &ProductOverviewMastering QuickBooksLevel 21

Introduction & Product Overview-Chapter 1IntroductionWelcomeWelcome to Mastering QuickBooks Level 2. The focus of this training is using QuickBooks to itsfullest potential, and getting what you need from QuickBooks.Goals/Learning Objectives1) Learn the advanced features and capabilities of QuickBooks (including thosefeatures that advanced users use most)2) Discover solutions to errors (that are difficult to find using available help)3) Apply workarounds to handle tricky transactions4) Learn tricks and tips to get the most from QuickBooks5) Gain insight into QuickBooks functionality to avoid unexpected results6) Learn how best to set up QuickBooks for your company7) Learn advanced reporting techniques to access the information you needAbout IntuitIntuit Inc. is a leading provider of business and financial management solutions for smallbusinesses, consumers and accounting professionals. Its flagship products and services, includingQuickBooks , Quicken and TurboTax sof

5501 LBJ Freeway, Suite 180 Dallas, TX 75240-5525 Phone (214) 515-0577 Fax (214) 515-0580 www.quickbookstraining.com. Mastering QuickBooks . Table of Contents. CHAPTER 1-INTRODUCTION & PRODUCT OVERVIEW . 1. INTUIT RESOURCES.