You are previewing QuickBooks 2006: The Missing Manual.
O'Reilly logo
QuickBooks 2006: The Missing Manual

Book Description

If your company is ready to minimize paperwork and maximize productivity, control spending and boost sales, QuickBooks 2006 can help you make it happen--but only if you know how to use it. And it doesn't come with a manual. Lucky for you, there's QuickBooks 2006: The Missing Manual, the comprehensive, up-to-date guide to saving time and money while beefing up business with QuickBooks.

Award-winning author and financial whiz Bonnie Biafore helps you select the best fit for your company from Intuit's QuickBooks line of financial management software, which includes five products ranging from basic accounting software for small businesses to sophisticated industry-specific enterprise solutions. She then shows you how to tweak and tailor it to your company's needs so you can manage your finances more effectively and efficiently than ever before.

If you're new to QuickBooks or to the 2006 version, you'll get started with ease and become quickly proficient with Biafore's tutorials on making and managing a company file and creating accounts, customers, jobs, invoice items, and other lists. If you're a more advanced user, you'll find countless tips, tricks, and shortcuts for becoming a QuickBooks pro. And everyone at every level will benefit from Biafore's seasoned, sensible advice on business accounting and finance.

Under Biafore's expert direction, you will be able to use QuickBooks for a lot more than everyday bookkeeping. Beyond billing and payroll servicing, generating business forms and easing end-of-year tax preparation, QuickBooks 2006: The Missing Manual shows you how to use QuickBooks to accomplish things like inventory control, budget building, and report creation for evaluating every aspect of an enterprise.

With Biafore's clear and friendly explanations and step-by-step instructions for every QuickBooks feature (along with plenty of real-world examples), you'll learn how to take advantage of online banking options, data exchange with other programs, and sophisticated planning and tracking tools for achieving maximum business success. QuickBooks 2006: The Missing Manual makes QuickBooks more powerful than you thought possible.

