You are previewing QuickBooks® 2013 In Depth.
O'Reilly logo
QuickBooks® 2013 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 2013: more productivity, more business knowledge, and more value! Drawing on her unsurpassed QuickBooks consulting and accounting experience, Laura Madeira delivers step-by-step guides and practical checklists for taking total control over business finances and improving 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

•     New! 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 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 2013’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 2013 book you need!

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Editor
  7. Dedication
  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 2013
    1. Easy to Learn and Use
    2. New and Improved Features
    3. For the Accounting Professional
    4. For QuickBooks Enterprise Users
    5. QuickBooks Enterprise with Advanced Inventory Subscription
  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. Creating Payment Terms
    8. Customizing QuickBooks Forms
    9. 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. Online Banking Center
    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
  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 Inventory Features
    1. QuickBooks Enterprise
    2. QuickBooks Enterprise with Advanced Inventory
  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
  35. Index