Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
QuickBooks Online: Bank Feeds & Bank Reconilications
Rating: 4.6 out of 5(1,253 ratings)
17,973 students
Created byHector Garcia
Last updated 5/2021
English

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

Course content

2 sections • 8 lectures • 6h 53m total length

  • Introduction to this course1: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 Matching2: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 PayPal2: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)30:08

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

Report abuse