This intermediate course teaches you how to execute specialized transactions and functions within QuickBooks. Topics include designing custom business forms, generating comprehensive financial reports, working with advanced account types, managing sales tax obligations, and leveraging online banking features. Students must successfully complete QuickBooks Part I or have a minimum of three months of hands-on QuickBooks experience prior to enrollment.
Course prerequisite: Completion of introductory QuickBooks training (Part I) or a minimum of three months of practical QuickBooks experience is required before participating in this course.
Complete course outline:
Lesson 1: Memorizing Transactions and Automating Data Entry
- Recording a new memorized transaction entry
- Terminating memorized transactions
- Removing memorized transactions from your system
- Organizing memorized transactions into logical groupings
- Utilizing stored, memorized transactions for data entry
- Generating a list of all memorized transactions
- Summary and key concepts
Lesson 2: Customizing Business Forms
- Building a custom form template
- Adjusting template layout and content
- Generating printed documents from customized forms
- Summary and key concepts
Lesson 3: Advanced Account Types and Functions
- Introduction to specialized QuickBooks account categories
- Processing credit card account transactions
- Managing fixed asset accounts and depreciation
- Handling long-term liability accounts
- Applying Loan Manager functionality
- Summary and key concepts
Lesson 4: Report Generation and Analysis
Generating Quick Report Views
- Working with pre-formatted report templates
- Distributing and sharing generated reports
- Converting reports into Microsoft Excel format
- Producing printed report documentation
- Summary and key concepts
Lesson 5: Creating Visual Data Presentations
- Generating QuickInsight visual graphs
- Implementing QuickZoom drill-down capabilities
- Creating and interpreting sales performance graphs
- Modifying graph appearance and format
- Printing customized graph presentations
- Summary and key concepts
Lesson 6: Sales Tax Management and Compliance
- Configuring sales tax functionality in QuickBooks
- Establishing tax rates and identifying tax agencies
- Determining taxable entities and transactions
- Calculating and applying tax to sales transactions
- Computing tax liability and amounts owed
- Processing tax agency payments
- Summary and key concepts
Appendix A: Online Banking and Electronic Payment Processing
- Establishing internet connectivity for online features
- Configuring bank feed connections for accounts
- Reviewing, retrieving, and entering downloaded transactions
- Executing electronic payment transactions
- Performing online account transfers
- Stopping and reversing online payments
- Summary and key concepts
Appendix B: File Management and Multi-user Administration
- Operating QuickBooks in collaborative multi-user environments
- Creating and administering user accounts with security controls
- Establishing fiscal close dates for accounting periods
- Generating QuickBooks data for accountant review and modification
- Installing QuickBooks software updates
- Creating backup files and restoring from backups
- Reducing file size through data compression
- Summary and key concepts
Appendix C: Project Estimation, Time Documentation, and Job Cost Tracking
- Generating project cost estimates for clients
- Converting project estimates into billable invoices
- Producing estimate summary reports and analysis
- Updating and tracking job progress status
- Recording time spent on projects and tasks
- Generating time tracking reports
- Monitoring vehicle mileage and usage
- Creating mileage reimbursement reports
- Accessing comprehensive job costing reports
- Summary and key concepts
Appendix D: Business Communication Document Generation
- Applying the Letters and Envelopes template wizard
- Designing custom letter templates for business communications
- Summary and key concepts
