
Understand what reconciling is in QuickBooks Online and why you should reconcile every month from oldest to newest to ensure accurate bank balances, reports, and catch duplicates or missing transactions.
Explore how QuickBooks Online imports transactions through the banking feeds and receipt capture, uses automated rules, and pre-reconciles items to simplify reconciliation.
Identify why the balance doesn’t equal zero, fix typos and date errors, locate missing or post-dated transactions with the browser's find, and adjust the statement ending date to reconcile.
Identify why the balance isn't zero by checking for typos and transposed digits. Then use the browser find to locate the missing transaction and adjust the statement ending date.
Identify and fix missing transactions in QuickBooks Online through bank feed reconciliation, verify against statements, locate mailchimp entries, and use Write Tool to add or adjust items.
Learn how to properly reconcile by handling not cleared transactions, applying filters, correcting misclassified and duplicate entries, and addressing uncashed checks and payroll issues.
Identify and resolve duplicated income in QuickBooks Online by matching bank feed transactions, cleaning duplicates across savings and checking accounts, and properly applying undeposited funds or payments to deposit.
Navigate accrual challenges when you cannot alter past periods, using offsetting transactions or January 1st journal entries to reverse old expenses or revenue while preserving tax implications.
Learn how to fix a wrong starting balance in QuickBooks Online during initial setup by addressing the opening balance equity entry and performing the first reconciliation.
Starting balance alerts indicate the beginning balance is off after reconciliations. Reconcile by repeating the last reconciliation, verify with the audit log, and fix misposted or future dated items.
Finish reconciliations only when the difference equals zero, using the finish now button. Save progress with save for later to resume, and avoid finishing if the difference isn't zero.
Learn how to access and interpret reconciliation reports in QuickBooks Online, including the reconciliation summary and history by account, with interactive details and undo options for accountants.
Explore the new AI-assisted reconciliation tool in QuickBooks Online, including uploading statements, AI mapping, and a detailed reconciliation report that calls out issues with payments and deposits.
Reconcile liabilities such as payroll and sales tax payable to zero, verify remittance accuracy, and correctly categorize expenses, illustrated through a quarterly Oregon employment tax reconciliation workflow.
Learn to reconcile loans in QuickBooks Online by splitting payments into principal, interest, and escrow, using splits, loan registers, or journ al entries, and verify splits with transaction activity pages.
Identify a bug in the reconciliation screen where older transactions don’t appear, then fix by filtering for no status and setting C on items, or use RightTool’s batch update.
Reconcile corporate credit cards by using a single control account with employee sub-accounts connected to the bank feed, and reconcile at the corporate level by zeroing sub cards monthly.
Even if you use the QuickBooks Online banking feed, it’s not a guarantee that your bank balances are correct. And when you have extra or missing transactions, your Profit & Loss and Balance Sheet are wrong!
Reconciliation is the monthly step to confirm your checkbook balance, credit cards, liabilities, and loans have been entered correctly. The problem is that most businesses reconcile the transactions that ARE on the statement, but ignore the ones that are not.
That’s not Reconciling, that’s “reconciling,” and the result is that you may be paying your taxes wrong!
In this class, not only will Alicia show you how to reconcile properly, but she’ll show you how to trick out the interface to finish in seconds instead of hours.
Even better, use reconciling as a troubleshooting tool. Learn how to identify errors in your accounting data by how they appear in your Reconciliation window:
duplicated entries
uncleared transactions
transactions coded to the wrong funding source
receipt captures that didn’t match the banking feed.
Take this class and save yourself hours of struggle...and make your reports a thing of beauty.
Instructional Level
Beginner through Intermediate
Course Length
1 hour
Course Credits
1 CPE, Certificate of Completion
Field of Study
Accounting
Delivery Method
Group Internet-Based, and QAS Self Study
Who should take this class?
Business owners who do their own bookkeeping
Bookkeepers who want to get routine tasks done blazingly fast
Accountants who make journal entries to correct errors instead of actually fixing the problem
What You’ll Learn
What accounts should get reconciled?
Why the banking feed still needs reconciliation
The Reconcile interface
Step-by-step reconciling
Tricks to locate errors quickly
How to solve common QBO workflow errors that create extra transactions