Accounting

Cannabis Inventory Accounting for New Mexico Businesses

Specialized cannabis inventory accounting for New Mexico operators that connects operational inventory, physical counts, accounting values and the general ledger — so cost of goods sold, gross margin and ending inventory are supported by records that can be traced rather than estimated.

Operational Inventory ↔ Physical Inventory ↔ Accounting Inventory ↔ General Ledger

Nearly every cannabis inventory problem we are asked to solve in New Mexico lives in the space between four records: what the seed-to-sale system says, what is physically on the shelf, what the inventory schedule values, and what the general ledger reports. Each record is created by a different process, maintained by a different team, and used for a different purpose. None of them is wrong on its own; the failure is that they are never reconciled to each other.

This engagement builds and maintains that reconciliation. We tie the operational quantity record to physical counts, attach supported cost to those quantities, roll the result forward month by month, and prove the ending balance against the general ledger. What comes out the other side is an inventory figure with a documented derivation — and, because cost of goods sold is derived from inventory, a COGS figure and gross margin that management can actually rely on.

The work is deliberately narrow in focus and deep in execution. It is not general bookkeeping, it is not tax return preparation, and it is not seed-to-sale compliance. It is the inventory value and reconciliation layer that all three of those depend on.

  • Inventory-to-general-ledger reconciliation performed as a monthly roll-forward
  • Inventory valuation methods documented and applied consistently across periods
  • Purchase, receiving, transfer and adjustment procedures reviewed and corrected
  • Physical and cycle count support, including cutoff discipline at period end
  • Cost of goods sold support and gross margin review by location and category
  • Cleanup and reconstruction where inventory has not reconciled for months or years

Who This Engagement Is Built For

Dispensaries whose POS inventory, seed-to-sale record and accounting inventory each report a different number; cultivators carrying production cost across period ends with no work-in-process discipline; manufacturers converting inputs into finished goods without a traceable cost per unit; and multi-location or multi-entity operators whose consolidated inventory balance is correct in total and wrong everywhere underneath it.

It is also built for operators approaching a year-end, a lender review, a transaction or an examination who have discovered that ending inventory cannot be supported with documentation. That situation is recoverable, but it is recovered by reconstruction from source records rather than by an adjusting entry.

Engagements run remotely using your accounting, seed-to-sale and point-of-sale systems, for licensed operators across New Mexico.

Printed cannabis financial statements, tax schedules and a calculator on an executive desk

The system

Cannabis Inventory Accounting for New Mexico Businesses

Cannabis inventory accounting is the process of recording, valuing and reconciling inventory activity so that physical inventory, operational inventory records and the accounting system agree — and so that the general ledger, cost of goods sold and the financial statements are supported by records that can be traced back to real activity.

  1. Purchase / production
  2. Inventory
  3. Operational · physical · financial
  4. Reconciliation
  5. General ledger
  6. COGS
  7. Gross profit
  8. Financial reporting

Most inventory problems in New Mexico cannabis businesses are not tracking problems. The operational system usually knows how many units exist. What breaks is the connection between those units and the dollars sitting in the inventory account on the balance sheet. When that connection is missing, cost of goods sold becomes an estimate, gross margin becomes unreliable, and the tax workpapers rest on numbers nobody can trace.

This page describes the commercial engagement. For educational background on the underlying concepts, see the New Mexico inventory accounting guide and the New Mexico cannabis accounting guide.

Definition

What Is Cannabis Inventory Accounting?

Cannabis inventory accounting tracks the financial value of inventory from purchase or production through sale, transfer, adjustment and ending inventory, so that the general ledger and cost of goods sold are supported by reliable records rather than estimates.

Four different inventory records and what each one answers
RecordWhat it representsQuestion it answers
Operational inventoryQuantity and movement data in the seed-to-sale or POS systemHow many units moved, and where?
Physical inventoryWhat is actually on the shelf, in the vault or in the roomWhat exists right now?
Accounting inventoryFinancial value carried in the inventory subledger or scheduleWhat is it worth in the books?
General ledgerThe financial record that feeds the balance sheet and COGSWhat do the financial statements say?

INVENTORY QUANTITY ≠ FINANCIAL INVENTORY VALUE