Table of Contents

  1. QuickBooks 2006: The Missing Manual
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. The Missing Credits
      1. About the Author
      2. About the Creative Team
      3. Acknowledgements
      4. The Missing Manual Series
    3. Introduction
      1. What's New in QuickBooks 2006
      2. Getting to Know QuickBooks
      3. Choosing the Right QuickBooks Product
        1. The QuickBooks Premier Choices
      4. Accounting Basics—The Important Stuff
      5. About This Book
      6. About the Outline
      7. The Very Basics
      8. About → These → Arrows
      9. About MissingManuals.com
      10. Safari® Enabled
    4. I. Getting Started
      1. 1. Creating a Company in QuickBooks
        1. 1.1. Opening QuickBooks
        2. 1.2. Creating a New Company
        3. 1.3. Steps to Take Before You Create Your Company File
          1. 1.3.1. A Start Date
          2. 1.3.2. Account Balances
          3. 1.3.3. Other Important Information
        4. 1.4. Starting the EasyStep Interview
          1. 1.4.1. Company Information
          2. 1.4.2. The Administrator Password
          3. 1.4.3. Create Your Company File
          4. 1.4.4. Customizing Your Company File
        5. 1.5. What's Next
        6. 1.6. Open an Existing Company File
        7. 1.7. Convert a Quicken File to QuickBooks
        8. 1.8. Restore a Backup File
        9. 1.9. Modifying Company Information
      2. 2. Setting Up a Chart of Accounts
        1. 2.1. Obtaining a Chart of Accounts
        2. 2.2. Account Naming and Numbering
          1. 2.2.1. Setting Up Account Numbers
          2. 2.2.2. Standardizing Account Names
        3. 2.3. Creating Accounts and Subaccounts
          1. 2.3.1. Creating an Account
          2. 2.3.2. Viewing Account Names and Numbers
        4. 2.4. Modifying Accounts
        5. 2.5. Merging Accounts
        6. 2.6. Hiding and Deleting Accounts
          1. 2.6.1. Hiding Accounts
          2. 2.6.2. Deleting Accounts
      3. 3. Setting Up Customers and Jobs
        1. 3.1. What to Do Before You Create Customers and Jobs
          1. 3.1.1. Categorizing Customers and Jobs
            1. 3.1.1.1. Creating types of customers
            2. 3.1.1.2. Categorizing jobs
        2. 3.2. Creating Customers in QuickBooks
          1. 3.2.1. Creating a New Customer
            1. 3.2.1.1. Entering address information
            2. 3.2.1.2. Specifying additional customer information
            3. 3.2.1.3. Designating payment information
        3. 3.3. Importing and Exporting Customer Information
          1. 3.3.1. Exporting Customer Information
            1. 3.3.1.1. Exporting to Excel
            2. 3.3.1.2. Customized exports using the Contact List report
            3. 3.3.1.3. Exporting a text file
          2. 3.3.2. Importing Customer Information
        4. 3.4. Creating Jobs in QuickBooks
          1. 3.4.1. Creating a New Job
        5. 3.5. Modifying Customer and Job Information
        6. 3.6. Adding Notes About Customers
        7. 3.7. Merging Customer Records
        8. 3.8. Hiding and Deleting Customers
          1. 3.8.1. Deleting Customers
          2. 3.8.2. Hiding Customers
      4. 4. Setting Up Invoice Items
        1. 4.1. What Items Do
        2. 4.2. When You Don't Need Items
        3. 4.3. Should You Track Inventory with Items?
        4. 4.4. The QuickBooks Item Types
          1. 4.4.1. Items for Services
          2. 4.4.2. Items for Products
          3. 4.4.3. Other Items
        5. 4.5. Planning Your Items
          1. 4.5.1. Generic or Specific?
          2. 4.5.2. Item Naming
          3. 4.5.3. Subitems
          4. 4.5.4. Taxing Decisions
        6. 4.6. Setting Up Sales Tax
          1. 4.6.1. Sales Tax Codes
            1. 4.6.1.1. Assigning tax codes to customers
            2. 4.6.1.2. Assigning tax codes to items
            3. 4.6.1.3. Creating additional sales tax codes
          2. 4.6.2. Sales Tax Items
        7. 4.7. Creating Items
          1. 4.7.1. Service Fields
          2. 4.7.2. Inventory Part Fields
          3. 4.7.3. Non-inventory Part Fields
          4. 4.7.4. Other Charge Fields
          5. 4.7.5. Subtotal
          6. 4.7.6. Group
          7. 4.7.7. Discount
          8. 4.7.8. Payment
          9. 4.7.9. Sales Tax Item
        8. 4.8. Modifying Items
        9. 4.9. Hiding and Deleting Items
          1. 4.9.1. Hiding Items
          2. 4.9.2. Deleting Items
      5. 5. Setting Up Other QuickBooks Lists
        1. 5.1. The Vendor List
          1. 5.1.1. Entering Address Information
          2. 5.1.2. Additional Info
        2. 5.2. Classes
        3. 5.3. Price Levels
        4. 5.4. Customer & Vendor Profile Lists
          1. 5.4.1. Sales Rep List
          2. 5.4.2. Customer Type List
          3. 5.4.3. Vendor Type List
          4. 5.4.4. Job Type List
          5. 5.4.5. Terms List
          6. 5.4.6. Customer Message
          7. 5.4.7. Payment Method List
          8. 5.4.8. Ship Via List
          9. 5.4.9. Vehicle List
        5. 5.5. Memorized Transactions
        6. 5.6. Fixed Asset Items
        7. 5.7. Creating and Editing List Entries
          1. 5.7.1. Creating Entries
          2. 5.7.2. Editing Entries
        8. 5.8. Merging List Entries
        9. 5.9. Hiding and Deleting List Entries
          1. 5.9.1. Hiding Entries
          2. 5.9.2. Deleting Entries
        10. 5.10. Sorting Lists
        11. 5.11. Printing Lists
          1. 5.11.1. Blasting Out a Quick List
          2. 5.11.2. Customizing a Printed List
      6. 6. Configuring Preferences to Fit Your Company
        1. 6.1. An Introduction to Preferences
        2. 6.2. Accounting Preferences
        3. 6.3. Checking
          1. 6.3.1. Choosing the Bank Accounts You Use
          2. 6.3.2. Setting the Way Company Checks Work
          3. 6.3.3. Choosing Company-Wide Payroll Accounts
        4. 6.4. Desktop View
          1. 6.4.1. Window Preferences
          2. 6.4.2. Preferences for Saving the Desktop
          3. 6.4.3. Choosing a Color Scheme
          4. 6.4.4. Setting Up the QuickBooks Home Page
        5. 6.5. Finance Charge
        6. 6.6. General
          1. 6.6.1. Tuning QuickBooks to Your Liking
          2. 6.6.2. Company-Wide General Preferences
        7. 6.7. Jobs & Estimates
        8. 6.8. Payroll & Employees
        9. 6.9. Purchases & Vendors
        10. 6.10. Reminders
          1. 6.10.1. Reminders on the My Preferences Tab
          2. 6.10.2. Reminders for Everyone
        11. 6.11. Reports and Graphs
          1. 6.11.1. Preferences for the Reports You Generate
          2. 6.11.2. Preferences That Apply to Every Company Report
        12. 6.12. Sales & Customers
        13. 6.13. Sales Tax
        14. 6.14. Send Forms
        15. 6.15. Spelling
        16. 6.16. Tax: 1099
        17. 6.17. Time Tracking
      7. 7. Managing QuickBooks Files
        1. 7.1. Where to Store Your Company Files
        2. 7.2. Backing Up Files
          1. 7.2.1. Manual Backups
          2. 7.2.2. Choosing Standard Settings for Your Backups
          3. 7.2.3. Automated QuickBooks Backups
          4. 7.2.4. Unattended Backups
        3. 7.3. Restoring Backups
        4. 7.4. Sending Company Files to Others
          1. 7.4.1. Creating a Portable Company File
          2. 7.4.2. Opening a Portable Company File
        5. 7.5. Verifying Your QuickBooks Data
          1. 7.5.1. Running the Verify Data Utility
          2. 7.5.2. Reviewing Problems
          3. 7.5.3. Running the Rebuild Data Utility
        6. 7.6. Cleaning Up Data
          1. 7.6.1. Running the Clean Up Company File Tool
        7. 7.7. Deleting Files
    5. II. Accounting with QuickBooks
      1. 8. Invoicing
        1. 8.1. Choosing the Right Type of Form
          1. 8.1.1. Sales Receipts
          2. 8.1.2. Statements
          3. 8.1.3. Invoices
        2. 8.2. Creating Invoices
        3. 8.3. Filling in Invoice Header Fields
          1. 8.3.1. Choosing an Invoice Template
          2. 8.3.2. Choosing the Customer or Job
        4. 8.4. The Rest of the Header Fields
        5. 8.5. Entering Invoice Line Items
          1. 8.5.1. Inserting and Deleting Line Items
          2. 8.5.2. Invoicing for Billable Time and Costs
            1. 8.5.2.1. Assigning time and expenses to customers or jobs
            2. 8.5.2.2. Adding billable time and expenses to invoices
          3. 8.5.3. Applying Subtotals, Discounts, and Percentage Charges
          4. 8.5.4. Adding a Message to the Customer
          5. 8.5.5. Choosing How to Send the Invoice
          6. 8.5.6. Adding a Memo to Yourself
        6. 8.6. Invoicing for Backordered Products
          1. 8.6.1. Using Pending Invoices for Backorders
          2. 8.6.2. Using Sales Orders for Backorders
        7. 8.7. Memorizing Recurring Invoices
          1. 8.7.1. Editing a Memorized Invoice
        8. 8.8. Estimating Jobs
          1. 8.8.1. Creating an Estimate
          2. 8.8.2. Creating Multiple Estimates
        9. 8.9. Creating Progress Invoices
          1. 8.9.1. Progress Invoicing Options
          2. 8.9.2. Fine-Tuning a Progress Invoice
        10. 8.10. Producing Statements
          1. 8.10.1. Creating Statement Charges
          2. 8.10.2. Generating Customer Statements
            1. 8.10.2.1. Choosing the date range
            2. 8.10.2.2. Selecting customers
            3. 8.10.2.3. Setting printing options
          3. 8.10.3. Previewing Statements
          4. 8.10.4. Generating Statements
        11. 8.11. Finding Invoices (and Other Sales Forms)
        12. 8.12. Editing Invoices and Sales Receipts
        13. 8.13. Voiding and Deleting Invoices and Sales Receipts
        14. 8.14. Handling Refunds and Credits
          1. 8.14.1. Creating Credit Memos
          2. 8.14.2. Creating Refund Checks
          3. 8.14.3. Applying Credits to Invoices
        15. 8.15. Sending Sales Forms
          1. 8.15.1. Setting Print Options
          2. 8.15.2. Aligning Forms and Paper
          3. 8.15.3. Choosing a Send Method
          4. 8.15.4. Print One Form
          5. 8.15.5. Printing in Batches
          6. 8.15.6. Printing Mailing and Shipping Labels
          7. 8.15.7. Printing Packing Slips
          8. 8.15.8. Emailing Sales Forms
          9. 8.15.9. Emailing One Form
          10. 8.15.10. Emailing in Batches
      2. 9. Managing Accounts Receivable
        1. 9.1. The Aging of Receivables
          1. 9.1.1. Accounts Receivable Aging Reports
          2. 9.1.2. Customer & Job Reports
        2. 9.2. Receiving Payments for Invoiced Income
        3. 9.3. Applying Credits to Invoices
        4. 9.4. Discounting for Early Payment
        5. 9.5. Deposits, Down Payments, and Retainers
          1. 9.5.1. Setting Up QuickBooks for Prepayments
          2. 9.5.2. Recording Prepayments
          3. 9.5.3. Applying a Deposit, Down Payment, or Retainer to an Invoice
          4. 9.5.4. Refunding Prepayments
        6. 9.6. Applying Finance Charges
          1. 9.6.1. Finance Charge Preferences
          2. 9.6.2. Assessing Finance Charges on Overdue Balances
        7. 9.7. Cash Sales
          1. 9.7.1. Creating Sales Receipts
          2. 9.7.2. Creating a Batch Sales Template
          3. 9.7.3. Reconciling Excess and Short Cash
        8. 9.8. Making Deposits
          1. 9.8.1. Choosing Payments to Deposit
          2. 9.8.2. Recording Deposits
          3. 9.8.3. Depositing Money from Merchant Card Accounts
      3. 10. Paying for Expenses
        1. 10.1. When to Pay Expenses
        2. 10.2. Entering Bills in QuickBooks
        3. 10.3. Automating Recurring Bills
          1. 10.3.1. Memorizing a Bill
          2. 10.3.2. Creating Memorized Groups of Bills
          3. 10.3.3. Using a Memorized Bill
        4. 10.4. Purchasing Inventory
          1. 10.4.1. Creating Purchase Orders
          2. 10.4.2. Receiving Inventory and Bills Simultaneously
          3. 10.4.3. Receiving Inventory Before the Bill
        5. 10.5. Handling Reimbursable Expenses
          1. 10.5.1. Setting Up Reimbursements as Income
          2. 10.5.2. Recording Reimbursable Expenses
        6. 10.6. Paying Your Bills
          1. 10.6.1. Selecting Bills to Pay
          2. 10.6.2. Modifying Payment Amounts
          3. 10.6.3. Applying Discounts and Credits
            1. 10.6.3.1. Applying discounts manually
            2. 10.6.3.2. Applying credits manually
          4. 10.6.4. Setting the Payment Method and Account
          5. 10.6.5. Saving Paid Bills
        7. 10.7. Producing Checks
          1. 10.7.1. Writing Checks by Hand
          2. 10.7.2. Setting Up QuickBooks for Printing Checks
          3. 10.7.3. Printing Checks
        8. 10.8. Writing Checks Without Entering Bills
          1. 10.8.1. Using the Write Checks Dialog Box
          2. 10.8.2. Adding Checks to an Account Register
        9. 10.9. Paying with Cash
        10. 10.10. Paying with Credit Cards
        11. 10.11. Recording Vendor Credits
        12. 10.12. Paying Sales Tax
          1. 10.12.1. Sales Tax Payment Preferences
          2. 10.12.2. Producing Reports of the Sales Tax You Owe
          3. 10.12.3. Remitting Sales Taxes
      4. 11. Payroll
        1. 11.1. Choosing a Payroll Service
        2. 11.2. Applying for a Payroll Service
        3. 11.3. Setting Up Payroll
          1. 11.3.1. Setting Up Compensation and Benefits
          2. 11.3.2. Setting Up Employees
            1. 11.3.2.1. Setting employee defaults
            2. 11.3.2.2. Creating employee records
          3. 11.3.3. Setting Up Payroll Taxes
        4. 11.4. Entering Historical Payroll
        5. 11.5. Running Payroll
          1. 11.5.1. Selecting Employees
          2. 11.5.2. Fill in Paycheck Data
          3. 11.5.3. Printing Paychecks and Pay Stubs
        6. 11.6. Paying Payroll Taxes
        7. 11.7. Preparing Payroll Tax Forms
      5. 12. Bank Accounts, Credit Cards, and Petty Cash
        1. 12.1. Entering Transactions in an Account Register
          1. 12.1.1. Opening a Register Window
          2. 12.1.2. Creating a Transaction in an Account Register
        2. 12.2. Handling Bounced Checks
          1. 12.2.1. Setting Up QuickBooks to Handle Bounced Checks
            1. 12.2.1.1. Bounced check item
            2. 12.2.1.2. Service charges for bounced checks
          2. 12.2.2. Recording Bank Charges
          3. 12.2.3. Bounced Checks
        3. 12.3. Transferring Funds
        4. 12.4. Reconciling Accounts
          1. 12.4.1. Preparing for the First Reconciliation
          2. 12.4.2. Preparing for Every Reconciliation
          3. 12.4.3. Starting a Reconciliation
          4. 12.4.4. Reconciling Transactions
          5. 12.4.5. Reconciliation Reports
          6. 12.4.6. Modifying Transactions During Reconciliation
          7. 12.4.7. Stopping and Restarting a Reconciliation
          8. 12.4.8. Correcting Discrepancies
            1. 12.4.8.1. The Discrepancy Report
            2. 12.4.8.2. Other ways to find discrepancies
          9. 12.4.9. Undoing the Last Reconciliation
          10. 12.4.10. When Your Bank Makes a Mistake
        5. 12.5. Managing Loans
          1. 12.5.1. Setting Up a Loan
          2. 12.5.2. Adding a Loan to Loan Manager
            1. 12.5.2.1. Basic setup
            2. 12.5.2.2. Payment information
            3. 12.5.2.3. Interest rate information
          3. 12.5.3. Modifying Loan Terms
          4. 12.5.4. Setting Up Payments
          5. 12.5.5. What If Scenarios
        6. 12.6. Tracking Petty Cash
          1. 12.6.1. Recording ATM Withdrawals and Deposits to Petty Cash
          2. 12.6.2. Recording Purchases Made with Petty Cash
      6. 13. Making Journal Entries
        1. 13.1. Balancing Debit and Credit Amounts
        2. 13.2. Some Reasons to Use Journal Entries
        3. 13.3. Creating General Journal Entries
        4. 13.4. Filling in General Journal Entry Fields
        5. 13.5. Checking General Journal Entries
        6. 13.6. Reclassifications and Corrections
        7. 13.7. Depreciation
      7. 14. Working with Financial Statements
        1. 14.1. The Profit & Loss Report
          1. 14.1.1. Understanding the Profit & Loss Report
          2. 14.1.2. Generating a Profit & Loss Report
          3. 14.1.3. Other Profit & Loss Reports
        2. 14.2. The Balance Sheet
          1. 14.2.1. Understanding the Balance Sheet
          2. 14.2.2. Generating a Balance Sheet Report
        3. 14.3. The Statement of Cash Flows
          1. 14.3.1. Understanding the Statement of Cash Flows
          2. 14.3.2. Generating a Statement of Cash Flows
    6. III. Managing Your Business
      1. 15. End-of-Year Tasks
        1. 15.1. Viewing the Trial Balance
        2. 15.2. Generating Year-End Financial Reports
          1. 15.2.1. The Year-End Profit & Loss Report
          2. 15.2.2. The Year-End Balance Sheet
        3. 15.3. Generating Tax Reports
        4. 15.4. Sharing the Company File with Your Accountant
          1. 15.4.1. Creating an Accountant's Review Copy
          2. 15.4.2. Merging Accountant Changes into Your Company File
          3. 15.4.3. Canceling an Accountant's Review Copy
        5. 15.5. 1099s
          1. 15.5.1. Generating 1099 Reports
          2. 15.5.2. Printing 1099-MISC Forms
        6. 15.6. Closing the Books for the Year
      2. 16. Managing Inventory
        1. 16.1. The QuickBooks Inventory Process
          1. 16.1.1. Setting Up Inventory Items
          2. 16.1.2. Ordering and Purchasing Inventory
          3. 16.1.3. Selling Inventory
        2. 16.2. Running Inventory Reports
          1. 16.2.1. Inventory Valuation: How Much Is Inventory Worth?
            1. 16.2.1.1. The Inventory Valuation Summary report
            2. 16.2.1.2. The Inventory Valuation Detail report
          2. 16.2.2. Inventory Stock Status
          3. 16.2.3. Viewing One Inventory Item
        3. 16.3. Performing a Physical Inventory
        4. 16.4. Adjusting Inventory in QuickBooks
          1. 16.4.1. Adjusting Quantities
          2. 16.4.2. Adjusting Quantities and Values
      3. 17. Tracking Time and Mileage
        1. 17.1. Setting Up Time Tracking
          1. 17.1.1. Turning on Time Tracking
          2. 17.1.2. Setting Up the People Who Track Time
          3. 17.1.3. Setting Up Items and Customers for Time Tracking
        2. 17.2. Entering Time in Timesheets
          1. 17.2.1. Filling in Weekly Timesheets
          2. 17.2.2. Entering Time for One Activity
        3. 17.3. Setting Up the Standalone Timer
          1. 17.3.1. Exporting Lists for Timer Users
          2. 17.3.2. Distributing Timer
          3. 17.3.3. Importing Workers' Time into QuickBooks
        4. 17.4. Using Timer to Track Time
          1. 17.4.1. Installing the Timer on a Computer
          2. 17.4.2. Setting Up the Timer Program
          3. 17.4.3. Setting Up an Activity
          4. 17.4.4. Entering Time
            1. 17.4.4.1. Stopwatch timing
            2. 17.4.4.2. Typing in time
          5. 17.4.5. Creating an Export File of Your Time
        5. 17.5. Running Time Reports
        6. 17.6. Tracking Mileage
          1. 17.6.1. Adding a Vehicle
          2. 17.6.2. Setting the Mileage Rate
          3. 17.6.3. Recording Mileage Driven
        7. 17.7. Generating Mileage Reports
      4. 18. Budgeting and Planning
        1. 18.1. Types of Budgets
        2. 18.2. Ways to Build Budgets
        3. 18.3. Creating Budgets in QuickBooks
        4. 18.4. Filling in Budget Values
          1. 18.4.1. Copy Across the Columns
          2. 18.4.2. Adjust Row Amounts
        5. 18.5. Creating Additional Customer:Job or Class Budgets
        6. 18.6. Copying Budgets and Creating What-if Budgets
        7. 18.7. Running Budget Reports
          1. 18.7.1. The Budget Overview Report
            1. 18.7.1.1. Report layouts
          2. 18.7.2. Budget vs. Actual Report
          3. 18.7.3. Profit & Loss Budget Performance Report
          4. 18.7.4. Budget vs. Actual Graph
        8. 18.8. Planning with QuickBooks Decision Tools
      5. 19. Tracking Your Business with Reports
        1. 19.1. Finding the Right Reports
        2. 19.2. A Quick Guide to QuickBooks Reports
          1. 19.2.1. Company & Financial Reports
            1. 19.2.1.1. Profit & Loss reports
            2. 19.2.1.2. Income and expenses
            3. 19.2.1.3. Balance sheet
            4. 19.2.1.4. Statement of Cash Flows
          2. 19.2.2. Customers & Receivables Reports
            1. 19.2.2.1. Accounts Receivable Aging reports
            2. 19.2.2.2. Customer balance reports
            3. 19.2.2.3. Customer lists
          3. 19.2.3. Sales Reports
          4. 19.2.4. Jobs, Time & Mileage
            1. 19.2.4.1. Job reports
            2. 19.2.4.2. Time reports
            3. 19.2.4.3. Mileage reports
          5. 19.2.5. Vendors & Payables
            1. 19.2.5.1. A/P Aging and Vendor Balance reports
            2. 19.2.5.2. 1099 forms
            3. 19.2.5.3. Sales tax reports
          6. 19.2.6. Purchases
          7. 19.2.7. Inventory
          8. 19.2.8. Employees and Payroll
          9. 19.2.9. Banking
          10. 19.2.10. Accountant and Taxes
          11. 19.2.11. Budgets and Forecasts
          12. 19.2.12. List Reports
          13. 19.2.13. Custom Reports
        3. 19.3. A Review of Report Preferences
          1. 19.3.1. Company-Wide Report Preferences
          2. 19.3.2. Individual Preferences
        4. 19.4. Running Reports
          1. 19.4.1. Printing and Saving Reports
          2. 19.4.2. Printing Reports
          3. 19.4.3. Saving Reports to Files
        5. 19.5. Customizing Reports
        6. 19.6. Date Ranges
        7. 19.7. Subtotals
        8. 19.8. Customizing the Columns in Reports
          1. 19.8.1. Adding and Removing Columns
          2. 19.8.2. Resizing and Moving Columns
        9. 19.9. Sorting Reports
        10. 19.10. Filtering Reports
        11. 19.11. Report Headers and Footers
        12. 19.12. Fonts and Numbers
        13. 19.13. Memorizing Reports
        14. 19.14. Swapping Reports Between Company Files
          1. 19.14.1. Exporting a Report
        15. 19.15. Importing Report Templates
    7. IV. QuickBooks Power
      1. 20. Online Banking Services
        1. 20.1. Setting Up Your Internet Connection
        2. 20.2. Setting Up Your Accounts for Online Services
          1. 20.2.1. Applying for Online Services
          2. 20.2.2. Activating Online Services for Your QuickBooks Account
        3. 20.3. Exchanging Data with Your Financial Institution
          1. 20.3.1. Downloading Statements with WebConnect
          2. 20.3.2. Exchanging Data via a Direct Connection
          3. 20.3.3. Working with Online Items
        4. 20.4. Creating Online Items for Direct Connections
          1. 20.4.1. Sending a Message to Your Bank
          2. 20.4.2. Transferring Funds Between Accounts
        5. 20.5. Viewing and Matching Downloaded Transactions
          1. 20.5.1. Matching the Transactions QuickBooks Couldn't Match
            1. 20.5.1.1. Unmatched checks
            2. 20.5.1.2. Unmatched deposits
            3. 20.5.1.3. Bank charges
        6. 20.6. Paying Bills Online
      2. 21. Sharing QuickBooks Data with Other Programs
        1. 21.1. Mail Merge to a Word Document
          1. 21.1.1. Creating Letters and Envelopes in QuickBooks
        2. 21.2. Synchronizing Contacts
          1. 21.2.1. Using QuickBooks Contact Sync for Outlook
          2. 21.2.2. Setting Up Contacts in Act!
          3. 21.2.3. Synchronizing Data with Act!
        3. 21.3. Finding Third-Party Integrated Applications
          1. 21.3.1. The QuickBooks Solutions Marketplace
          2. 21.3.2. Other Ways to Find Third-Party Programs
        4. 21.4. Setting Up an Integrated Application
        5. 21.5. Exporting QuickBooks Data
          1. 21.5.1. Exporting Lists and Addresses
            1. 21.5.1.1. Exporting lists
            2. 21.5.1.2. Exporting addresses
          2. 21.5.2. Exporting Reports
        6. 21.6. Importing Data from Other Programs
          1. 21.6.1. Importing an Excel Spreadsheet
          2. 21.6.2. Importing a Delimited File
        7. 21.7. QuickBooks Add-on Services
          1. 21.7.1. Merchant Services
          2. 21.7.2. Intuit Payroll Services
          3. 21.7.3. QuickBooks Billing Solutions
      3. 22. Customizing QuickBooks
        1. 22.1. Customizing the Home Page
        2. 22.2. Customizing the Icon Bar
          1. 22.2.1. Adding and Removing Icons
          2. 22.2.2. Changing Icon Appearance
          3. 22.2.3. Changing the Order of Icons
        3. 22.3. Customizing Forms
          1. 22.3.1. Editing an Existing Form
          2. 22.3.2. Creating a New Template
          3. 22.3.3. Customizing Form Content
          4. 22.3.4. Laying out Forms
          5. 22.3.5. Selecting Form Objects
          6. 22.3.6. Moving and Resizing Objects
            1. 22.3.6.1. Moving objects
            2. 22.3.6.2. Resizing objects
          7. 22.3.7. Adding, Removing, and Copying Objects
          8. 22.3.8. Formatting Forms
          9. 22.3.9. Other Handy Layout Tools
          10. 22.3.10. Managing Templates
            1. 22.3.10.1. Duplicate
            2. 22.3.10.2. Make active/inactive
            3. 22.3.10.3. Export
      4. 23. Keeping Your QuickBooks Data Secure
        1. 23.1. Setting Up the Administrator
          1. 23.1.1. Assigning the Administrator User Name and Password
          2. 23.1.2. Changing the QuickBooks Administrator
        2. 23.2. Creating QuickBooks Users
          1. 23.2.1. Adding New Users
        3. 23.3. Restricting Access to Features and Data
          1. 23.3.1. What the Access Areas Represent
          2. 23.3.2. Setting Access Rights
        4. 23.4. Audit Trails
    8. V. Appendixes
      1. A. Installing QuickBooks
        1. A.1. Before You Install
        2. A.2. Installing QuickBooks
        3. A.3. Registering QuickBooks
        4. A.4. Setting Up QuickBooks on a Network
          1. A.4.1. Storing Company Files
      2. B. Finding Help
        1. B.1. QuickBooks Help
        2. B.2. Help As You Work
        3. B.3. Other Help Resources
      3. C. Keyboard Shortcuts
        1. C.1. Task Shortcuts
        2. C.2. Transaction Shortcuts
        3. C.3. Date Shortcuts
        4. C.4. Window Shortcuts
        5. C.5. Miscellaneous Shortcuts
    9. Index
    10. About the Author
    11. Colophon
    12. SPECIAL OFFER: Upgrade this ebook with O’Reilly