240-393-4137 info@idcollins.com

By Iris Carter-Collins, Certified QuickBooks ProAdvisor | IDCOLLINS QuickBooks Solutions

If QuickBooks Online has not been reconciled in months, start by identifying the last completed reconciliation and gathering the statements that follow it. Downloaded bank transactions alone do not establish that the account has been reconciled.

Start with the records you have

List every bank and credit card account used by the business. Gather monthly statements, previous reconciliation reports, and questions from your accountant or CPA. Note closed accounts, loans, and payment processors that may help explain transfers or deposits. Request missing records rather than guessing at amounts.

Tell your QuickBooks professional what prompted the concern. You may be preparing for a tax appointment, applying for financing, changing software, or noticing report balances that do not make sense. Your deadline and the records available help establish the priorities.

Check the starting point before moving forward

Review the last statement ending date and the beginning balance before reconciling another period. If the beginning balance does not agree with the prior reconciliation, investigate before proceeding. Previously reconciled entries may need review. Avoid changing an opening balance simply to force agreement.

Work through one statement at a time

Work from the earliest unreconciled statement forward. Use each statement’s ending date and balance, compare its transactions with QuickBooks, and investigate differences. Missing entries, duplicates, fees, and transfers can require attention. An old outstanding item needs an explanation, rather than automatic deletion.

The goal is a zero reconciliation difference supported by the records. Avoid an unexplained adjustment just to finish. Intuit recommends resolving differences and consulting your accountant before accepting an adjusting entry. See Intuit’s reconciliation guidance.

Look beyond the reconciliation

Reconciliation is one part of reviewing your file. A transaction can match the statement and still have an incorrect category. Loan payments, transfers, and owner transactions need appropriate treatment so your Profit & Loss and Balance Sheet reflect the underlying activity. Coordinate with your accountant or CPA before changing records used for a filed tax return.

Months behind on reconciliation? Explore QuickBooks cleanup to identify the accounts and periods needing attention and discuss the work required.

Experience that supports the review

I have completed numerous cleanups bringing bank transactions current and properly categorized. I have also collaborated with accountants and CPAs on accounting software migrations. Those projects reinforced the importance of checking how information moves between systems and reviewing the resulting records.

Through building banking relationships, I developed an understanding of lenders’ Profit & Loss and Balance Sheet requirements. That experience helps me understand why business owners need supported, explainable reports. Each lender sets its own requirements; cleanup does not guarantee financing approval.

As a Certified QuickBooks ProAdvisor, I help business owners determine what their QuickBooks file needs. IDCOLLINS QuickBooks Solutions provides remote service nationwide.

Begin with a Book Review

A $795 Book Review is required. After the review, I’ll send you a video explaining what is needed, with cleanup pricing included in the video. Cleanup cost depends on what your file requires. I credit the $795 Book Review fee toward the cost of cleanup.

Visit the $795 Book Review service page, call 240-393-4137, or email info@idcollins.com to discuss the Book Review. You can also read How Much Does QuickBooks Online Cleanup Cost?