How to Reconcile Your Account in QuickBooks Online

In this tutorial, you’ll learn how to reconcile your accounts in QuickBooks Online. 

Quick Instructions:

  1. Navigate to the Reconciling Screen
    1. Click Accounting -> Reconcile in the left-hand menu
  2. Select the account you’re reconciling from the Account drop-down menu
  3. Enter the Ending balance from your bank statement
  4. Enter the Ending date from your bank statement
  5. Click the green Start reconciling button
  6. Check off any transactions in the list that appear on your bank statement
    1. If any transactions do not match with your bank statement DO NOT check them off.
    2. Look at the transaction to determine if it is a mistake or just a transaction that will carry through to next month. Like a check that has not yet been cashed
  7. Click the green Finish now button when done

Why Reconciling Is Important

Reconciling is comparing what’s on your bank statements to what appears in your QuickBooks.

It’s an important part of bookkeeping with QuickBooks Online.

Reconciling allows you to look for mistakes like duplicate or missing transactions.

How to Reconcile a Bank Account

There are several ways to get to the reconciling screen. I like to click on Accounting in the left-hand menu and select Reconcile.

Navigating to reconciling screen in QuickBooks Online

The first time you reconcile you’ll see a screen with a green Get Started button. Click the button to begin.

You’ll then see a pop-up showing you the workflow for reconciling.

Click the green Let’s do it button to continue.

Reconcile like a pro pop-up in QuickBooks Online

Select the account you’ll be reconciling from the Account drop-down menu.

Account drop down menu when reconciling in QuickBooks Online

When you select an account you’ll be asked to enter some information.

It will show you a Beginning balance that cannot be edited. This is the beginning balance from within QuickBooks. 

You’ll enter the Ending balance and Ending date from your bank statement. Then click the green Start reconciling button.

Entering your ending balance and ending date from your bank statement before beginning to reconcile and account in QuickBooks Online

NOTE: It’s best to reconcile your accounts one month/statement at a time. While you can reconcile multiple months at a time it’s best to do it monthly so it’s easier to catch any mistakes.

Checking Off What Appear On Your Bank Statement

On the Reconcile screen, you’ll see a list of transactions that have been entered into QuickBooks. These are transactions that have not yet been reconciled. That have a date before the ending date of your bank statement.

On the right-hand side are little circles. Clicking those circles will “check off” the transactions.

You want to check off all transactions in the list that appear on your bank statement.

DO NOT check off anything that doesn’t appear on your bank statement.

In this example, I have two transactions that I’ve found on my bank statement and checked off.

Checking off transactions that match you bank statement while reconciling QuickBooks Online

What To Do With Unchecked Transactions

There’s one transaction in QuickBooks that did match the bank statement. 

If you have a transaction like this, it does not necessarily mean anything is wrong.  Look at the transaction and determine if this is a transaction that will be on a later bank statement.

In my example, this is a bill payment made that was paid with a check that the vendor has not yet cashed. 

If this transaction were to remain the same next month (no match in QuickBooks). I’d give Robertson & Associates a call to find out if they forgot or lost the check.

If this transaction was a transfer, a payment to a credit card, or an expense then you need to investigate and correct it.

If you’ve got a transaction like this and you can’t figure out why it’s there. Click the green Schedule a FREE Consultation button below and we’ll be happy to help you.

When you’ve finished reconciling your statement click the green Finish now button in the upper right corner.

A pop-up will appear letting you know you’ve reconciled the account. Click the Done button.

Reconcile Summary

On the main Accounting -> Reconcile screen there’s a Summary link in the upper right-hand corner.

Reconcile summary link in QuickBooks Online

Clicking this link takes you to the Reconciliation summary

This shows you a list of the accounts you’ve reconciled, when you last reconciled them, and the ending date of the last reconciled statement.

Reconciliation summary in QuickBooks Online

If you have a lot of accounts to reconcile this is a great way to see where you left off and what you should reconcile next.

You now know how to reconcile your accounts in QuickBooks Online. If you have any questions please ask them in the comments. Or click the green button below to schedule a free consultation.

☕ If you found this helpful you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog

If you’d like to watch me walk through this process check out the video below:

 

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.