cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Importing Credit Card Transactions

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?

 

Hope this makes sense!

3 Comments
Highlighted
QuickBooks Team

Importing Credit Card Transactions

Hi there, @239.

 

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.

 

For more details, you can check this article: About bank or credit card sub-account setup

 

Once you’re done setting it up, you will only need to reconcile the parent account since all transactions in the sub-accounts roll up into it.

 

That information should get you on the right path. Keep me posted if you have other questions about banking. Have a good one!

Highlighted
Level 1

Importing Credit Card Transactions

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!

Highlighted
Moderator

Importing Credit Card Transactions

Hello there, ashley10.

 

I want to make sure you're able to import credit card transactions in QuickBooks Online (QBO).

 

Let's try manually updating your bank account in QuickBooks to refresh the connection between your bank site and QBO.

Here's how:

  1. Go to Banking from the left menu.
  2. Select the Update button in the upper right.
  3. Click Update Now.

Otherwise, you'll want to make sure you correctly map the transactions.  Let me walk you through how:

 

  1. From the left menu Banking, choose Banking.
  2. Select Browse and choose the file you downloaded from your bank.
  3. Select Next.
  4. 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.
  5. From the QuickBooks Account drop-down list, select the appropriate bank or credit card account and select Next.
  6. Map the statement fields according to your CSV file format and select Next.
  7. Select the checkboxes of the transactions to import and select Next.
  8. Click Yes.
  9. 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).

 

For a detailed steps, you may refer to this article: How to import bank transactions using Excel CSV files.

 

Let me how it goes and if you have further questions while importing credit card transactions in QBO. I'm always glad to help.

Need to get in touch?

Contact us