Accountant Squad
  • Home
  • About Us
  • Services
    • QuickBooks 24/7 Support
    • QuickBooks Error Tech Support
    • QuickBooks Desktop Support
    • QuickBooks Online Support
    • QuickBooks Point of Sale Support
    • QuickBooks Payroll Support
    • QuickBooks MAC Support
    • Quickbooks Enterprise Support
  • Blogs
  • Faqs
  • Contact
1-855-365-6012
  • Home
  • Blogs
  • QuickBooks Support
  • How to update Credit Card and Import Credit Card Transactions in QuickBooks?

How to update Credit Card and Import Credit Card Transactions in QuickBooks?

Update Credit Card
Published by John Smith at January 3, 2019
Categories
  • QuickBooks Support
Tags
  • Credit Card Transactions

QuickBooks Online is a cloud-based platform that ensures work is completed as per the business requirements. The article will focus on how to update credit card and then import Credit- card transactions in QuickBooks Online.

Update Credit Card in QuickBooks

Let’s start with understanding how to Update the Credit Card in QuickBooks. Before we go to the steps, it is essential to know some points beforehand.

  • The Payment info for your account can only be updated by ‘Master Administrator or the Company Administrator.’
  • Perform ‘Payment Info updates’ via QuickBooks Online in the web-browser. The update cannot be done from the mobile app.
  • In case you bought your QB Online subscription through an ‘App store’(iOS or Android) you have to update the payment info through this app store directly.
  • To change the ‘payment method,’ Log onto QuickBooks Online. You cannot change the ‘Payment method’ via a mobile app.

Steps to change/update Credit card Information

  • Click the ‘Gear Icon’
  • Go to ‘Your Company’ and select ‘Account & Settings.’
  • Choose the ‘Billing and subscription’ tab
  • In the payment method option, choose ‘’
  • Fill in the ‘full credit-card info’ by filling in the – card number, name on the card, expiry date, & the security code. Check and verify the billing address and ensure that the address in QB Online is the same as given in the credit card statement.
  • Save the ‘Changes’

Steps to Import the Credit Card Transactions in QuickBooks Online

If you are unable to locate you Bank in QuickBooks Online or you require to download credit card transactions for more than 90 days, then you have to import your credit card transactions in an Excel Format. The Excel format here is called as the ‘.CSV or the. QBO file’.

To initiate automatic Import of your Credit Card Transactions to QB Online, you require your Banking user ID & the password to Login.

Step 1: Go to Banking Centre

  • Go to Home Page and choose Transactions>> Banking
  • Fill in your Bank/credit card name in the search box
  • Now select from the list of the Banks/credit card companies
  • Choose your ‘Credit Card ’

Note: If unable to see your CC Company or you require to download more than 90 days of credit card transactions, then you need to ‘Upload Credit card transactions in a.CSV format.

Step 2: Log-in to the Business Credit Card Account.

  • Fill in your User ID & Password
  • In a few minutes, QuickBooks will be connected to your bank.

Step 3: Choose the Business Credit Card Account

  • Checkmark the accounts here that you want to connect to the QuickBooks.
  • You will see an Account name which is your bank’s name for this account.
  • Choose the QuickBooks Account you want to link the bank account selected. In case you haven’t set the account you can select ‘Add Account.’
  • The screen will have an account set-up window, complete the details here. You need to finish:
    1. Category type
    2. Detail type
    3. Name
    4. Description
  • Ensure that all the sections in the fields are filled in
  • Save the changes.

Step 4: Choose the ‘Date Range’

You can download transactions for a maximum of 90 days. If you require transactions more than this time frame, then upload the transactions via CSV format.

However, if a shorter time range data is needed, then click the link that tells ‘require a shorter date range.’

Step 5: Press ‘Connect’

Ensure to double-check the accounts that you require ‘to keep a track off.’ Do not check any undesired accounts.

Important: When you press ‘Connect,’ all the transactions will get downloaded to QuickBooks. However, there is an automatic undo feature here. If there was an error done here, you need to manually delete the unwanted transactions before deleting the credit card from QuickBooks.

Once done- click the blue ‘Connect button’ and initiate the download of your credit card transactions.

Step 6: You have the downloaded transactions.

Once the download is through, you will view a display message. The next step is to download the transactions.

Step 7: Review the ‘Downloaded Transactions’

  • In the Banking Centre- you will see the ‘credit card account’ & balance
  • In case you want to track ‘Other Credit Card Accounts’ in QuickBooks, -click the ‘Add account’ button

