Mastering QuickBooks 2020

Book description

Get up to speed with QuickBooks Online 2020 for financial management and bookkeeping

Key Features

  • Create a dashboard that highlights your company’s financial activity and status upon login
  • Manage customers, vendors, and products and services seamlessly with QuickBooks
  • Explore special transactions such as recurring transactions, managing fixed assets, setting up loans, and recording bad debts

Book Description

Intuit QuickBooks is an accounting software package that helps small business owners to manage all their bookkeeping tasks. Its complete range of accounting capabilities, such as tracking income and expenses, managing payroll, simplifying taxes, and accepting online payments, makes QuickBooks software a must-have for business owners and aspiring bookkeepers.

This book is a handy guide to using QuickBooks Online to manage accounting tasks and drawing business insights by generating reports easily. Using a fictitious company, the book demonstrates how to create a QuickBooks Online account; customize key settings for a business; manage customers, vendors, and products and services; generate reports; and close the books at the end of the period. QuickBooks records your debits and credits, so you don't need to learn accounting. However, you will find out what happens under the hood and understand how your financial statements are impacted by what you do in QuickBooks. You'll also discover tips, shortcuts, and best practices that will help you save time and become a QuickBooks pro.

By the end of this book, you'll have become well-versed with the features of QuickBooks and be able to set up your business and manage all bookkeeping tasks with ease.

What you will learn

  • Get to grips with bookkeeping concepts and the typical bookkeeping and accounting cycle
  • Set up QuickBooks for both product-based and service-based businesses
  • Track everything, from billable and non-billable time and expenses to profit
  • Generate key financial reports for accounts, customers, jobs, and invoice items
  • Understand the complete payroll process and track payments made to 1099 contractors
  • Manage various bank and credit accounts linked to your business

Who this book is for

If you’re a small business owner, bookkeeper, or accounting student who wants to learn how to make the most of QuickBooks Online, this book is for you. Business analysts, data analysts, managers, and professionals working in bookkeeping, and QuickBooks accountants will also find this guide useful. No experience with QuickBooks Online is required to get started; however, some bookkeeping knowledge will be helpful.

