How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

QuickBooks Online: How to import bank transactions from Excel .csv file into QuickBooks Online?

Now, you can import bank transactions if your bank provides .csv (comma-separated values) file type. This is new improvement they have just made.

You will take the following steps to import bank CSV file:

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

 

You can also import bank transactions directly from excel .csv file type into QuickBooks Online. Take these steps.

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

This could be a huge time-saving task especially when bank do not provide a way to download old bank transactions but available in other formats. If you have bank statements in PDF format, you may be able to just copy and paste to Excel. You can also edit description data and make necessary changes in Excel spreadsheet. Once it done, save file type as Text CSV (*.csv). It takes the following columns to import from Excel:

Column 1 = date

Column 2 = description

Column 3 = spent as negative amount and received as positive amount

OR

Column 1 = date

Column 2 = description

Column 3 = spent as debit

Column 4 = received as credit

If the bank statement provides deposits and withdrawals in two columns, use four column format spreadsheet.

Once the bank file is uploaded into “New Transactions” section of bank feed, you can also add manage rules before transferring transactions to “In QuickBooks” section of bank feed.
 
You can watch this QuickBooks Online Tutorial Video for step-by-step training instructions.

 

1 bank1 csv
 

2 Save as Text  CSV type 

3 file upload 

4 select the file to upload 

5 select bank account

6 bank account quickbooks field