Fix issues the first time you reconcile an account in QuickBooks Online (2024)

by Intuit201 Updated a day ago

Learn how to review your beginning balance and look for issues for accounts you haven't reconciled before.

If you'rereconciling an accountfor the first time and the beginning balance is off, don't worry. Most beginning balance issues are caused by an incorrect opening balance. This is the account's starting point you set when you first created it in QuickBooks.

Correcting the opening balance should also fix your beginning balance issues.Here's what to review so you can start reconciling your account for the first time.

Tip: If the account was already reconciled, here’s a different list of things to review. Or, if you're new to the entire process, start with our reconciliation guide.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Fix issues the first time you reconcile an account in QuickBooks Online (1)

Step 1: Review the opening balance in QuickBooks

Double-check the opening balance for the account you're reconciling. Sometimes, the opening balance doesn't include transactions that were still pending when you created the account. The opening balance is the balance of your bank account on the day you choose to start tracking transactions.

Note: If you recently entered older transactions dated before your opening balance, here's how to reconcile them. Then continue with these steps.

  1. Go to Settings ⚙, then Chart of accounts (Take me there).
  2. Find the account on the list.
  3. Select View register.
  4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  5. Take note of the date and balance.

Note: If you forgot to enter an opening balance, here's how to manually enter an opening balance later.

Step 2: Compare the opening balance with your real-life account

Now you know the date and amount of the opening balance in QuickBooks. Check it against your bank records:

  1. Sign in to your bank's website, or find your bank statement.
  2. Check the account's balance for the same day as the opening balance in QuickBooks.
  3. Compare the two balances.

If the balances match, you entered the opening balance correctly. Move on to Step 3.

If the opening balance in QuickBooks doesn't match your bank records, correct it:

  1. In QuickBooks, select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.
  3. Select Save.

Step 3: Review your account register

When you reconcile an account for the first time, the opening balance is the only entry that is reconciled. No other transactions should be reconciled. To check:

  1. Go to Settings ⚙, then Chart of accounts (Take me there).
  2. Find the account on the list.
  3. Select View register to get more details.
  4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  5. In the checkmark column, there should be an R.
  6. Check the other transactions. The checkmark column should either be blank or have a C.
  7. If there's an R on any other transactions, select the transaction to expand the view.
  8. Select box in the checkmark column. Keep selecting it until the box is blank. Then select Save.

Next steps: Start reconciling the account

Once you know your opening balance is correct, you can start reconciling. If you see a message about an incorrect beginning balance when you start, here are other things you can review.

If you’ve followed everything in our reconciliation guide but still have questions, connect with your bookkeeper.

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online LedgerQuickBooks Online PlusQuickBooks Online Simple Start

Fix issues the first time you reconcile an account in QuickBooks Online (2024)

FAQs

How do I fix a reconciliation error in QuickBooks Online? ›

To reconcile it again:
  1. Go to Transactions, then select Bank transactions (Take me there).
  2. Select the account you want to reconcile again, then select Go to bank register.
  3. Select Reconcile.
  4. Enter the info from your statement in the Ending balance field and Ending date field. ...
  5. Review the transactions. ...
  6. Select Finish now.

How do I reconcile for the first time in QuickBooks Online? ›

From the Gear icon ⚙ menu, select Reconcile (Take me there). Choose the account you want to reconcile and select Start Reconciling. Enter the ending balance from your bank statement and the ending date of the statement period. Check off all the transactions that appear on both your bank statement and in QuickBooks.

What if my beginning balance doesn't match my statement? ›

When the opening balance does not match the bank statement, there are two common reasons: There are previously reconciled transactions which were deleted OR. A transaction which was previously reconciled was unreconciled.

How to reset reconciliation in QuickBooks Online? ›

How to undo past bank reconciliation in qb online
  1. Go to the Gear icon and select Chart of Accounts.
  2. Locate the account that has the reconciled transaction and click View Register.
  3. Find the transaction and select it to expand the view. If the entry is reconciled, you'll see an R in the checkmark (✔) column. ...
  4. Select Save.
Aug 18, 2023

Can I force reconcile in QuickBooks Online? ›

You'll see a message explaining that your account isn't balanced. Select the Add adjusting entry link. This creates an expense transaction if the difference is negative, or an income transaction if the difference is positive. It forces the account to balance.

How do you correct a bank reconciliation error? ›

How do I fix it? Open Reconciliation > Reconcile Bank Accounts to review the outstanding checks and deposits. If the outstanding checks and deposits are correct, run Recalculate to calculate the outstanding check and deposit totals again.

Is there a way to edit a reconciliation in QuickBooks Online? ›

Editing and unreconciling transactions
  1. Locate the account for the transaction.
  2. Click the View Register on the Action Column and locate the transaction to change. ...
  3. For a reconciled transaction, you'll see an R in the checkmark column.
  4. Select and hold the box with the R symbol until a blank box appears. ...
  5. Click Save.
Apr 19, 2023

How do I manually reconcile in QBO? ›