A unit count is a quantity fact. An inventory value is an accounting conclusion that depends on cost basis, timing, and which costs the business supports capitalizing. Two operators holding identical shelves can carry very different inventory values, and both can be correct, because the cost histories behind those units differ. The purpose of inventory accounting is not to force the four records above into one number — it is to make the differences between them explainable and documented.

Why it matters

Why Cannabis Inventory Accounting Matters

Inventory sits at the center of a cannabis income statement. Almost everything that happens operationally — purchasing, receiving, production, transfers, adjustments, counts and sales — eventually resolves into two numbers: what remains in ending inventory and what flowed through to cost of goods sold. Those two numbers then determine gross profit, margin, reported earnings and the starting point for tax workpapers.

  1. Purchase / production
  2. Inventory
  3. Sale
  4. COGS
  5. Gross profit
  6. Financial reporting
  • Purchasing and receiving determine what enters inventory and at what cost
  • Production activity determines what is converted and what remains in process
  • Transfers determine which location or entity carries the value
  • Adjustments determine whether differences are documented or absorbed silently
  • Physical counts determine whether the books reflect reality at period end
  • Ending inventory determines COGS, and COGS determines gross profit

A business with unreliable inventory does not simply have an inventory problem. It has an income statement it cannot defend, a balance sheet with a growing unexplained asset, and a year-end that turns into a reconstruction project. Operators in Albuquerque, Santa Fe and Las Cruces most often discover this at tax time, when the ending inventory figure has to be supported and no one can explain how it was derived.

Core distinction

Operational Inventory vs Accounting Inventory

Operational inventory measures units, packages and movements. Accounting inventory measures financial value. The two systems must be reconciled to each other, but they are not interchangeable and neither one replaces the other.

Operational inventory compared to accounting inventory
Operational inventoryAccounting inventory
Units, grams and package countsFinancial value and cost basis
Lots, batches and package identifiersInventory subledger and GL balances
Movements, transfers and adjustmentsJournal entries supporting each change
Regulatory and operational trackingEnding inventory value and COGS support
Answers: what moved and whereAnswers: what it costs and what it is worth
Owned by operations and compliance staffOwned by accounting and reviewed at close

QUANTITY ≠ VALUE

Confusing the two produces predictable failures. A team that treats the operational report as an accounting record will book inventory at whatever the system displays, ignoring cost layers, freight, production cost and timing. A team that treats the accounting balance as an operational record will assume the shelf matches the ledger and stop counting. The discipline that works is simpler: keep both records complete, reconcile them on a schedule, and document every difference rather than deleting it.

Counts

Physical Inventory vs Book Inventory

Physical inventory is what exists. Book inventory is what the records say exists — and there are usually two book records, the operational system quantity and the accounting value. A useful reconciliation compares all three rather than two.

  1. Physical count
  2. Operational record
  3. Accounting record
  • Count sheets prepared by location, room and product category
  • Counts performed with a defined cutoff so late movements do not distort the result
  • Quantity differences identified against the operational system first
  • Value differences identified against the inventory schedule second
  • Every difference investigated before any entry is proposed
  • Documentation retained: count sheets, reviewer, date, and explanation

A difference is not automatically a loss. It is frequently a timing issue, a mis-scanned package, a transfer recorded in one system and not the other, a receiving entry booked into the wrong period, or a unit-of-measure inconsistency. Writing differences off on sight destroys the evidence needed to find the underlying process defect, and it converts an explainable variance into an unexplained charge to cost of goods sold.

Practitioner core

Inventory-to-General-Ledger Reconciliation

Inventory-to-GL reconciliation proves that the inventory value supported by the operational and physical records agrees with the inventory balance reported in the general ledger, with every difference identified, explained and supported by a documented entry.

  1. Operational inventory report
  2. Accounting inventory schedule
  3. General ledger inventory balance
  4. Reconciliation

The reconciliation is built as a roll-forward rather than a snapshot comparison. A snapshot tells you the two numbers differ; a roll-forward tells you where they began to differ, which is the only version that leads to a fix.

  1. 01Beginning inventory balance agreed to the prior period close
  2. 02Purchases and receipts added from vendor bills and receiving records
  3. 03Production activity added where the business converts inputs into finished goods
  4. 04Transfers in and out identified by location and entity
  5. 05Documented adjustments applied with their supporting explanation
  6. 06Cost relieved for the period's sales
  7. 07Ending balance computed and compared to the general ledger
  8. 08Residual differences investigated, explained and cleared with supported journal entries