Table of contents

  1. Title Page
  2. Copyright and Credits
    1. Mastering QuickBooks 2020
  3. Dedication
  4. About Packt
    1. Why subscribe?
  5. Contributors
    1. About the author
    2. About the reviewer
    3. Packt is searching for authors like you
  6. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
      1. Download the example code files
      2. Conventions used
    4. Get in touch
      1. Reviews
  7. Getting Started with QuickBooks Online
    1. What is QuickBooks?
    2. QBO editions
    3. Choosing the right QBO edition
      1. QBO Simple Start
      2. QBO Essentials
      3. QBO Plus
      4. QBO Advanced
    4. QBD product line
    5. Choosing the right QBD version
      1. QuickBooks Mac
      2. QuickBooks Pro
      3. QuickBooks Premier
      4. QuickBooks Enterprise
    6. New features in QBD 2019 and 2020
      1. New features in QBD 2019
      2. New features in QBD 2020
    7. Introduction to small business bookkeeping
      1. Money in (sales)
      2. Money out (expenses)
      3. Inventory and fixed asset purchases
      4. Liabilities
      5. Chart of accounts
      6. Accounting methods
      7. Double-entry bookkeeping
    8. Summary
  8. Company File Setup
    1. Creating a QuickBooks Online account
    2. Navigating in QuickBooks Online
      1. QuickBooks Online dashboard
      2. QuickBooks Online icons
      3. QuickBooks Online menus
    3. Setting up company preferences in QuickBooks Online
      1. Company
      2. Billing and subscription
      3. Usage
      4. Sales
      5. Expenses
      6. Payments
      7. Advanced
    4. Summary
  9. Migrating to QuickBooks Online
    1. Key information and documents required to convert to QuickBooks Online
    2. Questions to ask yourself in preparation for data conversion
    3. Choosing your QuickBooks start date
    4. Converting from another accounting software or Excel to QuickBooks Online
      1. Recording details of historical data in QuickBooks Online
      2. Recording a summary journal entry of historical data in QuickBooks Online
    5. Converting from QuickBooks Desktop to QuickBooks Online
      1. Functionality not available in QuickBooks Online
      2. QuickBooks Desktop data that will not convert to QuickBooks Online
    6. Converting from QuickBooks Desktop data to QuickBooks Online
      1. Checking the target count
      2. Creating a QuickBooks Online account
      3. Backing up your QuickBooks Desktop file
      4. Checking for updates
      5. Running the QuickBooks Desktop conversion to the QuickBooks Online tool
      6. Logging in to QuickBooks Online
      7. Verifying that all of your data was converted
    7. Summary
  10. Customizing QuickBooks for Your Business
    1. Customizing the chart of accounts
      1. How to add a new account to the chart of accounts list
      2. How to import a chart of accounts list
      3. How to edit accounts on the chart of accounts list
      4. How to inactivate an account on the chart of accounts list
    2. Connecting bank accounts to QuickBooks Online
      1. Importing banking transactions automatically
      2. Uploading banking transactions from an Excel CSV file
    3. Connecting credit card accounts to QuickBooks Online
      1. Importing credit card transactions automatically
      2. Uploading credit card transactions from an Excel CSV file
    4. Giving other users access to your QuickBooks data
      1. Standard user
      2. Company administrator
      3. Reports only user
      4. Time tracking user
      5. Accountant user
    5. Summary
  11. Managing Customers, Vendors, Products, and Services
    1. Managing customers in QuickBooks Online
      1. Manually adding customers in QuickBooks Online
      2. Importing customers into QuickBooks Online
      3. Making changes to existing customers in QuickBooks Online
      4. Inactivating customers in QuickBooks Online
    2. Managing vendors in QuickBooks Online
      1. Manually adding vendors in QuickBooks Online
      2. Importing vendors into QuickBooks Online
      3. Making changes to existing vendors in QuickBooks Online
      4. Inactivating vendors in QuickBooks Online
    3. Managing products and services in QuickBooks Online
      1. How to manually add products and services in QuickBooks Online
      2. How to import products and services in QuickBooks Online
      3. Making changes to existing products and services in QuickBooks Online
      4. Inactivating products and services in QuickBooks Online
    4. Summary
  12. Recording Sales Transactions in QuickBooks Online
    1. Understanding sales forms
      1. Recording income using a sales receipt
      2. Recording income using a deposit
      3. Recording income using a sales invoice
    2. Recording customer payments
    3. Issuing credit memos and refunds to customers
    4. Summary
  13. Recording Expenses in QuickBooks Online
    1. Entering and paying bills
      1. Entering bills into QuickBooks Online
      2. Paying bills in QuickBooks Online
    2. Managing recurring expenses
    3. Writing checks
    4. Printing checks
    5. Summary
  14. Managing Downloaded Bank and Credit Card Transactions
    1. Overview of the banking center
    2. Matching transactions
    3. Editing banking transactions
    4. Understanding bank rules
      1. How do you want to apply this rule?
    5. Reconciling accounts
    6. Summary
  15. Report Center Overview
    1. Navigating the report center
    2. Reports available in the Report Center
    3. Customizing reports
      1. General report customizations
      2. Rows/Columns customization
      3. Filters
      4. Header/footer
    4. Exporting reports
      1. Exporting reports to Excel
      2. Exporting reports to PDF
    5. Sending reports via email
    6. Summary
  16. Business Overview Reports
    1. Understanding profit and loss statements
    2. Generating balance sheet reports
    3. Understanding the statement of cash flows
    4. Creating a budget
    5. Summary
  17. Customer Sales Reports in QuickBooks Online
    1. Accounts receivable aging report
    2. Generating an open invoices report
    3. Generating a sales by customer report
    4. Generating a sales by product/service report
    5. Summary
  18. Vendor and Expenses Reports
    1. Generating an accounts payable (A/P) aging report
    2. Generating an unpaid bills report
    3. Generating an expenses by vendor summary report
    4. Generating a bill payments report
    5. Summary
  19. Managing Payroll in QuickBooks Online
    1. Setting up payroll
      1. Payroll setup checklist and key documents
      2. Setting up the payroll in QuickBooks Online
    2. Running payroll
    3. Generating payroll reports
    4. Filing payroll tax forms and payments
    5. Summary
  20. Managing 1099 Contractors in QuickBooks Online
    1. Setting up 1099 contractors
    2. Tracking and paying 1099 contractors
    3. 1099 year-end reporting
    4. Summary
  21. Closing the Books in QuickBooks Online
    1. Reviewing a checklist for closing your books
      1. Reconciling all bank and credit card accounts
      2. Making year-end accrual adjustments
      3. Reviewing new fixed asset purchases, and adding them to the chart of accounts
      4. Making depreciation journal entries
      5. Taking physical inventory, and reconciling with your books
      6. Adjusting retained earnings for owner/partner distributions
      7. Setting a closing date and password
      8. Preparing key financial reports
    2. Giving your accountant access to your data
    3. Recording journal entries
    4. Summary
  22. Handling Special Transactions in QuickBooks Online
    1. Using apps in QuickBooks Online
      1. Overview of the QuickBooks app center
      2. Finding apps for your business
    2. Managing credit card payments
    3. Customizing sales templates
    4. Setting up business loans and lines of credit
      1. Adding a business loan or line of credit to the chart of accounts
      2. Making payments on a loan or line of credit
    5. Managing petty cash
      1. Adding a petty cash account in QuickBooks
      2. Recording petty cash transactions
      3. Replenishing petty cash
      4. Reconciling petty cash
    6. Recording bad debt expense
      1. Creating a bad debt item
      2. Creating a credit memo
      3. Applying a credit memo to an outstanding customer invoice
    7. Understanding delayed charges and credits
    8. Summary
  23. Shortcuts and Test Drive
    1. QBO keyboard shortcuts
    2. QuickBooks Online test drive
  24. Other Books You May Enjoy
    1. Leave a review - let other readers know what you think

Product information

  • Title: Mastering QuickBooks 2020
  • Author(s): Crystalynn Shelton
  • Release date: December 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781789955101