How to Reconcile in QuickBooks Online (2024)

Reconciliation is a great practice to add to your business to-do list. You can easily roll it into other month end tasks you work on to keep up on the state of your company. While not required, keeping a close eye on your books and what’s coming in and out can save you from a lot of issues in the future. Reconciling gives you insight into your business and QuickBooks Online is equipped to make the process as easy as possible.

How to Reconcile in QuickBooks Online (1)

When reconciling an account, the first bit of information you need is the opening balance. If you choose to connect your bank and credit cards to your online account, QuickBooks will automatically bring over transactions and also the opening balance for you.

The first thing you’ll start when reconciling an account is Reviewing your opening balance. Get your bank statement and then follow the steps below:

  1. In QuickBooks Online, select Settings ⚙ and then Reconcile. If you're reconciling for the very first time, select Get started to continue.
  2. From the Account ▼ dropdown, select the account you want to reconcile.
  3. Review the Beginning balance. Does this match what you see in your statement? If they don’t match, take a look at this article: Fix issues the first time you reconcile an account in QuickBooks Online
  4. Enter the Ending balance and Ending date on your statement. This may also be called the "new balance."
  5. When you're ready to start, select Start reconciling.

The next step is basically a game of match. You’ll want to look at your statement, starting with the first transaction listed and find that same transaction in the Reconciliation window in QuickBooks. If they match, put a checkmark next to the amount. This marks that transaction as reconciled. Continue this through the whole statement.

You can also make small edits if needed right within this window. For example, if the payee is wrong, you can click on the transaction to expand the view and then select Edit.

Need to undo a reconciled transaction? Not a problem! (If you’re in the middle of reconciling, stay on the page you’re on and skip to step 4).

  1. Go to Accounting on the left menu.
  2. Select Chart of Accounts.
  3. Find the account holding the transaction. Choose View register.
  4. Select the transaction you want to unreconcile to expand the view.
  5. If the transaction is reconciled, you’ll see an “R.”
  6. Click the checkbox until it is blank. This removes the transaction from the reconciliation.
  7. Select Save.

Once you’re done, you should see a difference of $0, which means your books are balanced. Yay! Lastly, select Finish now and you are good to go.

Here are a few additional articles to help you accomplish a successful reconciliation:

Did things go smoothly for you or did you run into some bumps? Don’t you worry, stay tuned for another article addressing any setbacks you may encounter on your reconciling journey, and how to fix them!

How to Reconcile in QuickBooks Online (2024)

FAQs

How do I reconcile on QuickBooks Online? ›

Overview
  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.

How do I start over reconciliation in QuickBooks Online? ›

Select the account you want to reconcile again, then select Go to bank register. Select Reconcile. Enter the info from your statement in the Ending balance field and Ending date field. Then, select Start reconciling.

How do you reconcile bank statements? ›

The basic sequence, of preparing a bank reconciliation, consists of the following eight steps.
  1. Acquire Bank Statements. ...
  2. Aggregate Business Records. ...
  3. Match Deposits and Withdrawals to the Balance Sheet. ...
  4. Check Income and Expenses. ...
  5. Identify Errors with Check Deposits. ...
  6. Check for Other Transactions. ...
  7. Adjust Balances. ...
  8. Final Check.
Jan 10, 2023

How do I fix reconcile discrepancies in QuickBooks? ›

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

How do I manually reconcile in QuickBooks? ›

This ensures your account is successfully linked to a valid company ID.
  1. Go to the Banking menu, then select Reconcile.
  2. In the Account field, select the bank or credit card account you want to reconcile.
  3. The Statement Date is automatically filled in. ...
  4. QuickBooks also automatically enters the Beginning Balance.
Oct 20, 2023

Does QuickBooks Online automatically reconcile? ›

Connect QuickBooks to your bank, credit cards, PayPal, Square, and more 1 and we'll import your transactions for you. When you receive your bank statement or account statement at the end of the month, you'll only spend a minute or two reconciling your accounts.

Can I redo a reconciliation in QuickBooks Online? ›

You are able to undo their entire reconciliation and get a fresh start. Your clients can also edit individual transactions on a reconciliation whenever they need to.

How do I delete old unreconciled items in QuickBooks Online? ›

