4.30 (14 reviews)
☑ How to set up bank feeds for both bank accounts and credit card accounts
☑ How to set up QuickBooks Online and get up and running
☑ How to add transactions and assign proper general ledger accounts to them
☑ How to do bank reconciliations
☑ Understand the difference between a bank reconciliation when using a cash basis and accrual basis
☑ Generate reports and analyze reports after data has been entered using bank feeds
☑ Record transactions from two accounts that use bank feeds like a credit card account and a bank account
☑ How to create different kinds of bank feed rules to make data input even faster
This course will jump right into bank feeds and how to use them.
Most QuickBooks courses will spend a lot of time talking about how a full-service accounting system works using QuickBooks. We do recommend spending time learning the full accounting process, and we do have a course that does this.
However, many small businesses want to get right down to data input as fast as possible, and others already have a good understanding of the system and want to focus specifically on bank feeds.
This course will do just that.
For example, some small businesses may be perfectly happy using a cash basis system and will, therefore, not need some of the functions used in a full accounting cycle. Businesses that use a cash basis model can structure their data input to be much more heavily dependent on the bank and bank feed data.
We will discuss types of businesses that fit well into a cash basis model as we work through the practice problems. We will also discuss some problem areas many businesses have and how to set up a system that works.
This course will work through a practice problem and will provide test data that learners can use in their system to follow along if they choose.
One obstacle to learning bank feeds is access to a clean QuickBooks file to practice with. Here are some options you can use along with this course:
Intuit (the owner of QuickBooks) provides a free test drive available to anybody. You can find it by searching in your favorite browser (QuickBooks Test Drive).
Intuit often provides (almost always) a 30 day discount period. You can use the 30 days to practice by starting the 30-day trial, practicing with the data we provide in the course, and then canceling after the 30 days.
Intuit also provides discounts or a free version for students and educators.
Check with your accountant or CPA firm, and they may be able to provide a discount on QuickBooks Online
Documents To Download
315 How Do Bank Feeds Fit Into My Accounting System
Getting Set Up
2 Getting Set Up
.05 Recommendations For Success
.10 Purchase With 30 Day Trial
320 Project Outline
Month One - Set up Bank Feeds
3 Month One - Set up Bank Feeds
325 Set Up Bank Feeds
360 Download Transactions From Bank
365 Import Bank Data
Month One - Add Transactions from Bank Feeds
4 Add Transactions from Bank Feeds
370 Add Expense transactions
375 Add Capital Expenditures
380 Add Inventory Purchase
385 Add Amount Paid for Investment
390 Add Owner Withdraws
395 Add Bank Service Charge
395 Add Customer Deposits
400 Sales Tax
405 1 Deposit Owner
405 Deposit Loan
Month One – Bank Reconciliation
5 Month One – Bank Reconciliation
407 Bank Reconciliation
Month One – Compare Cash basis to Accrual Basis Using Bank Feeds
6 Month One – Compare Cash basis to Accrual Basis Using Bank Feeds
410 Compare Cash to Accrual
Month Two – Upload Bank Transactions
7 Month Two – Upload Bank Transactions
415 Upload Bank Transactions
Month Two – Add Transactions from Bank Feeds
8 Month Two – Add Transactions from Bank Feeds
420 Add Expenses
420 Add Insurance
425 Add Payroll Checks
430 Add Inventory
430 Add Loan Payments
435 Add Draw
440 Invoice & Bank Feeds
440 Receive Payments & Bank Feeds
445 Sales Receipt & Bank Feeds
Month Two – Bank Reconciliation
9 Month Two – Bank Reconciliation
450 Bank Reconciliation
Month Two – Analyze Reports
10 Month Two – Analyze Reports
455 Reports After Second Month
Credit Card Bank Feeds
11 Credit Card Bank Feeds
460 Credit Card Bank Feeds Upload
465 Add Credit Card Bank Feed Data
470 Reconcile Credit Card
Bank Feed Rules
12 Bank Feed Rules
470 Upload Bank Transactions
475 Bank Rules Deposit Same Customer Different Account
480 Bank Rules Amount Limit
485 Bank Rules Split Into Two Accounts
490 Bank Rules One Vendor Two Expense Accounts
495 Bank Rules More Rules & Techniques
I have go through this but want to ask something from you personally, can you share me yours contact on the comment space.
The course contains many great tips and tricks how to deal with bank feeds and bank rec in an easy and efficient way. The instructor is highly knowledgeable about the topic and there are many practical situations in real business life where you can apply what you learned. Just to add that you need at least some basic QBO knowledge in order to be able to follow and make the most of the course.