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
Etiqueta de envío: qué es y cómo se crea
Slippage in Trading: What Is It & How Can I Avoid?
Gomoviesmalayalam
PontiacMadeDDG family: mother, father and siblings
What to Serve with Lasagna (80+ side dishes and wine pairings)
J Prince Steps Over Takeoff
Matthew Rotuno Johnson
shopping.drugsourceinc.com/imperial | Imperial Health TX AZ
Shooting Games Multiplayer Unblocked
Enderal:Ausrüstung – Sureai
Chicken Coop Havelock Nc
Accuradio Unblocked
Nebraska Furniture Tables
Mbta Commuter Rail Lowell Line Schedule
N2O4 Lewis Structure & Characteristics (13 Complete Facts)
Idaho Harvest Statistics
Itziar Atienza Bikini
How to Create Your Very Own Crossword Puzzle
MLB power rankings: Red-hot Chicago Cubs power into September, NL wild-card race
Scout Shop Massapequa
ABCproxy | World-Leading Provider of Residential IP Proxies
Ahn Waterworks Urgent Care
Heart Ring Worth Aj
Atdhe Net
Skycurve Replacement Mat
Craigslist List Albuquerque: Your Ultimate Guide to Buying, Selling, and Finding Everything - First Republic Craigslist
NV Energy issues outage watch for South Carson City, Genoa and Glenbrook
Shiny Flower Belinda
Ice Dodo Unblocked 76
2016 Honda Accord Belt Diagram
Sinfuldeeds Vietnamese Rmt
PA lawmakers push to restore Medicaid dental benefits for adults
Robeson County Mugshots 2022
20 Best Things to Do in Thousand Oaks, CA - Travel Lens
Tugboat Information
Anderson Tribute Center Hood River
Florida Lottery Claim Appointment
Mbfs Com Login
Catchvideo Chrome Extension
Gas Buddy Il
Ssc South Carolina
Searsport Maine Tide Chart
3367164101
Theatervoorstellingen in Nieuwegein, het complete aanbod.
Walmart Front Door Wreaths
Campaign Blacksmith Bench
O'reilly's On Marbach
Bob Wright Yukon Accident
Lux Nails & Spa
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.