Part 1 - Quickbooks Online Fundamentals

Getting Started with QuickBooks Online

• Introducing QuickBooks Online
• QuickBooks Online Subscriptions
• Mobile Devices
• Updates and the Ever-Evolving User Interface
• Security
• The Test Drive

Other Tools You’ll Need

• Navigating the User Interface
• The Gear Menu
• The Top-Right Navigation Tools
• The Help Menu
• The Navigation Bar
• Accounting—Behind the Scenes

Generally Accepted Accounting Principles (GAAP)

• GAAP
• Accrual Basis vs. Cash Basis Accounting
• Account Types and Financial Reports

Working with Company Accounts and Settings

• Planning Your Company Settings
• Picking a Start Date for Your Data
• Setup Checklist—Elements of the Plan
• Customizing Your Company Settings
• The Chart of Accounts
• Adding a Bank Account to the Chart of Accounts
• Adding a Credit Card to the Chart of Accounts
• Adding and Editing Products and Services
• Adding and Managing Users update md
• Opening Balances and Historical Transactions
• Pre-fill Forms with Previously Entered Content
• Automatically Apply Credits
• Automatically Invoice Unbilled Activity
• Currency Selection
• Warn if Duplicate Check Number Used
• Warn if Duplicate Bill Number Used
• Automatically Apply Bill Payments

Working with Customers

• The Customer Hub
• Adding, Editing and Merging Customers
• Importing Customers from an Excel or CSV File
• Making Customers Inactive
• Recording Sales Transactions
• Adding an Invoice for a Customer
• Enabling and Adding Price Rules
• Using a Price Rule on a Sales Transaction
• Receiving Customer Payments
• Recording a Bank Deposit
• Creating Customer and Sales Reports
• Correcting Errors

Working with Vendors

• The Expenses & Bills Hub
• The Money Bar
• The Vendors List
• Adding and Editing Vendors
• Importing Vendor Data from an Excel or CSV File
• Merging and Making Vendors Inactive
• Creating Vendor Transactions: Purchases and Expenses
• Entering Checks and Expenses
• Managing Accounts Payable
• Entering and Paying Bills
• Accounts Payable Reports
• Other Vendor Reports

Banking and Credit Card Transactions

• Managing Bank Transactions
• Matching Bank Transactions to QuickBooks Online Transactions
• Matching Recognized, Partially Recognized and Unrecognized Transactions
• Managing Bank Rules
• Other Bank Feed Transactions
• Reconciling Accounts

Managing Inventory

• Enabling Tracking
• Inventory Items and the Products and Services List
• Adding and Using an Inventory Item
• Inventory Adjustments
• Inventory Reports

Purchase Orders

• Overview of Purchase Orders in QuickBooks Online
• Creating and Managing Purchase Orders
• Using a Posting Transaction to Receive a Purchase Order
• Purchase Order Reports

Credits, Returns, Taxes and Refunds

• Vendor Credits and Returns
• Customer Returns and Credits
• Customer Credit Memos
• The Sales Tax Hub
• Sales Tax Liability Reports

Working with Balance Sheet Accounts and Budgets

• Fixed Assets and Lon Term Liabilities
• Journal Entries and Recurring Transactions
• Depreciating an Asset with a Journal Entry
• Transferring Funds Between Accounts
• Handling Uncollectible Receivables/Bad Debts
• Handling Bounced/Returned Checks
• Budgets in QuickBooks Online

Extending Capabilities in QuickBooks Online

• Customizing Reports in QuickBooks Online
• Scheduling Reports to Send Email
• Adding a Custom Field in QuickBooks Online
• Keyboard Shortcuts
• Extending Capabilities with Apps
• The QuickBooks Community

Tacking Your Financials with Class and Location Tracking

• Enabling and Adding Classes to QuickBooks Online
• Using a Class on a Transaction
• Running the Profit and Loss by Class Report
• Enabling and Adding Locations to QuickBooks Online
• Assigning a Location to a Transaction
• Project Tracking

Completing the Accounting Cycle

• Completing the Accounting Cycle
• Using the Trial Balance Report
• Using Journal Entries to Make Financial Adjustments
• Adjusting Inventory Asset Value with a Journal Entry
• Running the Balance Sheet and Profit and Loss Reports
• Closing the Books
• The Audit Log in QuickBooks Online

Part 2 - Modern View Custom Reports

Understanding Report Types and Categories

• Standard Reports Overview
• Custom Reports Overview
• Management Reports Overview
• Searching Reports and Favorites Grouping
• Review - Understanding Report Types and Categories

Report Customization

• Classic View in Reporting
• Advantages of Switching to Modern View
• Customizing the Modern View Columns
• Customizing the Modern View Filters
• Saving Custom Modern View Reports
• Review - Report Customization

Advanced Customization of Modern View

• Customizing General Options
• Exporting Data from Modern View to Excel and CSV
• Emailing and Scheduling Modern View Reports
• Management Reports Modern View
• Review - Advanced Customization of Modern View

App Integration and Analysis

