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. Some UK banks provide .CSV transactions in 3 columns, and others in 4 columns (separating Amount into Debit and Credit fields). Both formats work for QuickBooks, if fields are mapped correctly.
  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. Note: Check if the date format is the one in your .CSV file. The dd/MM/yyyy format is used for UK banks. If your .CSV file separates out Amount into 2 columns, choose the 2 column option. Then, map the Debit and Credit fields. The Debit field in QuickBooks mean money out and Credit for money in.
  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!

If you need more help, get support from our Social channels by clicking on an icon: User-added image User-added image

Was this helpful?

You must sign in to vote, reply, or post