How to Import Credit Card Transactions into QuickBooks Online

You all welcome to QuickBooks Online Tutorial present by the Tax King Inc. By this program, the viewers shall be able to learn about How to Import Credit Card Transactions into QuickBooks Online. It also helps you to know the preparation strategies and also notify about QuickBooks Online Credit Card Transactions. QuickBooks Online also offers several details that would help you to easy learn and access of the receivable account.

An instance clearly mentioned along with steps and you can easily get them at your QuickBooks online account. However, if you are absolutely new to this arena and do not possess an account. You can sign yourself for a trial span of 30 days. You can go through the step by step instructions or watch the video in order to learn more in this context. And increase knowledge about bills related facility.

Why is it Important to Connect your Credit Card Account to QuickBooks?

One of the many advantages of QuickBooks Online is you can spare a great deal of time by downloading your business Visa exchanges into QuickBooks rather than physically contributing every exchange. Most huge banks permit you to rapidly and effortlessly interface with QuickBooks, a portion of the littler banks and credit unions don’t have that capacity.

We consider Bank of America to be the best bank for private ventures, in light of their low rates.  If you don’t have a business financial balance and are utilizing an individual ledger, then I prescribe getting a different financial balance for your business at the earliest opportunity and after that interface it to QuickBooks. It is constantly best practice from a bookkeeping and assessment outlook to keep business exercises totally isolate from individual. Click here to set up a private company financial balance with Bank of America.

Step by step instructions to Automatically Import Your Credit Card Transactions to QuickBooks Online

Keeping in mind the end goal to associate your Visa record to QuickBooks, you will require your web based managing an account client ID and secret key to sign into your record.

Step 1: Navigate to the Banking Center

From the Home Page, select Transactions and after that Banking from the left menu bar:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

  • Sort your bank/MasterCard name in the hunt box as showed underneath or
  • Select from the rundown of banks/MasterCard organizations directly underneath the inquiry box.

In the event that you can’t find your charge card organization or you have to download over 90 days of MasterCard exchanges then you have to Upload Credit Card Transactions utilizing CSV Format which is shrouded later in this lesson.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 2: Log into your Business Credit Card account

You ought to see your bank login screen like the one underneath.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Enter the client ID and secret word that you ordinarily use to get to your business MasterCard account as we have accomplished for Paul, proprietor of invented organization Paul’s plumbing. Contingent upon your web association and the quantity of records that you have, it might take a couple of minutes for QuickBooks to interface with your bank.

Step 3: Select Business Credit Card Accounts

You ought to see a screen like the one beneath that will list the greater part of the records you have at this bank.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

  1. Put a checkmark in the main segment for every record you might want to interface with QuickBooks.
  1. Account Name: This is the bank’s name for the record. No alters can be made to this field.
  1. QuickBooks Account: From the drop down, select the QuickBooks account you need to connection to this ledger. On the off chance that you have not setup the record in QuickBooks yet, select Add Account starting from the drop.

Your screen ought to show the accompanying record setup window. Finish the fields beneath to setup Paul’s MasterCard in QuickBooks:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

  1. Classification Type: Select the kind of record you are downloading exchanges for. Regularly this would be either a Bank or Credit Card account.
  1. Detail Type: This field consequently populates with Credit Card in view of the determination made in the Account Type field.
  1. Name: This is the manner by which the record name will appear in QuickBooks.
  1. Portrayal: Put the bank/Visa name and the last 4 digits of the record number.

TIP: If you have more than one business charge card that you plan to associate with QuickBooks, including the name of the card and the last 4 digits of the card number permits you to effectively let one know Visa account from another when you accommodate these records.

  1. Twofold check to ensure that you have make choices in every one of the 5 fields. Tap the Save and Close catch
Step 4: Select the correct date extend

The most extreme # of exchanges that will download is 90 days. On the off chance that you have to download over 90 days of MasterCard exchanges then skip to the Uploading Transactions utilizing CSV arrange segment of this course.

On the off chance that you might want a shorter date extend, simply tap the connection that says require a shorter date run as showed underneath:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

In the event that the date you begin utilizing QuickBooks is under 90 days, then you would need to utilize a shorter date extend.

The following is a case of when you may need to utilize a shorter date run:

Case: Paul has concluded that he will begin utilizing one of his own charge card represents business as it were. He has had this Visa for various years now however simply quit utilizing it for individual costs about a month prior.

This circumstance, Paul just needs to download exchanges throughout the previous 30 days into his QuickBooks account. In this circumstance, he needs to alter the date run by tapping the Need a shorter date go interface and enter in the right date run. The event that he doesn’t do this, QuickBooks will consequently download the most recent 90 days of exchanges and that will incorporate individual costs which Paul does not have any desire to add to his QuickBooks record.

Step 5: Click Connect

Before you tap the blue interface catch, you should twofold check to ensure that you didn’t choose any records that you would prefer not to monitor in QuickBooks. (i.e. individual financial balances). Once you click Connect, all exchanges will be downloaded into QuickBooks. Sadly there is no programmed fix catch. Later on in the event that you discover that you inadvertently chose a record that you don’t need associated with QuickBooks then you should physically erase those exchanges before you can erase the charge card from QuickBooks.

When you are prepared, tap the blue Connect catch to begin the way toward downloading your charge card exchanges into your QuickBooks document.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Contingent upon the quantity of records you have chosen and the date run, this could take a while to finish.

Step 6 – Transactions have been downloaded

Once the exchanges have been effectively downloaded into QuickBooks, the accompanying message will show:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 7 – Review Downloaded Transactions