The output is a reconciliation file, not a single number. When a lender, a reviewer or a tax preparer asks how ending inventory was determined, that file is the answer. Building it monthly is ordinary work; building it once a year for twelve months at a time is a reconstruction project. This work sits directly beside cannabis bookkeeping and feeds financial reporting.

Valuation

Cannabis Inventory Valuation

Inventory valuation determines what dollar amount attaches to the units on hand. For a reseller, that generally begins with purchase cost and the other acquisition costs the business supports including. For a producer, valuation may also involve production costs and, where relevant, work in process and finished goods. The right approach depends on the business model, the license type, the systems in place and the facts of the operation — not on a single universal method.

Purchase cost

The invoiced cost of product acquired for resale, tied to the vendor bill and the receiving record.

Production cost

Where the business produces rather than resells, costs incurred in converting inputs into finished goods, applied on a documented and consistent basis.

Freight and related costs

Costs of getting inventory to its point of use, where they are applicable, supportable and consistently treated.

Work in process

Where relevant, production that has begun but is not yet complete at period end.

Finished goods

Completed inventory available for sale or transfer, carried at its supported cost.

Ending inventory

The valued balance at period end that ties to the general ledger and supports the COGS calculation.

FINANCIAL INVENTORY VALUATION ≠ AUTOMATIC FEDERAL TAX TREATMENT

A cost classified one way for financial reporting is not automatically treated the same way for federal tax purposes. Those are separate analyses that share the same underlying records. The accounting work here is to produce records complete enough that the tax analysis can be performed on facts rather than assumptions — see 280E tax planning for that side of the work.

Deepest section

Cannabis COGS Accounting

Cost of goods sold is derived from inventory. Conceptually, beginning inventory plus applicable inventory activity for the period, less ending inventory, equals cost of goods sold for that period — which means COGS is only as reliable as the inventory records behind it.

BEGINNING INVENTORY + APPLICABLE INVENTORY ACTIVITY − ENDING INVENTORY = COGS

NET SALES − COGS = GROSS PROFIT

Read those two equations together and the consequence is unavoidable: every inventory error becomes a COGS error, and every COGS error becomes a gross profit error. If ending inventory is overstated, COGS is understated and margin looks better than it is. If ending inventory is understated, COGS is overstated and margin looks worse. Neither distortion announces itself; both simply appear as a margin that management cannot explain.

  • Missing vendor bills understate inventory activity and distort COGS timing
  • Purchases expensed directly instead of capitalized inflate cost in one period and starve the next
  • Unrecorded transfers move product without moving value
  • Unsupported adjustments push differences into COGS with no explanation
  • Cutoff errors shift activity into the wrong period on both sides of the equation
  • Mixed locations or entities make consolidated COGS meaningless at the unit level

A supported COGS figure is one where each component can be traced: beginning balance to the prior close, activity to source documents, ending balance to a count and a valuation schedule. That traceability is what makes the number usable for management reporting, for lenders, and for the tax workpapers that follow.

Margin

Inventory Accounting & Gross Margin

GROSS PROFIT ÷ NET SALES = GROSS MARGIN %

Gross margin is the metric operators watch most closely and the one inventory errors distort most easily. Before concluding that margin moved because of pricing, discounting or product mix, the inventory record has to be eliminated as the cause.

Common inventory causes of distorted gross margin
SymptomInventory cause to rule out first
Margin spikes in one monthEnding inventory overstated, or purchases recorded late
Margin collapses in one monthPrior overstatement correcting, or a large unsupported adjustment
Margin drifts steadily downwardInventory value accumulating without relief for sales
Margin differs sharply between locationsTransfers or purchases coded to the wrong location
Margin cannot be explained at allInventory never reconciled to the general ledger

We do not publish benchmark margins for New Mexico cannabis businesses, because a benchmark computed from unreliable inventory data is worse than no benchmark. The useful comparison is a business against its own reconciled history.

Inbound

Cannabis Inventory Purchases

  1. Order
  2. Receipt
  3. Vendor bill
  4. Inventory
  5. Accounts payable
  6. Payment

