How to Import Bank Transactions into QuickBooks Online via Excel - dummies

How to Import Bank Transactions into QuickBooks Online via Excel

By Elaine Marmel

If your bank supports downloading transactions to a CSV format (a comma-separated values format that can be read by Excel), you can download your banking activity to a CSV format and then import it into your QuickBooks Online Bank account. First, log in to your bank’s website and save your banking transactions. QBO can import CSV files formatted in either three or four columns.

An Acceptable Three-Column Format
Date Description Amount
1/1/2019 Example payment -100.00
1/1/2019 Example deposit 200.00

This is what it looks like in a four-column format.

An Acceptable Four-Column Format
Date Description Credit Debit
1/1/2019 Example payment 100.00
1/1/2019 Example deposit 200.00

Open your CSV file using Excel and make sure it matches one of these formats; if necessary, edit it. Then, follow these steps to import the transactions:

  1. Choose Transactions →   Banking in the Navigation bar.
  2. Click the arrow beside the Update button and, from the menu that appears, click File Upload.

    The Upload File page appears.

  3. Click the Browse button, select the CSV file you downloaded from your bank’s website, and click Next.
  4. Select the account into which you want to import transactions and click Next.
  5. On the Map CSV Columns screen that appears, match the fields in QBO to the fields in your CSV file and then click Next.

    The transactions you can import from your CSV file appear, with a check box to the left of each transaction. To avoid importing a particular transaction, select its check box.

  6. Click Next.

    QBO displays the number of transactions that will be imported and asks if you want to import the transactions.

  7. Click Yes to import the transactions.

    When QBO finishes importing the transactions, a confirmation screen appears.

  8. Click Finish.

    The Bank and Credit Cards page appears, and the transactions you imported appear on the New Transactions tab.

quickbooks-online-3e-qbo-csv
Match QBO fields to the fields in your CSV file.