• Understanding Integrated Apps in QuickBooks Online
• Using Excel to Chart Data from Modern View Reports
• Using Google Sheets for Data Analysis from Modern View Reports
• Review - App Integration and Analysis

Part 3 - Projects and Job Costing

Projects vs Job Costing in QuickBooks Online

• Job Costing using Customers and Sub Customers
• Projects in QuickBooks Online
• Impact on Financial Reports
• Considerations and Best Practices

Setting up Customers Vendors and Contractors for Projects and Job Costing in QuickBooks Online

• Creating a Customer in QuickBooks Online
• Create a Sub Customer for Job Costing in QuickBooks Online
• Creating a Vendor in QuickBooks Online
• Creating an Employee or Contractor in QuickBooks Online

Using Projects and Job Costing in QuickBooks Online

• Turn on Projects and Creating a New Project in QuickBooks Online
• Add or Change the Customer Assigned to a Project
• Add a New Transaction to A Project
• Add a New Transaction for a Sub Customer
• Add Expenses to a Project
• Bill an Expense to a Sub Customer
• Add Existing Time Sheets to a Project
• Add Existing Invoices to a Project

Projects and Job Costing Reports in QuickBooks Online

• Track Your Labor Costs
• Project Reports
• Create a Custom Profit and Loss Report for a Sub Customer Job
• Create a Custom Balance Sheet Report for a Sub Customer Job

Exporting and Charting Data in Projects and Job Costing Reports from QuickBooks Online to Excel

• Exporting Lists from QuickBooks Online to Excel
• Exporting Reports from QuickBooks Online to Excel
• Data Analytics with List Data in Excel
• Data Analytics with Report Data in Excel

Part 4 - Introduction to Business Accounting:

-Professional Bookkeeper Introduction-

Professional Bookkeeper Job Functions

• Potential Careers
• Required Traits
• Employment Outlook

Introduction to Accounting and Business

• Defining a Business
• Role of Accounting
• Ethics in Accounting
• Generally Accepted Accounting Principles (GAAP)

The Accounting Equation

• Transactions
• Common Revenue and Expense Accounts
• Financial Statements

Analyzing Transactions

• Analyzing Transactions
• The Accounting Equation and Transactions
• Journalizing Transactions

Entering Information - Posting Entries

• Posting Entries
• The Trial Balance
• Finding Errors Using Horizontal Analysis

Adjusting Process

• Adjusting Process
• The Purpose of the Adjusting Process

Adjusting Entries

• Adjusting Entries
• Revenues/Expenses
• Journal Entry
• Posting Accounts

Adjustment Summary

• Adjusted Summary Review
• Financial Statement Accuracy

Preparing a Worksheet

• Preparing a Worksheet

Financial Statements

• The Income Statement
• The Statement of Retained Earnings
• The Balance Sheet

Completing the Accounting Cycle

• Completing the Accounting Cycle
• Temporary vs. Permanent Accounts
• Closing Entries

The Accounting Cycle Illustrated

• Accounting Cycle Illustrated

Fiscal Year

• Fiscal Year
• Additional Accounting Terms

Spreadsheet Exercise

• Spreadsheet Exercises

-Effective Bookkeeping and Payroll-

Principles

• Principals
• Transactions

Overview of Internal Controls

• Overview of Internal Controls
• Principles of Internal Control
• Overview of Sarbanes Oxley Sections 302 and 404
• Audit Process and Conduct

Subsidiary Ledgers and Special Journals

• Subsidiary Ledgers
• Special Journals

Reconciliations

• Reconciliations
• Purpose
• Accounts To Be Reconciled
• Ownership and Accountability For Reconciliations
• Verifications of Account Balances

Correcting Entries

• The Wrong Amount
• The Wrong Account
• Reversing Entries

Sales Tax

• Calculations
• Recording Transactions
• Paying Collected Taxes
• Rules and Filing
• Sales Tax Rates
• Audits and Out of State Taxes

Budgeting

• Yearly Target Setting (Budgeting)
• Defining Objectives
• Types of Budgets
• Bookkeeper Role in Budgeting

Accounting for Merchandising

• Income Statements
• Revenue - Credits
• Discounts
• Net Sales
• Inventory System
• Merchandising Income Statement

Accounting for Cash

• Petty Cash
• Accounting for Cash Over or Short
• Cash Controls
• Bank Reconciliation
• Bank Statements
• Bank Errors
• Cash Book Errors

Payroll

• The Payroll Process
• Gross Pay
• Deductions
• Taxes
• Net Pay
• Recording
• Employer Expenses
• Accruals
• Internal Controls

Partnerships and Corporations

• Partnership Accounting
• Corporations
• Share Ownership
• Preferred Stock

Accounts Receivable and Bad Debts

• Accounts Receivable
• Bad Debt
• Accounts Receivable Entries

Interim Profit or Loss

• Interim Statement

Year End - Preparing to Close the Books

• Inventory
• Adjusting Entries
• Year End - The Worksheet
• The Spreadsheet

Year End - Closing the Books

• Closing the Books
• Accounting Information

Cash Flow

• Cash Flow
• Revenue and Receivables
• Expenses and Payables
• Inventory
• Capital / Investment