The purchasing cycle is where most inventory value enters the books, and where most of it goes wrong. The failure is rarely dramatic — a bill entered before the product arrives, a receipt with no bill behind it, a payment recorded as an expense because the bill was never entered at all. Each one breaks the tie between quantity and value at the moment the value is created.

  • Purchase orders where the business uses them, matched to receipts
  • Vendor bills entered with the correct date, location and entity coding
  • Inventory recognized when the business takes the product, not when it pays
  • Accounts payable carrying the obligation until payment clears
  • Payments applied to bills rather than posted directly to expense
  • Vendor statements reviewed periodically for bills never received

Inbound

Cannabis Inventory Receiving

Receiving is the point where an operational event and an accounting event have to agree. The operations team records a quantity received into the tracking system; accounting records a value received into inventory. When those two events happen on different dates, in different periods, or with different quantities, the reconciliation that follows inherits the difference.

  • Received quantity documented and matched against the vendor's paperwork
  • Vendor invoice matched to what was actually accepted, not what was shipped
  • Receiving date used consistently for both operational and accounting records
  • Location and entity identified at receipt, not reconstructed later
  • Cost captured at receipt so the value attaches to the correct units
  • Short shipments, rejections and returns documented rather than absorbed

A receiving process that produces a single dated document tying quantity, cost, location and entity together eliminates most month-end inventory disputes before they start.

Movement

Cannabis Inventory Transfers

Transfers move product. They do not automatically move value, and they do not automatically create the correct accounting result. A transfer between two rooms in the same facility, a transfer between two locations of the same company, and a transfer between two separate legal entities are three different accounting situations that can look identical in an operational report.

PHYSICAL / OPERATIONAL TRANSFER ≠ AUTOMATIC ACCOUNTING TREATMENT

Transfer types and their accounting consequence
Transfer typeAccounting consideration
Room to room, same locationGenerally no change in inventory ownership or total value; internal detail only
Location to location, same entityInventory value moves between location-level records; consolidated total unchanged
Entity to entityOwnership changes; separate books must reflect the movement on both sides
In transit at period endRequires a cutoff decision so the value is counted once, in the correct place

We address the accounting consequence of transfers; we do not provide regulatory transfer instructions. Where the operational movement is recorded in a seed-to-sale system, that record is evidence for the accounting entry, not a substitute for it — see seed-to-sale reconciliation.

Movement

Cannabis Inventory Adjustments

An inventory adjustment is a documented correction supported by evidence — a count difference, damage, a return, a timing correction or a system error that has been investigated. It is not a plug used to force the books to agree.

ADJUSTMENT = SUPPORTED CHANGE · ADJUSTMENT ≠ UNSUPPORTED PLUG ENTRY

  • Count differences confirmed by a recount before any entry is made
  • Damaged or unsellable product documented with date, quantity and reason
  • Waste where applicable, recorded consistently period over period
  • Customer or vendor returns tied to the original transaction
  • Timing corrections identified as timing rather than loss
  • System corrections explained, with the underlying defect noted

The test we apply is simple: could an independent reviewer, six months later, read the supporting documentation and reach the same conclusion? Adjustments that pass that test strengthen the inventory record. Adjustments that exist only to close a gap weaken every number downstream of them, including COGS and the tax workpapers.

Variances

Cannabis Inventory Shrinkage & Variances

A variance is the difference between the system quantity and the physical count. It is a measurement, not a conclusion. The accounting question is what the variance represents and whether the evidence supports recording anything at all.

  1. 01Quantify the variance by product, location and period
  2. 02Recount to confirm the physical figure before analysis begins
  3. 03Trace recent receipts, transfers and adjustments for the affected items
  4. 04Check unit-of-measure and package-conversion consistency
  5. 05Review cutoff around the count date on both systems
  6. 06Document the conclusion, and record an accounting effect only where supported

We do not imply theft or wrongdoing without evidence, and we do not publish industry shrink benchmarks. Most variances we investigate in New Mexico operations resolve into process issues: conversions between grams and units, transfers logged in one system only, or counts performed while product was moving.

Counts

Cycle Counts & Physical Counts

Recurring counts exist, from an accounting standpoint, to keep the gap between records and reality small enough to investigate. A business that counts once a year is investigating twelve months of accumulated difference at the worst possible moment. A business that cycle counts high-value categories regularly finds a defect while its cause is still traceable.

  • Identify quantity differences early, while source documents are still available
  • Validate that operational system records reflect actual movement
  • Support period-end inventory with contemporaneous evidence
  • Improve the quality and speed of inventory-to-GL reconciliation
  • Provide the count basis behind a supported COGS calculation
  • Reduce the size of the year-end reconstruction effort

