How to Import Discount Items into QuickBooks Desktop?

Importing discount items into QuickBooks Desktop (QBDT) helps businesses accurately apply sales discounts, promotional offers, customer-specific reductions, and invoice-level adjustments without manual setup. Many users search for this process when they need to transfer discount item lists from Excel, CSV files, eCommerce platforms, POS systems, or legacy accounting software into QuickBooks. It is especially useful for businesses handling seasonal promotions, wholesale pricing, or recurring discount structures that require organized item management inside QBDT.

This article explains the prerequisites for importing discount items, the required file formatting standards, and the available import methods. It also covers manual item creation, IIF imports, and automated tools like Dancing Numbers for faster and error-free bulk uploads.

Prerequisites for Importing Discount Items into QuickBooks Desktop

Before importing discount items into QuickBooks Desktop, it is important to properly prepare your company file, accounts, and spreadsheet data.

• Use a supported QuickBooks Desktop version such as Pro, Premier, or Enterprise
• Update QuickBooks Desktop to the latest release
• Prepare your Excel or CSV file with proper formatting
• Use a single header row with fields like Item Name, Rate, and Account
• Ensure discount amounts contain only numeric values
• Remove special characters, blank rows, and merged cells
• Verify that all required accounts already exist in QuickBooks
• Ensure discount item names are unique to avoid duplicates
• Save the file in .CSV or .XLSX format
• Create a backup of your QuickBooks company file before importing

Supported Discount Types in QuickBooks Desktop

QuickBooks Desktop supports multiple types of discount items that can be used during sales transactions, invoices, and promotional pricing setups.

• Percentage-Based Discounts: Used for discounts like 10% off or 25% seasonal promotions.
• Fixed Amount Discounts: Applies a specific discount value such as $5 or $20 off an invoice.
• Customer-Specific Discounts: Created for selected customers, wholesale clients, or loyalty programs.
• Promotional Discounts: Used for limited-time offers, festive sales, and marketing campaigns.
• Invoice-Level Discounts: Applied to the entire invoice total instead of individual line items.
• Product or Service Discounts: Used for discounts associated with specific products or services.

Method 1: Manually Creating Discount Items in QuickBooks Desktop

For businesses with a small number of discount items, manual creation is the simplest option.

• Open QuickBooks Desktop and go to the Lists menu
• Select Item List from the dropdown
• Click the Item button located at the bottom left corner
• Choose New to create a new item
• Select Discount as the item type
• Enter the Item Name for the discount
• Add a description explaining the discount purpose
• Enter the discount rate or percentage
• Select the linked income or discount account
• Configure tax settings if applicable
• Click OK to save the discount item
• Review the item in the Item List to confirm successful creation

This method is best for businesses managing only a few discount items.

Method 2: Importing Discount Items Using Add/Edit Multiple List Entries

QuickBooks Desktop allows users to create and update discount items in bulk using the Add/Edit Multiple List Entries feature.

• Prepare your Excel sheet with columns like Item Name, Type, Description, Amount/Percent, and Account
• Set the Item Type as “Discount” for all discount entries
• Open QuickBooks Desktop and go to the Lists menu
• Select Add/Edit Multiple List Entries
• Click on Customize Columns from the top-right corner
• Add and arrange columns to match your Excel sheet headers
• Copy the discount item data from your Excel spreadsheet
• Paste the data directly into the QuickBooks entry grid
• Review all item details carefully before saving
• Verify that accounts and discount values are mapped correctly
• Click Save Changes to import the discount items into QuickBooks Desktop
• Open the Item List to verify that all discount items were imported successfully

This method works best for businesses that want to import small or medium-sized discount item lists without using IIF files or third-party tools.

Method 3: Importing Discount Items Using IIF Files

IIF files allow bulk import of discount items directly into QuickBooks Desktop.

