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
QuickBooks Team

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

10 Comments
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

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
QuickBooks Team

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

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!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up