QuickBooks Online Tutorial: How to Reconcile Your Bank Account (and Discrepancies!)

About this video

A QuickBooks Online tutorial on bank reconciliation — ensuring bank statements and QuickBooks show the same data to avoid misreporting income and expenses — using the example business David’s Doughnut Den. Every day QuickBooks syncs bank and credit card transactions; before reconciling you must post them by reviewing category and vendor/customer. Without AI: download the bank statement, go to Accounting > Reconcile, enter the statement ending balance ($28,693 and change in the example) and ending date (November 30th, 2025), then uncheck all transactions and check only those that appear on the statement, verifying amounts (e.g., Sweet Ads Media for $1,500). The example leaves one QuickBooks transaction unchecked and finds interest earned missing from QuickBooks, leaving a $50.17 difference; if syncing does not fix it, create it manually as a bank deposit (or an expense if an expense is missing), then check it to reach $0 difference and click Finish Now. The unchecked City Utilities payment is explained as likely an uncashed check. With AI — available on Plus and Advanced plans, noted as in beta at filming — you drag and drop the statement, QuickBooks extracts the balance and date, bold text shows bank statement lines vs plain text for QuickBooks, the Accounting Agent advises unchecking the missing payment, and you add and post the missing deposit to clear to zero. Finally, fixing a common error: if a previously reconciled $165 expense for merchant processing fees from payee Card Pro was deleted, use ‘We can help you fix it’ to view its history, recreate it via Create > Expense, then re-reconcile the last statement to remove the error.

Key takeaways

• Post transactions first — review category and vendor/customer and click Post — before starting reconciliation for that month
• Manual method: enter the statement ending balance and date, uncheck everything, then check only transactions that match the bank statement amount-for-amount until the difference is $0
• A missing bank line like interest earned can be added manually as a bank deposit (or expense) if it is not a bank-sync issue; an unchecked payment is commonly a check the recipient has not cashed yet
• On Plus and Advanced plans, AI reconciliation lets you drag and drop the statement, auto-fills balance and date, and the Accounting Agent flags uncleared items like the $1,220 payment and $50 deposit in the example
• If a reconciled transaction was deleted, recreate it exactly from its history (example: $165 merchant processing fees to Card Pro) and re-reconcile that statement to clear the error

Episode details: published January 6, 2026 · 8:58 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: Vibe Coding Explained for Beginners (Everything You Need to Know) · Next: Adobe Acrobat: Redact Your PDFs the Right Way! →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube