Learn Quickbooks Online Qbo With Hector Garcia And Friends

2021 UPDATE. Categorizing transactions, matching, bank reconciliations, PayPal, and troubleshooting balances.

Last updated 2022-01-10 | 4.2

- Downloading transactions from the bank
- Categorizing transactions to the correct category
- Matching downloaded transactions with existing ones

What you'll learn

Downloading transactions from the bank
Categorizing transactions to the correct category
Matching downloaded transactions with existing ones
Use Bank Rules to automate transaction categorization
Reconcile bank and credit card transactions
Reconcile other accounts like loans and petty cash accounts
Downloading and Reconciling PayPal Transactions
Troubleshoot bank and credit card reconciliation discrepancies
Troubleshoot opening balances

* Requirements

* QuickBooks Online basic navigation
* Business and bookkeeping basics

Description

LAST UPDATE 05/28/2021

QuickBooks Online: Bank Feeds, Downloaded Transactions, Bank Reconciliation, PayPal, and Troubleshooting balances
This course is designed for active QuickBooks Online users that need to understand how banking works, downloading transactions, dealing with categorizing as expenses, income, or transfers across balance sheet transactions. The format of this course is 2 recorded webinars of 2 hours each, covering these topics:

  • Advanced Navigation Tips to boost efficiency with bank feeds

  • Direct Connection vs. Uploading QBO/CSV File

  • Bank Feeds Layout explained

  • Categorizing New Transactions

  • Bank Rules

  • Batch Categorizing Transactions

  • Exclude, Undo, and Delete

  • Matching Transactions

  • Cleaning up beginning balance issues

  • Reconciling Banks

  • Reconciling Credit Cards

  • Manual transactions in register

  • Getting rid of old uncleared transactions

  • Fixing Reconciliation Discrepancies

  • Dealing with Transfers (Troubleshooting)

  • Reconciling other accounts (Loans)

  • Reconciling Petty Cash

  • Working with PayPal (direct transactions downloads vs. manual transactions upload)

This course is designed for active QuickBooks Online users that need to understand how banking works, downloading transactions, dealing with categorizing as expenses, income, or transfers across balance sheet transactions

Taught by Hector Garcia, CPA - an active Accountant working with small business clients, Advanced QuickBooks ProAdvisors, and one of the top trainers of all things accountant on earth! He has a YouTube Channel with over 130k subscribers, and long-term Udemy course maker.  This course is updated in an annual basis to cover all the changes and feature upgrades in QuickBooks Online.


Who this course is for:

  • Anyone that has started working with QuickBooks Online (QBO)
  • All Accounting Professionals

Course content

2 sections • 8 lectures

Introduction to this course Preview 01:26

Introductory message by Hector Garcia, so you know what to expect from this 4.5 hour course!

Part 1: Downloading Bank Transactions, Categorizing, and Matching Preview 02:15:37

Part 1 covers:

  • Advanced Navigation tips to boost efficiency working with bank feeds

  • Connecting the Banks via Direct Connection vs. Uploading manual QBO/CSV Files

  • Bank Feeds Layout explained in detail

  • Categorizing New Transactions

  • Bank Rules

  • Batching Categorizing Transactions

  • Exclude, Undo, and Delete

  • Matching with Existing Transactions

Part 2: Reconciling Accounts, Troubleshooting issues, and working with PayPal Preview 02:11:51

Topics covered in Part 2:

  • Cleaning up beginning balance issues

  • Reconciling Banks

  • Reconciling Credit Cards

  • Manual transactions in register

  • Getting rid of old uncleared transactions

  • Fixing Reconciliation Discrepancies

  • Dealing with Transfers (Troubleshooting)

  • Reconciling other accounts (Loans)

  • Reconciling Petty Cash

  • Working with PayPal

Additional Reconciliation Example (with Bank of America) Preview 30:08

More Examples on Categorizing Expenses Preview 53:25

Why you should ALWAYS use a vendor name in bank feeds Preview 09:18

Chart of Accounts and "Detail Type" explained Preview 42:23

Undo Bank Reconciliations Preview 09:42