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

Credit Cards with Parent Account Balancing

Hello Awesome People,

 

I could use come expert advice and insight.  My credit cards are reconconciled and the total matches what we actually owe, but there are crazy numbers out there that I don't like to see.  (Gulp.)  Help.

 

Background

With QBs online I have a parent account and two sub accounts:

Credit Card (Parent Account)

     Employee #1 Credit Card - (transaction feed for this user)

     Employee #2 Credit Card - (transaction feed for this user)

 

On the balance sheet, I have some crazy numbers, but the total balance owed is correct.  

Credit Card (Parent Account)           $6.042.72

     Employee #1 Credit Card           -$142,603.82

     Employee #2 Credit Card             $148,016.61

Total Credit Cards Combined           $11,455.51

 

$11,455.51 is correct and matches to my credit card statement and to my reconciled balance. Yay!

 

The other numbers are scary, and looks like these are running totals perhaps?  Did I miss a journal entry or adjustment I should have been doing somewhere?  If so, how to fix now?

 

On my Dashboard, the bank balance matches what is owed $11,455.51.

Employee #1:  Bank Balance          $11,455.51

                        In Quickbooks        -$142,603.82

 

Employee #2:  Bank Balance         $0               

                         In Quickbooks       $148,016.61

 

Transactions are coming in separately for transactions in each account.  (These are Chase Credit Cards.)

I realize the bank feeds will show different balances, but shouldn't they add up to $11,455.51 (plus or minus a few outstanding transactions?)

 

Am I doing something wrong, or missing a step?  If so, how to fix?

 

Thank you, thank you for taking the time to help me. 

 

Poobah

 

 

 

           

 

 

 


 

 

 

 
 
 

 

 

6 Comments 6
RCV
QuickBooks Team
QuickBooks Team

Credit Cards with Parent Account Balancing

Thank you for sharing the breakdown of the amounts and in-depth details of your concern to discuss what help you need based on your initial post, Poobah.

 

Based on your scenario, you connected both the parent and sub-account of your credit card. When connecting the account, we must determine how your bank sends the downloaded transaction. If the bank entries download to one account, connect only the parent account. However, we need to connect the subaccounts and not the parent account if the transactions download to the individual accounts. We can’t connect both a parent account and its subaccounts since you’ll get a message that the account is already connected.

 

In your case, we'll have to disconnect all the parent accounts and then connect only the sub-account. This way, you'll only have to reconcile the  parent account (which you have already done) since all the transactions are rolled up into it. Here’s how to disconnect the parent account from online banking:

 

  1. Go to Transactions, then Bank transactions (Take me there).
  2. Select the tile for the bank account.
  3. Tap the pencil icon, then select Edit account info.
  4. Select the Disconnect this account on save checkbox. If QuickBooks is downloading new transactions, you won't see this option. Wait a few minutes for the update to finish and try again.
  5. Press Save and Close.

 

You can refer to this link in disconnecting the subaccounts: Disconnect or delete an account from the Downloaded Transactions page. To set up a bank or credit card account with multiple subaccounts to easily connect it to your bank and reconcile downloaded transactions in QuickBooks Online (QBO), check out this article: About bank or credit card subaccount setup.

 

Then, we can run the Transaction Detail by Account so that you can see the debits and credits for your credit card transactions. Here's how: 

 

  1. Go to Reports on the left side menu. 
  2. Type in Transaction Detail by Account in the search bar.
  3. Hit Switch to classic view, then click Customize
  4. Tap Change columns, scroll down, and tick Debit and Credit.
  5. Now click Filter, then choose the Transaction Type dropdown.
  6. Tick Check and Expense
  7. Click the Distribution Account and Account dropdown to specify the account you want to show in the report.
  8. Once done, press Run report

 

Moreover, you can memorize this report. This feature simplifies the customization process, allowing you to concentrate on other essential tasks. Let me add this article on how to compare your bank statement and QuickBooks and review or change reconciliations: Reconcile an account in QuickBooks Online.

 

