NMCannabis CPA New Mexico

Compliance

Metrc Reconciliation for New Mexico Cannabis Businesses

Reconcile New Mexico cannabis seed-to-sale records with operational activity, physical inventory and accounting so discrepancies can be identified, investigated and documented. Seed-to-sale systems record every plant, package, transfer and sale by a unique identifier. Your accounting system records the same events in dollars. When the two disagree — and they always do at first — the business is carrying both a licensing exposure with the Cannabis Control Division and a tax exposure on inventory. Reconciliation is the discipline of closing that gap every single period.

Why Track-and-Trace and Financial Records Drift Apart

The two systems are maintained by different people for different purposes. Compliance staff record physical events; accounting staff record dollar events. Nobody owns the connection between the two by default.

Drift shows up from untracked samples and promotional product, waste that's recorded physically but never financially, repackaging that breaks unit-cost lineage, transfer records accepted at the wrong cost, returns processed in only one system, and manual adjustments made to clear a compliance flag with no corresponding journal entry.

  • Sampling, R&D and employee product not costed out of inventory
  • Waste and destruction events with no financial write-off
  • Repackaging and conversion that breaks unit-cost lineage
  • Transfer quantities that don't match receiving quantities

The Reconciliation Framework

We build a period-end rollforward starting with opening inventory by package or SKU, adding receipts from transfer records, subtracting sales per POS or invoices, subtracting documented waste and conversion, and arriving at a computed ending balance compared against both the physical count and the BioTrack balance.

Every difference gets a classification: timing, documentation, costing error, physical loss, or system error. Timing and documentation items get cleared. Physical losses are written off with support. Costing errors are corrected at the source so they don't recur.

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

Cost Layer Integrity Through Transformation

Manufacturers and distributors face a harder version of this problem. When flower converts to extract and extract into finished units, the state's unique identifiers change and cost has to follow the material through the transformation on a defensible allocation.

We set conversion costing rules up front — yield assumptions, joint and by-product allocation, processing labor and overhead absorption — and apply them consistently so finished goods carry a cost that can be explained line by line.

Compliance Value and Audit Defense

The CCD reviews the same track-and-trace data your accounting system is supposed to mirror. Unexplained inventory shrinkage invites diversion questions; unexplained inventory growth invites questions about unreported purchases. Either way, the operator is answering with data it did not prepare.

A monthly reconciliation with signed workpapers changes that posture entirely, and it directly supports the inventory figure on the tax return — usually the single most scrutinized number on a cannabis filing.

  • Signed monthly reconciliation workpapers retained with the tax file
  • Variance log with root cause and a remediation owner
  • Physical count procedures with retained count sheets
  • Support package ready for a regulator or IRS inventory inquiry
Fractional CFO strategy session reviewing cannabis financial projections in a glass boardroom above downtown Albuquerque at dusk

Systems and Integrations

We work with the point-of-sale, inventory and ERP platforms New Mexico operators actually run, and we're direct about where integrations break down. Automated syncs handle volume well but propagate costing errors at scale, so the control has to sit on top of the integration, not inside a trust assumption.

Where an integration can't be trusted, we build a structured import and reconciliation process instead — slower, but auditable.

What a Real Three-Way Reconciliation Looks Like

The reconciliation that matters compares three independent records of the same item: BioTrack package quantities, the point-of-sale or inventory subledger, and the general ledger inventory balance. Agreement across all three is the only credible statement that inventory is right. Two out of three is a coincidence.

We run it monthly at package and category level. Variances are classified rather than plugged: receiving errors where a transfer was accepted in one system and not the other, sales voids that reversed in the POS but not in BioTrack, unrecorded waste and destruction, sampling and testing pulls, and genuine shrinkage. Each classification points at a different operational fix, and the classification itself is the audit documentation.

For a multi-location retailer, we run the reconciliation by license and then consolidate, because a variance that nets to nothing across two or three stores is usually two problems hiding each other.

  • Package-level quantity comparison across BioTrack, subledger and ledger
  • Variance classification with operational root cause, not plug entries
  • Documented waste, destruction, sampling and testing adjustments
  • Escalation thresholds and a signed monthly reconciliation record

Compliance Consequences and the Audit Trail

Track-and-trace discrepancies are a licensing issue before they're an accounting issue. New Mexico's Cannabis Control Division can and does cite operators for inventory reconciliation failures, and unexplained variance is a common finding in a state inspection. The same records also carry the federal tax burden, because ending inventory determines COGS and COGS is the only relief 280E allows.

One multi-location retailer we've worked alongside had a persistent 2 percent variance that turned out to be transfer packages accepted at the dock but recorded a day later at a different weight after moisture loss. Once the receiving procedure captured weight at acceptance and the accounting policy documented normal moisture variance, both the compliance exception and the costing error disappeared.

