Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm here to help, @MDBR.
In your case, you'll have to reconcile first before creating a journal entry. If you do it the other way around, this will confuse the reconciliation process and will show duplicates.
When posting moving forward, you'll need to ensure these are allocated to the correct accounts so you can reconcile all the transactions easily.
Should you need other references for banking transactions, feel free to visit our site: Banking and Bank Feeds for QuickBooks Online.
Please let me know if you have further questions about your sub-accounts. I'll be more than happy to help out.
I appreciate you getting back to us, @MDBR.
Since QuickBooks record all payments to the parent account, you'll need to check your bank statement. This way, you'll be able to know the amount of each child account that you're going to enter in the journal entry.
You can also check the balance amount of your child accounts in the Chart of Accounts and Balance Sheet report for your reference.
You can check out this article for the detailed steps and information in creating journal entry: Create a Journal Entry.
Also, setting up a percentage based on the credit limit for each card isn't available in QuickBooks. But I want to let you know that we're taking note of your feedback and suggestions to improve the experience we're providing.
In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBO Self-help.
Please feel free to post any questions you have below. The Community is always here to help out.
Thanks so much! Works perfect!
Hey @ClayJ ...maybe you can help me as well. When I first set up QB, we did so as you described above - my account is the parent/main Chase account + the other employees are sub-accounts. All were showing up w/ their individual purchases/balances. However, we recently added more cards/employees to the account + when I try to link those (the same way as before - as a sub-account of my main card), I get an error message saying that the account is already connected. I don't want to delete the cards + start over, as there are hundreds (if not thousands) of transactions w/ receipts uploaded/associated w/ the various purchases + I don't want to lose that info. Any insight?
Hi there, lingvall.
Before connecting to Online Banking, you need to know how your bank sends the downloaded transactions for multiple accounts.
If the transactions download to one account, connect only the parent account. There's no need to connect the sub-accounts.
If the transactions download to the individual accounts, connect the sub-accounts and not the parent account. Disconnect the parent account then connect the sub-accounts. Here are the steps:
You can’t connect both a parent account and its sub-accounts. If you do, that's the reason why you're getting an error saying the account is already connected.
Some banks may show the overall bank balance at each sub-account level. It is because the bank provides us with a static balance of the entire account, not the balance of each sub-account.
You have come to the right place to get help with banking questions, or if you need anything else. Have a great day!
@MDBR - I am experiencing the same thing that you dealt with. I have a main American Express card w/ 2 additional employee cards under it. So, that's a total of 3 card numbers for one American Express account (including the main card). I have set up a parent account with 3 sub-accounts. Each sub-account is connected online to the respective card account. The transactions are coming in fine to all 3 sub-accounts, but now they each have a balance but the bank balance says $0.00 for the two employee cards but the main card has the full balance attached to it. What am I supposed to do? I don't think this is the way it's supposed to work. What did you do?
I'd like to help you figure this out, DMP2.
As I've learned from your situation, it looks like some transactions are downloaded to the other sub-account. You'll want to transfer the transactions manually to each respective accounts.
Here's how:
I also suggest reaching out to your bank and verify if they have some updates or changes that may have caused the transactions to download to one account only.
Let us know if you need more clarification. We're just here to clear things for you.
Hi @Kristine Mae - thanks for your reply. I'm not sure if it directly applies to my situation, though. Transactions are coming in correctly to all 3 sub accounts (1 main AMEX holder + 2 employee cards) but the balance of the overall AMEX account is attached to the main AMEX holder and the 2 employee cards have a 0.00 bank balance but they are showing a quickbooks balance that never gets paid off since the payments go towards the main AMEX holder's sub-account. Are you saying that when a payment comes in on the main card holder, I'm supposed to split it and transfer some of that payment to "pay off" the 2 other employee cards, which would then bring them to a 0.00 balance?
Thank you for joining in on the thread, @DMP2.
You’re on the right track. To zero out the sub-account balance’s you’d just need to make a Journal Entry. The Credit Card account needs to be debited to reduce the balance.
Let me guide you on how to do that:
Note: If you’re using Sublevels and you use the Primary account to reconcile, don’t make entries. If you reconcile the Parent level and Split the payment to the Sub-categories so that each sub-balance gets its payment amount applied there. I strongly encourage you to consult with an accounting professional on which account should be used as the offset.
Here’s a link that will help you about credit card subaccount setup:
If there is anything else I can help with, feel free to drop a line.
I can see this thread has been going on for awhile, the same answer is given over and over also. I have a chase CC thats my main/primary card/parent card-account. I also have 3 sub account employee cards. I have chart of accounts set up correctly with the main card as the parent and the 3 employee cards added as sub accounts of that and show as such. That part is done. Next step, connect your bank accounts and know how they download, either as sub accounts individually or all as one and then you connect the parent account if so. My cc info downloads as one account which comes from my main/primary/parent card account, so i am supposed to connect that account only and not my sub accounts. However, when I do this, none of the transactions from my sub accounts download into qb. So, I try it the other way. I disable the parent account and connect the sub accounts. When I do that, all of the sub account info posts into qb to process like I want but then I lose my parent account info. What am I missing?
Hello netopscom01,
Connecting both parent and sub-accounts isn't possible.
Since your credit card account download transactions to your parent or main account, connect only to the parent account. Then, manually add the transactions of your sub-accounts in QuickBooks.
I'm attaching an article in case you want to read the details. Here's the link: About bank or credit card subaccount setup.
When you're ready to reconcile, you can check this article for the step-by-step guide: Reconcile an account in QuickBooks Online.
I'll be around if you have questions. Have a wonderful week ahead.
So that’s my issue. As much as we pay for QB, there is no way to not have to manually add transactions? Why can we not get the sub account transactions to download Into Qbo? All of your documentation says if the sub accounts download into one account from your main card then connect that card and the sub accounts will transfer info with the main account but that’s not happening. So either something is broke or all your documentation is false.
Hello @netopscom01,
Since your transactions from the sub-accounts aren't posting into the parent account of your credit cards, I'd recommend contacting our Customer Care Support.
They can pull up you're account, securely, and explain the components of connecting the parent and sub-account of your credit cards. With their tools, he/she can further investigate the set up of your credit card accounts to identify why your transaction is not posting into the parent account.
That being said, here's how you can contact our dedicated support:
In case you need some easy steps in categorizing your downloaded transactions, I've included a couple of article below for the detailed guidance:
If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.
I know I'm a little late to the party here but trying to connect my boss & his wife's AMEX accounts. I've created parent accounts and attempted to connect that way but no luck. Half of the time QBO usually tells me AMEX is experiencing technical difficulties.... To make sure I'm understanding this correctly, are you saying if they share a log in (same card number) then I cannot connect both?
Hi,
Is there a way we can import transactions in the sub-accounts if the bank won't allow us to connect Qb to the cards?
I was actually trying to import the statement lines in the sub-accounts and it never been successful. So I end up manually coding them one by one which is a lot of hassle and very time consuming.
Is there a way we can import statement lines from the bank in the sub-accounts credit cards? if the banking doesn't support QB integration?
Was trying to do this multiple time but it never been successful. I'm sure I have the correct formatting of my file before importing it since I've been doing this in most of our accounts.
I hope someone can give me quick feedback.
Thanks
Hi amobgirl29,
I'm happy to shed light on connecting AMEX accounts to QuickBooks.
For the AMEX Open/Business account type, you can only connect one account under the same login. For Personal or Corporate account types, you can connect multiple parent accounts using the same credentials. However, for the parent-subaccount setup of Personal and Corporate accounts, you can only connect the parent or the sub-accounts (not both types).
Which type do your boss and his wife have? Are you getting error codes?
Alternatively, you can manually upload your bank transactions.
Feel free to send an update about your attempt to connect your boss's and his wife's AMEX accounts.
Hello DRCris,
Yes, there's a way to manually import bank transactions to the sub-accounts. I can help you get this done.
A wrong file format is one cause of an unsuccessful import. Please be sure to only use the supported file formats for QBO:
Most banks only offer CSV or XLSX. I usually download mine in XLSX format and save it as CSV (Comma delimited). Then, I follow the steps to upload transactions using Excel CSV files. Give this a try, and let me know how it goes.
Hey Clay,
Hoping you can shed some light on my troubles, have tried calling QuickBooks for help with little success. We have a business AmEx account with multiple cards as well. I was given access to the books several years ago, at that time only the parent AmEx was connected. Transactions on all cards would still sync in QuickBooks. Several months ago transactions from the other cards quit syncing and only ones made on the 'parent' card would show up. Took us a while to catch and now our books are off for our AmEx. Curious if there's a way to fix this?
Let me give you some additional information about parent and sub-account credit card connections, @ClimbWorks.
Before connecting to Online Banking, you need to know 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 sub-accounts and not the parent account. You can't attach a parent account to its sub-accounts, either. If you try to connect both, you will receive a message that the account has already been connected to QuickBooks Online. Many banks can display the total bank balance at each level of the sub-account. This is because the bank gives us static stability of the account as a whole, not the balance of each sub-account.
For more information about account connection check out: bank or credit card sub-account setup.
I hope this helps. I you have any other questions, I'm only a reply away. Have a great week.
I'm experiencing this issue too. Phone support told it may be a "firewall" issue that would be fixed in 1-2 days... This pretty clearly seems not to be the case, but after an hour trying to troubleshoot I'm giving up.
I have attempted all these steps with the Chase Accounts trying to build the sub accounts. Yet nothing works. Chase will not connect to the employees sub-accounts. My books are completely out of whack for this fiscal year. In the past it was never a problem. Yet when the credit card numbers changed mid-year there was no way of tracking the sub accounts.
Hello, @muenstermann.
Currently, setting up your employees' Chase credit card account and connecting it as a sub-account in QuickBooks is not available. You can download a valid WebConnect (CSV) file through your bank's website or directly from your bank. Once you have this file, you can upload it to QuickBooks Online. You can read through these articles for more detailed instructions:
On the other hand, you can create a journal entry to normalize your account balances and help fix the issue. I'd recommend consulting with your accountant so you'd be guided properly in choosing the right account when creating a journal entry.
Don't hesitate to leave a comment below if you have other questions about managing your bank transactions in QuickBooks. I'm always here to help.
How in this day and age could QB and Amex not understand the importance of allowing multiple cards under one Corporate account to be allowed into a field. It's extremely frustrating when the only answer I get is to either create multiple sub accounts for my parent AMEX account or to manually import the fields. I run a small business and just manually enter the charges from 4 separate AMEX cards in our bank feed before reconciling. I used to be able to get my bank feed to download all of our companies charges, now for some god d***** reason, I can only download one of the cards into my feed. So extremely frustrating.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here