/ /

How to Format Discount Line Items in QuickBooks Online for Kintsugi

Format ad-hoc discount lines on QuickBooks Online invoices (Discount % name, negative amount, directly under the sale line) so Kintsugi imports line amounts correctly.
Updated 53 seconds ago

Some businesses give discounts by adding a separate discount line to a QuickBooks Online invoice, instead of using the invoice's built-in discount field. If that's you, the way you lay out each discount line tells Kintsugi which product it belongs to. Follow the format below and the amounts in Kintsugi will match your invoice, line by line.

Time required: About 2 minutes per invoice

You will need:

  • An active QuickBooks Online connection in Kintsugi

  • Permission to create and edit invoices in QuickBooks Online


Is This Article for You?

Yes, if you add discounts to your invoices as their own lines with a negative amount (sometimes called ad-hoc or line-item discounts). If you only use the discount field at the bottom of a QuickBooks Online invoice, this format doesn't apply to you.


The Three Rules

Rule

What it looks like

1. The discount line's name includes the text Discount %

Discount % Item A

2. The discount amount is negative

-$50.00

3. The discount line sits directly under the sale line it reduces

Sale line, its discount line, next sale line, its discount line

Important: Kintsugi needs all three. If a discount line breaks any of them, Kintsugi can't match it to the right product, and the line amounts in Kintsugi may not match QuickBooks Online.


Steps in Formatting Discount Line Items

  1. Open the invoice in QuickBooks Online.
    Create a new invoice or open an existing one.

  2. Add the product line.
    Enter the product or service, quantity, and amount as usual.

  3. Add the discount line directly below it.
    Don't place any other product between the sale line and its discount line.

  4. Name the discount line with Discount %.
    Choose or create a product or service whose name includes Discount %, for example, Discount % Item A. Adding the product name after it makes each discount easy to spot later.

  5. Enter the discount as a negative amount.
    For a $50.00 discount, enter -50.00.

  6. Repeat for each discounted product.
    Every discounted product gets its own discount line right below it.

  7. Save the invoice.

Example

All amounts are in USD.

Line

Product or service

Amount

1

Item A

$100.00

2

Discount % Item A

-$50.00

3

Item B

$300.00

4

Discount % Item B

-$100.00

Invoice total

$250.00

Here's how Kintsugi reads it:

  • Line 2 reduces Line 1, so Item A imports as $50.00.

  • Line 4 reduces Line 3, so Item B imports as $200.00.

  • The invoice total in Kintsugi is $250.00, the same as in QuickBooks Online.


What to Avoid

Instead of this

Do this

All products first, with one discount line at the bottom

One discount line directly under each product it reduces

A discount line named Promo, Rebate, or Loyalty Credit

A name that includes Discount %, such as Discount % Item A

A discount entered as a positive amount

A negative amount, such as -50.00

Editing the transaction in Kintsugi to fix the amounts

Fixing the invoice in QuickBooks Online, since the next sync replaces edits made in Kintsugi


How to Confirm It Worked

  1. Wait for the invoice to sync to Kintsugi.

  2. Log in to Kintsugi and go to Transactions.

  3. Find the invoice by its QuickBooks Online invoice number and open it.

  4. Check the Amount for each product. Each one should equal the sale price minus its own discount, and the total should match your QuickBooks Online invoice.

Tip: Compare the Amount column, not the Subtotal. The Subtotal shows prices before discounts, so it will be higher than your invoice total.


Things to Know

  • This format is for QuickBooks Online invoices. QuickBooks Desktop and QuickBooks Enterprise Desktop are not supported.

  • A discount line reduces only the sale line directly above it. It is never spread across other products on the invoice.

  • Kintsugi recognizes a discount line by three things only: its name, its negative amount, and its position on the invoice.

  • Kintsugi doesn't change your QuickBooks Online invoices. You make corrections in QuickBooks Online, and Kintsugi imports the result.

  • Invoices that synced before October 28, 2026 may still show different line amounts. Contact us and we can refresh them for you.

  • This article doesn't cover QuickBooks Online's built-in invoice discount field.


FAQs

Q: Why don't the product amounts in Kintsugi match my QuickBooks Online invoice?
A: Usually a discount line breaks one of the three rules. It isn't directly under its product, its name doesn't include Discount %, or its amount is positive. Correct the invoice in QuickBooks Online. If the amounts still don't match after the next sync, contact us and we'll take a look.

Q: Can I add one discount line at the bottom for the whole invoice?
A: Not with this format. Kintsugi can't tell which product a bottom discount line belongs to. For a discount on the whole invoice, use QuickBooks Online's built-in discount field instead.

Q: Does the percentage need to be in the name, like "Discount 10%"?
A: No. The name needs the exact text Discount %, with the percent sign right after the word Discount. Kintsugi subtracts the dollar amount you enter on the line.

Q: Why does my transaction still show a message that it's being processed?
A: That message is about the invoice address, not the discount. It stays until Kintsugi can verify the ship-to or bill-to address. See How to Enter Customer Addresses Correctly in QuickBooks.


Need Help?

For further concerns, we're always here to help. If you can't find the answer you're looking for, reach out to us using the chat in the bottom right corner of your screen.

Was this article helpful?