Learn how to use bank feeds with QuickBooks Online QBO from a Certified Public Accountant CPA
What you will 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
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.
.05 Getting Software For Free
.07 30 – Day Free Trial Setup
.20 Navigation Overview
305 Free QuickBooks Bank Feed Practice File
315 How do Bank Feeds Fit Into My Accounting System
320 How To Setup Bank Feeds
Bank Data – Download and Import Into QuickBooks
360 Download Transactions From Bank
364 Import Bank Transactions Into QuickBooks
365 Bank Feed Center Navigation
Add Bank Feed Transactions For Cash Decreases
370 Add Normal Expenses To Books From Bank Feed Limbo
375 Enter Transaction Purchasing Equipment Using Bank Feeds
380 Enter Transaction Purchasing Inventory Using Bank Feeds
385 Enter Transaction Purchasing Investments Using Bank Feeds
390 Enter Transaction For Owner Withdrawal or Personal Payment Using Bank Feeds
395 Enter Transaction for Income Deposit For Online Cash Basis Business