Nicole, Here Are Your Articles for Monday, November 23, 2020
Is this email not displaying correctly?
View it in your browser .
Our Website Contact Us About Us Services Tutorials Acumatica
Share Save

Is This Your Situation: QuickBooks Reconciliation Balance Doesn’t Match My Bank Statement


Several reasons may explain why the beginning reconciliation balance in QuickBooks does not match your bank statement. Ask yourself:

  • Is this the first time I have tried to reconcile the account? Did I even enter a balance? Or did I enter the incorrect amount to start?
  • Did I void, delete or change an amount of a previously cleared transaction since I last reconciled?
  • Did I accidentally change the status of a cleared transaction while working directly in the checking register?

It may feel like you are trying to find a needle in a haystack. Consider the following:

  • If this is your first time reconciling the account, try to find the account's opening balance transaction in the register (usually the first deposit transaction), or look for "Opening Bal Equity" in the Account field of the register. Depending on how your original balances were entered, you may need to correct the dollar amount and date to match your beginning bank balance.
  • To help you find a previously cleared transaction that was voided, deleted or changed, take advantage of some of the tools found under the "Locate Discrepancies" button in the bottom right corner of the "Begin Reconciliation" window (available only in QuickBooks desktop versions Premier and Enterprise).

The following tools can help you locate cleared transactions: 

  •  Discrepancy Report: This is often the easiest way to see what happened. Entries that have been modified or deleted will be displayed in their original form.

  •  Previous Reports: Under this option, choose the statement ending date that you wish to research, then choose to view prior reconciliations exactly as they were at the time of reconciliation, and compare them to the alternate reconciliation report that also includes any modifications that have transpired.

You can correct any identified discrepancies by following these steps:

  1. Enter missing or deleted transactions and re-clear them.
  2. Edit existing cleared transactions to again match the amount they were at the time of original reconciliation.
  3. As a last resort, simply undo previous reconciliations until you reach a good beginning balance for that date, and then re-reconcile each month as required.

If this feels overwhelming, you don't have to learn it on your own. We can help you with this and any other QuickBooks issues you may have. Give us a call and we'll help you work through them.


Share Save

Your Comments

Siegel Solutions Inc
Siegel Solutions Inc
(781) 487-7000
144 Gould Street Suite 205
Needham, MA 02494
Friend Me on Facebook
Follow Me on Twitter
Connect with me on LinkedIn
Saved Articles
Comments and Feedback
Refer A Friend
Your Privacy
Our firm provides the information in this e-newsletter for general guidance only, and does not constitute the provision of legal advice, tax advice, accounting services, investment advice, or professional consulting of any kind. The information provided herein should not be used as a substitute for consultation with professional tax, accounting, legal, or other competent advisers. Before making any decision or taking any action, you should consult a professional adviser who has been provided with all pertinent facts relevant to your particular situation. Tax articles in this e-newsletter are not intended to be used, and cannot be used by any taxpayer, for the purpose of avoiding accuracy-related penalties that may be imposed on the taxpayer. The information is provided "as is," with no assurance or guarantee of completeness, accuracy, or timeliness of the information, and without warranty of any kind, express or implied, including but not limited to warranties of performance, merchantability, and fitness for a particular purpose.
Powered by
Copyright © IndustryNewsletters All rights reserved.

This email was sent to:

Mailing address: 144 Gould Street Suite 205, Needham, MA 02494