Course curriculum

  • 01

    Introduction

    • 305 Setup New Bank Feed Test Company File

    • 315 How do Bank Feeds Fit Into My Accounting System

    • 320 How To Setup Bank Feeds
  • 02

    Bank Data - Download and Import Into QuickBooks

    • 360 Download Transactions From Bank

    • 364 Import Bank Transactions Into QuickBooks

    • 365 Bank Feed Center Navigation
  • 03

    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
  • 04

    Add Bank Feed Transactions For Cash Decreases

    • 395 Enter Transaction for Income Deposit For Online Cash Basis Business

    • 400 Enter Transaction for Owner Deposit or Loan Deposit Using Bank Feeds
  • 05

    Payroll and Sales Tax Transactions

    • 403 Enter Transaction for Payroll Using Bank Feeds

    • 405 Sales Tax & Bank Feed Overview
  • 06

    Matching Bank Feed Deposits to Invoice, Sales Receipt, & Deposit

    • 440 Bank Feeds Matching Invoice to Deposit

    • 445 Bank Feeds Matching Receive Payment to Deposit

    • 446 Bank Feeds Matching Deposit From Customer

    • 449 Bank Feeds Matching Sales Receipt
  • 07

    Credit Card Bank Feeds

    • 460 Bank Feeds Credit Card Data Setup

    • 465 Credit Card Bank Feed Add Data

    • 467 Bank Feed to Bank Feed Transaction

    • 475 Credit Card Reconciliation First Month

    • 480 Credit Card Reconciliation After First Month
  • 08

    Bank Rules

    • 540 Bank Rules – Same Customer Different Income Accounts

    • 550 Bank Rules – Same Vendor Filter by Amount

    • 580 Bank Feeds – Add Remaining Transactions & Bank Rules

    • 590 Bank Reconciliation Bank Feeds First Month

    • 592 Bank Reconciliation Bank Feeds After First Month

    • 596 Financial Reports Generated From Bank Feeds

Description

 

This is the Sixth in a series of courses covering QuickBooks Desktop Pro 2021; comprehensively.

We will discuss how bank feeds can fit into an accounting system, how to setup bank feeds, and how to construct financial statements using bank feed data.

We will import bank feed data into our QuickBooks system.

The course will add bank feed data to the financial statement, breaking the process out into cash increase transactions and cash decrease transactions.

Learners will understand how to generate bank rules to make the data input process faster as time passes, the first month of data input often being the most difficult due to not having prior transactions to refer back to.

As we construct bank feed transactions we will consider the difference between a cash method and an accrual method, the difference between an accounting system that is created from the bank data and an accounting system that uses bank data to verify data input.

The course will cover how bank feed data can be matched to transactions such as invoices, sales receipt forms, receive payment forms, deposit forms, bills, and checks. The matching of bank feed data to data impute forms can help with the bank reconciliation process, as we match up what has been entered into QuickBooks with what has cleared the bank.

Robert (Bob) Steele CPA CGMA CPI MStax

Instructor

The other sections are styled to help you create beautiful, high-converting pages. If you already know exactly what you want, use this section to add text, images, video, audio, etc. and build something completely custom. This is your sandbox — create what you want!