Prepare your .CSV file before you begin. Here are tips:
- 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.
- Mandatory fields should be filled in. For Amount fields with no value (normally happens to 4-column .CSV files), enter 0 (zero).
- Remove all symbols in the Amount field. For example, currency sign or comma.
- If your Amount field is in one column, use the minus - sign to depict money out rather than brackets ( ).
- Remove non-transactional info in the file (ex. account numbers, opening, closing balance).
- Save your changes.
Now that you've prepared your .CSV file, you can import bank transactions from the .CSV file to QuickBooks
- Select the Banking menu, then select File Upload.
- Select Browse and choose the .CSV file.
- Select Open, then select Next.
- Select the account from the QuickBooks Account drop-down, then select Next.
- 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.
- Select the Description and Amount statement fields.
- When you are ready, select Next.
- All transactions in your .CSV file will show. If you'd like to exclude transactions, clear the checkbox next to date.
- Select Next.
- Select Yes to import now, then select Let's go!