cancel
Showing results for 
Search instead for 
Did you mean: 
lainscough
Level 2

Reconciling 2 credit cards on combined statement

My client has two Chase Visa credit cards that are on a combined bank statement. In QBO, the two credit cards were set up as individual COA accounts and individual bank feeds. Credit Card #1 is where all the payments and interest come through on the bank feed and has a lot of historical transactions. Credit Card #2 only has actual CC transactions ... no payments nor interest. Credit Card #1 is reconciled though 5/14/2019. Credit Card #2 had its first charge on the next statement. Credit Card #2 also has a large opening balance which I think is incorrect since nothing had been charged on the card. When I look at the Audit History of the opening balance transaction for Credit Card #2, it is a Credit Card Credit and added by Online Banking Administration on July 8, 2019. Is this something that happened when someone connected the bank feed? My main question is how do I reconcile these accounts from the combined statements from 5/14 onwards without messing up all the historical transactions? Thanks!

Solved
Best answer February 11, 2020

Best Answers
MariaSoledadG
QuickBooks Team

Reconciling 2 credit cards on combined statement

Hi lainscough,

 

You'll want to set up the first bank account as a parent account and the other as a sub-account.

 

Here's how: 

  1. Go to the Banking menu or Transactions menu.
  2. Select Connect from the landing page, or select Add account if you've already created an account.
  3. Search for your bank. 
  4. Click Continue, then enter the username and password you use for your bank's website in the pop-up window. 
  5. Select the type of account you want to add. 
  6. Select the date range for the download. Some banks download the last 90 days of transactions, others go back as far as 24 months.
  7. Click Connect.

Once you connect to Online Banking, you'll have to make sure how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent account.

 

If you're opening balance is incorrect, you'll want to delete the balance, please see the steps below.

  1. Click the Accounting menu on the left panel.
  2. Select Chart of Accounts
  3. Select the account. then click View register.
  4. Click Edit to delete the opening balance. 
  5. Click Save.

Once done, you'll want to reconcile the parent account because all transactions will also roll up in the sub-accounts.

 

For more information, please check Banking and bank feed.

 

Reach out to us always if you have other questions. I'm always right here to help.

View solution in original post

Kristine Mae
Moderator

Reconciling 2 credit cards on combined statement

Let me ease your confusion, Lainscough.

 

When connecting accounts to Online Banking, we'll have to know how the bank sends the downloaded transactions. In your case, they're downloaded to the individual accounts. That's why it was correct to connect the credit card accounts to bank feeds.

 

Although, we still have to add the bank account (parent), then set up the credit card accounts as sub-accounts for reconciliation purposes. You will only have to reconcile the parent account because all transactions in the sub-accounts are rolled up into it. 

 

I know you're worried about the transactions in your bank feeds. It will remain intact since we're only adding the parent account. We're not disconnecting any accounts. I'm here to help you.

 

First, here's how to add the parent account:

  1. Click Accounting, then go to the Chart of Accounts tab.
  2. Click New.
  3. Fill in the necessary fields, then click Save and close.

Next, let's set up the credit card accounts as sub-accounts. Here's how:

  1. On the Chart of Accounts page, look for the credit card account.
  2. Click the View register drop-down arrow, then select Edit.
  3. Tick the Is sub-account box, then select the parent account.
  4. Click Save and Close

Then, you can reconcile the parent account. 

 

You can also check this reference about bank or credit card subaccount setup for more details.

 

If you have additional questions, feel free to drop a comment below. 

View solution in original post

19 Comments 19
MariaSoledadG
QuickBooks Team

Reconciling 2 credit cards on combined statement

Hi lainscough,

 

You'll want to set up the first bank account as a parent account and the other as a sub-account.

 

Here's how: 

  1. Go to the Banking menu or Transactions menu.
  2. Select Connect from the landing page, or select Add account if you've already created an account.
  3. Search for your bank. 
  4. Click Continue, then enter the username and password you use for your bank's website in the pop-up window. 
  5. Select the type of account you want to add. 
  6. Select the date range for the download. Some banks download the last 90 days of transactions, others go back as far as 24 months.
  7. Click Connect.

Once you connect to Online Banking, you'll have to make sure how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent account.

 

If you're opening balance is incorrect, you'll want to delete the balance, please see the steps below.

  1. Click the Accounting menu on the left panel.
  2. Select Chart of Accounts
  3. Select the account. then click View register.
  4. Click Edit to delete the opening balance. 
  5. Click Save.

Once done, you'll want to reconcile the parent account because all transactions will also roll up in the sub-accounts.

 

For more information, please check Banking and bank feed.

 

Reach out to us always if you have other questions. I'm always right here to help.

lainscough
Level 2

Reconciling 2 credit cards on combined statement

These 2 accounts were set up by another bookkeeper long ago.  So, I have 2 accounts on the same level, and they have been downloading transactions from their separate banking feeds for quite some time and the feeds are both current.  Are you saying I need to create new account that will server as the master, then move both accounts as a sub-account to the new master?  Will the bank feeds remain intact?  

 

