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.
Write a comment ...