Counting cadence is an operational decision that also has regulatory dimensions; we address the accounting purpose and do not prescribe regulatory counting schedules.

Close

Inventory Cutoff at Month-End

Cutoff is the discipline of putting each transaction in the period where it belongs. It is the single most common source of inventory differences that look inexplicable, because the amounts are usually correct — only the period is wrong.

  1. Period-end activity
  2. Cut-off review
  3. Correct period
  4. Ending inventory
Cutoff conditions and the correct treatment
ConditionWhat to review
Received but not recordedProduct accepted before period end with no vendor bill entered — accrue or record based on the receiving evidence
Recorded but not receivedBill entered for product that had not arrived — the value belongs in the following period
Sales near period endConfirm the sale and the cost relief fall in the same period
Transfers in transitConfirm the value is counted once, by one location or entity
Late vendor invoicesCompare against receiving logs before closing the period

By license type

Dispensary Inventory Accounting

  1. Purchase
  2. Inventory
  3. POS sale
  4. COGS
  5. Store gross profit

A retail location buys finished product, holds it, and sells it. The accounting looks simple until you count the systems involved: a purchasing process, a seed-to-sale record, a POS system, a bank account and an accounting system, each holding a partial version of the truth. Dispensary inventory accounting is the work of making those partial versions agree.

  • Retail purchases recorded to inventory with vendor bills matched to receipts
  • Receiving tied to the operational record at the package level
  • POS sales summarized and reconciled to recorded revenue
  • Cost relieved for sales so inventory and COGS move together
  • Physical counts performed by category and reconciled to both systems
  • Store-level inventory value and gross margin reported separately per location

For the full retail accounting engagement — revenue, cash, deposits, store P&L and reporting — see dispensary accounting. This page owns the inventory value, reconciliation and COGS layer beneath it.

By license type

Cultivation Inventory Accounting

A producer's inventory is not purchased; it is grown. That changes the accounting problem from matching invoices to tracking a production process across time, with costs incurred in one period attaching to product that will be sold in another.

  • Production stages identified so cost accumulation follows the actual process
  • Materials consumed in cultivation tracked to the batches they support
  • Labor accounted for where it is appropriately part of production cost
  • Work in process recognized where the business has incomplete production at period end
  • Harvested and finished inventory valued on a documented, consistent basis
  • Waste, adjustments and transfers recorded with supporting evidence

Cultivation cost accounting depends heavily on facts: facility layout, staffing, cycle length and how the business actually operates. We build the method around those facts rather than applying a template. For the broader engagement see cultivation accounting.

By license type

Cannabis Manufacturing Inventory Accounting

Manufacturing converts one form of inventory into another. The accounting has to follow that conversion: raw material leaves, production consumes inputs and effort, and finished goods arrive with a cost that should be traceable back to what was consumed.

  • Raw materials, ingredients and packaging tracked as distinct input categories
  • Work in process recognized where production spans a period end
  • Production activity recorded so input consumption and output creation agree
  • Yields measured and used consistently in cost per unit
  • Adjustments for loss or rework documented rather than absorbed
  • Finished goods valued on a documented basis that supports COGS and margin

See manufacturing accounting for the full cost-accounting engagement.

Structure

Raw Materials, WIP & Finished Goods

Inventory categories in a cannabis production business
CategoryWhat it represents
Raw materialsInputs acquired or harvested but not yet converted into finished product
Work in processProduction that has started but is not complete at period end, where applicable
Finished goodsCompleted inventory available for sale or transfer
  1. Raw materials
  2. Production
  3. WIP
  4. Finished goods
  5. Sale / COGS

Whether a business needs all three categories depends on its model. A retailer generally holds finished goods only. A producer or manufacturer usually needs at least two, and often all three. The exact treatment — what belongs in each category and how cost moves between them — depends on the facts of the operation and should be documented as a policy applied consistently, not decided item by item at close.

Systems

Metrc & Inventory Accounting

A seed-to-sale system such as Metrc or BioTrack is an operational and regulatory record of quantities and movements. Inventory accounting is the financial record of value in the general ledger. The seed-to-sale system does not replace inventory accounting, and its quantities are not inventory values.

