Skip to content

QuickBooks Item List Export

Introduction

The QuickBooks Item List Export produces a report of all services, drugs, and items from the HMIS item master, formatted for import into QuickBooks as an Items List. This synchronises the product/service catalogue between HMIS and QuickBooks so that billing entries use consistent item names and account codes in both systems.

Reports → Reports → QB Import Reports tab → 2. Item Import Report

Producing the Item List

  1. Set From and To.
  2. Choose the Institution, Site and Department if you need to narrow the report.
  3. Click Process.
  4. Click Excel to download the result, or Print.

Item List Layout

The item list uses QuickBooks' !INVITEM header type:

!INVITEM    NAME    INVITEMTYPE DESC    PURCHASEDESC    ACCNT   ASSETACCNT  COGSACCNT   PRICE   QBCLASS
INVITEM Blood FBC   SERVICE Full Blood Count    Lab Test    4200·Lab Revenue    ... 250.00  Laboratory
INVITEM Amoxicillin 250mg   INVENTORY   ... ... 4300·Pharmacy   1300·Pharmacy Inv   5000·COGS   120.00  Pharmacy
Field Description
NAME Item name as it appears in HMIS
INVITEMTYPE SERVICE (for services) or INVENTORY (for pharmacy drugs)
DESC Sales description
PURCHASEDESC Purchase description
ACCNT Income account for sales
ASSETACCNT Asset account (inventory items only)
COGSACCNT Cost of goods sold account (inventory items only)
PRICE Standard selling price
QBCLASS QuickBooks class (department)

Importing the Item List into QuickBooks

  1. In QuickBooks Desktop, go to File → Utilities → Import → IIF Files.
  2. Select the item list file, converted to .iif format.
  3. Import.
  4. Navigate to Lists → Item List in QuickBooks to verify the imported items.

Note: Importing an item list that already exists in QuickBooks will update existing items (not duplicate them), as long as the NAME field matches exactly.

When to Run This Export

  • Initial setup: Import the full item list when first connecting HMIS to QuickBooks.
  • After adding new services or drugs: Export and re-import to add new items to QuickBooks.
  • After price changes: The export includes updated prices — re-importing updates QuickBooks prices.

A monthly or quarterly refresh is typically sufficient unless many new items are added frequently.

Account Mapping for Items

Services and drugs must map to the correct QuickBooks income account:

Item Type Example QB Income Account
OPD Consultation 4100 · Consultation Revenue
Laboratory Tests 4200 · Investigation Revenue
Pharmacy Sales 4300 · Pharmacy Revenue
Inpatient Services 4400 · Inpatient Revenue
Surgery 4500 · Surgery Revenue

Contact your system administrator to configure or update account mappings in HMIS before generating the export.

Technical Reference

Item Detail
Controller QuickBookReportController (item list report type)
Item source Item, Service, InwardService, Pharmacy Item entities
IIF type INVITEM rows
Related QB Integration Overview, QB Daily Return Import