
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 how bank feeds integrate with QuickBooks to support cash and accrual flows across vendor, customer, and payroll cycles, including matching and avoiding duplicates.
Learn how to get started with QuickBooks Online, secure a clean practice file, follow along with problems, and explore purchasing options.
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.
Evaluate QuickBooks online purchase options during a 30-day trial, with guidance to delay buying until discounts and to choose the plus plan for inventory and invoicing needs.
Explore a bank feeds project in QuickBooks Online, outlining two months of accrual full-service data and a cash-basis alternative, with a January-to-March reconciliation comparison.
Set up bank feeds in month one by connecting banks to QuickBooks Online or uploading CSV files, with data awaiting approval before affecting the cash-basis system and accrual options.
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 to download a full year of bank transactions for import into QuickBooks Online, choose compatible formats, and clean data to map to vendors and expense accounts.
Import bank data into QuickBooks Online using a CSV file, uploading from bank feeds, and mapping dates, descriptions, and amounts to vendors, customers, and income and expense accounts.
Approve bank feed transactions in QuickBooks Online, record them to the financial statements by assigning vendors, customers, and accounts, and implement rules to streamline future cash-basis entries.
Learn to add expense transactions from bank feeds in QuickBooks Online, categorize them as utilities and other expenses, assign vendors, and review impact on balance sheet and P&L.
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.
Learn to record inventory purchases with bank feeds in QuickBooks Online, balancing accrual basis inventory with cash basis methods and tracking cost of goods sold.
Record an amount paid for investments via bank feeds in QuickBooks Online. Classify it as an investment asset and reconcile the balance sheet and profit and loss.
Record owner withdrawals from the bank feed into QuickBooks Online, classifying them as draws or expenses. Use proper audit trails by posting draws to equity rather than expense accounts.
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.
Identify owner deposits in QuickBooks Online bank feeds and classify them as equity, not income, using owner investment or capital accounts; distinguish customer deposits for accurate financial statements.
Record a loan deposit in QuickBooks Online and post it to the notes payable liability on the balance sheet, distinguishing it from owner deposits.
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.
Compare cash basis to accrual basis using bank feeds to generate major reports, including the profit and loss and balance sheet, and analyze timing differences for year-end tax preparation.
Compare cash and accrual accounting in QuickBooks Online, analyzing balance sheet and income statement timing differences from January to March, including accounts receivable, accounts payable, bank feeds, and clearance.
Upload bank transactions to QuickBooks Online by connecting to the bank or importing a csv file, then review, approve, and have data added to the balance sheet and income statement.
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.
Manage April bank feeds in QuickBooks Online to add expenses, categorize them (utilities, office supplies, telephone), and generate up-to-date balance sheet and P&L with automated rules.
Learn how to record insurance payments in QuickBooks Online using bank feeds, compare cash and accrual methods, and handle prepaid insurance with adjusting entries.
Learn to add payroll checks using bank feeds in QuickBooks Online, recording gross pay, withholdings, and payroll expenses while handling timing differences between cash and accrual reporting.
Learn how to add inventory using bank feeds in QuickBooks Online, comparing cash basis and accrual approaches, and explore tracking inventory outside QuickBooks with a periodic versus perpetual system.
Learn to record loan payments in QuickBooks Online using bank feeds, splitting payments into principal and interest, managing notes payable, and performing periodic amortization adjustments for accurate liability tracking.
Learn to add cash draws in QuickBooks Online using bank feeds, categorize them to owners pay or personal expense, and maintain an audit-ready equity balance without affecting net income.
Explore how invoices interact with bank feeds in QuickBooks Online, learn to match deposits to invoices, manage receive payments, and track accounts receivable.
Explore how invoices and receive payments tie to bank feeds in QuickBooks Online, tracking accounts receivable, balance sheet, and P&L while using un-deposited funds for deposits.
Explore how sales receipts relate to bank feeds in QuickBooks Online, manage UN deposited funds, and perform deposit matching for accurate balance sheet and P&L.
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.
Explore how bank feeds and credit card feeds shape balance sheet and P&L reports, comparing cash and accrual methods with monthly, by-month analyses.
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