Every reconciliation is retained with its supporting exports so that a state inspection or an IRS information document request is answered from an existing file rather than a scramble.

The system

Metrc Reconciliation for New Mexico Cannabis Businesses

Metrc reconciliation is the process of comparing seed-to-sale records with physical inventory, operational systems and accounting records to identify and investigate differences in quantities, transfers, adjustments and financial inventory activity, and to document supported resolutions.

We are an accounting firm, not a seed-to-sale software vendor. We are not affiliated with, endorsed by or certified by Metrc or any track-and-trace provider. We work with the data your systems produce and reconcile it to the accounting records that ultimately drive your financial statements and tax workpapers.

One point of clarity for operators licensed here: New Mexico’s state-designated seed-to-sale system is BioTrack, administered through the Cannabis Control Division, while Metrc is the system used in many other states. Multi-state operators and businesses arriving from Metrc markets frequently describe this work as “Metrc reconciliation.” The reconciliation discipline is the same in either system: compare the operational record, the physical count and the accounting record, then investigate and document every difference. Everything on this page applies to Metrc data, BioTrack data, or a group reconciling both.

  1. Metrc / seed-to-sale
  2. Operational inventory
  3. POS · production · transfers
  4. Physical inventory
  5. Reconciliation
  6. Accounting inventory
  7. General ledger
  8. Financial reporting

Definition

What Is Metrc Reconciliation?

Metrc reconciliation compares cannabis seed-to-sale records against physical inventory, point-of-sale or production records and accounting data so differences can be identified and resolved with supported documentation.

Four distinct records describe the same inventory, and each answers a different question. Reconciliation is what connects them; without it, an operator has four opinions about inventory and no way to tell which one is right.

What each inventory record represents
RecordWhat it isWhat it answers
Metrc / seed-to-saleOperational and regulatory recordWhat did the tracking system say moved?
Physical inventoryWhat actually exists on the shelf or in the vaultWhat is really here right now?
Accounting inventoryFinancial value carried on the booksWhat is this inventory worth?
General ledgerThe financial record of the businessHow does inventory affect the statements?

METRC QUANTITY ≠ FINANCIAL INVENTORY VALUE

METRC ≠ GENERAL LEDGER

Seed-to-sale reconciliation is the same idea stated in operational language: taking the movement history a tracking system records — receipts, packages, transfers, production events, sales, adjustments — and proving it against what physically exists and what the books say. When those agree, inventory reporting becomes reliable. When they do not, the differences need to be investigated rather than forced.

Why it matters

Why Metrc Reconciliation Matters

Inventory is usually the largest balance-sheet item a cannabis business carries and the largest driver of cost of goods sold. Every operational event either adds to or removes from that balance, and each one leaves a trace in more than one system. Purchases and receiving bring product in. Harvest and production convert one form of inventory into another where cultivation or manufacturing is involved. Packages get created, split, combined and relabeled. Transfers move product between licenses and locations. Sales remove it. Adjustments and waste records account for what did not follow the normal path. Physical counts test whether the record still describes reality.

  1. Operational activity
  2. Metrc
  3. Physical inventory
  4. Accounting reconciliation

When those events are recorded consistently across systems, inventory reporting holds together and the month-end close has something solid to stand on. When they are not, differences accumulate quietly. A missed transfer receipt, a package split that was never entered, a sale voided in one system but not another, a waste event captured operationally with no financial entry — none of these are dramatic on their own, and all of them roll forward until someone reconciles.

  • Inventory balances that cannot be supported weaken every downstream financial report
  • Unexplained differences become harder to trace the longer they age
  • COGS depends on inventory activity being complete and correctly valued
  • Management decisions on purchasing and pricing rely on believable inventory data
  • Tax workpapers require inventory figures that can be explained and supported
  • Multi-location groups cannot compare stores when each one reconciles differently

Reconciliation is a financial control, not a compliance guarantee. It identifies and documents differences so they can be investigated and resolved. It does not by itself determine regulatory outcomes, and we make no representations about how any agency will view a given record.

Distinction

Metrc vs Accounting Software

Metrc is an operational and regulatory tracking system that records quantities, packages and movements. Accounting software is a financial system that records money — banking, bills, payroll, inventory value, COGS, liabilities and equity. Neither one replaces the other, and neither one reconciles itself.

Metrc versus accounting software
Metrc / seed-to-saleAccounting software
Primary purposeTrack product through its lifecycleProduce financial records and statements
Unit of measureGrams, units, packages, plantsDollars
Core objectsPackages, lots and batches, plants, transfersAccounts, journal entries, subledgers
RecordsQuantities, movements, adjustments, waste entriesBanking, cash, vendor bills, payroll, debt, equity
Inventory viewOperational quantity on handFinancial inventory value
CostNot a costing engineCarries cost basis and computes COGS from recorded activity
OutputOperational and regulatory reportsBalance sheet, income statement, cash flow

METRC ≠ ACCOUNTING SOFTWARE · OPERATIONAL DATA ≠ FINANCIAL DATA

This distinction is where most reconciliation problems begin. Operators sometimes treat a tracking report as if it were an inventory valuation report, or assume that because the tracking system is current, the books must be too. The tracking system knows how many units moved; it does not know what those units cost, what overhead was absorbed into them, or how the movement should be journalized. That work belongs to inventory accounting and cannabis bookkeeping.

Distinction

Metrc vs Physical Inventory

A tracking record is a description of inventory. A physical count is an observation of inventory. When the two disagree, the difference is information — a starting point for investigation, not evidence of wrongdoing. Most variances we see have ordinary operational explanations, and treating them as anything else damages both accuracy and staff trust.

  1. Metrc record
  2. Physical count
  3. Variance
  4. Investigation

Timing

Activity occurred on one side of the cutoff and was recorded on the other. Very common around month-end and around transfer receipts.

Receiving

Product physically arrived but the inbound record was not completed, or was completed with a different quantity than what was accepted.

Transfers

An outbound record exists without a matching inbound record, or the two disagree on quantity, package or date.

Sales

A sale, return or void was processed in the retail system without a corresponding movement in the tracking system.

Adjustments

An adjustment was entered to correct a symptom rather than a cause, leaving the underlying difference unresolved.

Waste records

Product was removed operationally and recorded in one system only, so the other still carries it.

Count errors

Miscounts, unit-of-measure confusion, product counted twice, or locations skipped during the count.

System entry

Typos, wrong package selected, wrong location, duplicate entry, or a step performed out of sequence.

Package handling

Splits, combinations and relabeling that were done physically but recorded inconsistently or not at all.

The reconciliation output should be a variance list where each line has a probable cause, the support reviewed, and either a documented correction or an explicit note that it remains unresolved. Unresolved is an acceptable answer when the support does not exist; inventing a cause is not.

Retail

Metrc vs POS Reconciliation

For dispensaries, the point-of-sale system is the busiest source of inventory movement in the business. Every transaction reduces inventory, creates a sale, and produces a payment record. The tracking system should reflect the same product movement, and the accounting system should reflect the same revenue and inventory effect in dollars.

  1. Metrc
  2. POS
  3. Physical inventory
  4. Accounting

Some retail platforms exchange data with a tracking system and some do not, and the behavior varies by configuration, product and version. We do not assume any particular integration exists or works as described. Part of the initial review is establishing what actually flows between your systems, what is manual, and where a break would go unnoticed.

  • Sales: unit counts by product and day compared between the retail system and the tracking record, then compared to the revenue posted in accounting.
  • Returns and exchanges: whether returned product went back into sellable inventory, was destroyed, or was recorded in only one system.
  • Voids and corrections: transactions reversed at the register that may or may not have reversed the inventory movement.
  • Discounts and promotions: these change revenue and margin without changing units, and they belong in the accounting reconciliation rather than the quantity reconciliation.
  • Employee, sample and promotional product: units that leave inventory without a normal sale still need both an operational and a financial treatment.
  • Timing: business-day cutoffs, late-night transactions and time-zone settings that push activity into a different period in one system than another.

Retail-specific accounting for these items — revenue recognition, discount treatment, shrink and margin analysis — is covered under dispensary accounting.

Distinction

Metrc vs Accounting Inventory

Metrc inventory is a quantity. Accounting inventory is a value. A tracking system can tell you that 400 units are on hand; it cannot tell you what those 400 units cost, and a matching quantity does not mean the financial inventory balance is correct.

  1. Metrc quantity
  2. Reconciliation
  3. Accounting inventory schedule
  4. General ledger
Metrc inventory versus accounting inventory
Metrc inventoryAccounting inventory
MeasuresQuantity and movementCost and value
Built fromOperational eventsPurchase cost, production cost, allocation methods
Correctness testDoes the quantity agree with physical and system records?Is the value supported by cost data and consistently applied methods?
FeedsOperational reporting and regulatory recordsBalance sheet, COGS, gross margin, tax workpapers
Can be right while the other is wrongYesYes

Both failure directions are common. Quantities can tie perfectly while inventory value is wrong because costs were never loaded, freight and production costs were expensed instead of capitalized, or a valuation method was applied inconsistently. Value can look plausible while quantities are wrong because the cost per unit is masking a quantity error. Only reconciling both gives an inventory balance that can be defended. The valuation side of this work lives in cannabis inventory accounting.

Bridge

Metrc-to-General-Ledger Reconciliation

A tracking system does not produce general-ledger values, and it should never be treated as a source of journal entries. What it produces is a movement history. Turning that history into a ledger balance requires a bridge — an inventory schedule that takes operational quantities and applies cost, then agrees to the inventory account in the general ledger.

  1. Metrc / operational data
  2. Inventory reconciliation
  3. Accounting inventory schedule
  4. General ledger
  • Purchase data: vendor invoices and transfer documentation supporting cost per unit
  • Cost data: freight, packaging, testing and other costs that belong in inventory
  • Production records: inputs consumed, output produced, yield and conversion detail
  • Physical counts: independent evidence that the quantity side is real
  • Location and entity mapping: which license, facility and set of books owns each item
  • Supported adjustments: documented corrections with a stated cause and reviewer

The reconciliation is complete when the inventory schedule agrees to the general-ledger inventory balance, every reconciling item is explained, and the workpaper can be handed to someone else who can follow it without narration.

By license type

Dispensary Metrc Reconciliation

Retail is high-volume and high-frequency, which means small process gaps compound quickly. A dispensary reconciliation typically works across four records for the same product: what the tracking system says, what the register says, what is on the shelf and in the back, and what the books carry.

  1. Metrc
  2. POS
  3. Physical count
  4. Accounting
  1. 01Confirm inventory receipts — what was accepted from each inbound transfer, at what quantity and cost.
  2. 02Review retail packages — splits, relabeling and how items map to POS SKUs.
  3. 03Compare POS unit sales to tracking-system movement by product and day.
  4. 04Review returns and exchanges and where the product ended up.
  5. 05Review voids, corrections and any manual register overrides.
  6. 06Review transfers in and out, including product returned to a supplier.
  7. 07Review adjustments, samples, promotional units and employee product.
  8. 08Compare cycle counts and full physical counts against system quantities.
  9. 09Roll store-level quantities into the accounting inventory schedule.
  10. 10Tie the schedule to the inventory account in the general ledger.

Where several stores operate under one group, each location reconciles independently before anything is consolidated — otherwise one store’s variance quietly offsets another’s and the group total looks healthier than any individual store is. Store P&L, margin and shrink reporting are handled in dispensary accounting.

By license type

Cultivation Metrc Reconciliation

Cultivation reconciliation follows biological product through stages rather than moving discrete purchased units. Plants become harvest lots, harvest lots become packages after drying and curing, and packages get tested, split and transferred. Quantities change form along the way, which makes the reconciliation a roll-forward through production rather than a simple in-and-out comparison.

  • Plant records: counts by stage and the transitions between them, compared against what the operational team reports.
  • Harvest activity: wet weights, dry weights and the loss inherent in drying, recorded consistently period to period.
  • Package creation: how harvest lots convert into packages and whether the quantity relationship is traceable.
  • Transfers: outbound movements to retail, manufacturing or distribution partners and their matching receipt records.
  • Waste and adjustments: recorded operationally where applicable, with a corresponding accounting treatment where appropriate.
  • Physical inventory: counts of packaged product, and reasonable measurement of work in process at period end.

The accounting consequence is significant: cultivation costs accumulate in work in process and attach to harvested output, so an unreconciled quantity error changes cost per unit for an entire batch. We do not provide step-by-step regulatory instructions for plant or harvest reporting — that belongs to your compliance team and the state’s own requirements. Cost accumulation, batch costing and yield reporting are handled in cultivation accounting.

By license type

Manufacturing Metrc Reconciliation

Manufacturing reconciliation centers on conversion. Input packages are consumed, a production process runs, and output packages are created with different identifiers, different units and different characteristics. The reconciliation has to demonstrate a traceable relationship between what went in, what came out, and what was lost in process.

INPUTS CONSUMED − PROCESS LOSS = OUTPUT PRODUCED

  • Input packages: quantities consumed by production run, tied back to receiving records
  • Production records: run documentation connecting inputs to outputs
  • Package conversions: how new package identifiers relate to the inputs they came from
  • Finished goods: output quantities compared against production records and physical counts
  • Transfers: outbound finished goods and their matching receipt at the destination
  • Adjustments: process loss, failed batches and rework with documented support

Financially, conversion is where cost layers are most easily lost. If input cost does not follow material through the run, finished goods carry a cost nobody can explain. We do not fabricate manufacturing compliance procedures; we reconcile the records your process produces and make sure the cost story survives the conversion. Absorption, yield and batch costing are covered in manufacturing accounting.

Mechanics

Package & Lot Reconciliation

At the package or lot level, reconciliation is arithmetic. Every package has a beginning quantity, a set of movements during the period, and an ending quantity. The expected ending quantity is computed and compared to what the records actually show.

BEGINNING QUANTITY + RECEIPTS + INBOUND TRANSFERS − SALES / USAGE − OUTBOUND TRANSFERS ± SUPPORTED ADJUSTMENTS = EXPECTED ENDING QUANTITY

