You are previewing QuickBooks® 2014 In Depth.
O'Reilly logo
QuickBooks® 2014 In Depth

Book Description

Do more in less time!

Whether you’re an entrepreneur, accountant, or bookkeeper, this comprehensive guide will help you get the most out of QuickBooks 2014: more productivity, more business knowledge, and more value! Drawing on her unsurpassed QuickBooks consulting and accounting experience, Laura Madeira delivers quickstart instructions plus step-by-step guides and practical checklists for taking total control over business finances. With Quickbooks and this book at your disposal, you’ll improve everything from planning to reporting and payroll to invoicing.

  • Create a new QuickBooks file; convert from other software; and set up users, permissions, and preferences

  • Expanded! Learn how to use tools specific to your version of QuickBooks, including QuickBooks Enterprise Solutions

  • Understand QuickBooks lists from the chart of accounts, items, classes, and more

  • Set up and manage inventory, vendors, customers, and payroll

  • Track product or service sales and manage the profitability of your company

  • Efficiently use Bank Feeds to download bank and credit card transactions

  • Master all the essentials of financial reporting; customize and memorize reports

  • Review the accuracy of your data, with step-by-step instructions accompanied by checklists

  • Share QuickBooks data with your accountant or client at tax time

  • Use QuickBooks 2014’s tools for managing loans, planning and preparing for year-end, and syncing with Outlook contacts

  • Efficiently review and correct client data errors, from misclassified transactions to incorrect beginning balances

  • Prepare customized reports and documents using MS Excel and Word integration

  • Master powerful shortcuts for working more efficiently and saving precious time

  • Learn how to reliably back up your data, troubleshoot database errors, and manage QuickBooks data integrity

  • All In Depth books offer

  • Comprehensive coverage with detailed solutions

  • Troubleshooting help for tough problems you can’t fix on your own

  • Outstanding authors recognized worldwide for their expertise and teaching style

  • Learning, reference, problem-solving...the only QuickBooks 2014 book you need!

    Register your book at

    Table of Contents

    1. Title Page
    2. Copyright Page
    3. Dedication
    4. Contents at a Glance
    5. Contents
    6. About the Author
    7. About the Technical Editor
    8. Acknowledgments
    9. We Want to Hear from You!
    10. Reader Services
    11. Introduction
      1. How This Book Is Organized
      2. Conventions Used in This Book
    12. What’s New in QuickBooks 2014
      1. New and Improved Features
      2. For the Accounting Professional
      3. For QuickBooks Enterprise Users
      4. QuickBooks Enterprise with Advanced Pricing
    13. 1. Getting Started with QuickBooks
      1. Understanding QuickBooks
      2. Using QuickBooks Sample Data
      3. Creating a New QuickBooks File
      4. Converting from Other Accounting Software
      5. Setting Up Users and Permissions
      6. User Security in QuickBooks Enterprise
      7. Reporting on User Activity
    14. 2. Getting Around QuickBooks
      1. Home Page and Navigation
      2. Tutorials
      3. Preferences
      4. Help Options
      5. Selecting a Company File to Open
    15. 3. Accounting 101
      1. Basic Principles of Accounting
      2. Basic Financial Reports
      3. Accounting Checklist to Help You Manage Your Financials
      4. Setting Up a QuickBooks Data File for Accrual or Cash Basis Reporting
    16. 4. Understanding QuickBooks Lists
      1. Chart of Accounts
      2. Items
      3. Class
      4. Customer Type
      5. Managing Lists
      6. Reporting on Lists
      7. Finding and Fixing Chart of Account Errors
      8. Finding and Fixing Item List Errors
    17. 5. Setting Up Inventory
      1. Inventory Features by QuickBooks Edition
      2. Enabling Inventory Preferences
      3. Inventory Item Type Descriptions
      4. Adding or Editing Inventory Items
      5. Proper Inventory Processes
    18. 6. Managing Inventory
      1. Adjusting Inventory
      2. Inventory Reporting
      3. How QuickBooks Handles Negative Inventory
    19. 7. Setting Up Vendors
      1. Customizing Your Home Page for Vendor Activities
      2. Preferences That Affect Accounts Payable
      3. Working with the Vendor Center
      4. The Accounts Payable Process
    20. 8. Managing Vendors
      1. Accounts Payable Reporting
      2. Correcting Accounts Payable Errors
      3. Handling Unique Accounts Payable Transactions
    21. 9. Setting Up Customers
      1. Customizing Home Page Customer Activities
      2. Preferences That Affect Accounts Receivable
      3. Working with the Customer Center
      4. Working with Prospects in the Lead Center
      5. Setting Up Sales Tax
      6. Creating Price Level Lists
      7. Using Advanced Pricing in QuickBooks Enterprise
      8. Creating Payment Terms
      9. Customizing QuickBooks Forms
      10. Accounts Receivable Processes
    22. 10. Managing Customers
      1. Accounts Receivable Reporting
      2. Sales Tax Payable Reports
      3. Paying Sales Tax
      4. Correcting Accounts Receivable Errors
      5. Correcting Sales Tax Errors
      6. Correcting Undeposited Funds Account Errors
      7. Unique Customer Transactions
      8. Unique Sales Tax Transactions
    23. 11. Setting Up Payroll
      1. Getting Started
      2. Setting Up Employees
      3. Setting Up Payroll Items
      4. Paying Employees
      5. Preparing Payroll Liability Payments
    24. 12. Managing Payroll
      1. Report Center Payroll Reports
      2. Excel Reports
      3. Tax Forms and Filings
      4. Troubleshooting Payroll
      5. Recording Unique Payroll Transactions
    25. 13. Working with Bank and Credit Card Accounts
      1. Preferences That Affect Banking and Credit Card Management
      2. Working with Write Check Transactions
      3. Entering a Bank Debit Charge
      4. Entering Credit Card Charges
      5. Paying the Credit Card Bill
      6. Transferring Funds Between Bank Accounts
      7. Bank Feeds
      8. Reconciling the Bank or Credit Card Account
      9. Troubleshooting Reconciliations
    26. 14. Reporting in QuickBooks
      1. Using the Company Snapshot
      2. Report Center
      3. Reports & Graphs Preferences
      4. Modifying Reports
      5. Report Groups
      6. Memorized Reports
      7. Exporting and Importing Report Templates
      8. Exporting Reports to a .CSV File or to Excel
      9. Emailing Reports
    27. 15. Reviewing Your Data
      1. Reviewing the Balance Sheet
      2. Reviewing the Profit & Loss Report
      3. Other Reviews
    28. 16. Sharing QuickBooks Data with Your Accountant
      1. Overview
      2. QuickBooks File Types
      3. Data Sharing for the Business Owner
      4. Data Sharing for the Accountant
      5. Other Methods of Sharing Data
      6. Client and Accountant Collaboration
    29. 17. Managing Your QuickBooks Database
      1. The QuickBooks Database
      2. Keeping Your Software Current
      3. Protecting Your QuickBooks Database
      4. Monitoring Your QuickBooks Database
      5. QuickBooks Database Corruption
    30. 18. Using Other Planning and Management Tools
      1. Planning and Budgeting
      2. QuickBooks Loan Manager
      3. Using the Year-End Guide
      4. Synchronizing QuickBooks Lists with Microsoft Outlook
      5. Using the QuickBooks Timer
    31. A. Client Data Review
      1. Introduction: Features and Benefits
      2. Accessing Client Data Review Tools and Features
      3. Customizing the Accountant Center
      4. Customizing the Client Data Review Center
      5. Account Balances
      6. Review List Changes
      7. Accounts Receivable
      8. Accounts Payable
      9. Sales Tax
      10. Inventory
      11. Payroll
      12. Bank Reconciliation
      13. Miscellaneous
      14. Finishing a Client Data Review
      15. Reopening a Client Data Review
      16. Reporting on Review Activity
      17. Creating an External Accountant User
    32. B. QuickBooks Statement Writer
      1. Overview
      2. Getting Started
      3. Using the Report Designer
      4. Opening a Previously Created Report
      5. Creating a New Report from a Memorized Report
      6. Modifying a Statement Writer Report in Excel
      7. Working with Supporting Documents
      8. Printing or Exporting a Statement Writer Report
    33. C. QuickBooks Enterprise Solutions Features
      1. QuickBooks Enterprise Customization
      2. QuickBooks Enterprise Inventory
      3. QuickBooks Enterprise with Advanced Inventory
      4. QuickBooks Enterprise with Advanced Pricing
      5. QuickBooks Enterprise Reporting
    34. D. QuickBooks Shortcuts
      1. Editing QuickBooks Transactions and Lists
      2. Opening QuickBooks Dialog Boxes and Lists
      3. Memorized Transactions
      4. Standard Text Editing
      5. Opening QuickBooks Data Files
      6. QuickBooks Date Shortcuts
      7. Miscellaneous Shortcuts