Reconcile an account in QuickBooks Online
  1. Step 1: Select an account to reconcile.
  2. Step 2: Start the reconciliation.
  3. Step 3: Review and match transactions.
  4. Step 4: Finish the reconciliation.
  5. Step 5: Review past reconciliations.
  6. Step 6: Edit completed reconciliations.

Why does my bank balance not match my QuickBooks balance? ›

The relationship between QuickBooks Online and your bank is a real-time picture. What this means is that your bank balance and the balance in QuickBooks Online will only match if you don't have any outstanding checks. Think of the QuickBooks Online balance as the balance that would be in your checkbook register.

How to reconcile unreconciled transactions in QuickBooks Online? ›

Here's how:
  1. Click Accounting on the left menu and go to the Chart of Accounts tab.
  2. Look for the affected account and click View register.
  3. Look for the non-reconciled transaction and change the transaction status from blank or Cleared (C) to Reconciled (R).
  4. Click Save, then Yes to confirm the action.
Aug 8, 2022

How to fix incorrect beginning balance in QuickBooks Online reconciliation? ›

If the opening balance in QuickBooks doesn't match your bank records, correct it:
  1. In QuickBooks, select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.
  3. Select Save.

How do I fix a reconciliation discrepancy in QuickBooks Online? ›

Reconciliation Discrepancy
  1. Back up your QuickBooks company file.
  2. Go to Banking, and then Reconcile.
  3. Select Undo Last Reconciliation.
  4. When prompted, select Continue and then OK.
  5. Close out of reconciliation and open it again to redo the process.
Feb 15, 2021

What to do if bank reconciliation doesn't balance? ›

If your reconciliation doesn't balance, adjust the records to account for any missing data. For example, note uncleared checks and adjust the balance until the check clears.

What three conditions could lead to the beginning balance of a bank or credit card reconciliation being inaccurate? ›

Expert-Verified Answer

Three conditions that can lead to an inaccurate beginning balance in a bank or credit card reconciliation are: deletion of a reconciled transaction, change in the amount of a reconciled transaction, and a change in the status of a reconciled transaction to 'not reconciled'.

Why do I have a beginning balance in QuickBooks Online? ›

When you create a new account in QuickBooks Online, you pick a day to start tracking transactions and enter the balance for your real-life account for that day. This starting point is the opening balance.

Top Articles
Just Dance 2023 Song List & New Features
Are dentists expensive? | Modern Family Dental Care
Celebrity Extra
Couchtuner The Office
Guardians Of The Galaxy Showtimes Near Athol Cinemas 8
How Far Is Chattanooga From Here
Umn Pay Calendar
R Tiktoksweets
W303 Tarkov
Https //Advanceautoparts.4Myrebate.com
Pro Groom Prices – The Pet Centre
Alexandria Van Starrenburg
NHS England » Winter and H2 priorities
Where to Find Scavs in Customs in Escape from Tarkov
Pay Boot Barn Credit Card
Concordia Apartment 34 Tarkov
Apple Original Films and Skydance Animation’s highly anticipated “Luck” to premiere globally on Apple TV+ on Friday, August 5
Never Give Up Quotes to Keep You Going
Surplus property Definition: 397 Samples | Law Insider
Getmnapp
Bay Area Craigslist Cars For Sale By Owner
Afni Collections
Jackass Golf Cart Gif
Paradise Point Animal Hospital With Veterinarians On-The-Go
Spirited Showtimes Near Marcus Twin Creek Cinema
Elanco Rebates.com 2022
Shauna's Art Studio Laurel Mississippi
Craigslist Albany Ny Garage Sales
Skip The Games Ventura
Santa Cruz California Craigslist
Reading Craigslist Pa
Cherry Spa Madison
Linda Sublette Actress
2700 Yen To Usd
Panorama Charter Portal
Aita For Announcing My Pregnancy At My Sil Wedding
Danielle Ranslow Obituary
Gasoline Prices At Sam's Club
Citibank Branch Locations In North Carolina
Www Craigslist Com Atlanta Ga
What Is The Optavia Diet—And How Does It Work?
The Many Faces of the Craigslist Killer
Legs Gifs
Sams La Habra Gas Price
Costco Tire Promo Code Michelin 2022
Palmyra Authentic Mediterranean Cuisine مطعم أبو سمرة
Coldestuknow
Inloggen bij AH Sam - E-Overheid
Mast Greenhouse Windsor Mo
7 National Titles Forum
Latest Posts
Article information

Author: Rev. Porsche Oberbrunner

Last Updated:

Views: 5374

Rating: 4.2 / 5 (53 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Rev. Porsche Oberbrunner

Birthday: 1994-06-25

Address: Suite 153 582 Lubowitz Walks, Port Alfredoborough, IN 72879-2838

Phone: +128413562823324

Job: IT Strategist

Hobby: Video gaming, Basketball, Web surfing, Book restoration, Jogging, Shooting, Fishing

Introduction: My name is Rev. Porsche Oberbrunner, I am a zany, graceful, talented, witty, determined, shiny, enchanting person who loves writing and wants to share my knowledge and understanding with you.