Where expected and actual agree, the package is reconciled. Where they do not, the difference is isolated to a specific movement type, which narrows the investigation immediately: a receipts difference points at receiving, a transfer difference points at a counterparty record, a sales difference points at the retail or production system. This is a financial reconciliation method, not a substitute for the tracking system’s own requirements or reports.

  • Reconcile at the level the business actually manages — package, lot, batch or SKU
  • Keep the roll-forward for every period so differences do not silently reset
  • Investigate by movement type rather than scanning the whole population
  • Carry unresolved items forward explicitly instead of absorbing them

Mechanics

Transfer Reconciliation

Transfers are the single most common source of unmatched records, because two independent parties have to record the same event. Reconciliation compares the source record, the destination record and the accounting effect on both sides.

  1. Source record
  2. Destination record
  3. Accounting effect
  • Outbound transfers: what left, from which location and license, on what date
  • Inbound transfers: what was accepted, at what quantity, and whether it matched the manifest
  • Quantity differences: shortages, overages and partial acceptances that need documentation
  • Timing: transfers in transit across a period cutoff, recorded in different periods by each side
  • Location and entity: which set of books owns the inventory at each stage
  • Accounting: whether the transfer created a purchase, an intercompany movement, or no financial event at all

We do not provide regulatory transfer instructions. The accounting question is narrower: did both sides record the same event, and does the general ledger reflect the correct inventory ownership at period end?

Mechanics

Adjustment Reconciliation

An adjustment is a documented correction with a known cause. It is not a plug entered to make two systems agree. An adjustment without a cause hides the problem it was meant to fix and guarantees the difference returns next period.

ADJUSTMENT ≠ PLUG TO FORCE SYSTEMS TO MATCH

  • Why: the operational reason the adjustment occurred, stated specifically enough that a reviewer can evaluate it.
  • Support: the count sheet, production record, manifest, register report or correspondence backing it up.
  • Quantity effect: which package or lot changed, by how much, and in which direction.
  • Financial effect: whether the adjustment changes inventory value, and if so, which account absorbs it.
  • Timing: the period the adjustment belongs to, which is not always the period it was entered.
  • Review: who prepared it, who reviewed it, and where the documentation is retained.

A useful diagnostic is adjustment frequency by cause. When one cause dominates the log, the fix is a process change upstream, not more adjustments downstream.

Mechanics

Waste & Loss Reconciliation

Waste and loss records remove product from inventory outside the normal sales or transfer path. From an accounting perspective the questions are narrow and factual: was the removal recorded operationally, does the physical inventory reflect it, and does the financial record reflect it in the correct period?

  • Operational record: the waste or loss entry as captured in the tracking system
  • Physical impact: whether the product has actually left inventory as of the count date
  • Accounting impact: whether inventory value was reduced, and to which account
  • Timing: matching the operational and financial records to the same period
  • Documentation: the support retained for the entry and who reviewed it
  • Patterns: recurring loss by product, location or shift that warrants a closer process review

We do not provide disposal or destruction procedures, and we do not presume theft or misconduct when a variance appears. Most differences trace to process and recording gaps. Where a difference cannot be explained, the honest reconciliation outcome is a documented unresolved variance, escalated to management.

Mechanics

Receiving Reconciliation

Receiving is where cost enters the business, which makes it the highest-leverage point in the whole reconciliation. A quantity error accepted at receiving propagates through every downstream record for the life of that product.

  1. Purchase / transfer
  2. Receipt
  3. Metrc
  4. Inventory record
  5. Accounting
  • What was ordered: the purchase order or agreed transfer detail
  • What was received: the physical count at the door, including shortages and damage
  • What the tracking system shows: accepted quantities and package identifiers
  • What operational systems show: the inventory record created for the location
  • What accounting recorded: the vendor bill or payable, at what cost and in which period
  • Cost components: freight, testing and other costs that belong in inventory rather than expense

A three-way agreement between the order, the physical receipt and the recorded bill is the control. Where the three disagree, the difference should be resolved before the product is sold, not discovered at month-end.

Mechanics

Sales Reconciliation

For dispensaries, a single sale creates several records at once: a retail transaction, an inventory movement, a payment or cash event, and a revenue entry in the books. Sales reconciliation confirms that all four describe the same activity.

  1. POS sale
  2. Metrc inventory movement
  3. Payment / cash
  4. Accounting

METRC SALES DATA ≠ BANK DEPOSIT

Those two figures should never be expected to match directly. Tracking data reports product movement; a deposit reflects cash net of timing, tender mix, discounts, fees, returns and whatever was held back for change and float. Reconciliation runs register-to-tracking on units and register-to-bank on money, then ties both to recorded revenue.

  • Units sold per the retail system compared to tracking-system movement by day
  • Gross sales, discounts and net sales compared to recorded revenue
  • Tender mix reconciled to deposits, with timing differences identified
  • Returns, voids and corrections traced through both quantity and dollars
  • Cash handling: drawer counts, over/short and safe activity documented daily
  • Period cutoffs applied identically in all systems

Mechanics

Physical Count Reconciliation

