Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-19 19:44:11
30-Day Money-Back Guarantee
IT & Software Other IT & Software QuickBooks Online

QuickBooks Online (QBO) Bookkeeping With Bank Feeds 2021

Learn how to use bank feeds with QuickBooks Online QBO from a Certified Public Accountant CPA
New
Rating: 4.8 out of 54.8 (9 ratings)
3,389 students
Created by Robert (Bob) Steele
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • How to access QuickBooks Online using a Free - Day trial period often offered by Intuit, owners of QuickBooks Online
  • How to setup a company file
  • How to link bank and credit card accounts for automatic bank feed data
  • How to download bank data from your financial institution and upload it to QuickBooks Online
  • How to create financial report data from the bank feed information
  • How to create and use bank rules

Requirements

  • None

Description

This course is a project based course that will dive into bank feeds in detail using a step by step process.

We will start by setting up a free 30 day trial QuickBooks Online QBO file for the practice problem. Intuit, the owner of QuickBooks Online QBO, often offers a free 30 day trial period, a great tool for practice.

The course will demonstrate how to link QuickBooks Online QBO to the bank to receive bank data directly from the bank. We will also discuss the situations when you may want to download banking data from the bank and upload it to QuickBooks Online QBO.

Learners will follow along as we import bank data into the accounting software where it will be held in, what we call, Bank Feed Limbo, waiting for us to provide the added information necessary to use the data to create financial statements.

Learners will see how to add the bank data to the financial data in a step by step process, observing the creation of the balance sheet and profit and loss with each addition.

We will also discuss how to use bank rules to automate the process, benefiting future periods. As we enter data we will discuss best practices to make the data input as fast as possible and keep the financial statements as clean and readable as possible.

Who this course is for:

  • Business owners
  • Accountants
  • Students

Course content

3 sections • 15 lectures • 3h 58m total length

  • Preview06:13
  • .07 30 – Day Free Trial Setup
    10:12
  • .20 Navigation Overview
    17:48
  • 305 Free QuickBooks Bank Feed Practice File
    09:20
  • 315 How do Bank Feeds Fit Into My Accounting System
    14:47
  • 320 How To Setup Bank Feeds
    08:49

  • 360 Download Transactions From Bank
    08:43
  • 364 Import Bank Transactions Into QuickBooks
    07:52
  • 365 Bank Feed Center Navigation
    21:18

  • 370 Add Normal Expenses To Books From Bank Feed Limbo
    26:18
  • 375 Enter Transaction Purchasing Equipment Using Bank Feeds
    12:16
  • 380 Enter Transaction Purchasing Inventory Using Bank Feeds
    23:46
  • 385 Enter Transaction Purchasing Investments Using Bank Feeds
    17:18
  • 390 Enter Transaction For Owner Withdrawal or Personal Payment Using Bank Feeds
    20:22
  • 395 Enter Transaction for Income Deposit For Online Cash Basis Business
    33:16

Instructor

Robert (Bob) Steele
CPA, CGMA, M.S. Tax, CPI
Robert (Bob) Steele
  • 4.4 Instructor Rating
  • 15,851 Reviews
  • 329,397 Students
  • 95 Courses

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.  

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).  

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.  

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele's teaching philosophy is to make content applicable, understandable, and accessible.  

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.  

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.  

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.  

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.  

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.  

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge like Udemy.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.