By Iris Carter-Collins, Certified QuickBooks ProAdvisor | IDCOLLINS QuickBooks Solutions
Your bank account is connected to QuickBooks Online. Does that mean it is reconciled? No. Downloading activity and reviewing it in the bank feed are different from comparing your records with a bank statement. For a first reconciliation, start with the period your file is intended to cover and the documents that establish its starting point.
Choose a starting period you can support
Gather a complete bank or credit card statement and identify when you began tracking the account in QuickBooks. If you have years of activity, a recent migration, or records from another system, decide on the starting period with your accountant or the person reviewing your file. Do not assume the latest month is the right place to start simply because its statement is easiest to find.
Review the opening balance before proceeding
Intuit identifies an incorrect opening balance as a common cause of first-reconciliation problems. Compare its amount and date with the corresponding bank records. If older activity was added later, or someone entered another starting balance, stop and investigate the overlap. A first-time opening-balance issue calls for a different review from a change to an account already reconciled in an earlier period.
Stuck on one part of your first reconciliation? Explore the $175 QuickBooks Rescue Session for up to 60 minutes of focused help understanding the issue and your next steps. Additional work may be needed.
Use the statement rather than today’s available balance
Select the correct account and compare against the statement period, ending date, and ending balance. Review the transactions that appear on that statement. Outstanding checks and deposits may belong to a different clearing period. Keep a list of unfamiliar or missing items to investigate; checking everything on screen does not establish that your records agree with the statement.
Resolve the explanation before completing the process
Review missing transactions, duplicates, fees, and entries posted to the wrong account. Resist adding an unexplained adjustment to finish. Keep the completed reconciliation report with your records and build a monthly routine. A reconciliation is an important control, but it does not by itself prove every expense category, customer balance, or other report is correct.
When professional help makes sense
I’m Iris Carter-Collins, a Certified QuickBooks ProAdvisor. My experience includes numerous cleanups bringing bank transactions current and properly categorized, collaboration with accountants and CPAs on accounting software migrations, and building banking relationships to understand lenders’ Profit & Loss and Balance Sheet requirements. If the starting point is unclear or you have several accounts and missing periods, a review can establish what needs attention before you proceed.
Start with a Book Review
For full cleanup involving multiple accounts or periods, a $795 Book Review is required before cleanup pricing is provided. After the review, I send you a video explaining what is needed, with cleanup pricing included in the video. Cleanup cost depends on your file. I credit the $795 Book Review fee toward the cost of cleanup. Remote service is available nationwide.
Request a Book Review | 240-393-4137 | info@idcollins.com
Sources: Intuit: First reconciliation issues; Intuit: Reconcile an account