Uncleared transactions
  1. From the File menu, select Switch to Single-user mode. ...
  2. Go to the Accountant menu and select Batch Delete/Void Transactions.
  3. Choose the transactions you want to delete or void from the Available Transactions list.
  4. Click on Review & Delete (or Review & Void).
Jan 5, 2022

How to reconcile in QuickBooks when beginning balance is wrong? ›

Step 2: Reconcile to correct the Beginning Balance
  1. Go to Banking, and then select Reconcile.
  2. Select the account you want from the Account drop-down.
  3. Enter the statement date and ending balance that matches your Journal Entry.
  4. Select Continue.
  5. In Deposits and Other Credits, select the Journal Entry. ...
  6. Select Reconcile Now.
Nov 17, 2023

How to do a bank reconciliation step by step? ›

How to Do Bank Reconciliations Step by Step
  1. Compare the bank account balance to the cash balance on your books. ...
  2. Scrutinize your bank statement. ...
  3. Scrutinize your cash book. ...
  4. Adjust the balance of your bank account. ...
  5. Adjust the balance of your books. ...
  6. Record the reconciliation.
Apr 1, 2024

What are the 4 steps in the bank reconciliation? ›

The four steps in bank reconciliation are (1) accessing and comparing deposits between a company's bank statement and its internal systems of record, (2) normalizing the bank statement as needed, (3) formatting of data from internal systems of record, and (4) comparing the bank statement and internal records to confirm ...

What is the first step in the reconciliation process? ›

Reconciliation Compliance uses a six step process that starts with loading data. Load data-- Loading data is the first step in the process. Loading data can be from a premapped file or through Data Management.

What does C and R mean in Quickbooks online? ›

The C and R under the ✓ column on your Chart of Accounts are reconciliation status. C means cleared through the bank and checked off but not reconciled. On the other hand, R means reconciled. Transactions with R status will no longer show up on the next reconciliation screen at all.

What happens if bank reconciliation doesn't balance? ›

For unreconciled transactions, it may be necessary to revisit each step of the reconciliation process. A company may have to pull data again and compare each transaction. If their systems allow it, a business may choose to manually adjust a transaction (or multiple transactions) to rectify the situation.

How do I reconcile journal entries in QuickBooks? ›

Here's how:
  1. Click Banking on the top.
  2. Select Reconcile.
  3. On the Begin Reconciliation screen enter the necessary information.
  4. Click Continue.
  5. On the upper right hand of the Reconcile screen, uncheck the box for “Hide transactions after the statement's end date" to show the transactions.
Oct 19, 2018

Where do I find reconciliation in QuickBooks Online? ›

How to view a reconciliation report
  1. Go to Reports (Take me there).
  2. Type Reconciliation Report in the Find report by name search bar.
  3. Select Reconciliation Reports.
  4. Select the Account for the reconciliation report you want to view.
  5. From the Report period drop-down arrow, choose the reconcile period.
  6. Select View Report.
Feb 1, 2024

How do I match transactions in QuickBooks Online? ›

Match with an existing transaction
  1. Go toTransactions, then select Bank transactions (Take me there).
  2. Find a downloaded record. ...
  3. Select the downloaded record to expand the view. ...
  4. Review the Suggested matches for any possible matching transactions already entered in QuickBooks.

Does QuickBooks Online have bank reconciliation? ›

Just like balancing your checkbook, you need to review your accounts in QuickBooks to make sure they match your bank and credit card statements. This process is called reconciling. When you have your bank statement in hand, you'll compare each transaction with the ones entered into QuickBooks.

Is there a reconciliation report in QuickBooks Online? ›

Each time you finish reconciling, QuickBooks Online will automatically generate a reconciliation report for that session. The reconciliation report is useful if you have trouble reconciling the following month and when you meet with your accountant.

Top Articles
Latest Posts
Article information

Author: Foster Heidenreich CPA

Last Updated:

Views: 6612

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Foster Heidenreich CPA

Birthday: 1995-01-14

Address: 55021 Usha Garden, North Larisa, DE 19209

Phone: +6812240846623

Job: Corporate Healthcare Strategist

Hobby: Singing, Listening to music, Rafting, LARPing, Gardening, Quilting, Rappelling

Introduction: My name is Foster Heidenreich CPA, I am a delightful, quaint, glorious, quaint, faithful, enchanting, fine person who loves writing and wants to share my knowledge and understanding with you.