When do you require to import ‘Credit Card Transactions’ in a CSV File format?

If you haven’t bee unsuccessful in connecting your credit card to QuickBooks, or you need credit card transactions for more than 90 days, you have to upload the ‘Credit Card transactions via an Excel (.CSV file) or. QBO file.

  • Go to Credit Card Account
  • Navigate to ‘download transactions & credit card statements’ section (you have the option to download the transactions in various formats)
  • CSV /. QBO file option. (If you cannot see either of these options then contact your credit card company).

Steps to Import the ‘Credit Card Transactions in QuickBooks Online’ through a CSV file

  • Go to the ‘Banking Centre’
  • Choose Transactions & Banking
  • Choose the ‘Upload file ’
  • Select ‘Browse’ to find the file that you require to upload.
  • Now choose the QuickBooks Account that has to be linked to the Credit Card Account. (If there is no account in QuickBooks till now, you can click the drop-down & choose ‘Add ’
  • Now you have to set-up the QuickBooks Account and complete the details of the sections- Account Type, Detail Type, Name, and Save and move to the next screen.
  • Now map the QuickBooks Online Fields to the ‘bank account fields’
  • Map the QuickBooks Online Fields to Your Bank Account Fields
  • Now checkmark the transactions that have to be imported
  • Select Credit Card Transactions to Import
  • Confirm the ‘transactions’ to import by clicking Next.
  • Select ‘YES’ (select ‘NO’ if you want to make any changes)
  • You have the imported transactions
  • Finally, review the ‘Imported Transactions’

Hopefully, you are well aware now and can follow the procedure with the above-given steps. In case there is any issue faced, as this is a lengthy process, you should seek technical help to avoid any further issues. Speak to an expert at QuickBooks Tech Support phone number 1.877.221.952O to sort out all queries and issues related to this.

99 votes, average: 4.50 out of 599 votes, average: 4.50 out of 599 votes, average: 4.50 out of 599 votes, average: 4.50 out of 599 votes, average: 4.50 out of 5 (99 votes, average: 4.50 out of 5)
You need to be a registered member to rate this.
Loading...

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Related posts

QuickBooks error 9584
February 18, 2021

How to fix QuickBooks Error 9584?


Read more
how to track mileage in QuickBooks Online
February 1, 2021

How To Track Mileage in QuickBooks Online?


Read more
Quicken Vs QuickBooks
July 29, 2020

Quicken Vs QuickBooks: Which one will be better for your business?


Read more

Search Here

How can we help you?

Accountant Squad aims to provide global support, as well as technical assistance for the QuickBooks software. We care for you. Dial our Support Helpline and get connected to the best advisors.

Recent Posts

  • How to fix QuickBooks Error 9584?

    February 18, 2021
  • How To Track Mileage in QuickBooks Online?

    February 1, 2021
  • How to Process Credit Card Payments in QuickBooks Online?

    January 16, 2021

Categories

  • How to (120)
  • QuickBooks 2020 (12)
  • QuickBooks Desktop Support (55)
  • QuickBooks Enterprise Support (7)
  • QuickBooks Error Support (157)
  • QuickBooks MAC Support (3)
  • QuickBooks online support (22)
  • QuickBooks Payroll Support (8)
  • QuickBooks Point Of Sale Support (8)
  • QuickBooks Support (90)
  • QuickBooks Tools (9)

Quick Links

  • About
  • Service Offerings
  • Testimonials
  • Blogs
  • Frequently Asked Questions
  • Contact
  • Disclaimer

Services

  • QuickBooks Desktop Support
  • QuickBooks Online Support
  • QuickBooks POS Support
  • QuickBooks Payroll Support
  • QuickBooks MAC Support
  • Quickbooks Enterprise Support
  • QuickBooks Error Tech Support

Contact Information

Address: 649 Blythe CT APT 7A, SUNNYVALE, CA 94085
Toll Free: 1-855-365-6012

support@accountantsquad.com

Disclaimer

We are a technical support provider that works independently of Intuit Inc. The logos of Intuit, QuickBooks, Quicken, TurboTax, etc. that have been used in our site are registered trademarks of the respective organizations, and are used in our site for reference purposes only. One can subscribe to the same services by hitting the respective OEM’s site, i.e. Intuit QuickBooks. The subject matter on the website is for reference purposes only and does not substitute the advice of a professional accountant or a certified CPA. Read More...

© 2018 Accountant Squad. All Rights Reserved.
  • Terms And Conditions
  • Refund Policy
  • Privacy Policy