Before you begin
Download a CSV for one account and one continuous statement period. Keep the original export unchanged so you can compare it with the converted file. If your bank offers several CSV layouts, choose the one that includes a posted date, description, and either one signed amount column or separate debit and credit columns.
- Reconcile or note the opening and closing balance before importing.
- Remove summary lines such as “Beginning balance” if they are included as transaction rows.
- Use a small date range for your first test.
- Back up the QuickBooks company before a large import.
Map the transaction fields
Select the CSV columns that represent the date and description. For a signed Amount column, withdrawals should be negative and deposits positive. If your export separates money out and money in, map the Debit and Credit columns instead. Bank2QBO will make debit values negative and credit values positive.
Choose month/day/year for dates such as 07/25/2026 and day/month/year for dates such as 25/07/2026. An incorrect choice can shift a transaction to a different day when both numbers are 12 or below.
| QBO field | Typical CSV headings | What to verify |
|---|---|---|
| Date | Posted Date, Transaction Date | Date order and statement period |
| Description | Payee, Merchant, Details | Useful name, not a blank field |
| Amount | Amount, Net Amount | Withdrawals negative; deposits positive |
| Debit / Credit | Withdrawal / Deposit | Map these only when there is no signed amount |
| ID | Reference, Transaction ID | Unique per transaction; otherwise generate one |
Preview before downloading
Check at least one withdrawal, one deposit, the earliest date, and the latest date in the preview. Make sure the transaction count matches the data rows in the CSV. Blank rows are ignored, but totals and headings embedded in the transaction area may need to be removed from the source copy.
Select Checking or Savings for deposit accounts and Credit card / line of credit for card statements. The account identifier in the generated file can be a nickname or last four digits; a full bank account number is unnecessary.
Import carefully
Download the QBO file, open the intended account in QuickBooks, and use its file-upload or bank-data import workflow. Product menus change, so follow the labels shown in your current QuickBooks edition. Confirm the destination account before accepting transactions.
Start with a short file. If the result is correct, import the remaining non-overlapping periods. Do not upload the same date range repeatedly: transaction IDs help identify records, but duplicate behavior can depend on the receiving product and prior imports.
Worked example: a three-row checking export
Imagine a fictional CSV with a $42.60 office-supply purchase, a $900 customer receipt, and a $9 monthly fee. The source uses one signed Amount column: -42.60, 900.00, and -9.00. Map that field once; do not also map Debit or Credit.
The preview should show two negative transactions and one positive transaction. If it instead shows three positive values, stop and inspect the source rather than importing. With Checking selected, a short identifier such as “Operating-2048,” and the correct currency, download the test file and direct it only to the matching checking register.
- Expected row count: 3
- Expected net amount: +848.40
- Expected directions: 2 debits and 1 credit
- After import: compare all three records with the source before continuing