Chart of Account Mapping

Purpose

Map your items to your company's chart of accounts so financial transactions post correctly to your general ledger. This mapping is a required step when integrating with QuickBooks Online, and Flourish also supports it for QuickBooks Desktop, Sage Intacct, Xero, and other accounting systems.

Map items using the Edit Item screen or the Bulk Update Items feature.

Coordinate with your CPA, Controller, or Bookkeeper for guidance on which accounts to use.

Understand the chart of accounts

A chart of accounts is a list of financial accounts used to map transactions to your company's general ledger. Map each item to up to three accounts:

Account	What it's used for
Expense Account	Records and tracks purchases and expenses for an item. Suggested default: Cost of Goods Sold. Examples: Packaging Costs, Raw Materials Costs.
Income Account	Books revenue when an item is sold. Suggested default: Sales. Examples: Flower Sales, Concentrate Sales, Branded Sales.
Inventory Asset Account	Books the value of inventory on your company's balance sheet. Suggested default: Current Assets. Examples: Raw Materials Inventory, WIP Inventory, Finished Goods Inventory.

Choose an item type: Inventory vs. Non-Inventory

We recommend the Non-Inventory item type for all cannabis products because it:

Keeps Flourish as your system of record for inventory quantities
Keeps BioTrack/METRC compliance data in sync
Simplifies the integration and reduces sync errors
Avoids conflicts between QBO quantities and your compliance system

Check I sell this product for finished goods (flower, pre-rolls, edibles, concentrates) and any product you invoice to customers.

Check I purchase this product for raw materials (packaging, supplies, nutrients) and any item you buy from vendors.

Most cannabis products should have:

Type: Non-Inventory
I sell this product: checked ("Sellable")
I purchase this product: unchecked ("Purchasable")

Map an item to your chart of accounts

Click Settings.
Select Inventory.

Select an Item, map the Expense Account, Income Account, and Inventory Asset Account, then save your changes.

Alternatively, go to Bulk Update Items to import updates for multiple items at once. Use the last three columns in the template, which correspond to the three accounts.

If you use the QuickBooks Online integration, each value must match an account synced from QuickBooks. If you use QuickBooks Desktop, Sage Intacct, Xero, or another system, Bulk Update Items creates entries in Flourish to use going forward, and those entries also become available on the Edit Item screen.

Sync an item to QuickBooks from the Item screen

Once you save an item's chart of accounts mapping, sync that item to QuickBooks Online directly from the Item details view screen using the Sync to QB button, which appears under the Inventory Asset Account field. This gives you a faster way to sync an individual item without navigating to Integrations > QuickBooks Online > Map Items.

Sync to QB syncs the item's saved state to QuickBooks, so save your account mapping on the Edit Item screen first.

Chart of Account Mapping