Or, are you saying use Credit Card #1 as the master and move Credit Card #2 as a sub-account of the master?

 

My problem is this was set up and has been downloading for some time now and I don't want to reinvent the wheel.

Kristine Mae
Moderator

Reconciling 2 credit cards on combined statement

Let me ease your confusion, Lainscough.

 

When connecting accounts to Online Banking, we'll have to know how the bank sends the downloaded transactions. In your case, they're downloaded to the individual accounts. That's why it was correct to connect the credit card accounts to bank feeds.

 

Although, we still have to add the bank account (parent), then set up the credit card accounts as sub-accounts for reconciliation purposes. You will only have to reconcile the parent account because all transactions in the sub-accounts are rolled up into it. 

 

I know you're worried about the transactions in your bank feeds. It will remain intact since we're only adding the parent account. We're not disconnecting any accounts. I'm here to help you.

 

First, here's how to add the parent account:

  1. Click Accounting, then go to the Chart of Accounts tab.
  2. Click New.
  3. Fill in the necessary fields, then click Save and close.

Next, let's set up the credit card accounts as sub-accounts. Here's how:

  1. On the Chart of Accounts page, look for the credit card account.
  2. Click the View register drop-down arrow, then select Edit.
  3. Tick the Is sub-account box, then select the parent account.
  4. Click Save and Close

Then, you can reconcile the parent account. 

 

You can also check this reference about bank or credit card subaccount setup for more details.

 

If you have additional questions, feel free to drop a comment below. 

lainscough
Level 2

Reconciling 2 credit cards on combined statement

Thank you so much ... that worked like a charm.  Now I'm catching up on reconciliation.  Again, a huge THANK YOU!!!

Jaquline
Level 1

Reconciling 2 credit cards on combined statement

Hi I followed the steps, QuickBooks did not allow me to check sub-account because the account is already connected to the bank, how can I solve the problem?

ReyJohn_D
Moderator

Reconciling 2 credit cards on combined statement

Thanks for joining the thread, @Jaquline.

 

For us to set up the subaccounts, we'll have first to disconnect your current bank connection. Before doing it, ensure to add and match all the pending transactions in the Banking page. This is to prevent deleting any transactions in the For Review tab. Once done, follow the steps below:

 

  1. Go to Banking on the left pane then choose Banking at the top.
  2.  Select the account you want to change then click Edit (pencil icon).
  3.  Click Edit account info.
  4. In the Account window, check the box next to Disconnect this account on save
  5. Hit Save and Close.

 

Then, you can now follow the steps given by my peer Kristine Mae on how to set up the sub accounts. After, let's reconnect your bank account

 

I also want to make sure you can get back to working order always, so I'll be adding this article about the fixes if in case you encounter any bank errors: What to do if I encounter a bank error in QBO?.

 

Fill me in if you have more questions about managing your banking in QBO. I'll be here in the Community to lend you a hand. Take care always.

bettyjo2
Level 1

Reconciling 2 credit cards on combined statement

This is not working all it does is create another account.

I have a credit card that has multiple credit cards. When I go to reconcile all the transactions are included in the statement. they maybe separated but still included in the beginning and ending balance. I am pretty sure that Quickbooks has come across this problem so why can I not find good directions on how to make it work, without batch entering all the other transactions from the other credit cards.

DebSheenD
QuickBooks Team

Reconciling 2 credit cards on combined statement

Hi, bettyjo2.

Thank you for keeping us updated on your concern. I'll make sure that you can reconcile the two credit cards in one account.

In connecting 2 credit cards in one account you need to make one account a sub-account and connect it to other accounts which is called the parent account. This is because the bank provides the entire balance of the 2 accounts.
 

You can check this link on how to connect your bank to credit cards.

For future reference, read through this article to learn more about bank or credit card subaccount setup to only show what's relevant to you and your business.

Feel free to reply on this thread if you have additional questions or concerns about connecting bank accounts, We're always here to help.
 

janbrownbooks
Level 1

Reconciling 2 credit cards on combined statement

If it is done this way does the credit card show up as a parent and sub account on the balance sheet showing negative and positive amounts to equal the net of the total credit card?

RenjolynC
QuickBooks Team

Reconciling 2 credit cards on combined statement

Thanks for joining in on this thread, janbrownbooks.

 

Let me share some insights.

 

In the Balance Sheet report, both accounts will show up if there are transactions entered on them. With this sample screenshot, I've connected the parent account to online banking. Then, categorized the transactions from the For review page. On the other hand, I manually created some transactions in QuickBooks for the sub-account, and it shows under the parent.

 

 

To learn more about the Balance Sheet and other reports in QuickBooks Online, feel free to read these articles:

 

You can always reach out to me if you have any follow-up questions or other concerns. Take care and stay safe!

davidinmoscow
Level 1

Reconciling 2 credit cards on combined statement

