Skip to main content

Chart of Account Mapping

Mapping your accounts is a crucial step when integrating with QuickBooks Online. Map items to your financial general ledger's chart of accounts using the Edit Item screen or Bulk Update Item feature.…

Admin CG
Updated by Admin CG

Mapping your accounts is a crucial step when integrating with QuickBooks Online.

Map items to your financial general ledger's chart of accounts using the Edit Item screen or Bulk Update Item feature.

A chart of accounts is a list of financial accounts used to map transactions to a company's general ledger. An item should be mapped to up to three of these.

Please coordinate with your CPA, Controller, or Bookkeeper for guidance on setting this up.

Account

What is it used for?

Expense Account

This account is used to record and track purchases an expenses of an item.

A suggested default is: Cost of Goods Sold

Examples: Packaging Costs, Raw Materials Costs

Income Account

This is the account is used to book revenue when an item is sold.

A suggested default is: Sales

Examples: Flower Sales, Concentrate Sales, Branded Sales

Inventory Asset Account

This account is used to book the value of inventory on the company's balance sheet.

A suggested default is: Current Assets

Examples: Raw Materials Inventory, WIP Inventory, Finished Goods Inventory

QuickBooks Item Type: Inventory vs Non-Inventory

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

  1. ✅ Flourish remains your system of record for inventory quantities
  2. ✅ BioTrack/METRC compliance data stays in sync
  3. ✅ Simpler integration with fewer sync errors
  4. ✅ No conflicts between QBO quantities and compliance system

When to use "I sell this": ☑ Finished goods (flower, pre-rolls, edibles, concentrates) ☑ Any product you invoice to customers

When to use "I purchase this": ☑ Raw materials (packaging, supplies, nutrients) ☑ Any item you buy from vendors

Most cannabis products should have:

  • Type: Non-Inventory
  • ☑ I sell this product
  • ☐ I purchase this product

Steps to map an item or set of items to your company's chart of accounts:

  1. Go to Settings.
  2. Navigate to "Inventory" Bulk Update Items in Flourish
  3. Select an Item and map the account (don't forget to save changes!)
  4. Alternatively, go to the Bulk Update Items screen to import an update. Use the last three columns, which correspond to the three accounts.
If you use the QuickBooks Online integration, the value must match an account synced from QuickBooks. If you use QuickBooks Desktop, Sage Intacct, Xero, or another system, the Bulk Update Items feature will create entries in Flourish to use going forward, as well as in the Edit Item screen.

How did we do?

Item Tagging Functionality

Configuring Item E-Commerce Categories and Subcategories

Contact