Prepare your .CSV file before you begin. Here are tips:
- QuickBooks has 3 fields: Date, Description and Amount to import bank transactions.
- 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.
Here's how your file looks like when it's ready.
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.
- 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!