In the Banking Center, you ought to see the Visa record and adjust as showed underneath.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

In the event that you have other MasterCard accounts that you need to track in QuickBooks then you can simply tap the blue Add account catch as showed above and backtrack to step 1. To figure out how to oversee keeping money exchanges after they are downloaded, watch our well-ordered video instructional exercise on how would I oversee downloaded saving money exchanges?

At the point when to Import Credit Card Transactions Using a CSV File

On the off chance that you can’t specifically interface your Visa record to QuickBooks or you have to download over 90 days of Visa exchanges, it is critical that you know how to transfer your charge card exchanges utilizing an Excel .CSV document or .QBO record.

To get this kind of document, sign into your charge card account and go to the segment where you can download exchanges and financial records. Doubtlessly you will have the alternative to download your exchanges in numerous configurations.

On the off chance that you don’t see both of these alternatives (.CSV or .QBO) then contact your Visa organization. Tell them that you might want to download your Visa exchanges into QuickBooks and you might want to know how to do that from their site.

Step by step instructions to Import Credit Cards Transactions into QuickBooks Online with a CSV File

Step 1 – Navigate to the Banking Center

From the left symbol bar, select Transactions and Banking.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 2 – Select Upload a File

Tap the Upload a record alternative as showed beneath at the exceptionally base of the screen.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 3 – Select the File to Upload

Click Browse to find the document that you wish to transfer.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 4 – Select a QuickBooks Account

Starting from the drop, select the QuickBooks account you need to connection to this charge card account. In the event that you have not set up the record in QuickBooks yet, you can do that by tapping the drop down menu and selecting Add New.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 5 – Set Up the QuickBooks Account

Your screen ought to show the accompanying record setup window. Finish the fields underneath to setup Paul’s VISA MasterCard in QuickBooks:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

  1. Account Type: Select the kind of record you are downloading exchanges for. Ordinarily this would be either a Bank or Credit Card account.
  1. Detail Type: This field consequently populates with Credit Card in view of the choice made in the Account Type field.
  1. Name: This is the means by which the record name will appear in QuickBooks.

TIP: If you have more than one business Visa that you plan to interface with QuickBooks then make certain to incorporate the name of the card and the last 4 digits of the card number. This will permit you to effectively let one know MasterCard account from another when you accommodate every month.

  1. Depiction: Put the bank/charge card name and the last 4 digits of the record #.
  1. Twofold check to ensure that you have make determinations in every one of the 5 fields. Tap the Save and Close catch.

When you have both the Bank document and the QuickBooks Account chose as showed underneath, you can continue to the following screen.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 6 – Map the QuickBooks Online Fields to Your Bank Account Fields

Outline fields in your transfer record to the fields in QuickBooks Online.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

  1. On the off chance that your CSV record has a header push, make a point to check the crate at the upper left of the screen as showed previously.
  1. Select the segment that has the date in it
  1. Now select the configuration of the date section
  1. After that select the segment that has the portrayal of the exchange (i.e. Staples)
  1. Select whether your record has both positive and negative numbers in one section or in the event that it isolates the positive and negative numbers into two segments.
  1. It’s easy now select the segment that has the positive numbers (Debit)
  1. Select the segment that has the negative numbers (Credit)
Step 7 – Select Credit Card Transactions to Import

Select the exchanges to import into QuickBooks by putting a checkmark in the main segment and select Next.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

TIP #1: If you get to this screen and there are no exchanges recorded, ensure that you have done the accompanying:

  • Expel any organizing like $ from the dollar sum segment
  • Erase any clear lines in your spreadsheet. Make sure that everything starts at line 1, section 1 of the spreadsheet.

TIP #2: If you roll out any improvements to your spreadsheet, you will require spare it and reload it. Retreat to Step 3.

Step 8 – Confirm exchanges to Import

Click next and QuickBooks will affirm the quantity of exchanges that you have chosen for download:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

On the off chance that you concur with the # of exchanges then select Yes. Something else, select No to do a reversal and roll out any important improvements.

Step 9 – Transactions have been downloaded

Once the exchanges have been effectively imported the accompanying message will show:

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Step 10 – Review Imported Transactions

In the Banking Center, you ought to see the charge card record and adjust as showed underneath.

How to Import Credit Card Transactions into QuickBooks Online,Credit Card Transactions Processing,QuickBooks Online

Wrap Up

That wraps up the area on the most proficient method to Import Business Credit Card Accounts into QuickBooks. The following lesson in our QuickBooks Online Training Course will be How to Grant Multiple Users Access to Your QuickBooks Data. In this lesson, we will stroll through how to give your bookkeeper and clerk access to your QuickBooks information.

You might also like More from author

4 Comments

  1. Adal Berto says

    great points altogether, you simply gained a new reader. What could you suggest about your publish that you just made a few days ago? Any certain?

  2. Antony Loureiro says

    Hi there to every , because I am in fact keen of reading this web site’s post to be updated
    on a regular basis. It includes fastidious stuff.

  3. Lisette Caldwell says

    I believe this is one of the most vital info for me.
    And i am satisfied studying your article. However
    should observation on some common things, The site style is ideal, the articles is really nice : D.
    Just right process, cheers

  4. Chassidy Maclurcan says

    Do you mind if I quote a couple of your posts as long as I provide credit and
    sources back to your blog? My website is in the exact same area of interest as
    yours and my visitors would definitely benefit from a lot of the information you provide
    here. Please let me know if this alright with you. Thanks!

Leave A Reply

Your email address will not be published.