
Explore how bank feeds import bank and credit card data into QuickBooks Online to produce financial statements and support invoicing, cash and accrual workflows, reconciliation with CSV data and automation.
Explore practical options for accessing QuickBooks Online, including free test drive, student versions, and 30-day trials, to practice bank feeds and credit card feeds with your data.
Set up bank feeds in QuickBooks Online by connecting your bank or credit card and bringing in transactions. Consider date ranges, duplicates, and bank restrictions, using downloads if needed.
Learn how to add capital expenditures from bank feeds to QuickBooks Online, categorize purchases as fixed assets like furniture and fixtures, and apply rules to capitalize rather than expense.
Add bank service charges using QuickBooks Online bank feeds. The lecture shows assigning charges to the bank charges and fees expense and reviewing the balance sheet and income statement.
Demonstrates adding customer deposits via bank feeds in QuickBooks Online, compares cash-basis and invoicing methods, and explains deposits' impact on balance sheet and income.
Explore how sales tax works in a cash-based QuickBooks Online system, incorporating inventory, cost of goods sold, and bank feeds to calculate and record tax.
Learn how to perform bank reconciliations using bank feeds. Compare cash basis versus accrual impacts and identify deviations to an accrual system across month one and month two.
Explore how bank feeds integrate with QuickBooks Online, and perform bank reconciliations to match bank statements with ledgers, identify timing differences, and prevent duplicates.
Explore adding transactions from bank feeds, compare cash vs accrual approaches, and learn to match invoices, deposits, and sales receipts to bank feeds to avoid double recording.
Learn how to record insurance payments in QuickBooks Online using bank feeds, compare cash and accrual methods, and handle prepaid insurance with adjusting entries.
Perform month two bank reconciliation by comparing the bank statement with QuickBooks Online data; month two data affects financial statements, and timing differences are discussed.
Learn to perform a bank reconciliation in QuickBooks Online using bank feeds, verify deposits and outstanding checks, and understand timing differences and reconciliation outcomes for April.
Analyze month 2 reports, including balance sheet and income statement, generated from bank feed data and added revenue accruals with invoices and sales receipts, comparing cash versus accrual systems.
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