A physical count is the only independent test of whether the records describe reality. The reconciliation compares the system quantity to the counted quantity, isolates the variance, investigates it, and documents whatever correction the evidence supports.

  1. System count
  2. Physical count
  3. Variance
  4. Investigation
  5. Supported resolution
  1. 01Freeze or clearly cut off movement during the count so the comparison is meaningful.
  2. 02Count by location and by package or SKU using consistent units of measure.
  3. 03Record counts on retained sheets or in a system with an audit trail.
  4. 04Compare counted quantities to system quantities line by line.
  5. 05Rank variances by dollar impact rather than unit count.
  6. 06Investigate material variances against receipts, transfers, sales and adjustments.
  7. 07Document the cause and the support for each correction made.
  8. 08Post corrections in the correct period and note anything left unresolved.

Count frequency should be set by management based on volume, value and risk, and by whatever the business’s own regulatory obligations require. We do not prescribe a regulatory count frequency. From an accounting standpoint, cycle counting high-value product frequently and counting everything at least at period boundaries that matter is a workable baseline.

Process

Month-End Metrc Reconciliation

  1. Metrc data
  2. Operational reconciliation
  3. Inventory accounting
  4. Month-end close
  1. 01Confirm the relevant operational reports are complete and pulled as of a consistent cutoff.
  2. 02Review beginning inventory and confirm it agrees to last period's closing schedule.
  3. 03Review receipts for the period against purchase and transfer documentation.
  4. 04Review inbound and outbound transfers and confirm each has a matching counterparty record.
  5. 05Review sales or production activity depending on license type.
  6. 06Review every adjustment for cause, support and correct period.
  7. 07Review physical counts and cycle counts performed during the period.
  8. 08Investigate material differences and rank them by financial impact.
  9. 09Reconcile operational quantities to the expected ending quantity by package or SKU.
  10. 10Bridge reconciled inventory activity into the accounting inventory schedule.
  11. 11Reconcile financial inventory value and confirm cost data supports it.
  12. 12Document supported adjustments with preparer and reviewer noted.
  13. 13Tie the inventory schedule to the general ledger and complete month-end close.

Running this monthly keeps variances traceable. Running it quarterly or annually usually means investigating differences after the people who could explain them have moved on to three months of newer work.

Scope

Metrc Reconciliation & Cannabis Inventory Accounting

Metrc reconciliation asks whether the operational data reconciles. Inventory accounting asks what the inventory is worth. They are different questions, and reliable inventory reporting requires both to be answered.

Reconciliation versus inventory accounting
Metrc reconciliationInventory accounting
QuestionDoes the operational data reconcile?What is the financial value?
Works withQuantities, packages, movements, countsCost data, valuation methods, GL balances
OutputVariance list and supported correctionsInventory schedule, COGS, gross margin
Fails whenRecords disagree and nobody investigatesCosts are missing, misapplied or inconsistent

METRC → QUANTITY · INVENTORY ACCOUNTING → VALUE · BOTH → RELIABLE INVENTORY REPORTING

The valuation side is handled through cannabis inventory accounting, and the two engagements are usually run together because neither is fully useful alone.

Scope

Metrc Reconciliation & Cannabis Bookkeeping

Bookkeeping is the general financial record of the business — banking, cash, payables, payroll, revenue and the month-end close. Metrc reconciliation is the operational record reconciliation that feeds one specific and unusually large part of that close: inventory.

  1. Metrc / operations
  2. Reconciliation
  3. Accounting support
  4. Bookkeeping close

When reconciliation happens before the close rather than after it, the inventory number arrives supported and the close finishes on schedule. When it happens after, the books get reopened. Ongoing financial recordkeeping is covered under cannabis bookkeeping, and payroll allocations that touch production cost are handled in cannabis payroll.

Financial effect

Metrc Reconciliation & COGS

A tracking system does not calculate cost of goods sold. It can support an understanding of what moved and when, but COGS is a financial figure built from cost data applied to reconciled inventory activity in the accounting records.

METRC ≠ COGS CALCULATION SYSTEM

  1. Metrc quantity data
  2. Cost data
  3. Accounting inventory
  4. COGS support

Quantity data tells you units left inventory. Cost data tells you what those units carried. The accounting inventory schedule applies one to the other and produces a COGS figure that can be traced back to source documents. Skip the reconciliation step and COGS inherits every unresolved quantity difference in the tracking system. Skip the cost step and there is no COGS at all, only unit counts. See inventory accounting for the valuation methodology.

Financial effect

Metrc Reconciliation & Gross Margin

NET SALES − COGS = GROSS PROFIT · GROSS PROFIT ÷ NET SALES = GROSS MARGIN

Gross margin is only as reliable as the COGS beneath it, and COGS is only as reliable as the inventory activity feeding it. Unreconciled movement distorts margin in both directions: inventory that should have been relieved but was not understates COGS and overstates margin, while duplicated or overstated relief does the reverse. Either way, management ends up making pricing, purchasing and product-mix decisions on a number that does not describe the business.