METRC QUANTITY ≠ FINANCIAL INVENTORY VALUE

METRC ≠ GENERAL LEDGER

  1. Seed-to-sale system
  2. Physical inventory
  3. Accounting inventory
  4. General ledger

The seed-to-sale record is extremely useful to an accountant: it is a dated, independent, package-level history of what moved. That makes it the best available evidence for testing whether the accounting record is complete. What it cannot do is tell you what the inventory is worth, because it was never designed to carry cost. Businesses that treat the compliance export as a valuation schedule end up with a balance sheet nobody can support.

For the operational record reconciliation itself, see seed-to-sale reconciliation and the New Mexico seed-to-sale guide. We are an independent accounting firm and are not affiliated with any tracking system provider.

Systems

POS Inventory vs Accounting Inventory

POS = OPERATIONAL SALES / QUANTITY DATA · ACCOUNTING = FINANCIAL RECORD

A point-of-sale system tracks retail operational inventory: what is available to sell, what sold, and at what price. Some systems also carry a cost field, which is where the confusion starts — a cost field populated at setup and never maintained produces a COGS figure that looks authoritative and is not.

  • Treat POS quantity data as an operational record to be reconciled, not a ledger
  • Verify how, and how often, cost values in the POS are updated
  • Reconcile POS sales summaries to recorded revenue before analyzing margin
  • Relieve inventory cost in the accounting system on a documented basis
  • Investigate differences between POS inventory and the seed-to-sale record
  • Do not assume any two systems are integrated without verifying the data flow

Federal tax

Inventory Accounting & Section 280E

Where Section 280E applies to a cannabis business, the quality of the inventory record becomes the foundation of the entire tax position, because cost of goods sold is derived from inventory. That is an accounting-records question long before it is a tax question.

  1. Inventory accounting
  2. Supported COGS
  3. Tax workpapers
  4. 280E analysis where applicable

ACCOUNTING COST CLASSIFICATION ≠ AUTOMATIC FEDERAL TAX DEDUCTIBILITY

Our role on this page is to produce inventory records that are complete, reconciled and documented, so that the tax analysis can be performed on facts. How those facts are treated for federal tax purposes is a separate determination made with the applicable law and the taxpayer's circumstances in view — see 280E tax planning and the 280E guide. We do not approach inventory as a mechanism for moving costs, and we do not make claims about the tax outcome of a classification.

Relationship

Inventory Accounting & Cannabis Bookkeeping

Bookkeeping compared to inventory accounting
Cannabis bookkeepingInventory accounting
Broad financial recordkeeping across all accountsDeep focus on inventory value and COGS
Transaction coding, bank and card reconciliationQuantity-to-value reconciliation and GL tie-out
Monthly close of the full ledgerInventory roll-forward supporting the close
Produces the general financial recordProves the largest and most error-prone balance in it
  1. Bookkeeping
  2. Inventory reconciliation
  3. Month-end close

Most operators need both, and the sequence matters: bookkeeping without inventory reconciliation produces a clean-looking ledger with an unsupported inventory balance. See cannabis bookkeeping and the New Mexico cannabis bookkeeping guide.

Process

Inventory Accounting & Month-End Close

  1. Activity
  2. Reconciliation
  3. Ending inventory
  4. COGS
  5. Close
  1. 01Review beginning inventory against the prior period close
  2. 02Review purchases and receipts for completeness
  3. 03Review production activity where applicable
  4. 04Review transfers by location and entity
  5. 05Review adjustments and their supporting documentation
  6. 06Review physical and cycle count results
  7. 07Reconcile operational quantities to the accounting record
  8. 08Update supported inventory values
  9. 09Reconcile inventory to the general ledger
  10. 10Calculate and review cost of goods sold
  11. 11Review gross profit and investigate unexplained movement
  12. 12Close the period and archive the reconciliation file

Remediation

Inventory Accounting Cleanup

