QuickBooks HelpQuickBooksHelpIntuit

Common questions about importing data to QuickBooks Online

by Intuit•72• Updated about 17 hours ago

We understand that data imports are important to get right. We want to make sure that you have all of the information you need to be successful.

Here are the answers to some commonly asked questions about importing data to QuickBooks.

Tip: You can use the Subtitles feature to watch this video in your local language. To do this, turn on subtitles by selecting the video Settings ⚙, then Subtitles/CC, and English (auto-generated). Repeat this process and select Autotranslate to update the subtitles to a language of your choice. 

What information can I import to QuickBooks Online?

You can import the following information to QuickBooks Online:

  • Bank Data
  • Customers
  • Suppliers
  • Chart of Accounts
  • Products and Services
  • Invoices
  • Credit Notes
  • Sales Receipts
  • Journal Entries
  • Bills

Do I need to import my data in a specific order?

Yes. To make sure your data imports correctly, import lists in this order first:

  1. Chart of Accounts
  2. Customers
  3. Suppliers
  4. Products and services
  5. Invoices
  6. Bills
  7. Journal entries

If you need complete steps, use the above links to learn how to import your customers, suppliers, products and services, invoices, bills, or journal entries.

You can use a CSV (Comma Separated Values) file, Google Sheets, or an XLS/XLSX file to import information to QuickBooks Online. 

Here are some details about the different formats:

  • CSV file: A common file format used for text files. These contain tabular data. In CSV files, each field of text is separated by a comma, semicolon, or other special character.
  • Google Sheets: An online spreadsheet created in Google Drive.
  • XLS/XLSX file: XLS is the file format of Microsoft Excel 1997–2003. Microsoft Excel 2007 and newer use the XLSX file format.

You can import content from multiple sources. For example, if you have a list of contacts in Excel (XLS/XLSX), some in Google Sheets, and some in Outlook (CSV), follow the import process for each source.

You can now import Journal Entries using Excel CSV files.

  1. Select + New or + Create.
  2. Select Journal entry then select Import.

Before you import your journal entries, make sure that your file includes the following information:

  • Journal No
  • Journal Date
  • Journal Code
  • Account Name
  • Journal
  • Debits
  • Credits
  • Select date format

If your spreadsheet has new accounts, be sure to add them in your chart of accounts before importing.

QuickBooks Online uses the first row of your spreadsheet for mapping. This means that your first row’s content isn’t imported. If you need the information from the first row of your file, add a header row to your spreadsheet. You can also duplicate the first row before you import the file.

You can't import a contact that already exists in QuickBooks Online. To work around this, review your current contact list, then rename any duplicate contact(s) before you import your file.

You can only import spreadsheets with less than 1,000 rows. If your spreadsheet is larger than this, we suggest that you split your spreadsheet into smaller files, then import them separately.

QuickBooks Online can only import specific fields for each type of data.

To learn more about which fields can be imported, download the sample files available in your QuickBooks account.

No, QuickBooks Online doesn't make any changes to your spreadsheet.

Currently, there's not an option to bulk undo or delete imported contacts. 

  • QuickBooks Online doesn't import currency details from a contact list.
  • If your version of QuickBooks Online supports Multicurrency, your home currency is assigned to all customers and suppliers by default. If you need to change customer or supplier currency, select the Currency column during import. Then, select the new currency for the contact on the Review screen. 

    Note: You must turn on Multicurrency before starting the import process.

If you import your products and services incorrectly, you can overwrite‌ them. This replaces the values for each product or service that you import with an identical name. To do this,  import the same file again, then select Overwrite all values.

Note: After you select Import, your overwrite can't be undone.

It's not possible for you to merge multiple QuickBooks Online companies into one. However, you can consider using Qvinci Consolidations, which is our authorised 3rd party app. Qvinci can sync data from QuickBooks files in many locations, allowing you to consolidate and compare companies easily.

Next steps