Q QuickBooks

How to batch import transactions on QuickBooks

intermediate 8 min read Updated 2026-03-18
Quick Answer

Batch import transactions in QuickBooks by preparing your data in the correct CSV format, then using the Import Data feature from the Banking or Transactions menu. QuickBooks will guide you through mapping fields and reviewing transactions before finalizing the import.

Try QuickBooks Full QuickBooks Review

Prerequisites

  • QuickBooks Online or Desktop access with admin permissions
  • Transaction data in CSV or Excel format
  • Understanding of chart of accounts and transaction categories

Step-by-Step Instructions

1

Prepare your transaction data

Create a CSV file with columns for Date, Description, Amount, Account, and Category. Use MM/DD/YYYY format for dates and ensure amounts are in decimal format (e.g., 125.50). Include separate rows for debits and credits if needed.
Keep a backup copy of your original data file before making any formatting changes.
2

Access the Import Data feature

In QuickBooks Online, go to Banking > Banking and click File Upload. For QuickBooks Desktop, navigate to File > Utilities > Import > Excel Files or CSV Files.
3

Select your import file

Click Browse or Choose File to locate your CSV file. Select the file and click Open. QuickBooks will analyze the file structure and display a preview of your data.
Ensure your file is saved as CSV format, not Excel, as QuickBooks may have issues with .xlsx files.
4

Map your data fields

Review the field mapping screen where QuickBooks attempts to match your CSV columns to QuickBooks fields. Use the dropdown menus to correct any incorrect mappings. Ensure Date, Description, and Amount fields are properly mapped.
If you have custom fields, you may need to create them in QuickBooks first before they appear in the mapping options.
5

Configure import settings

Select the appropriate account for the transactions and choose whether to import as Bank Deposits, Expenses, or Journal Entries. Set the date range if you want to limit which transactions to import.
Choose 'Journal Entries' for complex transactions that affect multiple accounts.
6

Review and validate transactions

QuickBooks will display a preview of all transactions to be imported. Check for any errors or warnings highlighted in red. Review the Account assignments and Categories to ensure they match your chart of accounts.
Pay special attention to duplicate transactions that QuickBooks may flag for your review.
7

Complete the import

Click Import or Import Now to finalize the process. QuickBooks will process the transactions and display a summary showing successful imports and any errors. Note the transaction count and any items that failed to import.
8

Verify imported transactions

Navigate to the relevant account registers or go to Accounting > Chart of Accounts to verify the imported transactions appear correctly. Check that dates, amounts, and categories are accurate and that your account balances reflect the new transactions.
Run a trial balance report to ensure your books still balance after the import.

Common Issues & Troubleshooting

CSV file format errors during upload

Ensure your CSV uses UTF-8 encoding and comma separators. Remove any special characters from descriptions and check that date formats match MM/DD/YYYY.

Transactions showing as duplicates

QuickBooks flags potential duplicates based on date and amount. Review each flagged transaction and choose Skip for actual duplicates or Import if they are legitimate separate transactions.

Account or category mapping errors

Create missing accounts in your Chart of Accounts before importing. Ensure account names in your CSV exactly match existing QuickBooks account names, including capitalization.

Import fails with 'Invalid amount' errors

Check that all amounts are in decimal format without currency symbols. Use negative numbers for expenses and positive for income. Remove any commas or special formatting from number fields.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official QuickBooks website before purchasing.
Visit QuickBooks View QuickBooks Pricing