How to Import Excel and CSV Files into QuickBooks Online Without Re-entering Transactions?
QuickBooks Online lets you import supported business data from Excel and CSV files instead of entering each record manually. You can import bank transactions, invoices, bills, customers, vendors, and other records through their respective import options. However, each import method has specific file requirements and column-mapping rules. This guide explains how to prepare your spreadsheet and import supported data into QuickBooks Online.
Can You Import Excel and CSV Files into QuickBooks Online?
Yes, QuickBooks Online allows you to import supported data from Excel and CSV files without entering every record manually. You can import bank transactions, invoices, bills, customers, vendors, products and services, and Chart of Accounts.
However, QuickBooks Online uses different import methods for different data types. For example, you can upload bank transactions through the Bank transactions page, while invoices and bills have separate import options. The accepted file formats and transaction limits also depend on the selected import method.
How to Prepare an Excel or CSV File Before Importing It into QuickBooks Online?
Make sure you double-check these details before you import CSV files into QuickBooks
Column Headings
Use clear column headings that match the fields in QuickBooks. For example, bank transaction files should include Date, Description, and Amount or Date, Description, Credit, and Debit. Download the sample file for the selected import type to check the required format.
Chart of Accounts
Review your existing Chart of Accounts before importing records. This helps you avoid duplicate accounts and incorrect account mappings.
Removing Blank Rows and Unused Columns
Delete blank rows, unnecessary columns, and unrelated information. Keep only the data required for the selected import.
Dates and Amounts
Use a consistent date format throughout the spreadsheet. Check all transaction amounts before importing. For bank transactions, use either an Amount column or separate Credit and Debit columns.
Duplicate Transactions
Review existing QuickBooks records before importing new transactions. This helps prevent duplicate entries and incorrect financial records.
Bank Rules
Set up bank rules before uploading transactions if you want QuickBooks to automatically categorize eligible bank transactions during the upload process.
File format
QuickBooks Online supports CSV, Google Sheets, XLS, and XLSX files for applicable data imports. However, bank transaction uploads have separate file requirements. They accept CSV, TXT, QBO, and OFX files. Bank transaction files must be in English, must not exceed 350 KB, and can contain up to 1,000 transaction lines per upload.
What Are the Steps to Import Bank Transactions into QuickBooks Online?
You can manually import invoices into QuickBooks Online from Excel along with bank transactions, checks, deposits, estimates, purchase orders, bills, and more by uploading a prepared CSV file. Follow these steps:
- Go to All apps > Accounting > Bank Transactions. Choose the bank account to which you would like to add the transactions.
- Select the Link account > Upload from file. Choose the manual upload option if your account is not set up for online banking.
- Choose Drag and Drop or Select Files. Upload your prepared CSV file and click Continue.
- Under the QuickBooks account dropdown, select the bank account to which you want the transactions added. Choose Continue.
- Map the Date, Description, Amount, Credit, and Debit columns to their corresponding QuickBooks fields.
- Ensure that the date is correctly formatted and the amounts are correct. In case the amounts are reversed, reverse values where applicable. Select Continue.
- Choose the transactions to import. Check their dates, descriptions and amounts. Select Continue and then Yes, then Done.
When to Use a Bulk Import Tool?
QuickBooks Online offers built-in import options for several types of business data. However, each import method has specific file requirements and transaction limits. Businesses that regularly import large transaction batches or handle data from multiple sources may benefit from a dedicated bulk import tool.
If your business receives recurring monthly spreadsheets, Dancing Numbers can help import supported transaction data into QuickBooks in batches. This can reduce repetitive manual data entry and simplify recurring data imports.
Conclusion
Importing Excel and CSV files into QuickBooks Online one-time instead of entering information manually is a time saver. Make sure your spreadsheet is prepped, your column headings are in order, and you select the correct import option when you upload. When you regularly import large spreadsheets, a bulk import tool like Dancing Numbers can also help you manage the process.
Frequently Asked Questions
1. What lists cannot be imported from Excel into QuickBooks?
QuickBooks Online supports importing customers, vendors, products and services, and Chart of Accounts. However, it only imports supported fields for each list. Check the sample spreadsheet for the fields available for import.
2. What are three lists that can be imported into QuickBooks Online?
You can import these Customers, Vendors, and Chart of Accounts lists into QuickBooks Online. You can also import products and services using supported spreadsheet formats.
3. Can you link QuickBooks to Excel?
Yes. QuickBooks Online supports importing data from Excel spreadsheets and exporting reports to Excel. You can also use Spreadsheet Sync for supported spreadsheet-based workflows.
4. Is there a limit on import data in QuickBooks Online?
Yes. Import limits depend on the data type and import method. QuickBooks Online allows up to 100 invoices per import, up to 1,000 transaction lines per bank upload, and fewer than 1,000 rows for general spreadsheet imports.
5. Can you import invoices into QuickBooks Online?
Yes. Go to Settings > Import data > Invoices. Upload your prepared CSV file, map its columns to QuickBooks fields, select the date format, and complete the import. This method allows up to 100 invoices per import but does not support accounts with sales tax configured.






Comment