This method does not work if the credit cards are connected to online banking.  

 

QB Support told me the workaround is to disconnect from online banking, then make them subaccounts, then reconnect.  

 

relaxok
Level 1

Reconciling 2 credit cards on combined statement

This does not work for me - even though one CC is the master/parent of the other one in the bank, Quickbooks says I can't set the master as the parent - the error is 'Something is not quite right. You can't change the parent of this account to Credit Card (CORP MASTER) because it or its parent is already set up for Online Banking or Web Connect.'

 
One has payments and the other has the expenses, so I need both of them connected, plus I dont see how you could have one set as the parent if it's NOT connected'.. it seems like this is the perfect and primary case for sub accounts yet it doesn't work. 
JonpriL
Moderator

Reconciling 2 credit cards on combined statement

Let's work together and solve this, @relaxok. How did you connect these accounts to online banking?

 

Ideally, each credit card subaccounts balance will result in the total balance of the parent account. Learn more about credit card account connected to online banking using this article:  The Bank and Credit Card Subaccount Setup.

 

Since you need both of these accounts' transactions connected to online banking, you'll have to separately add them on your chart of accounts but not as the parent or subaccount setup.

 

I also suggest contacting your accountant for guidance in understanding each account balance along with working on your reports. Use the link to find someone you want to work with: The QuickBooks Certified ProAdvisor.

 

You may also read all related references in this article to make sure your account register matches your bank and credit card statements: Use this Guide Anytime you need Help Doing or Fixing a Reconciliation.

 

If you have any other clarifications or follow-up questions about bank and credit card accounts and transactions, please let me know by adding a comment below. I'll be here to lend a hand. Stay safe!

bambete
Level 1

Reconciling 2 credit cards on combined statement

This was set up correctly by the owner years ago (Parent Co 1st, then each cc acct under as subs) and are feeding correctly.  They have never reconciled these accounts and I started by doing a forced reconciliation last year end and reconconciling the year month by month.  I match the monthly ending balances on the statement by reconciling, but the balance sheet is still taking the J/E's from the past and so the balances are way off.  The accountant keeps making journal entries against the individual accounts AND the parent account which has set all of the balances off from the beginning.  He has made several to bring the balances to true at month end which I believe is duplicating transactions that came through the feed.

 

He closed 2021, so I cannot go back and try to sort it out.

Candice C
QuickBooks Team

Reconciling 2 credit cards on combined statement

Good afternoon, @bambete

 

Congrats on making your first post here in the Community. Allow me to point you in the right direction to get this handled once and for all. 

 

Based on the details you gave, I recommend contacting our Customer Support Team for further assistance. They'll be able to use a screen share tool to review your account. Here's how: 

 

  1. Go to the Help icon in the top right-hand corner. 
  2. Press the Contact Us button/hyperlink. 
  3. Enter the question and hit Let's talk
  4. Scroll down and pick to Get a callback

 

It's that easy! 

 

Keep us updated on how the call goes. We're always here to have your back. Best wishes!  

muny
Level 1

Reconciling 2 credit cards on combined statement

Hello, 

My screen looks nothing like what your instructions say. I have tried 3 times and am frustrated. I must be doing something wrong

 

Rasa-LilaM
QuickBooks Team

Reconciling 2 credit cards on combined statement

Thank you for joining this thread, muny.

 

I can assist you and provide answers to QuickBooks-related questions. I need more information on what you're going through to make sure we're on the same page. This is also to check if there's any open investigation similar to your concern.

 

Can you tell us which screen you're looking at? Are you going to reconcile the account or run the Balance Sheet report?

 

I appreciate any information you can share. Thank you, and have a good one. 

gchouinard
New Member

Reconciling 2 credit cards on combined statement

We have 3 credit cards linking to the master CC account.

In our case it seems that the payments are not allocated to the individual accounts, thus the QB balances are incorrect.  Should we unlink the individual cards to avoid this, or is there another way to "pay off" the individual cards?

DivinaMercy_N
Moderator

Reconciling 2 credit cards on combined statement

I'll make sure you set up your accounts in the correct way, @gchouinard.

 

In QuickBooks Online (QBO), connecting the parent (master CC account) and sub-accounts (three CC accounts) should be based on how the transactions are downloaded. 

 

If the entries download to one account, connect only the parent. If it is downloaded to individual accounts, connect the sub-accounts. This ensures that the balance is correct. 

 

Moreover, I recommend checking your bank statement to check to see if you input and download transactions that are processed in real life. This will also guarantee the balance of your QuickBooks Online (QBO) account is accurate.
 

Read this reference for more information: About bank or credit card subaccount setup.

 

Additionally, ensuring you perform the reconciliation process regularly is essential in maintaining the balance of your QBO and actual bank. Just keep in mind to reconcile only the parent account since all transactions roll up into it. 

 

Should you need additional assistance in managing your credit card accounts, please keep me posted below. I'm just a post away to help. Have a good one. 

Need to get in touch?

Contact us