Showing results for 
Search instead for 
Did you mean: 

Import Bank transactions via CSV [VIDEO]

Learn how to download bank transactions from your bank and upload the corresponding .CSV file to QuickBooks, to receive transaction data in QuickBooks Online.

How to download bank transaction data from your bank's website

We've provided a list of common banks below with articles on how to download .CSV files from their website:

How to import the transactions via a CSV file:

  1. Select Banking or Transactions from the left menu
  2. Under the drop-down arrow next to Link Account, select Upload from file. If this is the first time connecting a bank account, select Upload transactions manually at the bottom of the screen.
  3. Select Browse and choose the appropriate .CSV file then click Next.
  4. From the QuickBooks Account drop-down, select the appropriate bank or credit card account, then click Next.
  5. Map the statement fields according to your .CSV file's format then click Next.
  6. Put a check mark on the transactions to import then click Next.
  7. Select Yes on the notification asking if you want to import now.
  8. Select Let’s go when you get the Import Completed window.

You will now be directed to the Downloaded Transactions window where the imported transactions will appear under the For Review tab.

CSV template format

Before you begin the import, take note of the accepted .CSV template formats:

3 Columns

21/1/2018Example of a payment-100.00
31/1/2018Example of a deposit200.00

4 Columns

21/1/2018Example of a payment100.00
31/1/2018Example of a deposit200.00

Tips for a successful import

Now that you are aware of the CSV template formats, here are some tips and tricks to keep in mind to ensure you'll be able to successfully import your bank transactions.

  • The columns mentioned in the acceptable file formats are the only columns that QBO can import. You'll be able to enter additional information, such as the category and payee on the For Review tab of your Transactions page. If you have any rules or if QuickBooks recognises the descriptions of your transactions, it will fill in that information automatically.
  • CSV file for credit card accounts may show up transactions in reverse. Deposits, for example, display as negative amounts because paying your credit card reduces your balance. To make sure credit card transactions post correctly on your company file, you need to select a corresponding credit card account (not a bank account) in QuickBooks.
  • When you import CSV files that contain bank info into QBO, the file must be formatted correctly or you'll receive an error when you try to upload it, such as Error: We can’t upload this .csv file because some of the columns aren’t mapped correctly. If you have any issues importing your CSV file, make sure your file doesn't break any of these restrictions:
    • 0's are not allowed anywhere in the file, e.g $0 should be left blank
    • Ensure there are no ( ) used for negative amounts and ensure the column(s) are formatted correctly
    • $ symbols are not allowed, e.g $234 should be 234
    • Commas for thousands are not allowed, e.g 2,111 should be 2111
    • Other special characters such as #, %, and & are not allowed.
    • Correct any transactions with the amount showing in the description column
    • Remove the word “amount" if it appears in the credit or debit column, i.e. credit amount, debit amount
    • Correct and standardise the date format to a single format i.e. dd/mm/yyyy
    • MAC users must save the file as a Windows CSV file

Was this helpful?

You must sign in to vote, reply, or post