Intermediate
How to batch import transactions on QuickBooks
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.
Prerequisites
- QuickBooks Online or Desktop access with admin permissions
- Transaction data in CSV or Excel format
- Understanding of chart of accounts and transaction categories
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.
Tip
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.
Tip
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.
Tip
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.
Tip
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.
Tip
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.
Tip
Run a trial balance report to ensure your books still balance after the import.
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.
Ready to get started with QuickBooks?
Put this tutorial into practice. Visit QuickBooks and follow the steps above.
Visit QuickBooks →