QuickBooks Pro 2009: Level 2

By Trisha Hakola

 

Table of Contents


Lesson 1: Dealing with Physical Inventory

QuickBooks and Inventory Tracking

Should I Use QuickBooks to Track My Company’s Inventory?

Setting Up the Item List

Inventory vs. Non-Inventory Parts

Using Units of Measure

Cost of Goods Sold

Inventory Valuation

Dealing with Sales Tax in QuickBooks

Sales Tax Items and Groups

Default Tax Rate

Dealing with Multiple Sales Tax Rates

Creating Purchase Orders

Non-Posting Accounts

The QuickBooks To-Do List

The Reminders List

The Alerts Manager

Receiving Items

The Two Methods of Receiving Items

Including Expenses on a Bill for Items

Adjusting Quantity/Value on Hand

Adjusting the Quantity of Your Inventory

Adjusting the Value of Your Inventory

Managing Inventory-Related Reports

Physical Inventory Tally

Concepts Review

Skill Builders

Assessments

Critical Thinking

 

Lesson 2: Selling Inventory Items

Working with Customer & Vendor Profile Lists

Table of Customer & Vendor Profile Lists

Making the Lists Work for You

Selling Items

Templates Provided by Intuit

Producing Sales Orders

The QuickBooks Shipping Manager

Discount Payment Terms

Processing Sales Discounts and Electronic Payments

Working with Electronic Customer Payments

Assessing Finance Charges

Setting Finance Charge Preferences

Using a Batch of Statements to Bill for Finance Charges

Writing Off Bad Debt

Treating Bad Debt as a Discount

Using a Credit Memo to Write Off a Bad Debt

Paying Sales Tax

Sales Tax Payable

The Sales Tax Liability Report

Dealing with Adjustments in Sales Tax

Working with Sales and Receivables Reports and Graphs

 

Concepts Review

Skill Builders

Assessments

Critical Thinking

 

Lesson 3: Using QuickBooks for Payroll

Setting Up QuickBooks to Run Payroll

Evaluating Payroll Options

The Payroll Setup Interview

Payroll Items

Entering Historical Amounts

Payroll Recordkeeping in QuickBooks

Making Payroll Data More Meaningful

Verifying Correct Payroll Item Setup

Common Mistakes When Using QuickBooks for Payroll

Setting Up Employees Through the Payroll Setup Interview

Gather Your Employee Information

Working with the Employee List

Managing the Employee List

Setting Employee Defaults

Dealing with Payroll Taxes

Creating Paychecks

Passing On Billable Time to Customers

Tracking and Paying Payroll Liabilities

Knowing How Much to Pay

The Pay Payroll Liabilities Window

Working with 1099s and Processing Payroll Forms

W-2s and W-3s

940 and 941

1099 MISC and 1096

Concepts Review

Skill Builders

Assessments

Critical Thinking

 


Lesson 4: Working with Balance Sheet Accounts

Working with Other Current Assets

Balance Sheet Accounts

The Show Lowest Subaccount Preference

Setting a Default Bank Account

Transferring Funds Between Accounts

Memorizing Transactions

Tracking Petty Cash

Recording Methods

Working with Fixed Asset Accounts

Depreciation

Accumulated Depreciation: What Is It and Why Use It

Current Book Value

Fixed Asset Items

Setting Up a Long Term Liability

The QuickBooks Loan Manager

Preparing to Use the Loan Manager

Working with Equity Accounts

Owner’s Equity

Retained Earnings

Opening Balance Equity

Concepts Review

Skill Builders

Assessments

Critical Thinking

 

Lesson 5: Creating Estimates and Using Classes, Job Costing, and Time Tracking

Working with Classes

What Are Classes?

Common Uses for Classes

Setting Up and Managing Classes

Planning for Class Tracking

Using Classes for Profit Center Reporting

Utilizing Subclasses

Applying Classes to Transactions

Consistent Class Applications

Choosing Classes on Forms

Running Class Reports

The Profit & Loss Unclassified Report

Creating an Estimate for a Job

Job Costing in QuickBooks

Preparing for Job Costing

Converting an Estimate to an Invoice

Progress Invoicing

Using QuickBooks’ Time Tracking Feature

Methods of Entering Time

Using Time Tracking Hours to Create a Paycheck

Allocating Salaried Pay to an Individual Customer or Job

Invoicing a Customer for Time Spent on a Job

Reporting for Estimates and Time Tracking

Concepts Review

Skill Builders

Assessments

Critical Thinking

 

 

Lesson 6: Demystifying “Behind the Scenes” and Customizing QuickBooks

Digging in “Behind the Scenes”

Making Journal Entries

Rule #1: Debits and Credits Must Always Be Equal

Remembering the Item List

Customizing Reports and Graphs

Display Properties

Filtering

Formatting

Fonts

Working with Additional Formatting Options

Header and Footer Options

Page Layout

Dealing with Memorized Reports

Creating Custom Fields

Adding Custom Fields

Creating Custom Forms

Templates

Creating a Custom Template

Using Custom Fields in Forms and Reports

Working with the Layout Designer Window

Selecting Multiple Objects

Moving Objects in the Layout Designer

Resizing Objects

Closing the Books

The Audit Trail

Working with an Accountant’s Copy

Cleaning Up Your Data

Concepts Review

Skill Builders

Assessments

Critical Thinking