You can now import bank transactions to QuickBooks Online via Excel CSV (comma-separated values) files.

CSV template format

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

3 Columns

  A B C
1 Date Description Amount
2 1/1/2018 Example of a payment -100.00
3 1/1/2018 Example of a deposit 200.00

4 Columns

  A B C D
1 Date Description Credit Debit
2 1/1/2018 Example of a payment 100.00  
3 1/1/2018 Example of a deposit   200.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 Banking page. If you have any rules or if QuickBooks recognizes 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. 
  • Note that each bank formats its CSV files differently, so importing a CSV file may NOT be possible for every financial institution. If your bank doesn't support CSV but offers Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX), you can try to import then upload more than 90 days of bank transactions through Web Connect.
  • 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 standardize the date format to a single format i.e. dd/mm/yyyy
    • MAC users must save the file as a Windows CSV file

How to import the transactions from a CSV file:

  1. From the left menu, select Banking then Banking.
  2. From the Update drop-down arrow, choose File upload. If you’ve never connected an account, select Upload transactions manually at the bottom of the screen.

    NOTE: You can also upload CSV bank transactions through the Import Data page (Gear > Import Data > Bank Data).

  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.

HOW24759