Skip to main content

Mapping Deduction Types to GL Accounts in QuickBooks Online

Learn how to set up QBO non-inventory items so your deduction types map correctly to the right GL accounts in Confido.

S
Written by Support

1. Overview

How Confido connects deduction types to GL accounts via QBO.

The dropdown you see when mapping deduction types in Confido pulls directly from your QuickBooks Online non-inventory items. This is how Confido maps each deduction type to a corresponding GL / expense account in QBO.

Before you can complete the mapping in Confido, those non-inventory items need to exist in QBO — with the correct GL account linked to each one.


2. Step 1 — Create non-inventory items in QBO

One item per deduction type you want to map.

In QuickBooks Online, create a non-inventory item for each deduction type you need. Common examples include:

  • Retail discounts

  • Short ships

  • Early pay discounts

  • Retail credits

When creating each item, link it to the corresponding GL / expense account (e.g. retail payment terms, retail credits, etc.).


3. Step 2 — Complete the mapping in Confido

Once items exist in QBO, they'll appear in the Confido dropdown.

After your non-inventory items are set up in QBO, they will automatically populate in the deduction mapping dropdown inside Confido. From there:

  1. Navigate to the deduction mapping section in Confido.

  2. For each deduction type, select the matching QBO non-inventory item from the dropdown.

  3. Save your mapping.


4. Building out your mapping over time

You don't need to map every deduction type upfront.

Start with your most common deduction types. For anything new that comes through later, Confido will prompt you to complete the mapping before you can push to the GL — so you can build it out incrementally as new deduction types appear.

Tip: If the dropdown appears empty or a deduction type is missing, check that the corresponding non-inventory item has been created in QBO and is linked to the correct GL account. If you see a push error like "There is no income account associated with…" when posting to QBO, this is the same root cause — the QBO item behind that deduction/reason mapping doesn't have a GL account set. Set the account on the item in QBO and try the push again.

Which QBO items appear in the deduction mapping dropdown?

This section is for admins at QuickBooks Online (QBO) connected companies who map deduction reasons to QBO items in Settings → Chart of Accounts. The deduction mapping dropdown lists a QBO item under a deduction GL account only when the item's income account (the Income account field under Sales information on the QBO item) is that same GL account. Confido reads this income account for each item when it syncs your QBO items.

Can a QBO deduction item use an Expense or Other Expense account?

Yes. The deduction mapping dropdown isn't limited to accounts of the Income type in your QBO chart of accounts. If the income account set on a QBO item is an Expense or Other Expense account, Confido still shows that item in the deduction mapping dropdown, and you can map it to a deduction reason.

Why is a QBO item missing from the deduction mapping dropdown?

A QBO item is usually missing from the deduction mapping dropdown because only its purchasing side is filled in (an Expense account under Purchasing information) and it has no income account. To make the item appear:

  1. In QBO, open the non-inventory item.

  2. Under Sales information, set the Income account to the GL account the deduction should post to. An Expense or Other Expense account is fine.

  3. Save the item in QBO.

  4. In Confido, sync your accounting data so the updated QBO item comes in.

  5. Go to Settings → Chart of Accounts, find the deduction GL account, and select the QBO item from the dropdown.

  6. Click Save.

Once the sync finishes, the QBO item shows up under the matching deduction GL account. If it still doesn't appear, make sure the item's income account is exactly the deduction GL account you're mapping. Then email [email protected] with the item name and the GL account.

Limitation: Filling in only the Expense account under Purchasing information isn't enough, because Confido doesn't read that field for deduction mapping. Workaround: Set the same GL account as the item's Income account in QBO, then sync again.


5. Quick reference

Step

Where

What to do

1

QuickBooks Online

Create a non-inventory item for each deduction type and link it to the correct GL account

2

Confido

Open the deduction mapping dropdown — your QBO items will now appear

3

Confido

Select the matching item for each deduction type and save

Did this answer your question?