Showing results for 
Search instead for 
Did you mean: 

Import bank transactions from .CSV to QuickBooks

Prepare your .CSV file before you begin. Here are tips:

  1. QuickBooks has 3 fields: Date, Description and Amount to import bank transactions.
  2. Mandatory fields should be filled in. For Amount fields with no value (normally happens to 4-column .CSV files), enter 0 (zero).
  3. Remove all symbols in the Amount field. For example, currency sign or comma.
  4. If your Amount field is in one column, use the minus - sign  to depict money out rather than brackets ( ).
  5. Remove non-transactional info in the file (ex. account numbers, opening, closing balance).
  6. Save your changes.

Now that you've prepared your .CSV file, you can import bank transactions from the .CSV file to QuickBooks

  1. Select the Banking menu, then select File Upload.
  2. Select Browse and choose the .CSV file.
  3. Select Open, then select Next.
  4. Select the account from the QuickBooks Account drop-down, then select Next.
  5. Select a Date and a date format.
  6. Select the Description and Amount statement fields.
  7. When you are ready, select Next.
  8. All transactions in your .CSV file will show. If you'd like to exclude transactions, clear the checkbox next to date.
  9. Select Next.
  10. Select Yes to import now, then select Let's go!

Was this helpful?

You must sign in to vote, reply, or post