If you have further questions or need a helping hand in managing your credit card accounts and transactions, just let me know and I'll get back to you as quickly as I can. You have a good one. 

Poobah
Level 2

Credit Cards with Parent Account Balancing

Thank you so much for your prompt and detailed reply! I appreciate you!

 

However, this does not appear to be my issue. (?)

 

Even though my credit card statement shows charges for both cards on one statement, the transactions are downloaded seperately for each card.  (Thank you Chase.)  I double checked, and I am downloading each card into each subaccount appropriately.  The transactions for each card are rolling up correctly to the parent account.  I have reconciled the parent account, and it balance is correct.  (This may not have been the case for all history however, because Chase changed their download process. (I followed your step 1.)

 

FYI- the steps for running the Transactional Detail by Account did not work for me.  My selection choices are different.  I do not have a classic view, there is not a Debit and Credit option to select....  so, I was not able to do this suggestion.

 

I read somewhere there might be a journal entry I need to make to record the payment to each card in the sub accounts? 

 

Still not fixed, and kind of lost at this point....   

Help?

 

 

RCV
QuickBooks Team
QuickBooks Team

Credit Cards with Parent Account Balancing

We appreciate you for coming back, Poobah.

 

Yes, you are right, when it’s time to reconcile, we only need to reconcile the parent account since all transactions in the subaccounts roll up into it. Also, we only connect the parent account if the transactions download to one account. 

 

Since you don't have the Switch to classic view option, we can click the Gear icon on the report. Then, choose the Debit and Credit columns to be added to the report. See the screenshot for your reference:

 

debit1.PNG

 

 

On the other hand, QuickBooks Online (QBO) allows you to record credit card payments in multiple ways to keep track of your expenses. Here's how to record your credit card payments on each credit card account:

 

  1. Click the + New Plus icon. 
  2. Under Money Out (if you’re in Business view), or Other (if you’re in Accountant view), choose Pay down credit card.
  3. Select the credit card you made the payment.
  4. Enter the payment amount and the date of the payment.
  5. Select the bank account you paid the credit card with.
  6. If you made a payment with a check, click I made a payment with a check. In the Check no. field, enter the check number, or if you paid electronically, enter the EFT number.
  7. If you want to add notes or file attachments, select Memo and Attachments and follow the instructions on the screen.
  8. Press Save and Close.

 

For other options to record payments you make to your credit cards, check out this article: Record your payments to credit cards in QuickBooks Online. You can also create a journal entry to record the payment to each card in the sub-accounts. Since all businesses are unique, please reach out to your accountant for additional guidance to ensure the on what account you need to apply when recording the transaction.

 

Once done, we can now reconcile your credit card transactions. Here's how:

 

  1. Go to the Gear icon, then select Reconcile. You can also select Reconcile from the Transactions tab in the MENU ▼.
  2. If it's your first time, select Get started and Let's do it.
  3. Choose the credit card account. Then, enter any missing transactions (if there are any) from the statement and adjust any incorrect transactions.
  4. Once the difference is zero, click Start reconciling.
  5. In the Reconcile screen, select the checkbox next to the transactions that match the transactions on your statement to mark it as cleared.
  6. Press Finish now, then select Done.

 

Feel free to visit our Banking page for more insights about bank feeds and reconciling accounts.

 

If you require additional assistance with your credit card accounts or other QuickBooks-related, please do not hesitate to leave a comment. I am always available to lend a helping hand. 

Chaoscoordinator
Level 1

Credit Cards with Parent Account Balancing

Poobah, did you ever figure this out? I’m in the exact same situation and those wonky extra numbers for the subaccounts are driving me mad.

mwbeke
Level 2

Credit Cards with Parent Account Balancing

Chaoscoordinator, I'm having this issue too. I don't think the QB's employee understood Poobah's question. I thought I read somewhere that you have to do a journal entry on the sub accounts to zero them out, but I'm not 100% sure. I'm still searching. 

gharveysr
Level 1

Credit Cards with Parent Account Balancing

Yes, you have to a journal entry each month: debit the sub account(s) for the monthly charges per bank statement and credit the parent account for the same amount.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us