Getting Started with QuickBooks Online Part 2: Reconciling

This is part two in a series on getting started in QuickBooks. This series is for anyone who’s been using QuickBooks and already has it set up.

Part one was all about reviewing transactions and adding them to the register.

Today I’ll show you how to :

  • Reconcile reviewed transactions with your bank statements
  • Double-check categories in the Profit and Loss report

You’ll be looking for any missing or duplicate transactions. And, fixing them when needed.

If all transactions were added correctly, as I showed part one, then your bank balance and your Quickbooks balance should match.

Bank balance and QuickBooks balance should match

Reconciling

There are a couple of ways to start reconciling your accounts. 

One way is to click on Account -> Reconcile in the left-hand menu.

Navigating to the reconciliation from left-hand menu

You can also get there by clicking the gear icon in the upper right corner. Then selecting Reconcile under Tools.

Navigating to reconciliation from the tool menu

Either method will get you to the same place.

From here you’ll select the account you’ll be reconciling. Make sure you have the corresponding account’s bank statement on hand.

Verify that the beginning balance in Quickbooks matches the beginning balance (or last month balance) on your bank statement.

Entering the beginning balance when reconciling a bank account in Quickbooks Online

In the Ending Balance field, you’ll enter the ending balance from your bank statement. Then enter the ending date of the bank statement and click the “State reconciling” button.

Start reconciling your QuickBooks accounts

You’ll see a list of transactions. Check off every transaction that appears on your bank statement.

Checking off transactions when reconciling accounts in QuickBooks Online

You want to make sure every transaction that appears on your bank statement gets checked off in QuickBooks.  

If you have any transactions that don’t get checked off then you may have a duplicate transaction.

You want the difference to be zero.

Reconciling difference equals zero in QuickBooks Online

If the difference equals zero and you’ve checked off all transactions from you’ve bank statement. Then you want to click the Finish now button.

Finished reconciling a QuickBooks Online bank account

You’ll need to repeat this for each bank account for every month that you haven’t yet reconciled.

Double Checking Categories

Now I’ll show you how to double-check that your categories are correct.

This isn’t foolproof but it does a great job of catching most incorrect categories.

Click on Reports in the left-hand menu and then select the Profit and Loss report.

Navigating to QuickBooks Online Profit and Loss report

If you don’t see the Profit and Loss report in your favorites you can use the search box.

Searching for the Profit and Loss report

The Profit and Loss report is available no matter which version of QuickBooks Online you’re using. This is not a special report limited to higher editions.

When the report first appears you won’t see a way to change the date range on the screen. You’ll need to scroll up to view the customization fields.

This Year-to-date should be fine or you can adjust it to the date period you’ve been working with.

Changing the date on the Profit and Loss report in QuickBooks Online

Below the date you’ll see “Display column by” and it will be set to “Total Only.”

Profit and Loss report Display columns by customization option

This means it will show you the totals for the date range you selected.

I’d like you to change “Total Only” to “Months” and then click the “Run report” button.

Changing Display columns by in Profit and Loss report of QuickBooks Online.

In part one I showed you how to organize and categorize the incoming and outgoing money. Earlier, when reconciling we checked that all the numbers match the bank statement.

Now we’re going to look at the Profit and Loss report and check if the totals, by month, make sense. 

First, I’m going to look at the total income.

Total income on the Profit and Loss report in QuickBooks Online

I’m look at each month and checking for any anomalies. In my example March is very high compared to the other months.

If you see a difference like this it could be a miscategorized transaction. A transfer that was incorrectly entered as income. Or, if you put your  own money into your business from a personal account and entered it as income.

That’s the end of part two. In part three I’ll show you how to check the Transaction Report and fix any mistakes.

☕ 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

How to Manage Incorrect Payee and Category Suggestions in QuickBooks Online with Bank Rules

Learn how to use bank rules to make sure you don't incorrectly categorize transactions.

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.

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.