This course is designed for those interested to learn the basics of QuickBooks Desktop 2021 software in accounting, how to set up bank feeds, construct financial statements, generate bank rules to make the data input process faster and learn about bank reconciliation process.
Read more.Instructor
Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Accountants
- Bookkeepers
- Business owners
What you’ll learn:Â
- Setting up bank feeds
- Constructing financial statements
- How to generate bank rules to make the data input process faster
- Bank reconciliation process
Software version used in the course:Â
- QuickBooks Desktop Pro 2021
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 set up 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.
Our Promise to You
By the end of this course, you will have learned bank feeds in QuickBooks.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about using QuickBooks Desktop 2021.
Course Curriculum
Section 1 - Introduction | |||
Setup New Bank Feed Test Company File | 00:00:00 | ||
How Do Bank Feeds Fit Into My Accounting System | 00:00:00 | ||
How To Setup Bank Feeds | 00:00:00 | ||
Section 2 - Bank Data - Download And Import Into QuickBooks | |||
Download Transactions From Bank | 00:00:00 | ||
Import Bank Transactions Into QuickBooks | 00:00:00 | ||
Bank Feed Center Navigation | 00:00:00 | ||
Section 3 - Add Bank Feed Transactions For Cash Decreases | |||
Add Normal Expenses To Books From Bank Feed Limbo | 00:00:00 | ||
Enter Transaction Purchasing Equipment Using Bank Feeds | 00:00:00 | ||
Enter Transaction Purchasing Inventory Using Bank Feeds | 00:00:00 | ||
Enter Transaction Purchasing Investments Using Bank Feeds | 00:00:00 | ||
Enter Transaction For Owner Withdrawal Or Personal Payment Using Bank Feeds | 00:00:00 | ||
Section 4 - Add Bank Feed Transactions For Cash Decreases | |||
Enter Transaction For Income Deposit For Online Cash Basis Business | 00:00:00 | ||
Enter Transaction For Owner Deposit Or Loan Deposit Using Bank Feeds | 00:00:00 | ||
Section 5 - Payroll And Sales Tax Transactions | |||
Enter Transaction For Payroll Using Bank Feeds | 00:00:00 | ||
Sales Tax And Bank Feed Overview | 00:00:00 | ||
Section 6 - Matching Bank Feed Deposits To Invoice, Sales Receipt, And Deposit | |||
Bank Feeds Matching Invoice To Deposit | 00:00:00 | ||
Bank Feeds Matching Receive Payment To Deposit | 00:00:00 | ||
Bank Feeds Matching Deposit From Customer | 00:00:00 | ||
Bank Feeds Matching Sales Receipt | 00:00:00 | ||
Section 7 - Credit Card Bank Feeds | |||
Bank Feeds Credit Card Data Setup | 00:00:00 | ||
Credit Card Bank Feed Add Data | 00:00:00 | ||
Bank Feed To Bank Feed Transaction | 00:00:00 | ||
Credit Card Reconciliation First Month | 00:00:00 | ||
Credit Card Reconciliation After First Month | 00:00:00 | ||
Section 8 - Bank Rules | |||
Bank Rules – Same Customer Different Income Accounts | 00:00:00 | ||
Bank Rules – Same Vendor Filter By Amount | 00:00:00 | ||
Bank Feeds – Add Remaining Transactions And Bank Rules | 00:00:00 | ||
Bank Reconciliation Bank Feeds First Month | 00:00:00 | ||
Bank Reconciliation Bank Feeds After First Month | 00:00:00 | ||
Financial Reports Generated From Bank Feeds | 00:00:00 |