• Open QuickBooks Desktop and navigate to the File menu
• Select Utilities, then choose Import and click IIF Files
• Locate your prepared .IIF file on your computer
• Ensure the file includes correct item headers and formatting
• Verify item names, discount rates, and account mappings
• Click Open to begin the import process
• Wait for the import confirmation message
• Review the import summary for failed entries or formatting issues
• Open the Item List to verify imported discount items

This method works well for bulk imports but requires precise formatting knowledge.

Method 4: Using Dancing Numbers to Import Discount Items into QuickBooks Desktop

• Open Dancing Numbers and connect it with your QuickBooks Desktop Company File
• From the dashboard, locate the Import option and click on it
• Click the Browse File button to upload your Excel or CSV file
• Select the file from your local system
• Choose Discount Item as the QuickBooks transaction or item type
• You can also download and use the sample template file provided by Dancing Numbers
• Map the spreadsheet columns with QuickBooks fields like Item Name, Description, Discount Rate, and Account
• If you use the Dancing Numbers template, field mapping may happen automatically
• Review the imported data on the Review Grid screen
• Verify that all discount item details are correctly aligned
• Click on Send to QuickBooks to start the import process
• Wait for the confirmation message indicating successful import
• Open the Item List in QuickBooks Desktop
• Verify that all discount items have been imported correctly

This method is ideal for businesses handling bulk discount item imports, as it minimizes manual work and improves data accuracy.

Go through the below table with a detailed description of Mapping fields before beginning the import setting.

Field Mapping Details for Importing Discount Items

Review the table below to understand the commonly used fields while importing discount items into QuickBooks Desktop.

Field Name	Format	Description
Item Name	String (up to 31 characters)	Required field used to define the discount item name
Parent Full Name	String	Displays the parent item name if the discount item is created under a hierarchy
Is Active	Boolean (True/False)	Specifies whether the discount item is active or inactive
Class Ref Full Name	String (up to 159 characters)	Defines the class or category associated with the discount item
Sales Tax Code Full Name	String	Indicates whether the discount item is taxable or non-taxable
Description	String (up to 4095 characters)	Description that appears on invoices and sales forms
Discount Rate Percentage	Decimal	Defines the percentage discount applied to the item
Discount Amount	Decimal	Specifies a fixed discount amount such as $5 or $10
Account Full Name	String (up to 159 characters)	Defines the discount or income account linked with the item
Barcode Value	String (up to 50 characters)	Stores the barcode value associated with the item, if applicable

Note: Depending on the discount setup, you may use either the Discount Rate Percentage field or the Discount Amount field during import.

Common Errors While Importing Discount Items

Here are a few errors that you will encounter when you are importing discount items into QuickBooks Desktop. In case you have encountered any of these errors, check our its causes and solutions in the table given below:

Error Name	Cause	Solution
Invalid Item Type Error	Incorrect item category selected	Ensure item type is set as Discount
Duplicate Item Name Error	Item already exists in QuickBooks	Rename duplicate entries before import
Account Mapping Failure	Linked account does not exist	Create required accounts before importing
File Format Error	Unsupported spreadsheet formatting	Save file as CSV or XLSX
Missing Required Fields	Essential columns are blank	Complete all mandatory fields

Preventive Tips to Avoid Import Errors

• Log in as QuickBooks Administrator before importing
• While Method 2 (Add/Edit Multiple List Entries) often works in Multi-User Mode, Methods 3 and 4 (IIF and third-party tools) strictly require Single-User Mode to prevent data conflicts and errors.
• Verify account mappings before starting the import
• Use properly formatted Excel or CSV files
• Remove special characters and blank rows
• Test the import with a small sample file first
• Create a backup of your company file before bulk imports
• Review imported discount items after completion

Importing discount items into QuickBooks Desktop helps businesses streamline invoicing, promotional pricing, and customer discount management. While manual entry is suitable for smaller datasets, bulk imports require careful formatting and validation to avoid errors. By preparing your files correctly and using reliable import methods, you can maintain organized and accurate discount item records inside QuickBooks Desktop.

If manual imports become difficult or time-consuming, using an automated solution like Dancing Numbers can significantly simplify the entire process.

---

Frequently Asked Questions