item details field mapping


View Categories

item details field mapping

2 min read

Table of Contents

Since key tasks such as item creation, purchase orders, receiving, and inventory adjustments are completed in QuickBooks Online, it’s important to understand how item data syncs to the register app.

The table below outlines the item fields that sync between QuickBooks Online and register. It includes details on naming conventions, the purpose of each field, the field name used in both systems, and the character limits—giving you clear insight into how your data is mapped and displayed.

register field names QuickBooks Online field names purposecharacter limit/notes
namenameItem name descriptor111 characters max; must be unique
item typeproduct/service informationindicates if the item is inventory, non-inventory, or service type
register does not support QuickBooks Online bundle type
must match one of the supported types; bundles not supported in register
skuskuused for barcode, lookup, vendor identifier111 characters max
belongs to a categoryn/aindicates whether the item is displayed in register (Yes/No)Boolean (Yes/No); auto-determined
categorycategoryused organize items and services111 characters max; optional field
quantity on handquantity on handdisplays the current stock quantitynumeric; syncs only for inventory-type items
reorder pointreorder pointhelps track when to reorder inventory based on stock thresholdsnumeric; optional field
descriptiondescriptionprovides additional information about the item or service4,000 characters max (QuickBooks Online limit); register displays truncated version if too long
sales price/ratesales price/ratethe price at which the item or service is soldUp to 2 decimal places; numeric only

account details #

At the bottom of each item record, you’ll find important account information that maps to your chart of accounts. This includes:

  • Asset account
  • Income account
  • Expense account (Cost of Goods Sold)

In addition, this section provides key audit details, such as:

  • Created by
  • Created on
  • Last modified by
  • Last modified on

These details help ensure transparency and accuracy when reviewing item history and financial mappings.

Need Help? #

If you need assistance with understanding how register syncs with QuickBooks Online contact our support team at support@abilitybusiness.com or visit Ability Wiki — register help center.

Powered by BetterDocs