QuickBooks Online: Bank Feeds & Bank Reconilications
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
- Preview01:26
- 02:15:37Part 1: Downloading Bank Transactions, Categorizing, and Matching
- 02:11:51Part 2: Reconciling Accounts, Troubleshooting issues, and working with PayPal
- 30:08Additional Reconciliation Example (with Bank of America)
Instructor
![Hector Garcia](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 1,130 Reviews
- 27,943 Students
- 1 Course
Hector also earned 3 post-graduate degrees, each strengthen his career in the fields of Accounting, Finance, and Taxation. Hector’s passion for training comes from this successful career in which he applied his personal philosophy of continuous learning and training co-workers. Currently, Hector dictates QuickBooks Courses in Miami,FL
Hector also earned 3 post-graduate degrees, each strengthen his career in the fields of Accounting, Finance, and Taxation. Hector’s passion for training comes from this successful career in which he applied his personal philosophy of continuous learning and training co-workers. Currently, Hector dictates QuickBooks Courses in Miami,FL