Cleanup engagements usually begin the same way: the inventory account has not agreed to anything for months, and no one is confident where the difference started. The work is methodical rather than dramatic.

  1. Diagnose
  2. Reconstruct
  3. Reconcile
  4. Document
  5. Correct supported entries
  • Inventory has not matched the books for several months
  • Old balances remain in inventory accounts with no explanation
  • COGS swings dramatically from period to period
  • Operational quantities and accounting records do not agree
  • Physical counts do not agree with either system
  • Purchases have been expensed inconsistently across periods
  • Transfers are missing from one side of the record
  • Adjustments were entered without support
  • Multiple locations are mixed together in one inventory account
  • Multiple entities share an inventory balance
  • Year-end inventory cannot be supported with documentation

We reconstruct from source records — vendor bills, receiving documentation, seed-to-sale exports, POS data and bank activity — establish a defensible starting balance, and then rebuild forward with a reconciliation at each period so the correction itself is documented.

Diagnostics

Common Cannabis Inventory Accounting Problems

Common inventory complaints and what to investigate
What we hearWhat we investigate first
Our tracking quantity matches, but the dollar value doesn'tCost basis, cost layering, freight treatment and whether value was ever maintained
Our POS inventory and accounting inventory are differentWhether POS cost fields are maintained and how cost relief is posted
Our inventory account keeps growingWhether cost is being relieved for sales at all, and whether purchases are duplicated
Our COGS changes wildly month to monthCutoff, missing bills, unsupported adjustments and inconsistent capitalization
We don't know which inventory belongs to which locationLocation coding at purchase, receipt and transfer
Transfers aren't reflected correctlyOne-sided transfer entries and in-transit cutoff at period end
We don't have reliable physical countsCount method, cutoff during counting and unit-of-measure consistency
We can't explain old inventory balancesRoll-forward from the last period that reconciled, then forward from there
Our year-end inventory doesn't tie to the ledgerThe full inventory-to-GL reconciliation and its supporting schedules
We use inventory adjustments as plugsEvery adjustment above a threshold, and the process defect creating the gap

Scale

Multi-Location Cannabis Inventory Accounting

  1. Location A
  2. Location B
  3. Location C
  4. Location-level reconciliation
  5. Consolidated inventory view

Multi-location operators face a structural problem: a consolidated inventory balance can be correct in total while every location within it is wrong. Consolidation hides offsetting errors, so the reconciliation has to happen at the location level first and roll up afterward.

  • Purchases coded to the receiving location at the point of entry
  • Transfers between locations recorded on both sides in the same period
  • Physical counts performed and reconciled per location
  • Inventory value maintained by location, not allocated after the fact
  • COGS and gross margin reported at the location level
  • The same valuation method and close calendar applied everywhere

An operator running stores in Albuquerque, Rio Rancho and Las Cruces should be able to answer what each location holds and what each location earned. Location-level inventory reconciliation is what makes that possible, and it feeds directly into the reporting work described under financial reporting.

Scale

Multi-Entity Cannabis Inventory Accounting

  1. Entity A inventory
  2. Entity B inventory
  3. Separate ownership / accounting
  4. Intercompany reconciliation

Where inventory is held by more than one legal entity, ownership matters more than location. Each entity's books have to reflect the inventory that entity owns, and movements between entities have to be recorded on both sides so that the intercompany relationship reconciles.

  • Inventory ownership established by entity, not by physical location
  • Purchases recorded in the entity that acquired the product
  • Entity-to-entity movements recorded on both sets of books
  • Intercompany balances reconciled before consolidated reporting
  • Ending inventory determined per entity for its own workpapers
  • COGS computed per entity so each return rests on its own records

We address the accounting treatment of entity structures that already exist; we do not provide legal structuring advice. Related work is described under entity structuring.

Metrics

Inventory Turnover

COGS ÷ AVERAGE INVENTORY = INVENTORY TURNOVER

Turnover describes how many times inventory cycles through the business over a period. It is only meaningful when both inputs are reliable — an unreconciled inventory balance or an unsupported COGS figure produces a ratio that looks precise and means nothing.

  • Business type: retail, cultivation and manufacturing behave differently
  • Product mix: fast-moving categories mask slow-moving ones in a blended figure
  • Purchasing strategy: bulk buying lowers turnover without indicating a problem
  • Seasonality and local demand patterns
  • Data quality: the ratio inherits every inventory error beneath it

We do not publish good or bad cannabis turnover benchmarks. The comparison worth making is a business against its own reconciled trend, by category and by location.

Metrics

Days Inventory on Hand

AVERAGE INVENTORY ÷ COGS × NUMBER OF DAYS = APPROXIMATE DAYS INVENTORY ON HAND

