How to easily import credit card transactions into quickbooks

QuickBooks online has added an extremely good feature as a way to assist you to effortlessly of time and effort. you could now download and import credit score card transactions into QuickBooks with the intention to control your finances and price range.

On this weblog, we are able to describe the steps to import credit card transactions into QuickBooks online easily. furthermore, we’ve got furnished particular steps to download transactions in CSV format.

Important Matters to consider

  • You have to upload a column for QuickBooks account variety whilst downloading a file from your credit card enterprise. if you already have an account quantity then offer the bottom sub-account number.
  • There is a ‘pay’ column within the document which receives downloaded from the credit score business enterprise containing greater details like service provider identification. you may mold this column to healthy it with the vendor call.
  • There’s no compulsion to feature a new cost for your import record. there’s a choice to provide a default price when you import credit card transactions into QuickBooks desktop.
  • To import credit card transactions into QuickBooks Online, you may enter credits manually.
  • If you want to download transactions of extra than 90 days you then want to import your transaction in Excel format (CSV or QBO report).

Easy Steps to Import credit Card Transactions into QuickBooks online

Step 1: Choose Your Banking middle

  • First of all, enter your bank/credit score card name within the seek bar.
  • Now choose your bank/credit card employer from the listing.
  • In case you couldn’t locate your credit score card agency or you want to download 90 days transaction then you need to do it using CSV format.

Step 2. Login in your commercial enterprise and credit card account

Login the usage of your identity and password. it could take a couple of minutes to attach your bank with QuickBooks.

Step three. Select your credit score card account

  • Tick mark every account you want to connect to QuickBooks.
  • Subsequent, you need to input your financial institution account call.
  • Select the QuickBooks account where you have related your bank account.
  • If you are unable to locate it, then add an account from the drop-down listing.

Step 4. Pick out the proper date variety

  • The transactions are commonly downloaded in 90 days. if you want transactions of extra than ninety days then it’s miles important to download it the usage of CSV format.
  • In case you want transactions for a shorter date variety then click on the link “need a shorter date range”.

Step 5. Click on connect

Click on at the join button to download all of the transactions into QuickBooks.

Important Thing: There is no undo option once the transactions are downloaded. consequently, ensure that you pick out the ideal account due to the fact later you may delete all of the transactions and downloaded it again.

Step 6. Transactions are downloaded

Once the transactions have been downloaded, you’ll get a message “We successfully downloaded your transactions. Hooray!”.

Step 7. Evaluate Your Downloaded transactions

  • Test your credit card account and stability in the banking center.
  • If you want to music some other credit score card account then click on add account and observe step 1.

How to Import credit Card Transactions into QuickBooks online with CSV document?

  • First of all, choose Transaction and Banking.
  • Upload your file or transaction via clicking on upload a record alternative.
  • Pick the QuickBooks account you want to lick with the credit card account.
  • You can upload Account from the drop-down listing in case you do not have an account in QuickBooks.
  • Refill the desired fields to set up your account.
  • After entering all the information, map QuickBooks on-line fields for your financial institution account fields.
  • Comply with the underneath steps to map QuickBooks online:
  • Pick out the date column, then pick the date layout.
  • Now visit description and click on at the record.
  • You will get high-quality and bad numbers in an unmarried column.
  • Select the column with a terrible wide variety.
  • Tick transaction you need to import into QuickBooks and pick out subsequent.
  • QuickBooks will confirm the transaction.
  • Click on sure to verify.
  • Subsequently, your transaction has been downloaded.


Although this newsletter will help you import credit card transactions without problems in case you nonetheless need any technical resource then name us on QuickBooks support phone number speak our QuickBooks ProAdvisor and get the great solutions to all QuickBooks associated issues.

Leave a Reply

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