We have recently set up a new credit card account with Bank of America. We have 3 credit cards and 1 main account. The 3 credit card balances are then consolidated to the 1 main account so that we only have to pay 1 bill. When I import these transactions from our bank to Quickbooks it connects all 4 accounts. The main account has no transactions but recognizes the balance and the 3 individual credit cards have transactions and a balance. I want to link these transactions to the main account as that is the only one I will be reconciling. I'm not sure if this is something that I have to do when importing, chart of accounts or when I action the account?
Thanks for giving me the opportunity to help you. Let's work together to resolve your importing Credit Card transactions concern.
The first thing to consider when connecting to online banking is how your bank sends the downloaded transactions. If the transactions download to one account, connect only the main account. On the other hand, if the transactions download to the individual accounts, then that's the time you'll have to connect the sub-accounts and not the main.
I am having this same exact issue. I have the main BofA CORP credit card account with 3 active credit cards for 3 employees. Everything was set up correctly until I had to add the new 3rd credit card account. I modeled the sub-accounts after the first two credit cards that import transactions correctly. This 3rd credit card and sub-account is not importing the transactions. I've tried connecting it any way I can find and it's only reporting on the balance, not transactions. Help!
Otherwise, you'll want to make sure you correctly map the transactions. Let me walk you through how:
From the left menu Banking, choose Banking.
Select Browse and choose the file you downloaded from your bank.
If you haven't downloaded your CSV file yet, follow the on-screen instructions in the Upload file window to download your transactions and then select the file you downloaded.
From the QuickBooks Account drop-down list, select the appropriate bank or credit card account and select Next.
Map the statement fields according to your CSV file format and select Next.
Select the checkboxes of the transactions to import and select Next.
Select Let’s go when the Import Completed notification appears.
If you’ve never connected an account, you can select Upload transactions manually. You can also begin your upload from the Import Data page (select the Gear icon, under Tools, select Import Data, and select Bank Data).