Bulk Import Inventory Products
QUICKBOOKS ONLINE | INVENTORIES
How to import products and services in bulk in QuickBooks Online
Learn how to prepare an Excel file to import multiple products or services into QuickBooks Online, set up their accounting accounts, quantities, and costs, and verify that the records have been created correctly.
What will you learn?
- Prepare an Excel file containing the catalog of products and services.
- Identify the necessary and optional columns.
- Correctly assign revenue, expense, and inventory accounts.
- Set the date and initial stock levels.
- Import and map the file columns.
- Verify imported products and correct errors.
- Review the initial inventory value.
Before starting
Prepare the file containing the products you wish to import and verify that the corresponding accounting accounts already exist in QuickBooks Online. You must also have a user account with permissions to import data; some functions may require administrator access.
Step 1. Prepare the Excel file
Create a sheet with one row per product or service. The tutorial shows various columns that can be used depending on the type of item.
| Field | Function |
|---|---|
| First name | Name of the product or service. |
| Category | Optional classification of the item. |
| Article type | Inventory, non-inventory item, or service, as applicable. |
| SKU | Item reference code. |
| Sales description | Text used in sales documents. |
| Sale price | Rate per unit. |
| Revenue account | He states that he will receive the proceeds from sales. |
| Purchase description | Item description for purchases. |
| Purchase cost | Unit cost of the item. |
| Expense or cost account | Account associated with purchases or cost of sales. |
| Opening inventory | Quantity available at the start of the control process. |
| Start date | Date from which initial inventory is recognized. |
| Resupply point | Stock level for monitoring. |
| Inventory count | Asset account used for inventory. |
| Taxes and preferred vendor | Additional information where applicable. |
Not all columns are mandatory. The required information depends on the item type and the options available during import.
Step 2. Use the exact names from QuickBooks
When completing the Excel, it is important that the ledger accounts and item types match the names that exist in QuickBooks.
- Go to the Products and services section.
- Open the option to create a new item.
- Check the available item types.
- Check the exact names of the accounting accounts.
- Copy those names to the Excel file.
If you use subaccounts, make sure to keep the full name structure when QuickBooks displays it with the primary and secondary account.
For example, do not replace the actual name of an account with an approximate description, because the importer might not recognize it.
Step 3. Review the inventory start date
The start date of the inventory is especially important when importing inventoryable products.
The video explains that if you set the inventory start to December 31, you could encounter issues when trying to record transactions prior to that date.
For example, if you need to use a product from October, check that its start date is compatible with the transactions you will record.
Important: initial date and quantities
Do not select an arbitrary date if the company already has inventory movements. Verify the actual initial balance, its valuation, and the cut-off date before importing products, especially when closed accounting periods exist.
Step 4. Import the file
- Log in to QuickBooks Online.
- Select the icon of Settings.
- Click on Import data.
- Select Products and services.
- Select the option to load data from a file.
- Locate the prepared Excel file and select Open.
- Wait for QuickBooks to process the document.
Step 5. Associate the columns
QuickBooks will ask to match the Excel columns with the fields used by the system.
Correctly map the name, category, item type, SKU, descriptions, prices, accounting accounts, dates, and quantities, based on the data included in your file.
Also check the selected date format. In the example in the video, day, month, and year are used.
When you're done, select Next.
Step 6. Review the items before saving
In the preview, carefully check each record:
- That inventoryable products appear as inventory.
- That services appear as services.
- That income and expense accounts are correct.
- That prices and costs correspond to the amounts in the Excel.
- Ensure that the tax indicators included in the price are configured correctly.
- Ensure that the initial quantities correspond to the type of item.
In the tutorial, the "taxes included" options are deselected because the sale and purchase prices in the example do not include taxes.
If any data was not imported correctly, check whether the screen allows you to correct it before proceeding.
Services do not involve inventory quantities or inventory asset accounts. For this reason, some fields may appear disabled depending on the type selected.
Step 7. Save and verify the results
- Review all the products in the preview.
- Select Save or the corresponding option to complete the import.
- Check the message indicating how many records were imported.
- If errors appear in red, review the highlighted rows and fields.
- Go to Products and services and look for the newly created items.
In the example, three records were imported, and QuickBooks confirmed that all three were saved successfully.
Step 8. Review the codes and the initial inventory value
If you work with codes such as CAByS in fields enabled by your configuration or integration, use the Text format in Excel to prevent leading zeros from being lost or long codes from being altered.
After importing inventory items, review their movements. When initial stock levels are recorded, QuickBooks can generate an Initial inventory value transaction.
Verify that the quantity and initial cost are correct, and that the account used for the initial adjustment aligns with the company’s accounting treatment.
The initial cost of inventory should not be confused with the selling price of the item.
Important recommendations
- Keep a copy of the original Excel file.
- Use the exact names of the configured accounts.
- Check the classification of each item.
- Check the dates and initial stock levels before importing.
- Verify the initial value and the inventory adjustment account.
- Correct the errors indicated by QuickBooks before retrying the import.
Result of the procedure
Once the import is complete, the products and services will be available in QuickBooks Online with their corresponding names, prices, classifications, and accounting accounts. Inventory items can be used to track stock levels, provided they are configured correctly.
Do you need help?
If you have questions regarding the bulk import of products, accounting classification, or inventory configuration, our team can help you.
Mondragón & Associates
WhatsApp: 4000-3589