A tracking system does not compute financial gross margin. It contributes quantity data that, once reconciled and costed, supports the margin figures produced in financial reporting.

Tax

Metrc Reconciliation & Section 280E

Where Section 280E applies, the treatment of inventory and cost of goods sold carries more weight than it does in a conventional business, because the deductions available are narrower and the support expected for what remains is correspondingly higher. That makes the quality of the underlying records a tax issue and not only an accounting one.

  1. Metrc data
  2. Inventory reconciliation
  3. Financial accounting
  4. COGS support
  5. Tax workpapers

METRC CLASSIFICATION ≠ AUTOMATIC FEDERAL TAX TREATMENT

How a package, cost or adjustment is categorized in a tracking system has no automatic bearing on how it is treated for federal tax purposes. Tax positions are built from financial accounting records, cost data and documented methodology — not from operational categories. Reconciliation matters here because unsupported inventory figures produce unsupported workpapers, and the wording of federal treatment for cannabis businesses has been subject to ongoing legal and regulatory developments that any planning should account for. Facts differ by business; nothing here is tax advice for a specific situation. See 280E tax planning and the 280E guide.

Diagnostics

Common Metrc Reconciliation Problems

Metrc does not match the POS

Start with sales and returns by day, then voids and manual overrides. Confirm cutoffs and whether any product movement is entered manually on one side.

Physical inventory does not match Metrc

Isolate by product and location, then test receipts, transfers and adjustments for that subset before questioning the count itself.

Transfers are missing or unmatched

Compare outbound records to counterparty inbound records. Most gaps are unaccepted manifests, partial acceptances or period-cutoff timing.

Package quantities do not reconcile

Run the roll-forward per package. The failing movement type points directly at the process that needs review.

Quantities look right but the books are wrong

This is a costing problem, not a tracking problem. Review cost loading, capitalized costs and valuation method consistency.

Accounting inventory does not tie out

Rebuild the inventory schedule and agree it to the GL account. Identify whether the break is quantity, cost or an unposted entry.

Sales differ between systems

Reconcile units separately from dollars. Discounts, returns and tender timing explain most dollar gaps without any unit difference.

Adjustments are being used as plugs

Review the adjustment log by cause. A dominant or blank cause category means the real issue is upstream and still active.

Old discrepancies roll forward

Establish the last period that reconciles, then work forward. Carrying an unexplained balance indefinitely corrupts every later period.

Locations cannot be reconciled separately

Usually a mapping problem — inventory, POS and GL are not segmented consistently, so store variances offset each other.

Nobody owns the reconciliation

Compliance records physical events, accounting records dollars, and the connection is unassigned. Assign preparation and review explicitly.

Reports pulled at different times

Systems pulled on different days or with different filters will never agree. Standardize report parameters and pull timing.

Cleanup

Metrc Reconciliation Cleanup

When reconciliation has not been performed for several periods, the work starts with diagnosis rather than correction. The goal is to establish a defensible position going forward and to document historical differences honestly, not to force old periods into agreement.

  1. Diagnose
  2. Reconstruct
  3. Reconcile
  4. Document
  5. Establish recurring process
  1. 01Identify the last period where records can be considered reliable.
  2. 02Gather the relevant operational, retail, production and accounting reports for the gap period.
  3. 03Reconstruct opening quantities where documentation supports it.
  4. 04Review receipts across the period against purchase and transfer support.
  5. 05Review transfers and match them to counterparty records.
  6. 06Review sales or production movement depending on license type.
  7. 07Review adjustments and separate documented corrections from plugs.
  8. 08Compare the reconstructed position to any physical count records available.
  9. 09Identify and quantify variances that cannot be explained with available support.
  10. 10Document supported corrections with cause, evidence and reviewer.
  11. 11Reconcile the reconstructed inventory to accounting where the support allows.
  12. 12Stand up a recurring monthly process so the gap does not reopen.

Some historical differences cannot be resolved because the supporting records no longer exist. We do not promise that every historical discrepancy can be explained. What a cleanup can deliver is a documented reconstruction, a clear statement of what remains unresolved and why, and a reliable process from a defined starting point forward.

Scale

Multi-Location Metrc Reconciliation

  1. Location A · B · C
  2. Location-level reconciliation
  3. Transfer review
  4. Consolidated management view

Multi-location groups fail reconciliation for a structural reason more often than a diligence one: the data is consolidated before it is reconciled. Once totals are combined, a shortage at one store offsets an overage at another and the group looks fine while neither store is. Each location has to reconcile on its own before anything rolls up.

  • Location-specific inventory records, segmented consistently in every system
  • Transfers between locations matched on both sides before consolidation
  • POS activity reconciled store by store, not at the group level
  • Physical counts scheduled per location with retained documentation
  • Accounting inventory tracked by location in the general ledger
  • Facility and store reporting that lets management compare sites on equal terms

