Are you seeking to import credit card transactions into QuickBooks? We are here to resolve you are problems and solution regarding to QuickBooks desktop. Importing credit card transactions into QuickBooks can help you track expenses, manage cash flow, and simplify financial reporting. In this segment we learn about how to import credit cards in QuickBooks desktop and online, benefits of the transaction process, some tricks and tips.

Importing credit card statement and bank statement is straightforward when you set up your bank feeds direct on your accounting software. Your also import credit card transaction by downloading a file direct from the bank website. After this you may need to import your bank credit card transaction and statements into the QuickBooks desktop and online by scanning copies of the statement and transaction. Let’s start the process by following below steps-

How to import credit card transaction in QuickBooks desktop and online

Step 1- selecting banking sector

· First open your QuickBooks account.

· Go to the QuickBooks software dashboard.

· In listed you can find out transaction option click on it.

· Now click on “bank transaction”.

Step 2- connect your credit card account

· If you’re connecting first time your bank or credit card in QuickBooks then you will see on screen allowing you to connect your account to QuickBooks online. If you already connected then then it will directly taken you in to the banking center.

· From banking center click on Link account button for connect a new credit card account.

· Every details of your credit card such as name of card provider etc. have to fill in this section.

· After selecting your card provider details, QuickBooks displayed a new screen in which you have to login to my bank account.

· QuickBooks asked you to share your banking information with intuit. Click on ok button for confirmation.

Step 3- Set up the account in the chart of account.

· Now you have to select appropriate credit card account from chart of account. If any account already created before it will show you here. This is the place where imported transaction recorded automatically in the account.

· QuickBooks shows you list of available account which is associated with your bank such as saving, credit card, checking.

· If you have a new account then click on Add new.

· Here you need to give information such as appropriate account and account name.

· Select your starting date or the date you need to track your transaction.

· Once done click on green button to save it.

· After linking your credit card from your chart of accounts. Begin the importing transaction into the QuickBooks by clicking green connect button.

· After connecting credit card into the account all transaction will be automatically imported into the QuickBooks on daily basis.

Method to Import Credit Card Transactions into QuickBooks desktop & online

Method 1- Import credit card transaction manually into the QuickBooks online.

· For importing credit card transaction you need first to download the transaction file from your credit card company.

· For this, browse your credit card company online.

· Login your account.

· Now locate the option to download my account transaction.

· Select the transfer file and import it into the QuickBooks.

· For this now open the QuickBooks desktop software in your system.

· Import a transaction file click on banking.

· If you have already account on it select your account and click “down the arrow” next to the Link Account button.

· Click on upload from file.

· Look for the browse button and click on it to connect for the QuickBooks web connect file.

· Then click next to open it.

· Review that QuickBooks Web Connect file you are going to import such as filename, Account ID, Account Type, and Date range.

· Click on next and then let’s go.

By clicking on review you can check four transactions which are imported. Description is actually the Payee name and the Payee name is empty because there is need to match vendor’s records in QuickBooks. For this categorize the transaction and match them to the vendors or Payees.

When you are categorizing bank or credit card transaction in QuickBooks you need to ensure that your transactions are correctly categorized.

· Now click on the transaction and select vendor records and category.

· Click Add for adding the transaction to register.

· Continue to the transaction. All transaction shows you now.

You can also read: Payroll Taxes Not Calculating in QuickBooks? Here's the Fix

Method 2- Import credit card transaction manually into the QuickBooks desktop

You have already credit card transaction file you have to follow these steps to import it manually into the QuickBooks desktop.

· Open your QuickBooks desktop software. Click on list then click on charts of accounts.

If you see yellow strike icon there then you need to first remove it because this icon show that this account is online linked to direct download.

· To disconnect it right click on Edit account.

· Then click on Bank feed setting and then click on Deactivate all Online Services.

· Now check yellow icon is showing or not now.

· If it not showing you can import transaction web file.

· For this go to the File Menu then select Utilities then Import then click on web connect file.

· Now check the details like account number, name, account type etc.

· Then click on continue button.

· Now your transaction is imported.

· Click on transaction list to review the transaction. Assign vendor records and expense account before adding transaction to register.

· Payee name and the Payee name are empty. Choose vendors records.

· Click on Show Bank Memo to see description the bank memo column.

· Once your vendor records and account are set. Add transaction to register.

· Now you can see all transaction.

Conclusion-

In this segment we learnt about how to import credit card transaction in QuickBooks desktop and online. By following methods and steps you can easily import the transaction in QuickBooks. If you are failed to do it and you still need technical guidance then you contact our QuickBooks technical support team at +1-800-761-1787 is suggested. You can speak our experts they will provide you immediate guidance for your problem.

How to Easily Import Credit Card Transactions into QuickBooks (Desktop & Online Versions)