How to Reconcile a Corporate Credit Card with Sub Accounts in QuickBooks Online

Written By

In this blog post, I’ll show you how to reconcile a credit card in QuickBooks Online. Specifically a credit card with sub accounts.

I’ll be using a fake bank account and fake statements so some things might look a little weird. But the instructions are valid.

Here is the statement I’m working from. It’s a parent account x7821, with two sub accounts, x8359 and x6549.

Example of a statement for a credit card with sub accounts.

 

Quick Instructions:

  1. Click Transactions -> Reconcile in the left side menu
  2. In the Account drop-down select the parent account
  3. Enter the Ending balance and Ending date on the statement
  4. Click Start reconciling
  5. Go down the list of transactions for each sub account, checking them off in QB as you go
  6. The difference should be $0.00, click the Finish now button

Keep reading for a complete walkthrough with screenshots:

Reconcile

To get to the Reconcile screen in QuickBooks Online click Transactions in the left side menu. Then click Reconcile.

Navigating to Reconcile from the left side menu in QBO

From the Account drop-down menu select the account to reconcile.

Selecting the account when reconciling in QBO

I’m selecting the parent account, not the sub account.

Fill in the Ending balance and Ending date from your statement.

In my example statement, the Ending balance, $1,781, is in the Account Summary section of the statement. 

Example of a bank statement ending balance.

In my example statement the ending date, 2/14/2023, is found at the top of the statement.

Example bank statement ending date.

When the Ending balance and Ending date are filled in select the Start reconciling button.

Ending balance and ending date entered when reconciling a bank account in QBO

I’m going to look at the list of charges on the statement for the first credit card, x8159, and check them off on the Reconciling screen.

Reconciling an account in QBO

Now I’ll look at the list of charges on the statement for the next credit card, x6594, and check those off on the Reconciling screen.

Reconciling an account in QBO

The DIFFERENCE is now $0.00 so I can click the Finish now button in the upper right corner. 

Chart of Accounts

On the Chart of Accounts the sub accounts will appear below the parent account and slightly indented.

A credit card with sub accounts on the Chart of accounts in QBO

When you view the register for each of the sub accounts they will show the charges for that account.

If you view the register for the parent account, it will show the charges for ALL the sub accounts.

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

If you have questions about setting up sales tax in QuickBooks Online click the green button below to schedule a free consultation.

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

Restoring QuickBooks Online Using Rewind Backup Software

Learn how to restore your QuickBooks Online data using Rewind backup software.

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.