Days inventory on hand restates turnover in a form management usually finds easier to act on: roughly how long current inventory would last at recent cost of sales. Like turnover, it is an approximation whose usefulness depends entirely on the reliability of the inventory and COGS figures behind it, and on the business context — a cultivator's cycle length and a dispensary's replenishment cadence are not comparable measures.

Cash

Inventory & Working Capital

INVENTORY USES CASH

  1. Cash
  2. Inventory purchase
  3. Inventory
  4. Sale
  5. Cash recovery

Inventory is cash in another form. Every dollar sitting on a shelf is a dollar unavailable for payroll, vendor payments, tax deposits or expansion — which is why a profitable cannabis business can still run short of cash, particularly where Section 280E applies and the tax burden is calculated on a figure that does not reflect cash position.

  • Liquidity: excess inventory converts available cash into shelf value
  • Vendor payments: overbuying in one period compresses the next period's payables capacity
  • Payroll: inventory-heavy purchasing cycles can collide with pay dates
  • Tax cash: obligations arrive on their own schedule regardless of inventory position
  • Expansion: capital tied up in slow inventory is capital unavailable for a new location

Forward-looking planning around these constraints is CFO work — see fractional CFO services and cash flow planning.

Reporting

Inventory Accounting & Financial Reporting

Where inventory appears in the financial statements
ItemStatement effect
Ending inventoryBalance sheet — often the largest current asset
Cost of goods soldIncome statement — drives gross profit and margin
Inventory purchasesCash flow — timing of cash outlay versus cost recognition
Location inventory detailManagement reporting — store or facility level performance

Inventory is the balance most likely to be questioned by a lender, an investor or a reviewer, precisely because it is large and judgment-dependent. Reconciled inventory turns the financial statements into something that can be presented rather than explained away. See financial reporting and the financial reporting guide.

Tax

Inventory Accounting for Tax Preparation

  1. Year-end physical / operational records
  2. Inventory reconciliation
  3. Ending inventory
  4. COGS support
  5. Tax workpapers
  6. Return preparation

Return preparation depends on an ending inventory figure that can be supported. When the reconciliation has been performed monthly, year-end is a confirmation. When it has not, the preparer is reconstructing a year of activity under a deadline, and the resulting workpapers carry that weakness into every position that relies on cost of goods sold. See cannabis tax preparation and the New Mexico cannabis tax guide.

Engagement

Our Cannabis Inventory Accounting Process

  1. 01Understand the entity and location structure
  2. 02Review the accounting system and chart of accounts
  3. 03Review inventory systems and how values are maintained
  4. 04Review the seed-to-sale system and available exports
  5. 05Review POS or production systems and their data flow
  6. 06Review opening inventory balances and their support
  7. 07Review purchasing and receiving procedures
  8. 08Review transfers and adjustments and their documentation
  9. 09Review the physical-count process and recent results
  10. 10Reconcile quantities across operational and physical records
  11. 11Reconcile financial values to the inventory schedule
  12. 12Tie inventory to the general ledger
  13. 13Review cost of goods sold and gross profit for reasonableness
  14. 14Establish recurring month-end inventory procedures

Not every engagement includes every step, and the sequence changes with the condition of the records. A business with a clean ledger and one problem month needs a very different scope than one that has never reconciled inventory to the general ledger.

Coverage

Cannabis Inventory Accounting Across New Mexico

We work with licensed operators throughout New Mexico — retailers in Albuquerque, Santa Fe and Rio Rancho, producers and vertically integrated operators around Las Cruces and Los Lunas, and businesses in Roswell, Farmington, Clovis, Hobbs, Alamogordo, Carlsbad and Gallup. Engagements are conducted remotely using the operator's accounting, seed-to-sale and point-of-sale systems, which means the quality of the work depends on data access rather than proximity.

The inventory problems are consistent statewide: quantities that reconcile while values do not, transfers recorded on one side only, and inventory accounts that have not agreed to the general ledger in a year. To discuss your situation, see cannabis bookkeeping, dispensary accounting and cannabis payroll, or schedule a consultation.

Questions

Inventory Accounting questions

Explore the rest of the practice

Consultation

Talk with a New Mexico cannabis CPA

Bring your license types, current books and open deadlines. We will tell you what needs to happen first and in what order.