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

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.

English

Language

Content

Introduction

.05 Getting Software For Free

.07 30 – Day Free Trial Setup


Get Instant Notification of New Courses on our Telegram channel.


.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