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

Managing corporate credit cards with multiple sub-accounts in QuickBooks Online requires precise reconciliation to ensure your financial records are accurate.

This guide provides a step-by-step approach to reconcile a corporate credit card and its associated 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

Understanding Parent and Sub-Accounts

In QuickBooks Online, you can organize your credit card accounts by setting up a parent account for the main corporate card and sub-accounts for each individual cardholder.

This structure allows for detailed tracking of expenses per cardholder while maintaining a consolidated view under the parent account.

When transactions are downloaded, they typically post to each respective sub-account.

At the end of your statement period, you’ll need to transfer the balances from each sub-account to the parent account to reflect the consolidated statement accurately.

For this example, 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.

Steps to Reconcile a Corporate Credit Card with Sub-Accounts

Click Transactions in the left side menu, select Reconcile.

Navigating to Reconcile from the left side menu in QBO

From the Account drop-down menu, select the parent credit card account.

Selecting the account when reconciling in QBO

Enter Statement Details:

  • Ending Balance: Input the ending balance as shown on your credit card statement.

  • Ending Date: Enter the statement’s ending date.

Click Start reconciling.

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.

The ending date, 2/14/2023, is found at the top of the statement.

Example bank statement ending date.

Here’s what this looks like entered into QuickBooks:

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

Match Transactions:

  • Review the list of transactions in QuickBooks and compare them with your credit card statement.
  • Check off each transaction that matches the statement.

In my example statement the transactions are separated by sub-account. I go through the first credit card’s x8159 transactions and check them off on the Reconciling screen.

Reconciling an account in QBO

Next, I go through the charges on the statement for the next credit card, x6594, and check those off on the Reconciling screen.

Reconciling an account in QBO

Verify and Finalize:

  • Ensure the Difference displayed is $0.00, indicating all transactions are accounted for.
  • Click Finish now to complete the reconciliation process.

Chart of Accounts

The sub-accounts on the Chart of Accounts appear below the parent account and are indented.

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

When you view the register for each sub-account you’ll see the charges for that account.

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

By following these steps, you can reconcile a corporate credit card with sub-accounts in QuickBooks Online, ensuring accurate financial records.

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

If you have questions about corporate credit cards in QuickBooks Online click the green button below to schedule a free consultation.

For a video demonstration, you may find the following tutorial helpful:

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.

2 Responses

  1. This is the way I have our company cards set up. I reconcile the main account as that is the account number on the statement. However, the online banking that brings in the transaction in QBO is from the subaccount. That register has gotten bigger and bigger since there are no payments to offset it. Is that normal?

    1. Hi Ann, the total balance is correct. The easiest way to see it is on the balance sheet.

      To fix it so it doesn’t drive you nuts, you can transfer the register balance as of the last statement from the sub-account into the parent account. If this feels unclear let me know and Rachel can make a video on it.

Leave a Reply

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

Read similar articles

5 Common QuickBooks Errors (And How to Fix Them)

Learn how to handle 5 common errors in QuickBooks Online.

Finding the Right Mentor and Coaching for Your Bookkeeping Journey

Learn how mentor and coaching can transform your bookkeeping business and help you achieve your professional goals.

QuickBooks Test Drive: How to Access and Use the Sample Company

Learn how to access QuickBooks Test Drive to practice transactions and explore features without affecting real data.

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.