Map Shopify Discount to Discount Line Items in QuickBooks Online Sales Receipts and Refund Receipts

'How to' Tips
, , , , ,
1

Overview

When syncing Shopify orders to QuickBooks Online, weintegrate provides you with a choice recording the discount in the standard QuickBooks Online discount field (the default) or the option of recording the discount as a dedicated line item instead.

mapping_shopify_discount_as_line_item
mapping_shopify_discount_as_line_item1396×723 66.2 KB

This setting is supported for these QuickBooks Online transaction types:

Why Map Discounts as Line Items?

By default, discounts may be applied as adjustments to the overall transaction. However, mapping discounts as separate line items provides:

  • Enhanced visibility: Track discount performance and impact at the line-item level
  • Improved reporting: Generate detailed reports on discount usage and effectiveness across all transaction types
  • Better reconciliation: Simplify month-end closing with granular discount tracking
  • Class tracking: Optionally assign QuickBooks Online classes to discount line items for departmental or location-based reporting
  • Accurate financial data: Maintain consistency between Shopify and QuickBooks Online for audit purposes
  • Works with all record types: Same configuration applies whether you use Sales Receipts or Invoices

Prerequisites

Before configuring discount line item mapping, ensure you have:

  1. Service Item Created: A dedicated Service-type item in QuickBooks Online for tracking discounts
  2. Class Tracking Enabled (Optional): If you plan to assign classes to discount line items, class tracking must be enabled in QuickBooks Online

How to Configure Discount Line Item Mapping

Step 1: Access Sales & Deposits Settings

  1. Navigate to your Shopify connection settings in weintegrate
  2. Locate the Sales & Deposits tab
  3. Scroll to the Sales section

Step 2: Enable Discount as Line Item

  1. Locate the checkbox labeled “Create Discount as Line Item in QuickBooks Online”
  2. Check this box to enable discount line item mapping
  3. The Discount Line Item dropdown field will appear below

Step 3: Select Your Discount Service Item

  1. Click the Discount Line Item dropdown menu
  2. Select the Service-type item you created in QuickBooks Online for tracking discounts
  3. You can search by typing the product name in the search field

Step 4: Assign Class to Discount Line Item (Optional)

If you want to track discounts by department, location, or other classifications:

  1. Check the “Assign Class to Discount Line Item” checkbox
    • This option only appears if class tracking is enabled in QuickBooks Online
    • If the checkbox appears greyed out, you need to enable class tracking first
  2. Select your desired class or sub-class from the Class dropdown menu
  3. All discount line items will be assigned to this class on all transaction types

For detailed instructions on class assignment, see: Set a QuickBooks Online Class to Discount Line Items by Store Connection

Step 5: Save Configuration

  1. Review your selections
  2. Click Save or Next (depending on whether you’re in the setup wizard or editing an existing connection)
  3. Your discount line item mapping will be applied to all future transactions

What Happens After Configuration

Once enabled (this setting is not retroactive), weintegrate on new orders created after saving this setting will:

  1. Create a separate line item for discounts on your configured QuickBooks Online transaction type
  2. Apply the discount amount from Shopify to the line item
  3. Map the line item to your selected QuickBooks Online service item
  4. Apply the selected class (if configured) to enable class-based reporting
  5. Maintain accurate synchronization between Shopify and QuickBooks Online

Troubleshooting

The “Create Discount as Line Item” checkbox doesn’t appear

The “Assign Class to Discount Line Item” checkbox is greyed out

Discounts aren’t appearing on transactions

  • Verify the checkbox is enabled in Sales & Deposits settings
  • Ensure you’ve selected a valid Service item from the dropdown
  • Check that the Shopify orders contain discount information
  • Review a recently synced order to confirm the discount line item appears

Discount amounts don’t match between Shopify and QuickBooks

  • Verify the Service item is not marked as taxable if discounts should be tax-exempt
  • Check the discount calculation method in your Shopify store
  • Contact support if discrepancies persist

Related Topics