Consolidated reporting and location comparison are handled through financial reporting.

Scale

Multi-Entity Metrc Reconciliation

  1. Entity A · Entity B
  2. Separate operational records
  3. Separate accounting
  4. Reconciliation

Where several legal entities operate under common ownership, inventory ownership has to be unambiguous at every point in time. Each entity keeps its own books, each license maps to a specific entity, and movements between them are real transactions with an accounting effect on both sides rather than internal shuffles.

  • Entity ownership of each license, facility and inventory location documented clearly
  • Location-to-entity mapping applied identically across operational and accounting systems
  • Transfers between entities recorded as transactions with matching entries on both sides
  • Intercompany balances tracked, agreed between entities and eliminated only where a consolidated view is appropriate
  • Separate books maintained per entity rather than one blended set
  • Inventory ownership at period end supported for each entity independently

We do not provide legal structuring advice. Entity accounting mechanics are covered under entity structuring support and the related accounting work.

Downstream

Metrc Reconciliation & Financial Reporting

  1. Operations
  2. Reconciliation
  3. Accounting
  4. Financial reporting

Reliable operational inventory supports reliable accounting inventory, and reliable accounting inventory is what makes the balance sheet, COGS, gross profit, gross margin and management reporting worth reading. When inventory is unreconciled, every one of those outputs inherits the uncertainty — and inventory is usually large enough that the uncertainty is material. Reporting deliverables are produced through financial reporting, with background in the financial reporting guide.

Downstream

Metrc Reconciliation for Tax Preparation

  1. Year-end operational data
  2. Inventory reconciliation
  3. Accounting inventory
  4. COGS support
  5. Tax workpapers
  6. Return preparation

Year-end inventory is one of the most closely examined figures on a cannabis return, and it is only as good as the reconciliation behind it. Preparation runs far more smoothly when the inventory schedule already agrees to the general ledger, the variance documentation is retained, and adjustments have stated causes. Return preparation itself is a separate engagement — see cannabis tax preparation and the New Mexico cannabis tax guide.

Downstream

Metrc Reconciliation & Fractional CFO Support

  1. Reconciled operations
  2. Reliable accounting
  3. Financial reports
  4. Forecasting
  5. Decision support

Forecasting, budgeting and cash planning are all extrapolations of historical data. If inventory and COGS are unreliable, the margin assumptions inside the forecast are unreliable too, and the model produces confident answers to the wrong question. Reconciliation is what makes forward-looking work credible. See fractional CFO services and cash flow planning.

Engagement

Our Metrc Reconciliation Process

Engagements differ by license type, systems, volume and the condition of existing records. The sequence below describes how we typically approach the work rather than a fixed template applied identically to every business.

  1. 01Understand entity and location structure, and which license belongs to which set of books.
  2. 02Review the seed-to-sale workflow as it is actually performed, not as documented.
  3. 03Review the POS or production systems in use and how data moves between them.
  4. 04Review the physical inventory and cycle count process and its documentation.
  5. 05Review the accounting system, chart of accounts and inventory account structure.
  6. 06Review opening quantities and establish the last reliable reconciled position.
  7. 07Review receipts and receiving controls against purchase and transfer support.
  8. 08Review inbound and outbound transfers and match counterparty records.
  9. 09Review sales or production activity for the period under review.
  10. 10Review adjustments for cause, support, period and reviewer.
  11. 11Compare system quantities across tracking, retail or production, and accounting.
  12. 12Compare system quantities to physical count records.
  13. 13Identify differences and rank them by financial impact.
  14. 14Document supported resolutions and flag what remains unresolved.
  15. 15Bridge reconciled inventory data into the accounting inventory schedule and the general ledger.
  16. 16Establish recurring monthly reconciliation procedures with defined ownership and review.

Coverage

Metrc Reconciliation Across New Mexico

We support cannabis businesses throughout New Mexico with Metrc and seed-to-sale reconciliation, working remotely with operators statewide. That includes dispensaries and retail groups in Albuquerque, Santa Fe, Las Cruces and Rio Rancho; cultivation and manufacturing operations serving Roswell, Farmington, Clovis and Hobbs; and businesses in Alamogordo, Carlsbad, Gallup and Los Lunas. Reconciliation work is document- and data-driven, so location is rarely a constraint — the constraint is whether the underlying records exist and can be traced.

Multi-location groups operating across several of these markets get location-level reconciliation first and a consolidated view second, so each store or facility can be evaluated on its own performance. Further background is available in the New Mexico seed-to-sale tracking guide, the inventory accounting guide and the New Mexico cannabis accounting guide.

Questions

Metrc Reconciliation 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.

Schedule Consultation Speak With a Cannabis CPA